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
April 30, 2016
Lyceum Stage
... yes, as in DANCING with, on, and around a POLE! In their 10th show, San Diego's Fun Pole Fitness brings their renditions of what pole dancing might have looked like in the decades pre-2K, before it became the growing mainstream form of art and sport it has evolved to.
May 10, 2016
Lyceum Stage
Be in the audience for the most spectacular TV show in San Diego history, "San Diego Tonight!".
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. 
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. 
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
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.