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 (66460,74422,63665,67221,62274,66159,361446,79528,68473,140606,278736,172536,357103,343924,274720,353936,65086,284598,357854,330983,133494,184933,357731,70801,72710,154919,355153,360394,342190,336709,14171,63692,67016,88161,355290,182516,14193,66162,353964,67110,359591,132773,359319,82265,179102,87988,172697,355894,282274,355152,355155,356215,355219,64081,77086,346591,79283,13650,14170,61992,66960,357886,303882,355145,330186,354751,73220,360395,367442,68461,336014,322040,67569,66160,166478,325417,364415,63664,166479,326914,62455,184015,340276,359774,71795,156189,357317,86680,317672,355289,357623,14250,116276,355200,358631,75802,312516,354341,353762,67134) && b1.wide_range_catg=0 && final_catg='Y'
ORDER BY FIELD(b1.slno, 66460,74422,63665,67221,62274,66159,361446,79528,68473,140606,278736,172536,357103,343924,274720,353936,65086,284598,357854,330983,133494,184933,357731,70801,72710,154919,355153,360394,342190,336709,14171,63692,67016,88161,355290,182516,14193,66162,353964,67110,359591,132773,359319,82265,179102,87988,172697,355894,282274,355152,355155,356215,355219,64081,77086,346591,79283,13650,14170,61992,66960,357886,303882,355145,330186,354751,73220,360395,367442,68461,336014,322040,67569,66160,166478,325417,364415,63664,166479,326914,62455,184015,340276,359774,71795,156189,357317,86680,317672,355289,357623,14250,116276,355200,358631,75802,312516,354341,353762,67134)
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 (116276,64099,315229,348977,351296,356079,13619,239272,354019,357516,13315,354382,263150,336326,354381,65749,66182,115095,246780,320615,337913,355218,358533,11933,62134,72859,72963,144062,173930,350887,354386,358402) && 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, 116276,64099,315229,348977,351296,356079,13619,239272,354019,357516,13315,354382,263150,336326,354381,65749,66182,115095,246780,320615,337913,355218,358533,11933,62134,72859,72963,144062,173930,350887,354386,358402)
LIMIT 40
Post Free Ad