SELECT GL.*, E.joueur FROM game_lines GL, joueurequipe E, joueur J WHERE GL.FK_team = 15 AND E.id = GL.FK_joueur AND E.id = J.id_joueur AND J.season = 2037 AND GL.season = 2037 AND linetype = "even" AND isdef IS NULL AND isgoalie IS NULL ORDER BY linenum ASC
VHLQ

Statistiques des trios - Nashville

Attaquants 5vs5

Trios
GP
G
A
PTS
DIFF
G/GP
Ross Colton Josh Anderson Connor McDavid 2515304590.6
Barclay Goodrow Denis Gurianov Owen Tippett 26172037-220.65
Connor McDavid Barclay Goodrow Josh Anderson 6101727161.67
Kevin Stenlund Luke Kunin Givani Smith 17771450.41
Kevin Stenlund Grant Mismash Givani Smith 106814110.6
Connor McDavid Owen Tippett Josh Anderson 4347-80.75
Alexandre Texier Luke Kunin Oskar Lindblom 11246-30.18
Alexandre Texier Grant Mismash Oskar Lindblom 1741520.24
Alexandre Texier Ross Colton Josh Anderson 331441
Barclay Goodrow Owen Tippett Oskar Lindblom 2134-10.5
Alexandre Texier Luke Kunin Givani Smith 222431
Kevin Stenlund Alexandre Texier Oskar Lindblom 5033-10
Kevin Stenlund Givani Smith Julien Gauthier 3112-10.33
Kevin Stenlund Grant Mismash Julien Gauthier 311200.33
Ross Colton Owen Tippett Denis Gurianov 6022-70
Luke Kunin Grant Mismash Givani Smith 4101-10.25
Luke Kunin Grant Mismash Oskar Lindblom 3011-30
Barclay Goodrow Ross Colton Denis Gurianov 4000-150
Luke Kunin Grant Mismash Julien Gauthier 100000

Attaquants PP

Trios
GP
G
A
PTS
G/GP
Barclay Goodrow Denis Gurianov Oskar Lindblom 3669150.17
Owen Tippett Josh Anderson Connor McDavid 3547110.11
Alexandre Texier Owen Tippett Josh Anderson 30220
Barclay Goodrow Alexandre Texier Oskar Lindblom 20000

Défenseurs 5vs5

Duos
GP
G
A
PTS
DIFF
G/GP
Dylan Samberg Brandon Montour 72173249140.24
Niko Mikkola Jake McCabe 3631316-180.08
Eemeli Rasanen John Kovacevic 18055-10
Jake Chelios John Kovacevic 1805570
Brandon Montour Niko Mikkola 222411
Dylan Samberg Jake McCabe 2000-40
Brandon Montour John Kovacevic 2000-20
Eemeli Rasanen Dylan Samberg 2000-50

Défenseurs PP

Duos
GP
G
A
PTS
G/GP
Niko Mikkola Dylan Samberg 382570.05
Ross Colton Brandon Montour 382350.05