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/1498600950_header_image_FRINGE_AVI.jpeg
June 22 - July 2, 2017
San Diego International Fringe Festival
Lyceum Space
San Diego International Fringe Festival is a non-profit project of CONTACT ARTS, in association with the Actors Alliance of San Diego, designed to help provide a platform for artists while also helping the community as a whole - boosting arts and culture within the gorgeous City of San Diego. http://sdfringe.org/contact/
Tickets and info
/home/sdreporg/public_html/images/shows/1496701727_header_image_UWM_THUMB.jpg
July 21 - July 22, 2017
transcenDANCE Youth Arts Project Presents "United We Move"
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.
Tickets and info
tps://www.facebook.com/SanDiegoREP/videos/10153891455402667/