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
April 3 - April 22, 2018
The family musical that takes us on an odyssey through the triumphs and challenges of a cultural phenomenon, Rabbi Shlomo Carlebach.
/home/sdreporg/public_html/images/shows/1520818416_header_image_MASHED UP THUMB.jpg
April 28 - May 6, 2018
Kelrik Productions presents "PINKALICIOUS THE MUSICAL" April 28-May 6 65 Min Pinkalicious can't stop eating pink cupcakes despite warnings from her parents. Her pink indulgence lands her at the doctor's office with Pinkititis, an affliction that turns her pink from head to toe—a dream come true for this pink-loving enthusiast. But when her hue goes too far, only Pinkalicious ca[...]
May 12, 2018
It’s 1963 in Mimosa Heights, and Tanqueray Tonic has only one desire – to get into rehab with the nicest drunks in town and dance on the Corky Poppers Show! Orchestra tickets include VIP pre-show reception with hosted hors d'oeuvres starting at 6:30pm. PG - 13
May 18 - May 20, 2018
Continuing its commitment to bringing ballet and live jazz together in a fully staged setting, the San Diego Ballet presents A Night of Jazz and Dance at the Lyceum Theatre. This mixed bill performance features music composed and performed by San Diego-based jazz legend Charles McPherson, and two-time Grammy Award winning artist Kamau Kenyatta.
May 19, 2018
Join us, post concert, in the beautifully renovated Lyceum lobby to celebrate our extraordinary season! Saturday, May 19th $20 per guest (purchased separately from performance tickets) Mingle with the artists from San Diego Ballet, Jazz Icon, Charles McPherson and Artistic Director, Javier Velasco, as we celebrate our last show of our 28th season.