SELECT shows.img_alt_tag, shows.pre_header, shows.subscribe, shows.ticket_link, shows.subscribe_show_listing, shows.subscription_link, shows.show_id, shows.single_ticket, shows.status, shows.start_date, shows.end_date, shows.sale_date, shows.title, shows.short_description, shows.running_time, shows.short_cuts, shows.show_venue, images.i_file, shows.heading_picture, shows.`front_page_display`, images.i_title , STR_TO_DATE( start_date, '%m/%d/%Y' ) AS DATE_START, STR_TO_DATE( end_date, '%m/%d/%Y' ) AS DATE_END, shows.list_image_alt, shows.list_image FROM `shows` LEFT JOIN `images` ON((`images`.`i_show_id` = `shows`.`show_id`) AND (`images`.`it_id`=2) ) WHERE #`shows`.`show_type` like '%Regular Show%' `shows`.`show_type` like '%Lyceum Show%' #`shows`.`show_type` like '%Lyceum%' AND `shows`.`front_page_display` = 0 AND STR_TO_DATE( end_date, '%m/%d/%Y' )>= CURDATE() AND shows.status=1 GROUP BY shows.show_id ORDER BY STR_TO_DATE( `start_date`, '%m/%d/%Y' ) ASC
February 20 - March 24, 2019
San Diego’s beloved artist, Hershey Felder, returns with an entirely new take on the world’s greatest composer, BEETHOVEN. This promises to be his most unforgettable journey yet.
May 3 - May 5, 2019
The complicated game of growing up hapa, multiple, or mixed-race today. Funny, outrageous, and true experiences in the interactive game show of modern America, through skits, video, live music, and celebrity impersonations of debatable quality.
May 24 - May 26, 2019
WORLD PREMIERE! Featuring a score by jazz legend Charles McPherson, SONG OF SONGS celebrates a poem beloved by people from all walks of life and beliefs.
May 31 - June 2, 2019
HIGH STRUNG is an exceptional performance, featuring Malashock Dance Company and Art of Élan's Ensemble-in-Residence, the Kontras Quartet.
May 31, 2019
Join Malashock Dance and Art of Élan for their pre-show Young Professionals Happy Hour on Friday, May 31st at 6:30pm! Tickets to the 8:00pm performance of High Strung must be purchased separately.
June 14 - June 23, 2019
A truly timeless Old Testament tale, Joseph and the Amazing Technicolor Dreamcoat is set to a multitude of musical genres, spanning from country-western and calypso to bubble-gum pop and rock and roll.