error : Erreur -
SELECT MAX(kgsd.date_fin) AS max_date_fin, kgreta_sessions.titre AS titre_session, kgreta_sessions.*, kgreta_toulouse_formations.*, kgreta_toulouse_formations.titre AS titre_formation, kgreta_sessions.pageID, kgreta_toulouse_formations.titre, kgreta_sessions.id, kpage.url, kpage.affichage, kgreta_toulouse_formations.ref_commerciale,DATE_FORMAT(kgreta_sessions.date_creation, \'%Y%m%d\') AS date_creation_session,DATE_FORMAT(kgreta_sessions.date_maj, \'%Y%m%d\') AS date_maj_session, kgreta_sessions.pageID AS sessionPageID ,kgreta_toulouse_formations.pageID AS formationPageID,
GROUP_CONCAT(kgsd.`id`) AS date_id,
GROUP_CONCAT(
kgsd.`date_debut`
) AS date_debut,
GROUP_CONCAT(
kgsd.`date_fin`
) AS date_fin,
GROUP_CONCAT(
kgsd.`sessionID`
) AS date_sessionid,
kgreta_correspondance.financeurID,
kgreta_correspondance.publicviseID,
kgreta_correspondance.modaliteID,
kgreta_correspondance.modalites_de_financement as financementID
FROM kgreta_sessions
INNER JOIN `kgreta_sessions_dates` AS kgsd ON (`kgsd`.`sessionID` = `kgreta_sessions`.`pageID`)
INNER JOIN kgreta_toulouse_formations ON (kgreta_toulouse_formations.pageID = kgreta_sessions.formationID)
INNER JOIN kpage ON (kpage.id = kgreta_sessions.`pageID`)
LEFT JOIN kgreta_correspondance ON (kgreta_correspondance.id = kgreta_sessions.`correspondanceID`)
WHERE kgreta_toulouse_formations.type_de_composante = \'3\' AND kgreta_sessions.lieuID = 30@31 AND kgreta_sessions.gretaID = 3 AND kgreta_sessions.formationID = \'7335\' AND kgreta_sessions.sessionPereID IS NULL AND kpage.affichage = 1
AND (
(
kgreta_sessions.modalite_entree_sortie = 789
&&
(
(kgreta_sessions.duree_affichage = 0 && DATE_ADD(kgsd.date_fin, INTERVAL 1 MONTH) >= now())
OR
(kgreta_sessions.duree_affichage = 1 && DATE_ADD(kgsd.date_debut, INTERVAL 2 MONTH) <= now())
)
)
OR
(
(kgreta_sessions.modalite_entree_sortie = 790 OR kgreta_sessions.modalite_entree_sortie = 934) AND deroulement_date_debut >= \"2023-01-01\" AND deroulement_date_fin <= \"2023-12-31\"
)
)
GROUP BY kgreta_sessions.`pageID`
ORDER BY kgsd.date_debut DESC
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'@31 AND kgreta_sessions.gretaID = 3 AND kgreta_sessions.formationID = \'7335\' AND\' at line 23