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) GROUP By `s`.`show_id` ORDER BY STR_TO_DATE( `s`.`end_date`, '%m/%d/%Y' ) ASC
McCoy Studio Theater
October 18, 2018
FREE ADMISSION
Castle Theater
October 25, 2018
McCoy Studio Theater
October 26, 2018
Schaefer International Gallery
October 27, 2018
FREE ADMISSION
Castle Theater
October 28, 2018
Castle Theater
November 01, 2018
McCoy Studio Theater
November 09 - November 10, 2018
Yokouchi Pavilion & Courtyard
November 10, 2018
Yokouchi Pavilion & Courtyard
November 17, 2018
McCoy Studio Theater
November 17, 2018
Castle Theater
November 18, 2018
McCoy Studio Theater
November 24, 2018
A&B Amphitheater
November 28, 2018
Yokouchi Pavilion and A&B Amphitheater
December 01, 2018
McCoy Studio Theater
November 30 - December 02, 2018
Yokouchi Pavilion & Courtyard
December 02, 2018
Castle Theater
December 02, 2018
Castle Theater
December 13, 2018
McCoy Studio Theater
December 14, 2018
Yokouchi Pavilion & Courtyard
December 16, 2018
A&B Amphitheater
December 27, 2018
McCoy Studio Theater
December 29, 2018
Castle Theater
January 03, 2019
Castle Theater
January 04, 2019
McCoy Studio Theater
January 12, 2019
Castle Theater
January 18, 2019
Castle Theater
January 23, 2019
McCoy Studio Theater
January 31, 2019
McCoy Studio Theater
February 07, 2019
Castle Theater
February 08, 2019
McCoy Studio Theater
February 23, 2019
Castle Theater
February 28, 2019
March 03, 2019
Castle Theater
March 14, 2019
McCoy Studio Theater
March 15, 2019
McCoy Studio Theater
March 23, 2019
The Dunes at Maui Lani
April 06, 2019
Castle Theater
April 11, 2019
A&B Amphitheater
May 18, 2019

DISPLAY By Category

PAST EVENTS