Copying to tmp table Running Queries

[David]

I am getting time outs for running queries all of a sudden.

I’ll post the full code in a private & seperate reply, but here is 1 of the running queries:

STATE: Copying to tmp table
TIME: 10
COMMAND: Query
INFO: SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) 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 (18367) AND (
wp_term_relationships.term_taxonomy_id IN (7)
) AND (
wp_postmeta.meta_key = ‘_EventStartDate’
) AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’) AND (wp_postmeta.meta_value >= ‘2016-08-01 18:33:00’ OR (wp_postmeta.meta_value <= ‘2016-08-01 18:33:00’ AND tribe_event_end_date.meta_value >= ‘2016-08-01 18:33:00’ )) GROUP BY wp_posts.ID ORDER BY RAND() LIMIT 0, 3

[David]

This reply is private.

[Cliff]

This reply is private.

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts