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/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/