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,79528,140606,14171,69891,63665,66162,172697,71795,68473,304819,355200,71801,324215,62455,355145,251442,282274,64718,67134,68463,14096,14170,71995,77782,355805,360394,88161,325417,336014,342190,353964,358552,78519,137986,323545,355219,358736,64736,77957,330186,355155,63867,67036,67221,146875,348701,355404,64081,64189,66956,67354,82223,128810,137741,316957,353984,355289,357317,360110,62620,63598,63664,64038,64737,66960,74487,75802,79099,93380,105109,106460,133575,137985,170525,307527,312516,322371,349475,354311,355086,355290,355806,361095,13493,65217,66166,66350,67116,69892,71249,72162,93165,94176,137993,144894,179531,198100,201554,327348) && b1.wide_range_catg=0 && final_catg='Y'
ORDER BY FIELD(b1.slno, 66159,79528,140606,14171,69891,63665,66162,172697,71795,68473,304819,355200,71801,324215,62455,355145,251442,282274,64718,67134,68463,14096,14170,71995,77782,355805,360394,88161,325417,336014,342190,353964,358552,78519,137986,323545,355219,358736,64736,77957,330186,355155,63867,67036,67221,146875,348701,355404,64081,64189,66956,67354,82223,128810,137741,316957,353984,355289,357317,360110,62620,63598,63664,64038,64737,66960,74487,75802,79099,93380,105109,106460,133575,137985,170525,307527,312516,322371,349475,354311,355086,355290,355806,361095,13493,65217,66166,66350,67116,69892,71249,72162,93165,94176,137993,144894,179531,198100,201554,327348)
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 (355218,348977,166195,234452,329173,332060,332384,340613,349376,365624,323511,357516,358463) && 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, 355218,348977,166195,234452,329173,332060,332384,340613,349376,365624,323511,357516,358463)
LIMIT 40
Post Free Ad