SELECT GL.*, E.joueur FROM game_lines GL, joueurequipe E, joueur J WHERE GL.FK_team = 6 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 - Chicago

Attaquants 5vs5

Trios
GP
G
A
PTS
DIFF
G/GP
Mitchell Mattson Anthony Beauvillier Anders Bjork 31294978380.94
Brock Boeser Tomas Hertl Otto Koivula 31343973221.1
Tomas Hertl Martins Dzierkals Noah Gregor 3611243560.31
Kole Sherwood Nikolay Goldobin Nick Bjugstad 28101727190.36
Tomas Hertl Otto Koivula Philip Tomasino 5426-30.8
Mitchell Mattson Nikolay Goldobin Nick Bjugstad 532540.6
Anthony Beauvillier Anders Bjork Brock Boeser 5224-160.4
Philip Tomasino Nikolay Goldobin Nick Bjugstad 312300.33

Attaquants PP

Trios
GP
G
A
PTS
G/GP
Anthony Beauvillier Otto Koivula Nick Bjugstad 36410140.11
Anders Bjork Brock Boeser Tomas Hertl 363690.08

Défenseurs 5vs5

Duos
GP
G
A
PTS
DIFF
G/GP
Matt Mackenzie Joakim Ryan 367283530.19
Matt Mackenzie Sean Durzi 2861824180.21
Joakim Ryan Dmitry Semykin 2861723150.21
Joakim Ryan Sean Durzi 8291110.25
Erik Gustafsson Jordan Subban 301910190.03
Erik Gustafsson Dmitry Semykin 303300
Matt Mackenzie Dmitry Semykin 5022-110
Matt Mackenzie Jordan Subban 3011-80
Erik Gustafsson Michael Karow 200000
Darren Dietz Jordan Subban 100000

Défenseurs PP

Duos
GP
G
A
PTS
G/GP
Joakim Ryan Jordan Subban 210330
Joakim Ryan Erik Gustafsson 141120.07
Sean Durzi Matt Mackenzie 360000
Dmitry Semykin Joakim Ryan 10000