Erreur PDO : SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') GROUP BY id' at line 9

SELECT destinations.id as id, destinations.name_it as name, destinations_descriptions.description as description
, s_cruises.status as s_cruises, s_departures.status as s_departures, s_destinations.status as s_destinations
FROM ( cruises LEFT JOIN status s_cruises ON (s_cruises.id=cruises.id AND s_cruises.webgroup=@webgroup AND s_cruises.class='cruises' ) )
JOIN ( departures
LEFT JOIN status s_departures ON (s_departures.id=departures.id AND s_departures.webgroup=@webgroup AND s_departures.class='departures' ) ) ON departures.id_cruises=cruises.id
JOIN ( destinations
LEFT JOIN status s_destinations ON (s_destinations.id=destinations.id AND s_destinations.webgroup=@webgroup AND s_destinations.class='destinations' ) ) ON destinations.id IN (cruises.ids_destinations)
JOIN destinations_descriptions ON destinations_descriptions.id_destination = destinations.id AND destinations_descriptions.webgroup = @webgroup AND destinations_descriptions.id_website = 7
WHERE s_cruises.status IS NULL AND s_departures.status IS NULL AND s_destinations.status IS NULL /*AND departures.date_start > @date */AND cruises.webgroup=@webgroup AND destinations.id IN ()
GROUP BY id