Query failed => SELECT ID_Equipe, ID_Joueur, Club, Poste, Nom, Prenom, SUM(MJ) AS NbMatch, SUM(B) AS Buts, SUM( A ) AS Ass, SUM( AN ) AS ButsAN, SUM( DN ) AS ButsDN, SUM(PTS) AS Pts, SUM(PEM) AS Pen
FROM Compteurs
WHERE ID_Rencontre=42128 AND ID_Equipe=3504 GROUP BY ID_Joueur ORDER BY Buts DESC, Pts DESC, Ass DESC, Pem