Yoast SEO – Events Schema SQL error

Hi there,

This plugin renders an error (on multisite) together with Yoast SEO:

Error (site prefix: wpm02, blog #2: result: wpm02_2_):

Not unique table/alias: 'wpm02_2_tec_occurrences'

SELECT wpm02_2_posts.*, CAST( orderby_event_date_meta.meta_value AS DATETIME ) AS event_date
FROM wpm02_2_posts
LEFT JOIN wpm02_2_postmeta
ON ( wpm02_2_posts.ID = wpm02_2_postmeta.post_id
AND wpm02_2_postmeta.meta_key = '_EventHideFromUpcoming' )
LEFT JOIN wpm02_2_tec_occurrences
ON wpm02_2_posts.ID = wpm02_2_tec_occurrences.post_id
LEFT JOIN wpm02_4_postmeta AS orderby_event_date_meta
ON ( orderby_event_date_meta.post_id = wpm02_4_posts.ID
AND orderby_event_date_meta.meta_key = '_EventStartDate' ) JOIN wpm02_2_tec_occurrences
ON wpm02_2_posts.ID = wpm02_2_tec_occurrences.post_id JOIN wpm02_2_tec_occurrences
ON wpm02_2_posts.ID = wpm02_2_tec_occurrences.post_id
WHERE 1=1
AND ( wpm02_2_postmeta.post_id IS NULL
AND CAST(wpm02_2_tec_occurrences.end_date AS DATETIME) <= '2023-02-05 00:00:00'
AND CAST(wpm02_2_tec_occurrences.start_date AS DATETIME) >= '2022-12-26 00:00:00' )
AND wpm02_2_posts.post_type = 'tribe_events'
AND ((wpm02_2_posts.post_status = 'publish'
OR wpm02_2_posts.post_status = 'private'))
GROUP BY wpm02_2_tec_occurrences.occurrence_id
ORDER BY wpm02_2_tec_occurrences.start_date ASC, wpm02_2_posts.post_date ASC

Stack Trace:

WP_Query->get_posts()

wp-includes/class-wp-query.php:3272
TEC\E\C\V\W\Custom_Tables_Query->get_posts()
wp-content/plugins/the-events-calendar/src/Events/Custom_Tables/V1/WP_Query/Custom_Tables_Query.php:199
TEC\E\C\V\W\M\Events_Only_Modifier->filter_posts_pre_query()
wp-content/plugins/the-events-calendar/src/Events/Custom_Tables/V1/WP_Query/Modifiers/Events_Only_Modifier.php:77
apply_filters_ref_array('posts_pre_query')
wp-includes/plugin.php:256
WP_Query->get_posts()
wp-includes/class-wp-query.php:3097
Tribe__Events__Query::getEvents()
wp-content/plugins/the-events-calendar/src/Tribe/Query.php:392
tribe_get_events()
wp-content/plugins/the-events-calendar/src/functions/template-tags/general.php:341
TEC\E\I\P\W\Events_Schema->get_month_events()
wp-content/plugins/the-events-calendar/src/Events/Integrations/Plugins/WordPress_SEO/Events_Schema.php:294
TEC\E\I\P\W\Events_Schema->generate()
wp-content/plugins/the-events-calendar/src/Events/Integrations/Plugins/WordPress_SEO/Events_Schema.php:85
Yoast\W\S\G\Schema_Generator->generate_graph()
wp-content/plugins/wordpress-seo/src/generators/schema-generator.php:129
Yoast\W\S\G\Schema_Generator->generate()
wp-content/plugins/wordpress-seo/src/generators/schema-generator.php:76
Yoast\W\S\P\Indexable_Presentation->generate_schema()
wp-content/plugins/wordpress-seo/src/presentations/indexable-presentation.php:718
Yoast\W\S\P\Abstract_Presentation->__get()
wp-content/plugins/wordpress-seo/src/presentations/abstract-presentation.php:66
Yoast\W\S\P\Schema_Presenter->get()
wp-content/plugins/wordpress-seo/src/presenters/schema-presenter.php:60
Yoast\W\S\P\Schema_Presenter->present()
wp-content/plugins/wordpress-seo/src/presenters/schema-presenter.php:44
Yoast\W\S\I\Front_End_Integration->present_head()
wp-content/plugins/wordpress-seo/src/integrations/front-end-integration.php:326
do_action('wpseo_head')
wp-includes/plugin.php:517
Yoast\W\S\I\Front_End_Integration->call_wpseo_head()
wp-content/plugins/wordpress-seo/src/integrations/front-end-integration.php:300
do_action('wp_head')
wp-includes/plugin.php:517
wp_head()
wp-includes/general-template.php:3043
load_template('wp-content/themes/genesis/header.php')
wp-includes/template.php:783
locate_template()
wp-includes/template.php:718
get_header()
wp-includes/general-template.php:48
genesis()
wp-content/themes/genesis/lib/framework.php:24

Cheers, Jory