SELECT concat(b1.catg1,'~~',b1.url_iyp) AS l2_catg, b1.slno as l2_slno, tci.img_name_home, tci.img_name_home_width_height FROM category_tbl b1 LEFT JOIN tbl_category_image tci ON tci.final_catg_slno = b1.slno WHERE b1.slno IN (66159,79528,69892,140606,172697,73298,355145,66960,14170,63665,68473,10048,304819,14171,74422,67221,63747,360394,361446,62274,68492,69891,66162,66460,67080,369433,66160,324215,355200,358703,66956,348701) && b1.wide_range_catg=0 && final_catg='Y'
ORDER BY FIELD(b1.slno, 66159,79528,69892,140606,172697,73298,355145,66960,14170,63665,68473,10048,304819,14171,74422,67221,63747,360394,361446,62274,68492,69891,66162,66460,67080,369433,66160,324215,355200,358703,66956,348701)
LIMIT 40
Post Free Ad
www