Query failed => SELECT j.ID_Joueurs as idplayer, j.Nom, j.Prenom, sum( MJ ) AS MJ, sum( B ) AS Buts, sum( A ) AS Ass, sum( B + A ) AS Pts, sum(MP) as Pem, (sum( B )/sum( MJ )) as ButsMJ, (sum( A )/sum( MJ )) as AssMJ, (sum( MP )/sum( MJ )) as PenMJ, ((sum( B ) + sum( A ))/sum( MJ )) as PtsMJ
FROM Composition c, Joueurs j, Division d
WHERE c.ID_Joueurs = j.ID_Joueurs
AND c.ID_Division = d.ID_Division
AND d.ID_Competition =40
GROUP BY j.ID_Joueurs, j.Nom, j.Prenom ORDER BY Ass DESC, Pts DESC, Buts DESC, Pem LIMIT 0,1