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

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=124) AND c.ID_Saison=1 GROUP BY c.ID_Joueurs, c.ID_Equipe ORDER BY PtsMJ DESC, Pts DESC, Buts DESC, Ass DESC
User 'hockeyrouendb' has exceeded the 'max_questions' resource (current value: 1623)

#

P

Nom

Prénom

Club

MJ

B

A

Pts

PEM

B/MJ

A/MJ

Pts/MJ

Pen/MJ