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 (140606,63665,68473,63692,14171,355805,14170,87988,324215,13085,356215,168732,182516,355894,358631,73245,74422,88161,160895,355219,74600,319545,353936,65086,71795,75933,77782,159645,180812,313203,358709,360394,14305,61992,66159,72216,79528,80145,86680,100522,137741,277865,355200,13083,13731,63658,64038,67221,68463,325417,357774,10048,64440,70315,71841,340276,362215,14158,14250,62620,63598,63664,64081,64242,66290,68461,69680,70610,74014,78519,86629,93165,127145,323545,341150,344816,355079,355145,355290,355310,357824,357841,358703,14297,62734,63530,64034,67411,68361,69915,69927,73917,77816,78774,81320,82223,82265,86601,86752,93380) && b1.wide_range_catg=0 && final_catg='Y'
ORDER BY FIELD(b1.slno, 140606,63665,68473,63692,14171,355805,14170,87988,324215,13085,356215,168732,182516,355894,358631,73245,74422,88161,160895,355219,74600,319545,353936,65086,71795,75933,77782,159645,180812,313203,358709,360394,14305,61992,66159,72216,79528,80145,86680,100522,137741,277865,355200,13083,13731,63658,64038,67221,68463,325417,357774,10048,64440,70315,71841,340276,362215,14158,14250,62620,63598,63664,64081,64242,66290,68461,69680,70610,74014,78519,86629,93165,127145,323545,341150,344816,355079,355145,355290,355310,357824,357841,358703,14297,62734,63530,64034,67411,68361,69915,69927,73917,77816,78774,81320,82223,82265,86601,86752,93380)
LIMIT 40SELECT 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 (349936,140416,331886,354386,351085,351296) && b1.wide_range_catg=0 && final_catg='Y'
ORDER BY
FIELD(b1.slno, 62697,63871,66054,323511,351437,354019,354371,358190) DESC,
FIELD(b1.slno, 349936,140416,331886,354386,351085,351296)
LIMIT 40
Post Free Ad
