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
December 10 - December 20, 2015
Teatro Máscara Mágica in partnership with the Black Ensemble Theatre is presenting La Pastorela, the real holiday tradition is back celebrating our 26th Anniversary
December 11 - December 20, 2015
The award-winning ACT-San Diego presents Charles Dickens' A Christmas Carol, directed by veteran actor/director Bernard Baldan. This is a fresh adaptation of the original old classic. A fun holiday show perfect for all ages!
December 26, 2015 - January 10, 2016
In 2009, CYC Theatre made history with the world’s first-ever youth theatre production of this iconic musical. Now, in 2015, this award-winning group that brought Les Miserables, Shrek and Spring Awakening to the Lyceum, is bringing this amazing musical back.