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/1517697119_header_image_Malachock 220x220.jpg
March 17 - March 25, 2018
Lyceum Stage
Malashock Dance presents "THE RIDE: Malashock@30" March 17-25   Celebrating a landmark 30th Anniversary Season the newly expanded Company of 11 dancers will inspire audiences with their unparalleled talent and evocative performance.  
/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!
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
This mixed repertoire of dance brings back jazz saxophone great Charles McPherson to perform his SWEET SYNERGY SUITE as well as a world premiere in May of 2017. Also on the program, last year’s popular TIME FURTHER OUT set to the music of Dave Brubeck.  
May 19, 2018
Lyceum Space
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.