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
img

Resident Orchestra

ANNA GENIUSHENE, piano Winner of 2022 Van Cliburn Silver Medal

Oct 09, 2022 - - The Norris Theatre

img

Resident Orchestra

BORIS ALLAKHVERDYAN, clarinet Principal with the Los Angeles Philharmonic

Nov 13, 2022 - - The Norris Theatre

img

Resident Orchestra

CLAIRE HUANGCI, piano Winner of Multiple International Prizes

Jan 15, 2023 - - The Norris Theatre

img

Resident Orchestra

MARCIA DICKSTEIN, harp PHILIP VAIMAN, violin “In Honor of Women’s History Month”

Mar 05, 2023 - - The Norris Theatre

img

Resident Orchestra

"Beethoven to Broadway"

Apr 15, 2023 - - The Norris Theatre