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/1471904762_header_image_s41_Manifest_web_thumbnail.jpg
September 15 - October 9, 2016
Lyceum Space
From a founding member of Culture Clash and the award-winning writer of El Henry, A Weekend with Pablo Picasso and Steal Heaven comes an outrageously hilarious adaptation of Moliere's The Imaginary Invalid.
/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/1471395578_header_image_ENCHANTED16_Thumb.jpg
October 14 - October 16, 2016
Lyceum Space
Mojalet Dance Collective presents Enchanted and Endangered, an original contemporary dance performance with aerial work and acting with the focus on environmental issues regarding preservation of our forest and respecting nature.
/home/sdreporg/public_html/images/shows/1470334168_header_image_el cipitio thumbnail.jpg
October 17, 2016
Lyceum Space
Original Culture Clash members, Herbert Siguenza and Ric Salinas (both Salvadorans), team up for this darkly comic work based on the novel "The Lives and Times of El Cipitío" by Randyl Ertll.
/home/sdreporg/public_html/images/shows/1471904832_header_image_s41_Disgraced_web_thumbnail.jpg
October 20 - November 13, 2016
Lyceum Stage
A Pulitzer Prize winning drama that dares to face the truth about the stories we tell our friends, the secrets we tell our lovers and the lies we tell ourselves.
/home/sdreporg/public_html/images/shows/1474680587_header_image_fun_pole_fitness_logo220x220.jpg
October 29, 2016
Lyceum Space
Fun Pole Fitness presents their 11th semi-annual charity recital dedicated to our SOFA's: Significant Others, Friends & Family and Awesome Admirers of Pole Fitness! 
/home/sdreporg/public_html/images/shows/1474660395_header_image_Historias thumbnail.jpg
October 31 - November 1, 2016
Lyceum Space
Amigos del REP's elaborate and unique cultural annual event that will entertain, educate and enlighten families of all ages about the similarities and difference between Halloween and Dia de los Muertos. 
/home/sdreporg/public_html/images/shows/1471904754_header_image_JOPLIN_THUMB.jpg
November 18 - November 20, 2016
Lyceum Stage
Folklore meets Funk! An ancient tale of a magical bird of fire comes to life with an contemporary twist.
/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/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/1471913268_header_image_RITMOS_THUMB.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/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/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/