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

Statistiques des trios - New York

Attaquants 5vs5

Trios GP G A PTS DIFF G/GP
Chris Valentine Otto Koivula Nathan MacKinnon 554931
Martin Necas Michael Rasmussen Dylan Strome 1291019160.75
Mark Scheifele Connor McMichael Jesse Puljujarvi 22861480.36
Chris Valentine Keegan Kolesar Kole Lind 324640.67
Otto Koivula Dylan Strome Martin Necas 332531
Nathan MacKinnon Michael Rasmussen Jesse Puljujarvi 236901.5
Chris Valentine Connor McMichael Mark Scheifele 434730.75
Nathan MacKinnon Keegan Kolesar Kole Lind 57294069380.51
Nathan MacKinnon Otto Koivula Dylan Strome 54812100.8
Chris Valentine Michael Rasmussen Martin Necas 75510-20.71
Michael Rasmussen Connor McMichael Martin Necas 554951
Chris Valentine Dylan Strome Nathan MacKinnon 1917173470.89
Otto Koivula Jesse Puljujarvi Mark Scheifele 198513-30.42
Martin Necas Keegan Kolesar Kole Lind 1014520.1
Adam Beckman Martin Necas Nathan MacKinnon 233641.5
Michael Rasmussen Jesse Puljujarvi Dylan Strome 100000
Chris Valentine Michael Rasmussen Nathan MacKinnon 233681.5
Jesse Puljujarvi Martin Necas Michael Rasmussen 951621170.56
Chris Valentine Connor McMichael Nathan MacKinnon 74610130.57
Otto Koivula Dylan Strome Mark Scheifele 100000
Nathan MacKinnon Dylan Strome Martin Necas 691423151.5
Michael Rasmussen Jesse Puljujarvi Connor McMichael 2011-20
Otto Koivula Chris Kontos Mark Scheifele 232561.5
Otto Koivula Connor McMichael Mark Scheifele 14202-100.14
Chris Valentine Michael Rasmussen Dylan Strome 78101861.14
Nathan MacKinnon Connor McMichael Martin Necas 6551080.83
Dylan Strome Kole Lind Keegan Kolesar 2000-70
Martin Necas Jesse Puljujarvi Nathan MacKinnon 514500.2
Chris Valentine Dylan Strome Connor McMichael 532560.6
Otto Koivula Michael Rasmussen Mark Scheifele 66612101
Dylan Strome Jesse Puljujarvi Nathan MacKinnon 3371061
Michael Rasmussen Otto Koivula Martin Necas 65712120.83
Adam Beckman Michael Rasmussen Martin Necas 1000-30
Chris Valentine Otto Koivula Connor McMichael 1000-30
Nathan MacKinnon Kole Lind Mark Scheifele 341541.33
Martin Necas Otto Koivula Nathan MacKinnon 2101-40.5
Nathan MacKinnon Michael Rasmussen Martin Necas 4224100.5
Chris Valentine Jesse Puljujarvi Nathan MacKinnon 2000-80
Martin Necas Connor McMichael Dylan Strome 234721.5
Michael Rasmussen Kole Lind Keegan Kolesar 1000-20
Chris Valentine Otto Koivula Dylan Strome 3112-60.33
Chris Valentine Jesse Puljujarvi Martin Necas 3123-20.33
Connor McMichael Michael Rasmussen Mark Scheifele 211230.5
Otto Koivula Kole Lind Keegan Kolesar 112341
Nathan MacKinnon Michael Rasmussen Dylan Strome 463941.5
Otto Koivula Jesse Puljujarvi Connor McMichael 3314-21
Michael Rasmussen Chris Kontos Mark Scheifele 4101-60.25
Kole Lind Jesse Puljujarvi Keegan Kolesar 3000-100
Chris Valentine Dylan Strome Jesse Puljujarvi 215670.5
Nathan MacKinnon Adam Beckman Dylan Strome 212330.5
Chris Valentine Otto Koivula Jesse Puljujarvi 1000-30
Mark Scheifele Connor McMichael Keegan Kolesar 100000
Michael Rasmussen Kole Lind Nicholas Merkley 100010
Chris Valentine Michael Rasmussen Connor McMichael 3022-10
Chris Valentine Connor McMichael Martin Necas 102200
Martin Necas Jesse Puljujarvi Dylan Strome 2112-20.5
Michael Rasmussen Connor McMichael Nathan MacKinnon 122472
Chris Valentine Otto Koivula Mark Scheifele 133643
Michael Rasmussen Otto Koivula Dylan Strome 2516122.5
Nathan MacKinnon Jesse Puljujarvi Adam Beckman 111221
Dylan Strome Kole Lind Mark Scheifele 111231
Otto Koivula Jesse Puljujarvi Dylan Strome 21-1030.5
Martin Necas Connor McMichael Jesse Puljujarvi 100000
Mark Scheifele Connor McMichael Martin Necas 1000-40
Otto Koivula Jesse Puljujarvi Martin Necas 112331
Chris Valentine Michael Rasmussen Jesse Puljujarvi 1112-91
Chris Valentine Dylan Strome Martin Necas 111201
Otto Koivula Michael Rasmussen Nathan MacKinnon 111201
Chris Valentine Otto Koivula Martin Necas 212320.5
Nathan MacKinnon Connor McMichael Mark Scheifele 111201

Attaquants PP

Trios GP G A PTS G/GP
Martin Necas Nathan MacKinnon Michael Rasmussen 791213250.15
Dylan Strome Otto Koivula Jesse Puljujarvi 51915240.18
Dylan Strome Connor McMichael Jesse Puljujarvi 2638110.12
Dylan Strome Adam Beckman Jesse Puljujarvi 50110
Michael Rasmussen Martin Necas Mark Scheifele 20000
Michael Rasmussen Martin Necas Jesse Puljujarvi 10000

Défenseurs 5vs5

Duos GP G A PTS DIFF G/GP
Devon Toews Aaron Ekblad 84196079340.23
Kaedan Korczak Jacob Trouba 4893544200.19
Jonas Siegenthaler Aaron Ekblad 18291100.11
Devon Toews Jacob Trouba 1941317150.21
Jonas Siegenthaler Tobias Bjornfot 18281030.11
Devon Toews Kaedan Korczak 1415600.07
Aaron Ekblad Tobias Bjornfot 204450
Jonas Siegenthaler Jacob Trouba 2592231170.36
Devon Toews Radim Simek 201100
Jacob Trouba Tobias Bjornfot 2251621290.23
Jonas Siegenthaler Kaedan Korczak 2601212120
Aaron Ekblad Kaedan Korczak 2021214150.1
Kaedan Korczak Nathan Clurman 100000
Jonas Siegenthaler Radim Simek 5257100.4
Scot Kleinendorst Aaron Ekblad 2000-70
Aaron Ekblad Jacob Trouba 9268-40.22
Devon Toews Jonas Siegenthaler 6066160
Nathan Clurman Aaron Ekblad 102200
Radim Simek Aaron Ekblad 202200
Jyrki Seppa Aaron Ekblad 101110
Devon Toews Tobias Bjornfot 112331
Nathan Clurman Jonas Siegenthaler 200000

Défenseurs PP

Duos GP G A PTS G/GP
Connor McMichael Aaron Ekblad 221340.05
Jonas Siegenthaler Chris Valentine 142130.14
Chris Valentine Aaron Ekblad 54210120.04
Tobias Bjornfot Connor McMichael 100110
Kaedan Korczak Chris Valentine 30000
Jonas Siegenthaler Connor McMichael 70110
Kaedan Korczak Connor McMichael 140110
Aaron Ekblad Otto Koivula 262570.08
Jonas Siegenthaler Mark Scheifele 50220
Chris Valentine Tobias Bjornfot 60110
Radim Simek Connor McMichael 30000