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/1419299444_header_image_Loveloss_wore.jpg
February 25 - March 22, 2015
Philip Roger Roy & Dana Matthow Present 'Love, Loss, and What I Wore'
Lyceum Space
Proving that a great show is always in fashion, Love, Loss, and What I Wore has become an international hit.  
Tickets and info
/home/sdreporg/public_html/images/shows/1423862563_header_image_WithoutWalls_AVI.jpg
March 10, 2015
MidraSHOW Presents 'Without Walls'
Lyceum Space
MidraSHOW is a new Jewish theatrical project that aims to make Jewish concepts relevant and personal using theater, film, and visual arts.
Tickets and info
/home/sdreporg/public_html/images/shows/1419286233_header_image_PeterPan_Jr3- Copy.jpg
April 24 - May 3, 2015
Arms Wide Open Presents "Peter Pan Jr."
Lyceum Stage
Arms Wide Open is excited to perform their fifth annual production, Disney's Peter Pan Jr. where you will be taken to Never Land with Wendy, Michael and John as they go on a magical adventure with Peter Pan and Tinkerbell.    
Tickets and info
fPfDg38YVkQ