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 (140606,66926,73917,63665,66159,71552,335511,357348,79528,353787,88161,353784,68473,360394,14171,63692,355894,355404,13305,67221,243880,14305,73245,75125,362329,355289,168377,353964,355290,71879,73386,87988,146875,77782,168366,303882,316957,349475,13650,62660,63601,84712,163162,70661,349474,355145,356883,86680,182516,323545,62135,64183,70115,71154,71569,92074,94176,124366,154124,336014,342190,355439,357774,358736,66162,105060,329607,348705,353355,355219,355248,356215,356512,63412,64063,74611,172697,325417,330186,349992,63867,64590,67134,69691,79257,329622,342668,66960,67309,69915,322371,337814,358703,13649,61992,64034,64217,64242,70656,72705) && b1.wide_range_catg=0 && final_catg='Y'
ORDER BY FIELD(b1.slno, 140606,66926,73917,63665,66159,71552,335511,357348,79528,353787,88161,353784,68473,360394,14171,63692,355894,355404,13305,67221,243880,14305,73245,75125,362329,355289,168377,353964,355290,71879,73386,87988,146875,77782,168366,303882,316957,349475,13650,62660,63601,84712,163162,70661,349474,355145,356883,86680,182516,323545,62135,64183,70115,71154,71569,92074,94176,124366,154124,336014,342190,355439,357774,358736,66162,105060,329607,348705,353355,355219,355248,356215,356512,63412,64063,74611,172697,325417,330186,349992,63867,64590,67134,69691,79257,329622,342668,66960,67309,69915,322371,337814,358703,13649,61992,64034,64217,64242,70656,72705)
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 (13619,239272,128094,349960,316858,352250,355218,356079,342080,69438,324451,351438,99708,14207,62112,66054,323511,329758,330005,348977,357516,358463,63871,76675,349845,66182,263150,354019,354382) && 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, 13619,239272,128094,349960,316858,352250,355218,356079,342080,69438,324451,351438,99708,14207,62112,66054,323511,329758,330005,348977,357516,358463,63871,76675,349845,66182,263150,354019,354382)
LIMIT 40
Post Free Ad
