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/1460593135_header_image_SDTONIGHT_thumb.jpg
May 10 - August 4, 2016
Lyceum Stage
Be in the audience for the most spectacular TV show in San Diego history, "San Diego Tonight!".
/home/sdreporg/public_html/images/shows/1463614339_header_image_Peter _Pan and_ Wendy_THUMB.jpg
May 25, 2016
Lyceum Space
The classic tale of the boy who refuses to grow up, Peter Pan and Wendy is adapted by Doug Rand from the original by J.M. Barrie.
/home/sdreporg/public_html/images/shows/1459985207_header_image_circustantial_AVI.jpg
May 27 - May 29, 2016
Lyceum Space
The Circus Collective of San Diego is back at the Lyceum Theater with a new show! Crime fighting Inspector Gibbs has mystery to solve in the film noir inspired Circustantial Evidence. 
/home/sdreporg/public_html/images/shows/1461018436_header_image_BillyElliot_thumb.jpg
May 28 - June 5, 2016
Lyceum Stage
BILLY ELLIOT has won the hearts of millions since it opened in London’s West End, becoming one of the most beloved, award-winning shows on stage today. 
/home/sdreporg/public_html/images/shows/1460502197_header_image_STARMERMAID_AVI.jpg
June 11 - June 19, 2016
Lyceum Stage
Based on one of Hans Christian Anderson's most beloved stories and the classic animated film, Disney's The Little Mermaid is truly a love story for the ages
/home/sdreporg/public_html/images/shows/1460684871_header_image_SME_thumb.jpg
June 17 - June 18, 2016
Lyceum Space
“THE SOUL MATE EXPERIMENT” the romantic comedy is a modern day tale of two people who meet at a friend’s wedding anniversary celebration and are struck with an immediate attraction and fall in love with the idea of marriage.
tps://www.facebook.com/SanDiegoREP/videos/10153891455402667/