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

Attaquants 5vs5

Trios
GP
G
A
PTS
DIFF
G/GP
Jesse Puljujarvi Vladislav Namestnikov Nikolaj Ehlers 18152439400.83
Mark Scheifele Sebastian Aho Alex Debrincat 30151934-350.5
Sebastian Aho Simon Deslauriers Jonathan Walker 37161834-220.43
Nikolaj Ehlers Jesse Puljujarvi Ryan Nugent-Hopkins 128132160.67
Ryan Nugent-Hopkins Max Zimmer Nikita Korostelev 18991810.5
Vladislav Namestnikov Max Zimmer Nikita Korostelev 1641216-50.25
Mark Scheifele Sebastian Aho Nikolaj Ehlers 436900.75
Ryan Nugent-Hopkins Sebastian Aho Alex Debrincat 2235-21
Ryan Nugent-Hopkins Alex Debrincat Jesse Puljujarvi 4112-40.25
Mark Scheifele Alex Debrincat Jesse Puljujarvi 1112-11
Vladislav Namestnikov Max Zimmer Jan Jenik 3101-40.33
Nikolaj Ehlers Jesse Puljujarvi Mark Scheifele 2000-60
Ryan Nugent-Hopkins Sebastian Aho Nikolaj Ehlers 100000

Attaquants PP

Trios
GP
G
A
PTS
G/GP
Mark Scheifele Sebastian Aho Alex Debrincat 3077140.23
Nikolaj Ehlers Jesse Puljujarvi Ryan Nugent-Hopkins 303250.1
Mark Scheifele Sebastian Aho Nikolaj Ehlers 51340.2
Alex Debrincat Jesse Puljujarvi Ryan Nugent-Hopkins 50000
Mark Scheifele Nikolaj Ehlers Jesse Puljujarvi 20000
Ryan Nugent-Hopkins Sebastian Aho Alex Debrincat 20000

Défenseurs 5vs5

Duos
GP
G
A
PTS
DIFF
G/GP
Cale Makar Justin Hache 3771825-10.19
Cale Makar Philip Kemp 2851621-10.18
Zach Werenski Gabriel Beaupre 2811112-30.04
Jack Rathbone Zach Werenski 272810-160.07
Zach Werenski Cale Makar 9415-100.44
Filip Hronek Zach Werenski 1022440.2
Gabriel Beaupre Philip Kemp 822420.25
Gabriel Beaupre Dennis Busby 100000

Défenseurs PP

Duos
GP
G
A
PTS
G/GP
Max Zimmer Zach Werenski 291780.03
Vladislav Namestnikov Cale Makar 291230.03
Cale Makar Justin Hache 81120.13
Zach Werenski Filip Hronek 80000