SELECT ed.* FROM events_date AS ed LEFT JOIN events AS e ON e.id = ed.event_id WHERE ed.year >= '2010' AND e.showtype_id = 1 or e.showtype_id = 7 AND e.live = 1 ORDER BY time