Calendar

Aug 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
August 31, 2019
McCoy Studio Theater
September 06, 2019
A&B Amphitheater
September 06, 2019
FREE ADMISSION
McCoy Studio Theater
September 12, 2019
McCoy Studio Theater
September 13, 2019
Castle Theater
September 14, 2019
Schaefer International Gallery
September 18, 2019
FREE ADMISSION
Yokouchi Pavilion & Courtyard
September 21, 2019
A&B Amphitheater
September 27 - September 28, 2019
McCoy Studio Theater
September 28, 2019
A&B Amphitheater
September 29, 2019
FREE ADMISSION
Castle Theater
October 06, 2019
Castle Theater
October 10, 2019
McCoy Studio Theater
October 10, 2019
McCoy Studio Theater
October 11, 2019
McCoy Studio Theater
October 12, 2019
Yokouchi Pavilion & Courtyard
October 12, 2019
Schaefer International Gallery
October 16, 2019
FREE ADMISSION
Schaefer International Gallery
October 17, 2019
FREE ADMISSION
Castle Theater
October 20, 2019
Castle Theater
October 25, 2019
McCoy Studio Theater
November 08, 2019
Castle Theater
November 14, 2019
McCoy Studio Theater
November 25, 2019
Castle Theater
December 01, 2019
Castle Theater
December 02, 2019
Yokouchi Pavilion and A&B Amphitheater
December 07, 2019
Yokouchi Pavilion & Courtyard
December 13, 2019
Castle Theater
December 29, 2019
Castle Theater
January 02, 2020
A&B Amphitheater
January 03, 2020
Castle Theater
March 27, 2020

DISPLAY By Category

PAST EVENTS