SELECT * FROM event e INNER JOIN event_location el ON e.event_id = el.event_id INNER JOIN region r on r.region_id = el.region_id INNER JOIN event_event_type eet on eet.event_id = e.event_id WHERE date_format(el.event_location_end_date, '%Y%m%d') >= 20100909 AND eet.event_type_id = 16 ORDER BY el.event_location_start_date ASC