SELECT p.post_content, p.ID, p.post_excerpt, p.post_title, p.post_type, mt_start_d.meta_value as start_date, mt_end_d.meta_value as end_date, (case when (DATEDIFF( mt_end_d.meta_value, mt_start_d.meta_value ) >= 120) THEN 1000 ELSE 0 END) AS date_range FROM wp_77_posts p INNER JOIN wp_77_term_relationships as wp_term_relation ON (p.ID = wp_term_relation.object_id ) INNER JOIN wp_77_term_taxonomy as wp_term_taxonomy ON (wp_term_taxonomy.term_taxonomy_id = wp_term_relation.term_taxonomy_id AND wp_term_taxonomy.term_id='66' ) INNER JOIN wp_77_apollo_eventmeta mt_start_d ON p.ID = mt_start_d.apollo_event_id AND mt_start_d.meta_key = '_apollo_event_start_date' INNER JOIN wp_77_apollo_eventmeta mt_end_d ON p.ID = mt_end_d.apollo_event_id AND mt_end_d.meta_key = '_apollo_event_end_date' LEFT JOIN wp_77_apollo_post_term pt ON pt.post_id = p.ID WHERE ( p.ID NOT IN ("64847") ) AND p.post_status = 'publish' AND p.post_type = 'event' AND ( ( mt_start_d.meta_key = '_apollo_event_start_date' AND CAST( mt_start_d.meta_value AS DATE ) >= '2019-11-14' ) OR ( mt_end_d.meta_key = '_apollo_event_end_date' AND CAST( mt_end_d.meta_value AS DATE ) >= '2019-11-14' ) ) AND ( pt.post_id is NULL OR ( pt._is_category_feature <> 'yes' ) ) AND p.ID NOT IN ( -1,46484 ) GROUP BY p.ID ORDER BY mt_end_d.meta_value ASC

Featured Partners

 

BROUGHT TO YOU BY:-------------PREMIER PARTNER:

 

MEDIA PARTNERS:

Artsopolis Network Members: Akron OH | Austin TX | Bainbridge Island WA | Birmingham AL | Boston MA | Cape Cod MA | Cincinnati OH | Cleveland OH | Colorado Springs CO | Columbia SC | DuPage County IL | Essex County MA | Flagstaff AZ | Flint MI | Fort Lauderdale FL | Indianapolis IN | Kalamazoo MI | Kansas City MO | Macon GA | Main Line Area PA | Marin County CA | Marquette County MI | Mendocino County CA | Middlesex County NJ | Milwaukee WI | Montgomery County MD | Napa Valley CA | Nashville TN | Niagara County NY | Oklahoma City OK | Orange County CA | Orlando FL | Ottawa IL | Panama City FL | Pittsburgh PA | Providence RI | Quito, Ecuador | Richardson TX | Sacramento CA | San Antonio TX | St. Cloud MN | St. Croix Valley MN/WI | St. Johns County FL | Stillwater MN | Tallahassee FL | Tampa Bay FL | Utah | Ventura CA | York County PA