WordPress database error: [The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay]
SELECT wp_posts.ID, CAST( orderby_event_date_meta.meta_value AS DATETIME ) AS event_date, CAST( orderby_event_duration_meta.meta_value AS DECIMAL ) AS event_duration
FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
LEFT JOIN wp_postmeta tribe_start_date_utc
ON ( wp_posts.ID = tribe_start_date_utc.post_id
AND tribe_start_date_utc.meta_key = '_EventStartDate' )
LEFT JOIN wp_postmeta tribe_end_date_utc
ON ( wp_posts.ID = tribe_end_date_utc.post_id
AND tribe_end_date_utc.meta_key = '_EventEndDate' )
LEFT JOIN wp_postmeta AS orderby_event_date_meta
ON (
orderby_event_date_meta.post_id = wp_posts.ID
AND orderby_event_date_meta.meta_key = '_EventStartDate'
)
LEFT JOIN wp_postmeta AS orderby_event_duration_meta
ON (
orderby_event_duration_meta.post_id = wp_posts.ID
AND orderby_event_duration_meta.meta_key = '_EventDuration'
)
WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (130)
) AND wp_posts.post_type = 'tribe_events' AND ((wp_posts.post_status = 'publish')) AND ((
TIMESTAMPDIFF ( SECOND, tribe_start_date_utc.meta_value, '2038-05-25 23:59:59' ) >= 1
AND
TIMESTAMPDIFF ( SECOND, '2038-05-25 00:00:00', tribe_end_date_utc.meta_value ) >= 1
))
GROUP BY wp_posts.ID
ORDER BY event_date ASC, event_duration ASC, wp_posts.post_date ASC
Laster inn visning.