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
March 2 - March 11, 2018
Lyceum Stage
Come see "Arms Wide Open" perform Roald Dahl's Willy Wonka Jr! This is a timeless story of the world-famous candy man and his quest to find an heir is a golden ticket to adventure!
/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/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.