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/1537578539_header_image_memories-thumbnail.jpg
November 16 - November 18, 2018
Lyceum Space
Memories of Best Friends… who would have thought, as adults, they would be enemies?
/home/sdreporg/public_html/images/shows/1540501957_header_image_heathers-thumbnail.png
November 23 - November 25, 2018
Lyceum Space
Based on the classic 1989 film, Westerberg High is ruled by Heather, Heather, and Heather, the hottest and cruelest girls in all of Ohio.
/home/sdreporg/public_html/images/shows/1540423524_header_image_Sundry-thumbnail.jpg
November 30 - December 2, 2018
Lyceum Space
Mojalet Dance Collective presents Mixed Sundry II, a performance of athletic, powerful movement by Faith Jensen-Ismay and guest choreographer, Blythe Barton.
/home/sdreporg/public_html/images/shows/1541814766_header_image_Pastorela_thumbnail_220x220.jpg
December 13 - December 23, 2018
Lyceum Space
The newest in Teatro Máscara Mágica’s award-winning series of Mexican-inspired Christmas musicals, Pastorela de la Familia once again features the timeless battle between Lucifer’s forces of evil and Michael the Archangel’s champions of goodness set in today’s world of chaos and hope.

Facebook