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/1541814766_header_image_Pastorela_thumbnail_220x220.jpg
December 13 - December 23, 2018
Lyceum Space
The newest in Teatro Máscara Mágica’s award-winning series of Mexican-inspired Christmas musicals, Pastorela de la Familia once again features the timeless battle between Lucifer’s forces of evil and Michael the Archangel’s champions of goodness set in today’s world of chaos and hope.
/home/sdreporg/public_html/images/shows/1544399697_header_image_Ritmos-thumbnail.png
February 15 - February 17, 2019
Lyceum Stage
  SDB’s annual celebration of Latin Music brings three of San Diego Ballet’s signature ballets together in one program!
/home/sdreporg/public_html/images/shows/1544400056_header_image_Movida_Reception.jpg
February 16, 2019
Lyceum Stage
Mingle with the artists from San Diego Ballet and Artistic Director, Javier Velasco, as we celebrate in the Lyceum Lobby post show.
/home/sdreporg/public_html/images/shows/1544401631_header_image_Jazz-dance-thumbnail.png
May 24 - May 26, 2019
Lyceum Stage
  WORLD PREMIERE! Featuring a score by jazz legend Charles McPherson, SONG OF SONGS celebrates a poem beloved by people from all walks of life and beliefs.  
/home/sdreporg/public_html/images/shows/1544401869_header_image_JD_Reception.jpg
May 25, 2019
Lyceum Stage
Mingle with the artists from San Diego Ballet, Jazz Icon, Charles McPherson and Artistic Director, Javier Velasco, as we celebrate our last show of our 29th season.

Facebook