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 (63650,82241,61992,356215,63649,63692,356103,66159,66800,87988,361711,62968,63662,79528,344902,355799,367587,79257,100522,150326,342190,358631,66051,76797,140606,150329,325726,355807,355894,360394,71154,190916,323528,340408,353964,354279,356883) && b1.wide_range_catg=0 && final_catg='Y'
ORDER BY FIELD(b1.slno, 63650,82241,61992,356215,63649,63692,356103,66159,66800,87988,361711,62968,63662,79528,344902,355799,367587,79257,100522,150326,342190,358631,66051,76797,140606,150329,325726,355807,355894,360394,71154,190916,323528,340408,353964,354279,356883)
LIMIT 40
Post Free Ad
