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/1510527842_header_image_La Pastorela 220.jpg
December 7 - December 17, 2017
Lyceum Stage
Southern California’s favorite holiday show, where devils and angels battle it out to preserve Christmas and its spirit for new generations. (In English with traditional Spanish holiday carols)
/home/sdreporg/public_html/images/shows/1507163338_header_image_WlliyWonka_Thumb.jpg
March 2 - March 11, 2018
Lyceum Stage
Come see "Arms Wide Open" perform Roald Dahl's Willy Wonka Jr! This is a timeless story of the world-famous candy man and his quest to find an heir is a golden ticket to adventure!

Facebook