WordPress database error: [Incorrect DATE value: '2022-10']SELECT wp_z8p3grjgdy_posts.*
FROM wp_z8p3grjgdy_posts INNER JOIN wp_z8p3grjgdy_tec_occurrences ON wp_z8p3grjgdy_posts.ID = wp_z8p3grjgdy_tec_occurrences.post_id
WHERE 1=1 AND wp_z8p3grjgdy_posts.post_name = 'events' AND (
wp_z8p3grjgdy_tec_occurrences.post_id IS NOT NULL
AND
CAST(wp_z8p3grjgdy_tec_occurrences.end_date AS DATETIME) >= '2024-10-31 08:22:06'
) AND wp_z8p3grjgdy_posts.post_type = 'tribe_events' AND CAST(wp_z8p3grjgdy_tec_occurrences.start_date AS DATE) = '2022-10'
GROUP BY wp_z8p3grjgdy_tec_occurrences.occurrence_id
ORDER BY wp_z8p3grjgdy_tec_occurrences.start_date ASC, wp_z8p3grjgdy_posts.post_date ASC