The following query is overloading my WP Engine server, causing regular 504 errors on the 80+ websites I host. It has shown up in our mysql slow logs more than 2,000 times in the past 12 hours. Would you mind helping me fix this issue? Thanks!<\/p>\n
# Time: 2017-02-27T13:14:10.967755Z
\n# User@Host: kvne[kvne] @ [127.0.0.1] Id: 205696
\n# Schema: wp_kvne Last_errno: 0 Killed: 0
\n# Query_time: 7.501045 Lock_time: 0.000443 Rows_sent: 1 Rows_examined: 1336595 Rows_affected: 0
\n# Bytes_sent: 1882
\nSET timestamp=1488201250;
\nSELECT
\n SQL_CALC_FOUND_ROWS *
\n FROM (
\n SELECT DISTINCT wp_posts.*, wp_postmeta.meta_value as EventStartDate, tribe_event_end_date.meta_value as EventEndDate FROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) LEFT JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id AND mt2.meta_key = ‘_EventHideFromUpcoming’ ) LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) WHERE 1=1 AND wp_posts.ID NOT IN (49052) AND (
\n wp_postmeta.meta_key = ‘_EventStartDate’
\n AND
\n (
\n ( mt1.meta_key = ‘_EventStartDate’ AND CAST(mt1.meta_value AS DATETIME) < ‘2017-02-07 09:30:00’ )
\n OR (
\n ( mt1.meta_key = ‘_EventStartDate’ AND CAST(mt1.meta_value AS DATETIME) = ‘2017-02-07 09:30:00’ )
\n AND mt1.post_id < 49052
\n )
\n )
\n AND
\n mt2.post_id IS NULL
\n) AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’) ORDER BY EventStartDate DESC, wp_posts.ID DESC
\n ) a
\n GROUP BY IF( post_parent = 0, ID, post_parent )
\n ORDER BY EventStartDate DESC
\n LIMIT 0, 1
\n \/* From [kvne.com\/event\/square-1\/2017-02-07\/] in [\/nas\/content\/live\/kvne\/wp-content\/plugins\/the-events-calendar\/src\/Tribe\/Query.php:1017] *\/;<\/p>\n","protected":false},"template":"","class_list":["post-1247773","topic","type-topic","status-closed","hentry"],"yoast_head":"\n