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/1428610195_header_image_2015_Enchanted - Copy.jpg
May 28 - May 31, 2015
Lyceum Space
Mojalet Dance Collective presents Enchanted and Endangered, an original Contemporary Dance  performance including Aerial Work with the focus on the Environment  regarding Preservation of our forest and Respecting nature.
/home/sdreporg/public_html/images/shows/1429736989_header_image_Sun _Cafe_AVIjpg.jpg
June 25 - June 28, 2015
Lyceum Space
A new perspective on life growing up Japanese- or Chines-American in San Diego, through the eyes of people who lived it and an iconic Cafe that saw it all.
__Xj9PU387g