Events

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 AND STR_TO_DATE(events.e_date, '%m/%d/%Y') > DATE_SUB(NOW(),INTERVAL 2 DAY) AND `s`.`show_type`='1' GROUP By `s`.`show_id` ORDER BY STR_TO_DATE( `s`.`end_date`, '%m/%d/%Y' ) ASC
Schaefer International Gallery
October 16, 2019
FREE ADMISSION
Schaefer International Gallery
October 17, 2019
FREE ADMISSION
A&B Amphitheater
October 18, 2019
FREE ADMISSION
Castle Theater
October 19, 2019
Castle Theater
October 20, 2019
Castle Theater
October 25, 2019
McCoy Studio Theater
October 27, 2019
McCoy Studio Theater
November 08, 2019
Castle Theater
November 14, 2019
McCoy Studio Theater
November 17, 2019
McCoy Studio Theater
November 21 - November 24, 2019
A&B Amphitheater
November 24, 2019
FREE ADMISSION
McCoy Studio Theater
December 20, 2019
McCoy Studio Theater
December 27, 2019
Castle Theater
December 28, 2019
A&B Amphitheater
January 03, 2020
Castle Theater
January 16, 2020
Castle Theater
January 23, 2020
McCoy Studio Theater
January 31, 2020
McCoy Studio Theater
February 06, 2020
Castle Theater
February 27, 2020
McCoy Studio Theater
March 12, 2020
McCoy Studio Theater
March 21, 2020
Castle Theater
April 09, 2020
McCoy Studio Theater
April 23, 2020
McCoy Studio Theater
April 24 - April 25, 2020
McCoy Studio Theater
May 09, 2020

DISPLAY By Category

PAST EVENTS