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

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
Aaron Ekblad Devon Toews 84196079340.23
Jacob Trouba Tobias Bjornfot 2251621290.23
Jonas Siegenthaler Kaedan Korczak 2601212120
Jonas Siegenthaler Jacob Trouba 2592231170.36
Kaedan Korczak Jacob Trouba 4893544200.19
Devon Toews Radim Simek 201100
Tobias Bjornfot Jonas Siegenthaler 18281030.11
Devon Toews Jacob Trouba 1941317150.21
Aaron Ekblad Kaedan Korczak 2021214150.1
Jonas Siegenthaler Devon Toews 6066160
Nathan Clurman Jonas Siegenthaler 200000
Aaron Ekblad Jonas Siegenthaler 18291100.11
Kaedan Korczak Devon Toews 1415600.07
Jonas Siegenthaler Radim Simek 5257100.4
Radim Simek Aaron Ekblad 202200
Aaron Ekblad Jacob Trouba 9268-40.22
Jyrki Seppa Aaron Ekblad 101110
Devon Toews Tobias Bjornfot 112331
Scot Kleinendorst Aaron Ekblad 2000-70
Aaron Ekblad Tobias Bjornfot 204450
Kaedan Korczak Nathan Clurman 100000
Aaron Ekblad Nathan Clurman 102200

Défenseurs PP

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