Calendar

Apr 2017
  • 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


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
April 29, 2017
Castle Theater
April 30, 2017
A&B Amphitheater
May 02, 2017
Castle Theater
May 06 - May 07, 2017
Castle Theater
May 09, 2017
FREE ADMISSION
A&B Amphitheater
May 13, 2017
Events Lawn
May 14, 2017
Castle Theater
May 16, 2017
FREE ADMISSION
Castle Theater
May 18, 2017
A&B Amphitheater
May 19, 2017
FREE ADMISSION
Yokouchi Pavilion & Courtyard
May 21, 2017
Castle Theater
May 25, 2017
McCoy Studio Theater
May 25, 2017
Yokouchi Pavilion & Courtyard
June 17, 2017
McCoy Studio Theater
June 22, 2017
A&B Amphitheater
June 25, 2017
FREE ADMISSION
Castle Theater
July 01, 2017
Castle Theater
July 21 - July 23, 2017
Yokouchi Pavilion and A&B Amphitheater
August 18, 2017
Castle Theater
September 09, 2017
Castle Theater
October 09, 2017
A&B Amphitheater
October 15, 2017
FREE ADMISSION

DISPLAY By Category

PAST EVENTS