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 (355145,66960,366048,66159,353355,100394,140606,366753,64018,77782,79273,87988,359141,70140,72258,357774,14171,63665,63692,63977,79528,163201,342215,355219,355894,68473,70266,78839,91277,168732,306261,343853,349212,354559,356215,357787,360394,361095,363128,14293,64063,66716,67001,67036,71195,71250,74899,75414,77673,77957,78293,179531,353964) && b1.wide_range_catg=0 && final_catg='Y'
ORDER BY FIELD(b1.slno, 355145,66960,366048,66159,353355,100394,140606,366753,64018,77782,79273,87988,359141,70140,72258,357774,14171,63665,63692,63977,79528,163201,342215,355219,355894,68473,70266,78839,91277,168732,306261,343853,349212,354559,356215,357787,360394,361095,363128,14293,64063,66716,67001,67036,71195,71250,74899,75414,77673,77957,78293,179531,353964)
LIMIT 40
Post Free Ad
