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

TPS Turku (Fin)
.
Valtteri Laiho Meilleur compteur

Matchs joués: 5
Buts: 5
Assists: 1
Points: 6
Pénalités: 2

Jere Roslakka Meilleur passeur

Matchs joués: 5
Buts: 3
Assists: 3
Points: 6
Pénalités: 2

Valtteri Laiho Meilleur buteur

Matchs joués: 5
Buts: 5
Assists: 1
Points: 6
Pénalités: 2

 
# P Nom Pr�nom Club MJ B A AN DN Pts PEM B/MJ A/MJ Pts/MJ Pen/MJ
1 J Horkko Eemil 5 1 0 0 0 1 10 0.20 0.00 0.20 2.00
2 J Vvolajarvi Eero 5 1 1 0 0 2 4 0.20 0.20 0.40 0.80
3 J Roslakka Jere 5 3 3 0 0 6 2 0.60 0.60 1.20 0.40
4 J Laiho Valtteri 5 5 1 0 0 6 2 1.00 0.20 1.20 0.40
5 J Haavisto Niklas 5 1 2 0 0 3 2 0.20 0.40 0.60 0.40
6 J Veranen Juuso 5 1 1 0 0 2 2 0.20 0.20 0.40 0.40
7 J Koivisto Charlotta 5 0 1 0 0 1 2 0.00 0.20 0.20 0.40
8 J Ahkera Jesse 5 0 0 0 0 0 2 0.00 0.00 0.00 0.40
9 J Anderson Ursula 5 0 0 0 0 0 2 0.00 0.00 0.00 0.40
10 J Lehtinen Eemil 5 2 2 0 0 4 0 0.40 0.40 0.80 0.00
11 J Valli Kaarlo 5 1 1 0 0 2 0 0.20 0.20 0.40 0.00
12 J Suokas Mikael 5 0 0 0 0 0 0 0.00 0.00 0.00 0.00
13 J Malminen Onni 5 0 0 0 0 0 0 0.00 0.00 0.00 0.00

Query failed => SELECT DISTINCT c.ID_Club as id, eq.ID_Equipe as eq, c.NomOfficiel as cl, d.ID_Division as IDdiv FROM Equipe eq, Engagement en, Club c, Division d WHERE en.ID_Division=d.ID_Division AND d.ID_Competition= AND en.ID_Equipe=eq.ID_Equipe AND eq.ID_Club=c.ID_Club AND en.ID_Saison=50 ORDER BY NomOfficiel
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND en.ID_Equipe=eq.ID_Equipe AND eq.ID_Club=c.ID_Club AND en.ID_Saison=50 ORDER' at line 1