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 (357214,62361,360394,358736,353941,63692,140606,139877,66159,70603,354310,78213,353936,71154,360395,116276,164515,357170,79273,87988,63867,101378,357317,88161,68473,79528,356215,63733,63665,64018,355894,62522,355079,77030,355086,74885,356883,357437,355247,74422,13083,357854,14193,64958,74899,353988,353964,12576,62455,77086,14087,14171,64736,138298,13051,355883,62352,64737,64701,77957,358156,65086,103258,128268,359141,321068,366048,319431,358233,76803,355805,13058,86680,62108,107361,355897,363187,63598,353509,77782,322584,61992,65655,136979,303882,354041,67306,357623,175232,243880,13305,109443,64099,67178,235003,65554,68911,357103,366845,12966) && b1.wide_range_catg=0 && final_catg='Y'
ORDER BY FIELD(b1.slno, 357214,62361,360394,358736,353941,63692,140606,139877,66159,70603,354310,78213,353936,71154,360395,116276,164515,357170,79273,87988,63867,101378,357317,88161,68473,79528,356215,63733,63665,64018,355894,62522,355079,77030,355086,74885,356883,357437,355247,74422,13083,357854,14193,64958,74899,353988,353964,12576,62455,77086,14087,14171,64736,138298,13051,355883,62352,64737,64701,77957,358156,65086,103258,128268,359141,321068,366048,319431,358233,76803,355805,13058,86680,62108,107361,355897,363187,63598,353509,77782,322584,61992,65655,136979,303882,354041,67306,357623,175232,243880,13305,109443,64099,67178,235003,65554,68911,357103,366845,12966)
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 (135397,356079,358190,173930,351438,358189,357516,350436,256575,354382,354397,66182,354386,351437,116276,355499,357198,64099,358318,358116,13858,77584,137164,349845,351296,355218,328849,66054,246780,354019,354371,285168,331062,355854,358439,283956,348977,315229,107923,351085,351385,358533,11937,62142,62510,77002,151648,76675,331886,354394,317500,71157,284314,350887,13315,67168,325177,115095,354947,323511,332317,335627,337913,13859,234033,304728,358464,67047,239272,320615,356289,316318,317275,337452,350924,358463,365779,13619,67255,80453,350159,12545,69249,72859,324451,350433,350632,351439,353999,358442,367255,13226,13316,62146,65749,72963,77786,96570,206932,230252) && 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, 135397,356079,358190,173930,351438,358189,357516,350436,256575,354382,354397,66182,354386,351437,116276,355499,357198,64099,358318,358116,13858,77584,137164,349845,351296,355218,328849,66054,246780,354019,354371,285168,331062,355854,358439,283956,348977,315229,107923,351085,351385,358533,11937,62142,62510,77002,151648,76675,331886,354394,317500,71157,284314,350887,13315,67168,325177,115095,354947,323511,332317,335627,337913,13859,234033,304728,358464,67047,239272,320615,356289,316318,317275,337452,350924,358463,365779,13619,67255,80453,350159,12545,69249,72859,324451,350433,350632,351439,353999,358442,367255,13226,13316,62146,65749,72963,77786,96570,206932,230252)
LIMIT 40
Post Free Ad
