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 (357170,358736,64701,66159,336014,14171,93165,71292,63665,62620,79528,341680,93380,360394,139483,140606,88161,85900,68473,87988,175677,355894,63692,353936,73367,71795,62455,13429,67134,71949,61992,355145,358738,86680,357886,13226,168732,75677,313988,66488,355086,356215,172697,357317,14170,64718,357214,62746,74422,66960,76300,104846,331182,69331,13083,139877,325417,333659,360395,123197,357787,66926,338663,355806,303882,77782,322024,355079,66162,353964,355744,64736,339314,353355,355343,358233,73404,78826,342190,13338,62361,235003,355219,357437,13649,62568,63867,65086,77661,321290,358411,243880,323545,345480,349706,358631,13305,72162,359551,66350) && b1.wide_range_catg=0 && final_catg='Y'
ORDER BY FIELD(b1.slno, 357170,358736,64701,66159,336014,14171,93165,71292,63665,62620,79528,341680,93380,360394,139483,140606,88161,85900,68473,87988,175677,355894,63692,353936,73367,71795,62455,13429,67134,71949,61992,355145,358738,86680,357886,13226,168732,75677,313988,66488,355086,356215,172697,357317,14170,64718,357214,62746,74422,66960,76300,104846,331182,69331,13083,139877,325417,333659,360395,123197,357787,66926,338663,355806,303882,77782,322024,355079,66162,353964,355744,64736,339314,353355,355343,358233,73404,78826,342190,13338,62361,235003,355219,357437,13649,62568,63867,65086,77661,321290,358411,243880,323545,345480,349706,358631,13305,72162,359551,66350)
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 (356079,62112,351438,173930,66054,315229,350686,331886,351437,354394,66182,354382,350651,354019,355218,256575,357516,76615,348977,337913,63871,135397,358318,246780,351296,11937,329758,358190,304728,323511,357198,144077,234033,284314,354386,13858,71006,77002,273738,283956,343563,354290,358464,358539,365779,13315,72363,167408,313783,116276,332332,358189,367255,72361,317500,358439,13619,78647,149774,212981,239272,328880,348978,350436,350887,350912,354379,357860,11933,64099,76675,115095,153265,320615,322383,328849,331062,337629,350433,351085,351385,356041,358116,358202,358463,362710,10368,13316,65749,66390,67255,107923,144062,322286,322777,338827,349960,353999,354909,355683) && 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, 356079,62112,351438,173930,66054,315229,350686,331886,351437,354394,66182,354382,350651,354019,355218,256575,357516,76615,348977,337913,63871,135397,358318,246780,351296,11937,329758,358190,304728,323511,357198,144077,234033,284314,354386,13858,71006,77002,273738,283956,343563,354290,358464,358539,365779,13315,72363,167408,313783,116276,332332,358189,367255,72361,317500,358439,13619,78647,149774,212981,239272,328880,348978,350436,350887,350912,354379,357860,11933,64099,76675,115095,153265,320615,322383,328849,331062,337629,350433,351085,351385,356041,358116,358202,358463,362710,10368,13316,65749,66390,67255,107923,144062,322286,322777,338827,349960,353999,354909,355683)
LIMIT 40
Post Free Ad
