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
/home/sdreporg/public_html/images/shows/1513220556_header_image_Schlomo 220x220.jpg
April 3 - April 22, 2018
Lyceum Stage
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 20 - April 22, 2018
Lyceum Space
PGK Dance presents "MASHED UP Songs & Dance" 90 Minutes with intermission An Evening of Unexpected MASHINGS of Pop & Theater Songs Performed by Truly Dynamic Singers, Accompanied by Stellar PGK Dance!
/home/sdreporg/public_html/images/shows/1522973300_header_image_PINKALICIOUS thumb.jpg
April 28 - May 6, 2018
Lyceum Space
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[...]
/home/sdreporg/public_html/images/shows/1521318418_header_image_GMSR_BearsparyMusical_thumb.jpg
May 12, 2018
Lyceum Stage
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
/home/sdreporg/public_html/images/shows/1518385376_header_image_SDB_Jazz -18_220x220.jpg
May 18 - May 20, 2018
Lyceum Stage
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.  
/home/sdreporg/public_html/images/shows/1518385850_header_image_JD_Reception.jpg
May 19, 2018
Lyceum Stage
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.

Facebook