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)
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!
/home/sdreporg/public_html/images/shows/1513220556_header_image_Schlomo 220x220.jpg
April 3 - April 22, 2018
Lyceum Stage
The family musical that takes us on an odyssey through the triumphs and challenges of a cultural phenomenon, Rabbi Shlomo Carlebach.