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 (66159,140606,355894,79528,67048,341150,70603,357317,88161,63665,62361,78519,13979,68473,360394,357214,353964,62038,366048,319884,355247,79516,345480,70266,75771,66162,13649,66552,333461,87988,355086,353966,357704,361446,13337,358736,70135,323545,353936,63234,325417,62564,143042,67016,14087,358156,77086,63650,13083,73524,63598,82223,77957,13988,330186,335209,329914,355079,360395,79810,65764,319431,355219,79273,339592,322371,164515,14170,77782,314715,172697,62522,139877,182516,354311,118361,80895,61992,318838,78774,136979,65355,177663,312880,167522,14193,65083,62025,313463,73008,65116,339364,353971,355404,74422,336014,355912,67221,65238,134934) && b1.wide_range_catg=0 && final_catg='Y'
ORDER BY FIELD(b1.slno, 66159,140606,355894,79528,67048,341150,70603,357317,88161,63665,62361,78519,13979,68473,360394,357214,353964,62038,366048,319884,355247,79516,345480,70266,75771,66162,13649,66552,333461,87988,355086,353966,357704,361446,13337,358736,70135,323545,353936,63234,325417,62564,143042,67016,14087,358156,77086,63650,13083,73524,63598,82223,77957,13988,330186,335209,329914,355079,360395,79810,65764,319431,355219,79273,339592,322371,164515,14170,77782,314715,172697,62522,139877,182516,354311,118361,80895,61992,318838,78774,136979,65355,177663,312880,167522,14193,65083,62025,313463,73008,65116,339364,353971,355404,74422,336014,355912,67221,65238,134934)
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 (173930,356079,351438,351437,66054,354019,357516,354382,304728,135397,343626,273738,337913,354386,332317,357198,358190,331886,234033,358189,76615,354394,350924,246780,357860,345480,317275,355218,323511,328849,351296,358318,149774,350436,358539,77002,331062,348977,350433,351385,14207,239272,354371,358469,283956,354290,358439,76675,13619,358533,71157,116276,358464,13858,66182,317263,350887,354947,349845,351439,64099,358463,62142,212981,310474,336326,337629,351085,355499,115095,134934,315229,151648,65749,324959,345476,107923,318758,358116,354397,65236,70380,324451,350666,327128,331996,78976,332671,63871,69438,78647,12545,13315,326033,351418,137606,317500,350159,350632,354381) && 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, 173930,356079,351438,351437,66054,354019,357516,354382,304728,135397,343626,273738,337913,354386,332317,357198,358190,331886,234033,358189,76615,354394,350924,246780,357860,345480,317275,355218,323511,328849,351296,358318,149774,350436,358539,77002,331062,348977,350433,351385,14207,239272,354371,358469,283956,354290,358439,76675,13619,358533,71157,116276,358464,13858,66182,317263,350887,354947,349845,351439,64099,358463,62142,212981,310474,336326,337629,351085,355499,115095,134934,315229,151648,65749,324959,345476,107923,318758,358116,354397,65236,70380,324451,350666,327128,331996,78976,332671,63871,69438,78647,12545,13315,326033,351418,137606,317500,350159,350632,354381)
LIMIT 40
Post Free Ad
