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/1471904932_header_image_s41_Dybbuk_web_thumbnail.jpg
November 23 - December 18, 2016
Lyceum Space
World-renowned performer Ron Campbell is joined by Klezmer musician Yale Strom in this immersive retelling of the greatest Jewish play in history.
/home/sdreporg/public_html/images/shows/1472756210_header_image_SW_2016-new 200x200.jpg
December 2 - December 24, 2016
Lyceum Stage
This American panto version of the classic fairytale is a fun-filled, family friendly show featuring singing, dancing and interactive fun and magic.
/home/sdreporg/public_html/images/shows/1478894161_header_image_rep220x220warm.jpg
January 8 - January 29, 2017
Lyceum Space
This Tony-nominated, Olivier and Academy Award-winning story isn’t just a battle between the sexes… It’s war. New Fortune Theatre Company proudly presents the San Diego premiere.
/home/sdreporg/public_html/images/shows/1471905612_header_image_s41_Tchaikovsky_web_thumbnail.jpg
January 12 - February 12, 2017
Lyceum Stage
Using his virtuosic signature storytelling and musical stylings, Hershey Felder presents a time bending story of culture and politics around the greatest music ever composed.
/home/sdreporg/public_html/images/shows/1479327450_header_image_RitmosLatinos_WebBoxf-01.jpg
February 17 - February 19, 2017
Lyceum Stage
Samba! Rhumba! Cha-Cha-Cha! Get swept away in the sizzling tempo and rhythms of last year’s smash hit, AUDAZ. performed live by jazz icon, Gilbert Castellanos and San Diego’s hottest Latin Jazz musicians.
/home/sdreporg/public_html/images/shows/1471905686_header_image_s41_Strangers_web_thumbnail.jpg
February 23 - March 19, 2017
Lyceum Space
The sensuous and provocative comedy about fame, cyber identity and big ambition is a critical and audience favorite all across America.
/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/1473705068_header_image_The Roustabouts1.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/