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/1474309917_header_image_ATHENAEUM_THUMB.jpg
September 19, 2016 - May 8, 2017
Lyceum Space
FREE concerts at noon every other Monday from fall through spring . . . no wonder the Mini-Concerts are the longest-running and one of the most popular classical music series at the library!
/home/sdreporg/public_html/images/shows/1488502133_header_image_MARGIN_THUMB_NEW220.jpg
April 19 - May 7, 2017
Lyceum Space
The World premiere of MARGIN OF ERROR by Will Cooper, directed by Rosina Reynolds, and featuring Ruff Yeager playing at the Lyceum Theatre, Horton Plaza from April 15 to May 6.
/home/sdreporg/public_html/images/shows/1478810288_header_image_LION_KING_THUMB.jpg
May 5 - May 14, 2017
Lyceum Space
The Circle Of Life continues…  WELCOME to Arms Wide Open’s production of Disney’s The Lion King Jr. featuring all of your favorite songs, incredible talent, beautiful choreographed numbers and even a special drummers, flyers and “sky dancers”
/home/sdreporg/public_html/images/shows/1472080654_header_image_SDB_Jazz_220x220.jpg
May 19 - May 21, 2017
Lyceum Stage
This mixed repertoire of dance brings back jazz saxophone great Charles McPherson to perform his SWEET SYNERGY SUITE as well as a world premiere in May of 2017.
/home/sdreporg/public_html/images/shows/1491873718_header_image_MINOR_BANNER_AVI.jpg
June 1 - June 3, 2017
Lyceum Stage
MINOR FALL/MAJOR LIFT is a bi-coastal collaboration of live music and dance, featuring all-new choreography by iconic San Diego Choreographer John Malashock and co-produced with Art of Élan.
tps://www.facebook.com/SanDiegoREP/videos/10153891455402667/