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/1504133479_header_image_SB_compact.jpg
October 13 - October 29, 2017
Lyceum Space
Six kids face off in the battle of their lives. The competition is intense. The words are outrageous. Let the spelling (and the singing) begin!
/home/sdreporg/public_html/images/shows/1507934102_header_image_PKGFB_THUMB.jpg
November 17 - November 19, 2017
Lyceum Stage
During its 15th Anniversary Season DANCE SPIRIT MAGAZINE calls The PGK Dance Project San Diego’s PREMIERE Contemporary Dance Company presenting their SPECTACULAR, WORLD PREMIERES Program featuring 6 fresh, inventive works by 4 award winning choreographers including Viviana Alcazar-Haynes, Alyssa Junious, Jennifer Puls and Founding Director, Peter G. Kalivas.
/home/sdreporg/public_html/images/shows/1507163338_header_image_WlliyWonka_Thumb.jpg
March 2 - March 11, 2018
Lyceum Stage
Come see "Arms Wide Open" perform Roald Dahl's Willy Wonka Jr! This is a timeless story of the world-famous candy man and his quest to find an heir is a golden ticket to adventure!
tps://www.facebook.com/SanDiegoREP/videos/10153891455402667/