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
Teatro Máscara Mágica presents "Pastorela de la Familia"
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.
Tickets and info
/home/sdreporg/public_html/images/shows/1544399697_header_image_Ritmos-thumbnail.png
February 15 - February 17, 2019
San Diego Ballet presents "Ritmos Latinos: Que Bonito Amor"
Lyceum Stage
  SDB’s annual celebration of Latin Music brings three of San Diego Ballet’s signature ballets together in one program!
Tickets and info
/home/sdreporg/public_html/images/shows/1544400056_header_image_Movida_Reception.jpg
February 16, 2019
San Diego Ballet Ritmos Latinos Champagne Reception
Lyceum Stage
Mingle with the artists from San Diego Ballet and Artistic Director, Javier Velasco, as we celebrate in the Lyceum Lobby post show.
Tickets and info
/home/sdreporg/public_html/images/shows/1544401631_header_image_Jazz-dance-thumbnail.png
May 24 - May 26, 2019
San Diego Ballet presents "Jazz/Dance: Song of Songs"
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.  
Tickets and info
/home/sdreporg/public_html/images/shows/1544401869_header_image_JD_Reception.jpg
May 25, 2019
San Diego Ballet Jazz/Dance Champagne Reception
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.
Tickets and info

Facebook