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

Attaquants 5vs5

Trios
GP
G
A
PTS
DIFF
G/GP
Tyler Seguin Tyler Bertuzzi Dylan Cozens 1210152510.83
Tyler Seguin Ilya Mikheyev Tyler Bertuzzi 87142110.88
Tyler Seguin Jesper Bratt Dylan Cozens 1612820110.75
Brayden Point Jesper Bratt Ilya Mikheyev 1171219150.64
Brendan Gaunce Tyler Bertuzzi Brayden Point 571017141.4
Ilya Mikheyev Tyler Bertuzzi Brayden Point 1261016-80.5
Brayden Point Jesper Bratt Dylan Cozens 5671351.2
Tyler Seguin Carl Grundstrom Connor Chatham 9561100.56
Tyler Motte Brendan Gaunce Dillon Dube 945910.44
Tyler Seguin Dillon Dube Connor Chatham 1144850.36
Brayden Point Jesper Bratt Brendan Gaunce 4358-40.75
Jake Leschyshyn Carl Grundstrom Brendan Gaunce 534770.6
Brayden Point Brendan Gaunce Dillon Dube 424650.5
Brayden Point Dillon Dube Connor Chatham 323580.67
Jake Leschyshyn Carl Grundstrom Tyler Seguin 414550.25
Tyler Motte Carl Grundstrom Dylan Cozens 322410.67
Tyler Seguin Dillon Dube Tyler Motte 421320.5
Jake Leschyshyn Tyler Motte Connor Chatham 421300.5
Brendan Gaunce Dillon Dube Connor Chatham 2112-20.5
Jake Leschyshyn Dillon Dube Tyler Motte 111231
Brayden Point Carl Grundstrom Tyler Motte 201110
Brayden Point Carl Grundstrom Connor Chatham 110111
Jake Leschyshyn Carl Grundstrom Tyler Motte 3000-90
Tyler Bertuzzi Jesper Bratt Brayden Point 1000-30
Tyler Seguin Ilya Mikheyev Dylan Cozens 1000-30
Tyler Motte Dillon Dube Ilya Mikheyev 2000-60
Jake Leschyshyn Brendan Gaunce Tyler Motte 7000-40
Jake Leschyshyn Dillon Dube Brendan Gaunce 2000-30
Tyler Seguin Jesper Bratt Ilya Mikheyev 1000-40

Attaquants PP

Trios
GP
G
A
PTS
G/GP
Tyler Seguin Ilya Mikheyev Jesper Bratt 133360.23
Tyler Bertuzzi Ilya Mikheyev Tyler Seguin 91340.11
Tyler Bertuzzi Dylan Cozens Brayden Point 162240.13
Tyler Seguin Tyler Motte Jesper Bratt 32240.67
Brayden Point Jesper Bratt Dylan Cozens 121010.08
Ilya Mikheyev Tyler Motte Brayden Point 50000
Tyler Seguin Tyler Bertuzzi Jesper Bratt 50000
Tyler Seguin Tyler Bertuzzi Tyler Motte 30000
Brayden Point Tyler Bertuzzi Jesper Bratt 50000
Tyler Seguin Ilya Mikheyev Dylan Cozens 20000
Tyler Seguin Tyler Motte Dylan Cozens 30000

Défenseurs 5vs5

Duos
GP
G
A
PTS
DIFF
G/GP
Dustyn McFaul Joshua Mahura 539384730.17
Connor Carrick Jake Christiansen 46103040-20.22
Dustyn McFaul Connor Carrick 1231215130.25
Mason Geertsen Joshua Mahura 1026840.2
Jake Christiansen Joshua Mahura 716770.14
Connor Carrick Mason Geertsen 13066-90
Connor Carrick Nikolai Knyzhov 303310
Jake Christiansen Mason Geertsen 512340.2
Dustyn McFaul Mason Geertsen 311230.33

Défenseurs PP

Duos
GP
G
A
PTS
G/GP
Dustyn McFaul Connor Carrick 240440
Jake Christiansen Joshua Mahura 211230.05
Jake Christiansen Connor Carrick 140000
Dustyn McFaul Joshua Mahura 110000
Ilya Mikheyev Dustyn McFaul 30000
Joshua Mahura Ilya Mikheyev 30000