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/1568311202_header_image_s44_chopin_thumb_extension1.png
September 13 - October 6, 2019
Lyceum Space
Join beloved artist Hershey Felder at a strictly limited engagement celebrating one of the world’s greatest composers in Hershey Felder as Monsieur Chopin.
/home/sdreporg/public_html/images/shows/1557955237_header_image_s44_thumbnails_hombres.png
October 3 - October 27, 2019
Lyceum Stage
A hilarious new comedy from Culture Clash co-founder Herbert Siguenza that mixes The Importance of Being Earnest, The School for Wives, a Narco Telenovela and lots of festive Mexican songs to sing along to!
/home/sdreporg/public_html/images/shows/1568750448_header_image_recover-me-thumb.png
October 14, 2019
Lyceum Stage
Artists from Amigos Del Rep, TuYo, MaArte Theatre Collective, Diversionary, Blindspot Collective, Cygnet Theatre and Friends of Recover Me present a collection of short performances centered around mental health and mental illness.
/home/sdreporg/public_html/images/shows/1568842875_header_image_aliens-thumb.png
October 15, 2019
Lyceum Stage
A sci-fi Latino noir solo show written and performed by MAP Fund award-winning performance artist JOSÉ TORRES-TAMA.
/home/sdreporg/public_html/images/shows/1566598500_header_image_jungle-book-thumb.png
November 9 - November 10, 2019
Lyceum Stage
Last season’s world premiere is back by popular demand! SDB’s take on the Rudyard Kipling’s beloved adventure tale of an orphaned boy lights up the Lyceum stage with originality and boundless energy.
/home/sdreporg/public_html/images/shows/1557955215_header_image_s44_thumbnails_truths.png
November 14 - December 8, 2019
Lyceum Space
The inspiring true story of American hero Gordon Hirabayashi, a young man who defied an unjust order to report to an internment camp, and fought for 50 years to right this wrong. 
/home/sdreporg/public_html/images/shows/1557955188_header_image_s44_thumbnails_humans.png
January 8 - February 2, 2020
Lyceum Stage
This uproariously funny and deeply chilling drama takes place during a Thanksgiving dinner that reveals the hopes and heartbreaks of a modern American family. Winner of the 2016 Tony Award for Best Play.
/home/sdreporg/public_html/images/shows/1557955163_header_image_s44_thumbnails_joy.png
March 5 - March 29, 2020
Lyceum Space
Inspired by the epic legends of Indian history, this wildly entertaining story of palace intrigue and betrayal features sword fights, narrow escapes and sparks of revolution that culminates in a breathtaking conclusion! 
/home/sdreporg/public_html/images/shows/1557955084_header_image_s44_thumbnails_paris.png
May 7 - May 31, 2020
Lyceum Stage
A personal journey through the magic of Paris and its greatest composer, Claude Debussy.