Calendar

Dec 2016


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
December 10 - December 11, 2016
McCoy Studio Theater
December 16, 2016
McCoy Studio Theater
December 17, 2016
Castle Theater
December 17, 2016
Castle Theater
December 21, 2016
Castle Theater
December 13 - December 28, 2016
Castle Theater
December 29, 2016
McCoy Studio Theater
January 07, 2017
McCoy Studio Theater
January 11, 2017
McCoy Studio Theater
January 13, 2017
Castle Theater
January 14, 2017
Schaefer International Gallery
January 15, 2017
Castle Theater
January 15, 2017
Castle Theater
January 16 - January 17, 2017
Castle Theater
January 19, 2017
A&B Amphitheater
January 20, 2017
Castle Theater
January 21, 2017
Castle Theater
January 26, 2017
Castle Theater
January 27, 2017
McCoy Studio Theater
January 28, 2017
Castle Theater
January 28, 2017
McCoy Studio Theater
February 01, 2017
Castle Theater
February 07, 2017
Castle Theater
February 09, 2017
Castle Theater
February 16, 2017
Castle Theater
February 22, 2017
Castle Theater
February 23, 2017
Castle Theater
February 24, 2017
McCoy Studio Theater
February 26, 2017
A&B Amphitheater
February 28, 2017
Schaefer International Gallery
March 04, 2017
FREE ADMISSION
Castle Theater
March 05, 2017
McCoy Studio Theater
March 16, 2017
McCoy Studio Theater
March 18, 2017
A&B Amphitheater
March 24, 2017
Castle Theater
March 30, 2017
The Dunes at Maui Lani
April 22, 2017
A&B Amphitheater
May 13, 2017
Yokouchi Pavilion & Courtyard
June 17, 2017
Schaefer International Gallery
June 24, 2017
FREE ADMISSION

DISPLAY By Category

PAST EVENTS