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_tec_occurrences.occurrence_id + 10000000) as occurrence_id FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_tec_occurrences ON wp_posts.ID = wp_tec_occurrences.post_id 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 ( CAST(wp_tec_occurrences.end_date AS DATETIME) < '2025-04-08 23:43:31' AND ( wp_postmeta.meta_key = '_EventVenueID' AND wp_postmeta.meta_value IN ('29077') ) ) AND wp_posts.post_type = 'tribe_events' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_tec_occurrences.occurrence_id ORDER BY wp_tec_occurrences.start_date DESC, wp_tec_occurrences.duration DESC, wp_posts.post_date DESC LIMIT 0, 11