Erreur de la base de données WordPress : [Unknown column 'event_date' in 'order clause']
SELECT wp_f1ad56bd7b_posts.ID
FROM wp_f1ad56bd7b_posts LEFT JOIN wp_f1ad56bd7b_postmeta ON ( wp_f1ad56bd7b_posts.ID = wp_f1ad56bd7b_postmeta.post_id AND wp_f1ad56bd7b_postmeta.meta_key = '_EventHideFromUpcoming' ) LEFT JOIN wp_f1ad56bd7b_postmeta AS mt1 ON ( wp_f1ad56bd7b_posts.ID = mt1.post_id ) LEFT JOIN wp_f1ad56bd7b_postmeta AS mt2 ON ( wp_f1ad56bd7b_posts.ID = mt2.post_id ) JOIN wp_f1ad56bd7b_icl_translations wpml_translations
ON wp_f1ad56bd7b_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_f1ad56bd7b_posts.post_type)LEFT JOIN wp_f1ad56bd7b_postmeta AS orderby_event_date_meta
ON (
orderby_event_date_meta.post_id = wp_f1ad56bd7b_posts.ID
AND orderby_event_date_meta.meta_key = '_EventStartDate'
)
WHERE 1=1 AND (
wp_f1ad56bd7b_postmeta.post_id IS NULL
AND
( mt1.meta_key = '_EventEndDate' AND CAST(mt1.meta_value AS DATETIME) <= '2023-10-01 00:00:00' )
AND
( mt2.meta_key = '_EventStartDate' AND CAST(mt2.meta_value AS DATETIME) >= '2023-08-28 00:00:00' )
) AND wp_f1ad56bd7b_posts.post_type = 'tribe_events' AND ((wp_f1ad56bd7b_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'fr' OR (
wpml_translations.language_code = 'fr'
AND wp_f1ad56bd7b_posts.post_type IN ( 'awb_off_canvas' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_f1ad56bd7b_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'fr'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_f1ad56bd7b_icl_translations t2
JOIN wp_f1ad56bd7b_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'fr'
AND (
p.post_status = 'publish' OR p.post_status = 'private' OR
( p.post_type='attachment' AND p.post_status = 'inherit' )
)
) = 0 ) )
) ) AND wp_f1ad56bd7b_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','fusion_tb_section','fusion_form','tribe_venue','tribe_organizer','tribe_events','avada_portfolio','avada_faq','themefusion_elastic','awb_off_canvas','slide','fusion_element' ) ) OR wp_f1ad56bd7b_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','fusion_tb_section','fusion_form','tribe_venue','tribe_organizer','tribe_events','avada_portfolio','avada_faq','themefusion_elastic','awb_off_canvas','slide','fusion_element' ) )
GROUP BY wp_f1ad56bd7b_posts.ID
ORDER BY event_date ASC, wp_f1ad56bd7b_posts.post_date ASC
Communiqué conjoint | Les acteurs du Sud-Ouest de l’océan Indien main dans la main pour une meilleure efficacité des aires marines protégées de la région
