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/1527378655_header_image_WW Thumbnail.jpg
July 19 - July 22, 2018
Lyceum Stage
From the group that brought you The Phantom of the Empire and Into the Walker Woods comes the long awaited mash-up of the mega hit musical, WICKED, and the world’s most beloved book and movie series, HARRY POTTER! Featuring songs such as: “No One Names the Wizard”, “Azkaban Life”, and “A Wizard Am I”. Don’t miss your chance to see this two act musical event! 
July 20 - July 21, 2018
Lyceum Space
***VIP event Saturday night!*** San Diego’s own nationally-recognized creative youth development organization, transcenDANCE Youth Arts Project, proudly presents Light Within the Cracks, a dynamic dance theatre production that explores mental health, trauma & resilience.  Light Within the Cracks is a timely artistic work co-created by students that is meant to inspire thought-pr[...]
August 4 - August 12, 2018
Lyceum Stage
Strap on your ruby slippers and join the Scarecrow, the Tin Man, the Lion, Dorothy and her little dog Toto, too, for STAR Repertory Theatre's production of The Wizard of Oz.