Events

SELECT `s`.show_id, STR_TO_DATE( `s`.start_date, '%m/%d/%Y' ) AS start_date, STR_TO_DATE( `s`.end_date, '%m/%d/%Y' ) AS end_date, UPPER(DATE_FORMAT(STR_TO_DATE( `s`.start_date, '%m/%d/%Y' ), '%M %d %Y')) AS start_day, UPPER(DATE_FORMAT(STR_TO_DATE( `s`.end_date, '%m/%d/%Y' ), '%M %d, %Y')) AS end_day, UPPER(DATE_FORMAT(STR_TO_DATE( `s`.start_date, '%m/%d/%Y' ), '%d')) AS day, UPPER(DATE_FORMAT(STR_TO_DATE( `s`.start_date, '%m/%d/%Y' ), '%b')) AS month, `s`.title, `s`.post_header, `s`.short_description, `s`.description, `s`.status, `s`.single_ticket, `s`.subscribe_show_listing, `s`.p_meta_keywords, `s`.p_meta_desc, `s`.back_image_credit, `s`.is_free, `s`.heading_picture, `s`.heading_picture_alt, `s`.background_picture, `s`.background_image, `s`.list_image, `s`.short_title, `s`.show_seo, `s`.event_type, `s`.running_time, `s`.group_event, `s`.ticket_link, `s`.related_show, `s`.quote, `short_cuts`.`source` AS `short_cuts`, `venue`.*, events.e_time, events.e_end_time FROM `shows` `s` LEFT JOIN `venue` ON `venue`.`v_id`=`s`.`show_venue` LEFT JOIN `events` ON `events`.`e_show_id`=`s`.`show_id` LEFT JOIN short_cuts ON short_cuts.destination = CONCAT('event-detail.php?id=', `s`.`show_id`) WHERE 1=1 AND STR_TO_DATE( `s`.`end_date`, '%m/%d/%Y' )>= CURDATE() AND (YEAR(STR_TO_DATE(`s`.`start_date`,'%m/%d/%Y')) >= YEAR(CURDATE()) OR YEAR(STR_TO_DATE(`s`.`end_date`,'%m/%d/%Y')) >= YEAR(CURDATE()) ) AND `s`.status=1 AND STR_TO_DATE(events.e_date, '%m/%d/%Y') > DATE_SUB(NOW(),INTERVAL 2 DAY) AND `s`.`show_type`='1' GROUP By `s`.`show_id` ORDER BY STR_TO_DATE( `s`.`end_date`, '%m/%d/%Y' ) ASC
Castle Theater
October 26, 2017
Castle Theater
October 29, 2017
McCoy Studio Theater
November 02, 2017
McCoy Studio Theater
November 04, 2017
McCoy Studio Theater
November 16, 2017
McCoy Studio Theater
November 18, 2017
McCoy Studio Theater
November 21, 2017
FREE ADMISSION
Castle Theater
November 25, 2017
Yokouchi Pavilion and A&B Amphitheater
December 02, 2017
McCoy Studio Theater
December 16, 2017
McCoy Studio Theater
December 29, 2017
Castle Theater
December 30, 2017
McCoy Studio Theater
January 13, 2018
Castle Theater
January 20, 2018
Castle Theater
January 25, 2018
Castle Theater
February 01, 2018
Castle Theater
February 11, 2018
Castle Theater
February 17 - February 18, 2018
McCoy Studio Theater
February 23 - February 24, 2018
McCoy Studio Theater
March 03, 2018
McCoy Studio Theater
March 10, 2018
Castle Theater
March 17, 2018
Castle Theater
March 28, 2018
McCoy Studio Theater
March 29, 2018
Castle Theater
April 13, 2018
Castle Theater
April 28, 2018
A&B Amphitheater
May 19, 2018
Yokouchi Pavilion & Courtyard
June 02, 2018
Yokouchi Pavilion and A&B Amphitheater
August 18, 2018

DISPLAY By Category

PAST EVENTS