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 (314759,66159,79528,68448,10048,74354,66160,69875,74353,63665,66166,68473,281330,282274,360394,132858,162918,140606,66162,72008,14171,120481,62011,325858,67080,67134,355219,66956,342190,88161,336014,62274,71134,188372,336709,62620,69782,74422,93165,129423,182516,361446,73896,93380,341680,365847,71154,128268,353964,354751,355155,364415,67110,156189,322040,355145,366384,63867,67221,77142,82265,334321,13415,66960,71795,77782,251442,272146,277987,330186,355086,66460,68461,120834,172126,179102,337814,346591,355311,355805,61992,63692,64187,68945,73220,74352,82223,100598,172697,211529,317015,323545,337400,340276,355727,358233,358411,69892,75865,128810) && b1.wide_range_catg=0 && final_catg='Y'
ORDER BY FIELD(b1.slno, 314759,66159,79528,68448,10048,74354,66160,69875,74353,63665,66166,68473,281330,282274,360394,132858,162918,140606,66162,72008,14171,120481,62011,325858,67080,67134,355219,66956,342190,88161,336014,62274,71134,188372,336709,62620,69782,74422,93165,129423,182516,361446,73896,93380,341680,365847,71154,128268,353964,354751,355155,364415,67110,156189,322040,355145,366384,63867,67221,77142,82265,334321,13415,66960,71795,77782,251442,272146,277987,330186,355086,66460,68461,120834,172126,179102,337814,346591,355311,355805,61992,63692,64187,68945,73220,74352,82223,100598,172697,211529,317015,323545,337400,340276,355727,358233,358411,69892,75865,128810)
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 (350433,331886,323511,73546,239272,358464) && 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, 350433,331886,323511,73546,239272,358464)
LIMIT 40
Post Free Ad
