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/1433972833_header_image_Spring_AVI.jpg
July 3 - July 19, 2015
Lyceum Space
Spring Awakening, a new Broadway musical by Duncan Sheik and Stephen Sater is about young teens trying to learn to live and love in an age of repressive morality.  Based on the original play by Stephen Wedekind, this powerful musical explores the most basic humanity and the struggles of youth. 
/home/sdreporg/public_html/images/shows/1434154089_header_image_ME_WE_AVI.jpg
August 7 - August 9, 2015
Lyceum Space
transcenDANCE Youth Arts Project presents ME to WE, a CREATE program teen dance performance, in collaboration with the Museum of Photographic Arts (MOPA) and The Good Planet Foundation.
9831i_ihcw8