WordPress database error: [Incorrect DATE value: '2025-05']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-29 22:18:00'
) AND wp_z8p3grjgdy_posts.post_type = 'tribe_events' AND CAST(wp_z8p3grjgdy_tec_occurrences.start_date AS DATE) = '2025-05'
GROUP BY wp_z8p3grjgdy_tec_occurrences.occurrence_id
ORDER BY wp_z8p3grjgdy_tec_occurrences.start_date ASC, wp_z8p3grjgdy_posts.post_date ASC