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/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/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
/home/sdreporg/public_html/images/shows/1547513613_header_image_joseph_thumbnail.png
June 14 - June 23, 2019
Arms Wide Open presents "Joseph and the Amazing Technicolor Dreamcoat"
Lyceum Stage
A truly timeless Old Testament tale, Joseph and the Amazing Technicolor Dreamcoat is set to a multitude of musical genres, spanning from country-western and calypso to bubble-gum pop and rock and roll.
Tickets and info

Facebook