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/1439420683_header_image_Pitch_AVI.jpg
September 2 - September 6, 2015
Lyceum Space
A comedic journey through the not so funny world of pitching Latino programming to culture blind Studio execs - or why there aren’t Latino shows on television.
/home/sdreporg/public_html/images/shows/1439508334_header_image_FAT2015_AVI.JPG
September 6, 2015
Lyceum Space
F.A.T(Fashion Art Talent) Extravaganza is an annual cabaret of exciting Fashionistas, Artist and Talent displayed in a provocative showcase for creative entrepreneurs, visionaries and aspiring artist.
/home/sdreporg/public_html/images/shows/1437513605_header_image_PGK_AVI.jpg
September 18 - September 20, 2015
Lyceum Stage
San Diego's most widely-travelled top-tier contemporary dance company performs world premieres by 9 different, exciting choreographers from across the US. September 18 and 19 at 7:30pm and September 20 at 2pm.
/home/sdreporg/public_html/images/shows/1440455968_header_image_RJ2012web1.jpg
October 16 - October 18, 2015
Lyceum Stage
Come and experience this rapturous evening devoted to young love and to those who remember its triumphs and tragedies.
/home/sdreporg/public_html/images/shows/1440534385_header_image_Jazz.jpg
February 5 - February 7, 2016
Lyceum Stage
This mixed repertoire of dance features inspired pieces set to the live music of San Diego Jazz icon, Gilbert Castellanos.
H-tJOqiYS6Q