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 (14171,140606,66159,360394,63665,79528,67110,336709,337814,342190,358156,67221,68473,71795,72672,282274,325417,355200) && b1.wide_range_catg=0 && final_catg='Y'
ORDER BY FIELD(b1.slno, 14171,140606,66159,360394,63665,79528,67110,336709,337814,342190,358156,67221,68473,71795,72672,282274,325417,355200)
LIMIT 40
Post Free Ad