oops...
SELECT events.presenter_1, events.presenter_2, events.presenter_3, events.presenter_4, events.presenter_5, events.presenter_title_1, events.presenter_title_2, events.presenter_title_3, events.presenter_title_4, events.presenter_title_5, events.presenter_dept_1, events.presenter_dept_2, events.presenter_dept_3, events.presenter_dept_4, events.presenter_dept_5, events.presenter_desc_1, events.presenter_desc_2, events.presenter_desc_3, events.presenter_desc_4, events.presenter_desc_5, events.presenter_url_1, events.presenter_url_2, events.presenter_url_3, events.presenter_url_4, events.presenter_url_5, events.title AS event_title, events.content AS event_content, events.`date` AS event_date, events.`time` AS event_time, events.end_time AS event_end_time, events.image AS event_image, events.`type` AS event_type, events.contact AS event_contact, venue.name AS venue_name, venue.address AS venue_address, venue.url AS venue_url, sponsor.description AS sponsor_desc, sponsor.url AS sponsor_url, sponsor.name AS sponsor_name, events.id AS events_id FROM events Inner Join sponsor ON events.sponsors = sponsor.id Inner Join venue ON events.venue = venue.id WHERE events.`date` < '2014-07-29' and events.`ay_year` = '2010-2011' AND events.`publish`='1' AND events.`featured_confucius`='1' order by event_date DESC