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
April 3, 2015
We invite you to join us as we campaign to help Haiti. To raise awareness of and funds for the Institute, the young, classically trained opera singer Kasondra Kazanjian shares the stage with 2013 America’s Got Talent finalist Branden James -- together, they lend Project Edeline their voices.
April 11 - April 18, 2015
CYC Theatre, the group that brought you hit productions at the Lyceum Theatre like RENT, Shrek and Les Miz and voted “Best Theatre Group” on the San Diego A-List for three consecutive years, presents Stephen Sondheim’s masterpiece musical, 'Into the Woods'.
April 19, 2015
The Circus Collective of San Diego presents “Cirquetacular! The Circus Collective is proud to include guest performances by Lindley Lopez Circus and Kruciaal Element Dance Company. This program is presented in cooperation with Fern Street Circus and is funded in part by Horton Plaza Theater Foundation, an organization funded by the City of San Diego Special Promotion Programs.
April 24 - May 3, 2015
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.