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
Lyceum Space
Proving that a great show is always in fashion, Love, Loss, and What I Wore has become an international hit.  
/home/sdreporg/public_html/images/shows/1423862563_header_image_WithoutWalls_AVI.jpg
March 10, 2015
Lyceum Space
MidraSHOW is a new Jewish theatrical project that aims to make Jewish concepts relevant and personal using theater, film, and visual arts.
/home/sdreporg/public_html/images/shows/1419286233_header_image_PeterPan_Jr3- Copy.jpg
April 24 - May 3, 2015
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.    
fPfDg38YVkQ