Calendar

Dec 2019
  • 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`.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 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
Castle Theater
December 20 - December 21, 2019
McCoy Studio Theater
December 27, 2019
Castle Theater
December 28, 2019
McCoy Studio Theater
December 28, 2019
Castle Theater
December 29, 2019
McCoy Studio Theater
December 29, 2019
Castle Theater
January 02, 2020
A&B Amphitheater
January 03, 2020
A&B Amphitheater
January 04, 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 24, 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
Castle Theater
March 10, 2020
FREE ADMISSION
McCoy Studio Theater
March 12, 2020
McCoy Studio Theater
March 21, 2020
Castle Theater
March 26, 2020
Castle Theater
March 27, 2020
Yokouchi Pavilion and A&B Amphitheater
March 29, 2020
Castle Theater
March 31, 2020
FREE ADMISSION
Castle Theater
April 01, 2020
FREE ADMISSION
Castle Theater
April 07, 2020
FREE ADMISSION
Castle Theater
April 09, 2020
McCoy Studio Theater
April 23, 2020
McCoy Studio Theater
April 24 - April 25, 2020
Castle Theater
April 28, 2020
FREE ADMISSION
Castle Theater
May 06, 2020
FREE ADMISSION
McCoy Studio Theater
May 09, 2020

DISPLAY By Category

PAST EVENTS