SELECT shows.pre_header, shows.subscribe, shows.short_title, shows.ticket_link, shows.subscribe_show_listing, shows.subscription_link, shows.register_link, shows.show_id, shows.single_ticket, shows.status, shows.start_date, shows.end_date, shows.sale_date, shows.register_date, shows.title, shows.short_description, shows.running_time, shows.short_cuts, YEAR(shows.start_date) AS start_year, YEAR(shows.end_date) AS end_year, spaces.s_name AS LOCATION, show_types.heading_title AS show_type, show_types.id as show_type_id, CURDATE() FROM `shows` LEFT JOIN `spaces` ON `spaces`.`s_id`=`shows`.`show_venue` LEFT JOIN `show_types` ON `show_types`.`id`=`shows`.`show_type` WHERE shows.end_date >= CURDATE() AND shows.status=1 AND shows.show_type IN (16) GROUP BY shows.show_id ORDER BY `start_date` ASC