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 =627 GROUP BY j.ID_Joueurs, j.Nom, j.Prenom ORDER BY Pts DESC, Buts DESC, Ass DESC, Pem LIMIT 0,1