ELECT plotteur.nom as nom, sum(score.score) AS scoreTotal, sum(score.plotaverage) AS plotaverageTotal, plotteur.drapeau AS drapeau, plotteur.licence AS licence, count(score.score) as tournoisJoues, (SELECT count(*) FROM score AS score2 WHERE score2.idPlotteur = plotteur.id AND score = 10) AS victoires, (SELECT count(*) FROM score AS score2 WHERE score2.idPlotteur = plotteur.id AND score = 5) AS finales, (SELECT count(*) FROM score AS score2 WHERE score2.idPlotteur = plotteur.id AND score = 3) AS demifinales FROM plotteur, score WHERE plotteur.id = score.idPlotteur GROUP BY plotteur.id ORDER BY scoreTotal DESC