Calendar

Jan 2018
  • S
  • M
  • T
  • W
  • T
  • F
  • S
  •  
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31


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 GROUP By `s`.`show_id` ORDER BY STR_TO_DATE( `s`.`end_date`, '%m/%d/%Y' ) ASC
Castle Theater
January 25, 2018
Schaefer International Gallery
January 27, 2018
FREE ADMISSION
Castle Theater
January 28, 2018
Castle Theater
February 01, 2018
Yokouchi Pavilion & Courtyard
February 03, 2018
FREE ADMISSION
McCoy Studio Theater
February 02 - February 03, 2018
Castle Theater
February 04, 2018
FREE ADMISSION
Castle Theater
February 08, 2018
Castle Theater
February 11, 2018
Schaefer International Gallery
February 15, 2018
FREE ADMISSION
McCoy Studio Theater
February 16, 2018
Castle Theater
February 17 - February 18, 2018
Schaefer International Gallery
February 22, 2018
FREE ADMISSION
Yokouchi Pavilion & Courtyard
February 23, 2018
Castle Theater
February 24, 2018
Schaefer International Gallery
March 01, 2018
Castle Theater
March 03, 2018
McCoy Studio Theater
March 03, 2018
Castle Theater
March 08, 2018
Schaefer International Gallery
March 09, 2018
FREE ADMISSION
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 08, 2018
Castle Theater
April 13, 2018
Castle Theater
April 20, 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