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
February 16 - May 11, 2015
Free concerts at noon every other Monday from fall through Spring.
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.
/home/sdreporg/public_html/images/shows/1428610195_header_image_2015_Enchanted - Copy.jpg
May 28 - May 31, 2015
Mojalet Dance Collective presents Enchanted and Endangered, an original Contemporary Dance performance including Aerial Work with the focus on the Environment regarding Preservation of our forest and Respecting nature.
/home/sdreporg/public_html/images/shows/1428353151_header_image_Paul Babici and Yale Strom in Iasi, Romania - Copy.jpg
May 31, 2015
2nd Avenue Klezmer features an all-star cast of musicians. The popular quintet features the theatrical Yiddish vocals of favorite Deborah Davis, along with virtuoso clarinetist Robert Zelickman, guitarist Jiri Svoboda, drummer Bob Weller and contrabass legend Bertram Turetzky.
/home/sdreporg/public_html/images/shows/1428354661_header_image_Hot Pstromi 2012 - Copy.jpg
June 8, 2015
This features Ms. Barton Pine joining illustrious Festival favorites Yale Strom and Hot Pstromi in presenting klezmer music with scintillating improvisation and virtuosic technique. Opening the program will be the talented singers of the San Diego Jewish Men’s choir under the direction of Ruth Weber who will be performing selections from their upcoming newest CD.
/home/sdreporg/public_html/images/shows/1428357861_header_image_Women of Valor dream.jpg