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
Turning Tydes Theatre Company presents "Wicked Wizards"
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! 
Tickets and info
/home/sdreporg/public_html/images/shows/1528235939_header_image_Light_Within_Thumbnail.png
July 20 - July 21, 2018
transcenDANCE Youth Arts Project presents "Light Within the Cracks"
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[...]
Tickets and info
/home/sdreporg/public_html/images/shows/1529267773_header_image_wizard220x220.jpg
August 4 - August 12, 2018
Star Repertory Theatre presents "The Wizard of Oz"
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.  
Tickets and info

Facebook