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/1427741222_header_image_399631c22da29a020aca976a34a4b9a929154ce9.png
February 16 - May 11, 2015
Lyceum Space
Free concerts at noon every other Monday from fall through Spring.  
/home/sdreporg/public_html/images/shows/1425930561_header_image_ProjectEdeline.jpeg
April 3, 2015
Lyceum Stage
We invite you to join us as we campaign to help Haiti. To raise awareness of and funds for the Institute, the young, classically trained opera singer Kasondra Kazanjian shares the stage with 2013 America’s Got Talent finalist Branden James -- together, they lend Project Edeline their voices.
/home/sdreporg/public_html/images/shows/1425944790_header_image_IntoWoodsAVI.jpg
April 11 - April 18, 2015
Lyceum Stage
CYC Theatre, the group that brought you hit productions at the Lyceum Theatre like RENT, Shrek and Les Miz and voted “Best Theatre Group” on the San Diego A-List for three consecutive years, presents Stephen Sondheim’s masterpiece musical, 'Into the Woods'.
/home/sdreporg/public_html/images/shows/1426288971_header_image_cirquetacularthumbnail.jpg
April 19, 2015
Lyceum Stage
The Circus Collective of San Diego presents “Cirquetacular! The Circus Collective is proud to include guest performances by Lindley Lopez Circus and Kruciaal Element Dance Company.  This program is presented in cooperation with Fern Street Circus and is funded in part by Horton Plaza Theater Foundation, an organization funded by the City of San Diego Special Promotion Programs.
/home/sdreporg/public_html/images/shows/1419286233_header_image_PeterPan_Jr3- Copy.jpg
April 24 - May 3, 2015
Lyceum Stage
Arms Wide Open is excited to perform their fifth annual production, Disney's Peter Pan Jr. where you will be taken to Never Land with Wendy, Michael and John as they go on a magical adventure with Peter Pan and Tinkerbell.    
X_O8rQvyQCE