error 1064

[Phil Cour]

Hello
I encounter an error 1064 on an SQL query that I cannot resolve.
Your help is welcome !
THANKS !

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 'groups ON wagons.id = groups.wagon_comp_id WHERE date > '2022-07-31'' at line 4

SELECT DISTINCT groups.name,groups.size,groups.pmr as has_pmr,groups.phone, trains.id AS train_id, trains.date AS train_date, wagons.term_id AS wagon_term_id
FROM mod711_comp_trains AS trains
LEFT JOIN mod711_comp_wagons AS wagons
ON trains.id = wagons.train_comp_id
LEFT JOIN mod711_comp_groups AS groups
ON wagons.id = groups.wagon_comp_id
WHERE date > '2022-07-31'