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/1496701727_header_image_UWM_THUMB.jpg
July 21 - July 22, 2017
Lyceum Space
transcenDANCE Youth Arts Project is proud to present United We Move, the culminating event for the transcenDANCE Performance Group that shares personal narratives, celebrates diversity, and creates an inspiring vision for moving toward equality.
/home/sdreporg/public_html/images/shows/1499462120_header_image_LB_books_dog_THUMB.jpg
August 3 - August 13, 2017
Lyceum Space
A fabulously fun international award-winning musical based on the adored movie, Legally Blonde The Musical, follows the transformation of Elle Woods as she tackles stereotypes, snobbery and scandal in pursuit of her dreams.
tps://www.facebook.com/SanDiegoREP/videos/10153891455402667/