Calendar

Jun 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


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
Yokouchi Pavilion and A&B Amphitheater
June 21, 2019
FREE ADMISSION
A&B Amphitheater
June 23, 2019
FREE ADMISSION
McCoy Studio Theater
June 28, 2019
McCoy Studio Theater
June 29, 2019
McCoy Studio Theater
June 30, 2019
Castle Theater
July 19, 2019
Castle Theater
July 21, 2019
A&B Amphitheater
July 26 - July 27, 2019
McCoy Studio Theater
August 01 - August 04, 2019
A&B Amphitheater
August 13 - August 14, 2019
McCoy Studio Theater
August 24, 2019
Castle Theater
September 14, 2019
A&B Amphitheater
September 29, 2019
FREE ADMISSION
Castle Theater
December 02, 2019
Yokouchi Pavilion & Courtyard
December 13, 2019
Castle Theater
December 29, 2019
A&B Amphitheater
January 03, 2020

DISPLAY By Category

PAST EVENTS