"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 ...

Lettonie U18-1
Juris Upitis Meilleur compteur

Matchs joués: 30
Buts: 26
Assists: 27
Points: 53
Pénalités: 38

Bruno Zabis Meilleur passeur

Matchs joués: 29
Buts: 20
Assists: 33
Points: 53
Pénalités: 62

Juris Upitis Meilleur buteur

Matchs joués: 30
Buts: 26
Assists: 27
Points: 53
Pénalités: 38

Query failed => SELECT DISTINCT p.Abrev_Poste as Poste, c.ID_Joueurs as IDJ, c.ID_Equipe as IDE, cl.NomOfficiel as Club, j.Nom as Nomj, Prenom, sum(MJ) as NbMatch, sum(B) as Buts, sum(A) as Ass, sum(MP) as Pem, sum(B + A) as Pts, sum(B)/sum(MJ) AS ButsMJ, sum(A)/sum(MJ) AS AssMJ, sum(B + A)/sum(MJ) AS PtsMJ, sum(MP)/sum(MJ) AS PenMJ FROM Poste p, Club cl, Equipe eq, Composition c, Joueurs j WHERE MJ>0 AND c.ID_Poste=p.ID_Poste AND c.ID_Equipe=eq.ID_Equipe AND cl.ID_Club=eq.ID_Club AND c.ID_Joueurs=j.ID_Joueurs AND c.ID_Division IN (SELECT ID_Division FROM Division WHERE ID_Competition=260) AND c.ID_Saison=3 GROUP BY c.ID_Joueurs, c.ID_Equipe ORDER BY PenMJ DESC, Pts DESC, Buts DESC, Ass DESC
User 'hockeyrouendb' has exceeded the 'max_questions' resource (current value: 21783)
 
# P Nom Prénom Club MJ B A Pts PEM B/MJ A/MJ Pts/MJ Pen/MJ