"Nil Satis Nisi Optimum"
Champions : U15:
1999, 2000, 2001, 2005, 2006, 2007, 2008, 2013, 2018
// U17:
2000, 2002, 2005, 2010, 2011, 2014, 2017 // U20:
2004, 2006, 2009, 2011, 2013, 2015, 2017, 2019 ...
"Le sport est bien affaire de frissons" Jean Dion
 |
|
 |
|
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 =249
GROUP BY j.ID_Joueurs, j.Nom, j.Prenom ORDER BY Buts DESC, Pts DESC, Ass DESC, Pem LIMIT 0,1