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-04-23 23:59:59' ) >= 1 AND TIMESTAMPDIFF ( SECOND, '2038-04-23 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