Events
Loading view.
WordPress database error: [Unknown column 'event_date' in 'order clause']
SELECT wp_posts.ID
FROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = '_EventHideFromUpcoming' ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.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'
)
WHERE 1=1 AND (
wp_postmeta.post_id IS NULL
AND
( mt1.meta_key = '_EventEndDateUTC' AND CAST(mt1.meta_value AS DATETIME) <= '2023-04-30 00:00:00' )
AND
( mt2.meta_key = '_EventStartDateUTC' AND CAST(mt2.meta_value AS DATETIME) >= '2023-03-27 00:00:00' )
) AND wp_posts.post_type = 'tribe_events' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID
ORDER BY event_date ASC, wp_posts.post_date ASC