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 (355744,336014,331405,63867,62620,93380,93165,341680,78826,245281,88161,353940,328017,355806,78557,350233,355477,73367,69858,355782,193497,76300,355343,174935,115807,130799,236582,323566,13721,348734,66447,69737,72266,304724,353944,140606,90815,355753,316316,304836,264399,354471,62455,69859,349300,67861,62046,169986,355628,69106,169500,70297,268817,355289,169982,344355,208090,13304,168732,13380,340229,66159,69096,342879,312688,119763,357787,74422,353355,353936,78500,362213,65086,119756,169991,339972,78293,167522,328006,342340,355894,76299,79528,354751,67356,316504,353921,355408,66920,68473,355776,74387,107857,320588,67971,169981,169987,67959,71250,73325) && b1.wide_range_catg=0 && final_catg='Y'
ORDER BY FIELD(b1.slno, 355744,336014,331405,63867,62620,93380,93165,341680,78826,245281,88161,353940,328017,355806,78557,350233,355477,73367,69858,355782,193497,76300,355343,174935,115807,130799,236582,323566,13721,348734,66447,69737,72266,304724,353944,140606,90815,355753,316316,304836,264399,354471,62455,69859,349300,67861,62046,169986,355628,69106,169500,70297,268817,355289,169982,344355,208090,13304,168732,13380,340229,66159,69096,342879,312688,119763,357787,74422,353355,353936,78500,362213,65086,119756,169991,339972,78293,167522,328006,342340,355894,76299,79528,354751,67356,316504,353921,355408,66920,68473,355776,74387,107857,320588,67971,169981,169987,67959,71250,73325)
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 (348977,79290,343065,315917,344243) && 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, 348977,79290,343065,315917,344243)
LIMIT 40
Post Free Ad