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 (68473,326872,68968,355219,13863,72450,14171,63692,140606,323049,330202,345121,62734,66159,71154,77782,62589,67221,74010,74899,79528,126850,139877,353355,354201,355894,356215,63658,66794,69915,71795,72160,277987,278525,336138,342190,354310,355805,357437,357787) && b1.wide_range_catg=0 && final_catg='Y'
ORDER BY FIELD(b1.slno, 68473,326872,68968,355219,13863,72450,14171,63692,140606,323049,330202,345121,62734,66159,71154,77782,62589,67221,74010,74899,79528,126850,139877,353355,354201,355894,356215,63658,66794,69915,71795,72160,277987,278525,336138,342190,354310,355805,357437,357787)
LIMIT 40
Post Free Ad
