Calendar

Mar 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`.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
March 23, 2019
Castle Theater
March 24, 2019
McCoy Studio Theater
March 24, 2019
McCoy Studio Theater
March 28, 2019
Castle Theater
March 27 - March 28, 2019
McCoy Studio Theater
March 29, 2019
McCoy Studio Theater
March 30, 2019
Castle Theater
April 01, 2019
FREE ADMISSION
Castle Theater
April 02, 2019
FREE ADMISSION
Castle Theater
April 04, 2019
A&B Amphitheater
April 05, 2019
FREE ADMISSION
Castle Theater
April 06, 2019
Castle Theater
April 11, 2019
McCoy Studio Theater
April 11, 2019
A&B Amphitheater
April 12, 2019
Events Lawn
April 13, 2019
Castle Theater
April 16, 2019
FREE ADMISSION
A&B Amphitheater
April 19, 2019
Castle Theater
April 23, 2019
FREE ADMISSION
Schaefer International Gallery
April 27, 2019
FREE ADMISSION
McCoy Studio Theater
April 28, 2019
Castle Theater
May 02, 2019
Castle Theater
May 03, 2019
Castle Theater
May 04 - May 05, 2019
Castle Theater
May 15, 2019
FREE ADMISSION
A&B Amphitheater
May 18, 2019
Castle Theater
May 20, 2019
FREE ADMISSION
A&B Amphitheater
June 23, 2019
FREE ADMISSION
A&B Amphitheater
June 23, 2019
FREE ADMISSION
Castle Theater
July 21, 2019
A&B Amphitheater
September 29, 2019
FREE ADMISSION

DISPLAY By Category

PAST EVENTS