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 = 2038 AND GL.season = 2038 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
Josh Anderson Connor McDavid Barclay Goodrow 34303666240.88
Ross Colton Owen Tippett Denis Gurianov 34182341-300.53
Kevin Stenlund Grant Mismash Alexandre Texier 35101020-290.29
Luke Kunin Givani Smith Julien Gauthier 357815100.2
Ross Colton Josh Anderson Connor McDavid 47374178210.79
Barclay Goodrow Dmytro Timashov Denis Gurianov 42253459-290.6
Alexandre Texier Tanner Jeannot Owen Tippett 33101020-50.3
Kevin Stenlund Grant Mismash Luke Kunin 33661240.18
Alexandre Texier Grant Mismash Owen Tippett 9112-90.11
Kevin Stenlund Givani Smith Luke Kunin 9437-20.44
Barclay Goodrow Dmytro Timashov Owen Tippett 4246-40.5
Alexandre Texier Tanner Jeannot Luke Kunin 400030
Kevin Stenlund Grant Mismash Givani Smith 4101-30.25
Ross Colton Barclay Goodrow Josh Anderson 110131
Kevin Stenlund Owen Tippett Denis Gurianov 111231
Luke Kunin Grant Mismash Alexandre Texier 100000
Ross Colton Givani Smith Julien Gauthier 110111
Barclay Goodrow Owen Tippett Denis Gurianov 112351

Attaquants PP

Trios GP G A PTS G/GP
Josh Anderson Connor McDavid Barclay Goodrow 81515200.06
Ross Colton Owen Tippett Denis Gurianov 5259140.1
Ross Colton Dmytro Timashov Denis Gurianov 1755100.29
Ross Colton Dmytro Timashov Owen Tippett 132130.15
Kevin Stenlund Barclay Goodrow Josh Anderson 10000

Défenseurs 5vs5

Duos GP G A PTS DIFF G/GP
Brandon Montour Dylan Samberg 15220104124840.13
Mitchell VandeSompel Henri Jokiharju 7572633-410.09
Niko Mikkola John Kovacevic 23156-70.04
Niko Mikkola Mason Geertsen 38191040.03
Mitchell VandeSompel Niko Mikkola 1000-40
Jake Chelios John Kovacevic 6000-90
Mitchell VandeSompel Dylan Samberg 102810160.2
Henri Jokiharju Niko Mikkola 5246-30.4
Niko Mikkola Jake Chelios 12325-80.25
Ty Emberson Niko Mikkola 100020
Niko Mikkola Nauris Sejejs 200000
Brandon Montour Mitchell VandeSompel 2000-80
John Kovacevic Mason Geertsen 100000

Défenseurs PP

Duos GP G A PTS G/GP
Dylan Samberg Mitchell VandeSompel 181120.06
Henri Jokiharju Alexandre Texier 291340.03
Brandon Montour Dylan Samberg 470220
Dmytro Timashov Brandon Montour 160220
Mitchell VandeSompel Henri Jokiharju 331230.03
Denis Gurianov Brandon Montour 91010.11
Mitchell VandeSompel Owen Tippett 50000
Brandon Montour Tanner Jeannot 50000
Mitchell VandeSompel Alexandre Texier 10000
Ty Emberson Alexandre Texier 10000