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 (336014,93165,62620,93380,341680,317672,63665,63692,355894,14304,88161,66159,68473,316356,355200,68461,76300,140606,69858,79528,87988,354193,356215,356969,74226,91277,14171,67001,342190,66460,169500,14158,355744,67356,126850,358703,312688,355806,67221,74422,79844,355975,325417,14170,14305,66488,128085,355477,64183,64242,69211,72271,356103,63867,303882,336709,350233,355799,360394,14151,62274,353964,61992,69935,78519,78557,172536,68094,73446,74611,330186,331012,355145,355976,66271,66647,67116,116276,172697,348525,355628,357660,358736,366048,14250,62502,64217,66447,67110,75891,83030,92326,94224,268817,278736,322040,343924,349751,353945,357317) && b1.wide_range_catg=0 && final_catg='Y'
ORDER BY FIELD(b1.slno, 336014,93165,62620,93380,341680,317672,63665,63692,355894,14304,88161,66159,68473,316356,355200,68461,76300,140606,69858,79528,87988,354193,356215,356969,74226,91277,14171,67001,342190,66460,169500,14158,355744,67356,126850,358703,312688,355806,67221,74422,79844,355975,325417,14170,14305,66488,128085,355477,64183,64242,69211,72271,356103,63867,303882,336709,350233,355799,360394,14151,62274,353964,61992,69935,78519,78557,172536,68094,73446,74611,330186,331012,355145,355976,66271,66647,67116,116276,172697,348525,355628,357660,358736,366048,14250,62502,64217,66447,67110,75891,83030,92326,94224,268817,278736,322040,343924,349751,353945,357317)
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 (350433,323511,358463,358464,239272,13619,354379,314819,73546,349936,76675,334642,350436,351296,62697,66390,78647,329758,354019,354397,343563,69438,77002,324451,351438,354386,355683,66075,234033,351085,355218,358439) && 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, 350433,323511,358463,358464,239272,13619,354379,314819,73546,349936,76675,334642,350436,351296,62697,66390,78647,329758,354019,354397,343563,69438,77002,324451,351438,354386,355683,66075,234033,351085,355218,358439)
LIMIT 40
Post Free Ad
