Post Free Ad Login Sign Up

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 (355079,13024,69179,348426,86680,301075,112730,63665,13866,140606,66159,106291,68473,97632,357317,14135,14171,91737,172697,317672,358156,246712,63598,354201,79528,353762,87988,355145,14250,63692,66960,355894,88161,71154,71294,73105,78279,126850,74226,182516,325417,14170,353971,175747,67270,71801,64034,66944,13778,61992,348551,353974,357623,63605,71795,342290,361095,62455,312516,367626,67008,67214,211035,282274,340276,64187,71291,116217,179102,356215,361446,64468,71841,355200,13649,355219,357702,13023,63904,63908,64763,71296,105878,122931,176583,328734,359141,360394,68461,74487,331476,355975,13429,14158,63658,68094,163105,324215,350943,353964) && b1.wide_range_catg=0 && final_catg='Y' ORDER BY FIELD(b1.slno, 355079,13024,69179,348426,86680,301075,112730,63665,13866,140606,66159,106291,68473,97632,357317,14135,14171,91737,172697,317672,358156,246712,63598,354201,79528,353762,87988,355145,14250,63692,66960,355894,88161,71154,71294,73105,78279,126850,74226,182516,325417,14170,353971,175747,67270,71801,64034,66944,13778,61992,348551,353974,357623,63605,71795,342290,361095,62455,312516,367626,67008,67214,211035,282274,340276,64187,71291,116217,179102,356215,361446,64468,71841,355200,13649,355219,357702,13023,63904,63908,64763,71296,105878,122931,176583,328734,359141,360394,68461,74487,331476,355975,13429,14158,63658,68094,163105,324215,350943,353964) 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 (317275,135397,357516,358189,358190,356079,13619,116276,239272,351296,358318) && 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, 317275,135397,357516,358189,358190,356079,13619,116276,239272,351296,358318) LIMIT 40