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
November 25, 2017
Yokouchi Pavilion and A&B Amphitheater
December 02, 2017
McCoy Studio Theater
December 16, 2017
Castle 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
Schaefer International Gallery
January 27, 2018
FREE ADMISSION
Castle Theater
February 01, 2018
Castle Theater
February 08, 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
The Dunes at Maui Lani
April 07, 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