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`.calendar_view_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
McCoy Studio Theater
December 20, 2019
McCoy Studio Theater
December 21, 2019
McCoy Studio Theater
December 27, 2019
Castle Theater
December 28, 2019
McCoy Studio Theater
December 29, 2019
A&B Amphitheater
January 03, 2020
Haynes & Alexa Higashi Meeting Rooms
January 06, 2020
FREE ADMISSION
Castle Theater
January 16, 2020
Castle Theater
January 23, 2020
McCoy Studio Theater
January 31, 2020
Yokouchi Pavilion and A&B Amphitheater
February 13, 2020
Schaefer International Gallery
February 15, 2020
FREE ADMISSION
Castle Theater
February 15 - February 16, 2020
Castle Theater
February 27, 2020
McCoy Studio Theater
March 12, 2020
McCoy Studio Theater
March 21, 2020
Castle Theater
March 26, 2020
Yokouchi Pavilion and A&B Amphitheater
March 29, 2020
Castle Theater
April 09, 2020
McCoy Studio Theater
April 23, 2020
McCoy Studio Theater
April 24 - April 25, 2020
McCoy Studio Theater
May 09, 2020

DISPLAY By Category

PAST EVENTS