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/1471983408_header_image_s41_North_web_thumbnails.jpg
March 30 - April 23, 2017
Lyceum Space
 Award-winning playwright Karen Zacarias’ adaptation of a quest of epic proportions that looks at the dreams shared on both sides of the border. 
/home/sdreporg/public_html/images/shows/1480722486_header_image_HALO_THUMB.jpg
March 30 - April 9, 2017
Lyceum Space
Based on historical research and personal interviews, Halo-Halo creates a moving and eye-opening window into our city.
/home/sdreporg/public_html/images/shows/1488502133_header_image_MARGIN_THUMB_NEW220.jpg
April 14 - 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.
tps://www.facebook.com/SanDiegoREP/videos/10153891455402667/