WordPress database error: [Unknown column 'orderby_event_date_meta.meta_value' in 'field list']
SELECT wp_posts.ID, CAST( orderby_event_date_meta.meta_value AS DATETIME ) AS event_date, CAST( wp_tec_occurrences.duration AS DECIMAL ) AS event_duration FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND (((wp_posts.post_title LIKE '%awareness%') OR (wp_posts.post_excerpt LIKE '%awareness%') OR (wp_posts.post_content LIKE '%awareness%'))) AND (wp_posts.post_password = '') AND ( ( wp_postmeta.meta_key = '_EventEndDate' AND CAST(wp_postmeta.meta_value AS DATETIME) > '2025-11-17 02:00:25' ) ) AND wp_posts.post_type IN ('nfxf_research_study', 'nfxf_treatments', 'nfxf_webinars', 'nfxf_xtraordinary', 'post') AND ((wp_posts.post_status = 'publish')) GROUP BY wp_tec_occurrences.occurrence_id ORDER BY event_date ASC, event_duration ASC, wp_posts.post_title LIKE '%awareness%' DESC, wp_posts.post_date ASC LIMIT 0, 16