SELECT u.id id_u, g.name groupement, u.name u_name, u.email mail, u.street rue, u.zip_code zip_code, u.city city, c.name_FRA pays, reg.name_FRA region, u.contact_person contact, u.phone phone, u.fax fax, u.portable portable, u.comments comments, b.name marque, u.link web, mu.mappy_url FROM users u LEFT OUTER JOIN regions reg ON u.region_id = reg.id LEFT OUTER JOIN country c ON u.country_id = c.id LEFT OUTER JOIN groupement g ON u.id_group = g.id LEFT OUTER JOIN brands_concess b ON u.marque = b.id LEFT OUTER JOIN mappy_url mu ON u.id = mu.user_id WHERE u.id = GROUP BY id_u
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_u' at line 8