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/1452553551_header_image_waistwatcher-sdrep-sitegraphic2.jpg
February 24 - March 27, 2016
Lyceum Space
Set in Cook's Women's Gym, and in the same vein as Menopause the Musical®, WaistWatchers The Musical! takes a hilarious and lighthearted look at four women dealing with their obsession with food and assorted body image issues.
/home/sdreporg/public_html/images/shows/1449531580_header_image_MERMAID16_AVI.jpg
April 15 - April 24, 2016
Lyceum Stage
Featuring all of your favorite songs, incredible talent, beautiful choreographed numbers and even an “Under The Sea Band”.  This show is for ALL ages and is directed by Christopher Rubio who has pulled out all the stops for our best production yet. 
c24-Yc1AeHs