Une erreur est survenue [29/11/2023 @ 17:27.14].

select
AMB.id_page as id_amb, AMBD.titre_court as nom_amb, AMBD.ligne as ligne,
ART.id_page as id_art,
ART.publication_start, YEAR(ART.publication_start) as annee, ART.date_ajout,
ARTD.titre_court, ARTD.chapo,
GROUP_CONCAT(DISTINCT REPLACE(L.tag,"[lieu]","")) as lieux,
GROUP_CONCAT(DISTINCT REPLACE(T.tag,"[theme]","")) as themes
from cms_page AMB
left outer join cms_pagedesc AMBD on AMBD.id_page = AMB.id_page and AMBD.id_lang = "1"
inner join cms_page ART on ART.parent = AMB.id_page
left outer join cms_pagedesc ARTD on ARTD.id_page = ART.id_page and ARTD.id_lang = "1"
left outer join cms_pagetags L on L.id_page = ART.id_page and L.tag like "[lieu]%"
left outer join cms_pagetags T on T.id_page = ART.id_page and T.tag like "[theme]%"

inner join cms_pagetags LF on LF.id_page = ART.id_page and LF.tag like "[lieu]%" and LF.tag in ("[lieu]Val de Sioule - Saint-Pourçain", "[lieu]Lapalisse - Val de Besbre", "[lieu]Vichy - Montagne bourbonnaise")
inner join cms_pagetags TF on TF.id_page = ART.id_page and TF.tag like "[theme]%" and TF.tag in ("[theme]Culture & Patrimoine", "[theme]Bonne table")
where AMB.parent = "7160"

group by ART.id_page
order by ART.publication_start desc, ART.date_ajout desc