Filter
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
Resident Orchestra
MARCIA DICKSTEIN, harp PHILIP VAIMAN, violin “In Honor of Women’s History Month”
Mar 05, 2023 - - The Norris Theatre
Resident Orchestra
"Beethoven to Broadway"
Apr 15, 2023 - - The Norris Theatre