Navegación de búsqueda y vistas de Eventos
- No hay eventos en Calendario administrativo. Accede al calendario completo para ver una lista de eventos.
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 (246)
AND
tt1.term_taxonomy_id IN (246)
) AND (
fh_postmeta.meta_key = '_EventStartDateUTC'
AND
( mt1.meta_key = '_EventEndDateUTC' AND CAST(mt1.meta_value AS DATETIME) > '2020-05-26 08:31: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