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 17 - March 25, 2018
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/1520818416_header_image_MASHED UP THUMB.jpg
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
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
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.