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 LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) JOIN wp_tec_occurrences ON wp_posts.ID = wp_tec_occurrences.post_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' ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (118) ) AND wp_posts.post_type = 'tribe_events' AND ((wp_posts.post_status = 'publish')) AND (( TIMESTAMPDIFF ( SECOND, tribe_start_date_utc.meta_value, '2025-04-01 23:59:59' ) >= 1 AND TIMESTAMPDIFF ( SECOND, '2025-04-01 00:00:00', tribe_end_date_utc.meta_value ) >= 1 )) GROUP BY wp_tec_occurrences.occurrence_id ORDER BY wp_tec_occurrences.start_date ASC, wp_tec_occurrences.duration ASC, wp_posts.post_date ASC