Error en la base de datos de WordPress: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'a GROUP BY IF( post_parent = 0, ID, post_parent ) ORDER BY EventStartDate ' at line 13]
SELECT SQL_CALC_FOUND_ROWS * FROM ( SELECT DISTINCT fh_posts.*, fh_postmeta.meta_value as EventStartDate, tribe_event_end_date.meta_value as EventEndDate FROM fh_posts LEFT JOIN fh_term_relationships ON (fh_posts.ID = fh_term_relationships.object_id) LEFT JOIN fh_term_relationships AS tt1 ON (fh_posts.ID = tt1.object_id) INNER JOIN fh_postmeta ON ( fh_posts.ID = fh_postmeta.post_id ) INNER JOIN fh_postmeta AS mt1 ON ( fh_posts.ID = mt1.post_id ) LEFT JOIN fh_postmeta as tribe_event_end_date ON ( fh_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDateUTC' ) WHERE 1=1 AND ( fh_term_relationships.term_taxonomy_id IN (39) AND tt1.term_taxonomy_id IN (39) ) AND ( fh_postmeta.meta_key = '_EventStartDateUTC' AND ( mt1.meta_key = '_EventEndDateUTC' AND CAST(mt1.meta_value AS DATETIME) > '2020-05-26 08:18:00' ) ) AND fh_posts.post_type = 'tribe_events' AND (fh_posts.post_status = 'publish' OR fh_posts.post_status = 'tribe-ea-success' OR fh_posts.post_status = 'tribe-ea-failed' OR fh_posts.post_status = 'tribe-ea-schedule' OR fh_posts.post_status = 'tribe-ea-pending' OR fh_posts.post_status = 'tribe-ea-draft') AND fh_posts.id NOT IN (SELECT post_id FROM fh_wpfront_ure_post_type_permissions WHERE role IN ('wpfront-guest-role-1') AND enable_permissions = 1 AND has_read = 0 ORDER BY EventStartDate ASC, fh_posts.post_date ASC ) a GROUP BY IF( post_parent = 0, ID, post_parent ) ORDER BY EventStartDate ASC LIMIT 0, 20