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
Manifest Destinitis: An early California adaptation of Moliere's "The Imaginary Invalid"
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.
Tickets and info
/home/sdreporg/public_html/images/shows/1474309917_header_image_ATHENAEUM_THUMB.jpg
September 19, 2016 - May 8, 2017
Athenaeum Jacobs Mini-Concerts
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!
Tickets and info
/home/sdreporg/public_html/images/shows/1471395578_header_image_ENCHANTED16_Thumb.jpg
October 14 - October 16, 2016
Mojalet Dance Collective Presents "An Enchanted Evening"
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.
Tickets and info
/home/sdreporg/public_html/images/shows/1470334168_header_image_el cipitio thumbnail.jpg
October 17, 2016
El Cipitio
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.
Tickets and info
/home/sdreporg/public_html/images/shows/1471904832_header_image_s41_Disgraced_web_thumbnail.jpg
October 20 - November 13, 2016
Disgraced
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.
Tickets and info
/home/sdreporg/public_html/images/shows/1474680587_header_image_fun_pole_fitness_logo220x220.jpg
October 29, 2016
Fun Pole Fitness Presents "SOFA 11: Holiday Pole Show"
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! 
Tickets and info
/home/sdreporg/public_html/images/shows/1474660395_header_image_Historias thumbnail.jpg
October 31 - November 1, 2016
Historias Tenebrosas
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. 
Tickets and info
/home/sdreporg/public_html/images/shows/1471904754_header_image_JOPLIN_THUMB.jpg
November 18 - November 20, 2016
San Diego Ballet Presents "Joplin and Firebird"
Lyceum Stage
Folklore meets Funk! An ancient tale of a magical bird of fire comes to life with an contemporary twist.
Tickets and info
/home/sdreporg/public_html/images/shows/1471904932_header_image_s41_Dybbuk_web_thumbnail.jpg
November 23 - December 18, 2016
The Dybbuk for Hannah and Sam's Wedding
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.
Tickets and info
/home/sdreporg/public_html/images/shows/1472756210_header_image_SW_2016-new 200x200.jpg
December 2 - December 24, 2016
A Snow White Christmas
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.
Tickets and info
/home/sdreporg/public_html/images/shows/1471905612_header_image_s41_Tchaikovsky_web_thumbnail.jpg
January 12 - February 12, 2017
Our Great Tchaikovsky
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.
Tickets and info
/home/sdreporg/public_html/images/shows/1471913268_header_image_RITMOS_THUMB.jpg
February 17 - February 19, 2017
San Diego Ballet Presents "Ritmos Latinos"
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.
Tickets and info
/home/sdreporg/public_html/images/shows/1471905686_header_image_s41_Strangers_web_thumbnail.jpg
February 23 - March 19, 2017
Sex with Strangers
Lyceum Space
The sensuous and provocative comedy about fame, cyber identity and big ambition is a critical and audience favorite all across America.
Tickets and info
/home/sdreporg/public_html/images/shows/1471983408_header_image_s41_North_web_thumbnails.jpg
March 30 - April 23, 2017
Into The Beautiful North
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. 
Tickets and info
/home/sdreporg/public_html/images/shows/1473705068_header_image_The Roustabouts1.jpg
April 14 - May 7, 2017
The Roustabouts Present "Margin Of Error" by Will Cooper
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.
Tickets and info
/home/sdreporg/public_html/images/shows/1472080654_header_image_SDB_Jazz_220x220.jpg
May 19 - May 21, 2017
San Diego Ballet Presents "An Evening of Jazz & Dance"
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.
Tickets and info
tps://www.facebook.com/SanDiegoREP/videos/10153891455402667/