SELECT 
c.no,
c.category1,
c.category2,
c.year,
c.month,
c.photo1,
c.loc_id,
c.gear_type,
c.price,
c.sales_end,
c.owner_id FROM market_car_advertise a LEFT OUTER JOIN dash_car_info c ON a.parent_no=c.no WHERE c.mod_time > DATE_SUB(NOW(),INTERVAL 1 YEAR) AND c.make_id='ko3232' AND c.sale_now='t' AND  AND a.category=2 ORDER BY RAND() LIMIT 0,5