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 = 2039 AND GL.season = 2039 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 Nathan MacKinnon Connor McMichael 10131730251.3
Chris Valentine Dylan Strome Jesse Puljujarvi 169918-50.56
Otto Koivula Michael Rasmussen Pavel Zacha 52-11-20.4
Nathan MacKinnon Kole Lind Oskar Steen 322440.67
Dylan Strome Martin Necas Chris Valentine 17151934180.88
Michael Rasmussen Otto Koivula Jesse Puljujarvi 11121224211.09
Pavel Zacha Philip Tomasino Peyton Krebs 95712120.56
Dylan Strome Kole Lind Nicholas Merkley 127714-50.58
Nathan MacKinnon Martin Necas Michael Rasmussen 12141327-81.17
Otto Koivula Kole Lind Pavel Zacha 18111223270.61
Nathan MacKinnon Joel Kellman Nicholas Merkley 149112030.64
Michael Rasmussen Dylan Strome Peyton Krebs 1123-51
Chris Valentine Otto Koivula Jesse Puljujarvi 201100
Pavel Zacha Philip Tomasino Martin Necas 112301
Michael Rasmussen Jesse Puljujarvi Martin Necas 1381119160.62
Chris Valentine Dylan Strome Nathan MacKinnon 128917120.67
Pavel Zacha Otto Koivula Jakub Lauko 1913142780.68
Joel Kellman Kole Lind Dylan Strome 614550.17
Jesse Puljujarvi Dylan Strome Martin Necas 8437-50.5
Chris Valentine Michael Rasmussen Nathan MacKinnon 845960.5
Otto Koivula Peyton Krebs Martin Kaut 410120.25
Nathan MacKinnon Pavel Zacha Kole Lind 404440
Pavel Zacha Philip Tomasino Jakub Lauko 533620.6
Michael Rasmussen Kole Lind Nicholas Merkley 411240.25
Chris Valentine Michael Rasmussen Jesse Puljujarvi 1613142710.81
Otto Koivula Dylan Strome Pavel Zacha 5022-30
Dylan Strome Kole Lind Oskar Steen 713420.14
Martin Necas Dylan Strome Nathan MacKinnon 951015200.56
Nathan MacKinnon Joel Kellman Kole Lind 442681
Chris Valentine Joel Kellman Nicholas Merkley 300010
Nathan MacKinnon Otto Koivula Dylan Strome 6437-100.67
Chris Valentine Michael Rasmussen Martin Necas 323530.67
Peyton Krebs Jesse Puljujarvi Pavel Zacha 2000-30
Nathan MacKinnon Kole Lind Nicholas Merkley 1341014110.31
Chris Valentine Michael Rasmussen Dylan Strome 324620.67
Martin Necas Otto Koivula Jesse Puljujarvi 315680.33
Michael Rasmussen Jesse Puljujarvi Nathan MacKinnon 6369110.5
Chris Valentine Otto Koivula Dylan Strome 111231
Kole Lind Jesse Puljujarvi Joel Kellman 1000-60
Nathan MacKinnon Grant Besse Nicholas Merkley 3112-40.33
Michael Rasmussen Grant Besse Nicholas Merkley 1000-30
Oskar Steen Dylan Strome Nicholas Merkley 110101
Nathan MacKinnon Michael Rasmussen Dylan Strome 210130.5
Chris Valentine Jesse Puljujarvi Martin Necas 100000
Otto Koivula Peyton Krebs Pavel Zacha 4000-30
Nathan MacKinnon Grant Besse Kole Lind 111201
Dylan Strome Joel Kellman Nicholas Merkley 3123-20.33
Martin Necas Kole Lind Pavel Zacha 210100.5
Dylan Strome Connor McMichael Martin Necas 1000-80
Otto Koivula John Beecher Pavel Zacha 10-1-100
Connor McMichael Kole Lind Oskar Steen 1000-30
Nicholas Merkley Kole Lind Jesse Puljujarvi 120212
Pavel Zacha Otto Koivula Philip Tomasino 10-1-100
Otto Koivula Joel Kellman Pavel Zacha 10-2-200
Peyton Krebs Michael Rasmussen Jesse Puljujarvi 212330.5
Martin Necas Kole Lind Philip Tomasino 100000
Pavel Zacha Peyton Krebs Martin Necas 100000
Pavel Zacha Kole Lind Jakub Lauko 100000
Otto Koivula Philip Tomasino Kole Lind 100010
Nathan MacKinnon Stew Gavin Nicholas Merkley 10-1-1-10
Nathan MacKinnon Dylan Strome Jesse Puljujarvi 1011-20

Attaquants PP

Trios GP G A PTS G/GP
Jesse Puljujarvi Michael Rasmussen Dylan Strome 5277140.13
Pavel Zacha Chris Valentine Otto Koivula 322460.06
Michael Rasmussen Chris Valentine Jesse Puljujarvi 72240.29
Dylan Strome Pavel Zacha Otto Koivula 72350.29
Otto Koivula Michael Rasmussen Chris Valentine 848120.5
Dylan Strome Nathan MacKinnon Jesse Puljujarvi 42240.5
Dylan Strome Nathan MacKinnon Michael Rasmussen 121230.08
Dylan Strome Chris Valentine Martin Necas 92130.22
Dylan Strome Chris Valentine Otto Koivula 142350.14
Chris Valentine Nathan MacKinnon Otto Koivula 51010.2
Michael Rasmussen Chris Valentine Connor McMichael 30000
Dylan Strome Otto Koivula Jesse Puljujarvi 72350.29
Dylan Strome Chris Valentine Peyton Krebs 10000
Peyton Krebs Nathan MacKinnon Otto Koivula 20000
Pavel Zacha Nathan MacKinnon Otto Koivula 10000

Défenseurs 5vs5

Duos GP G A PTS DIFF G/GP
Aaron Ekblad Jacob Trouba 3542731300.11
Devon Toews Jonas Siegenthaler 5173542250.14
Devon Toews Kaedan Korczak 2962228260.21
Kaedan Korczak Jacob Trouba 4642832160.09
Yegor Zaitsev Aaron Ekblad 10066-20
Aaron Ekblad Devon Toews 386182420.16
Jonas Siegenthaler Jacob Trouba 3471926220.21
Aaron Ekblad Kaedan Korczak 203101320.15
Jacob Trouba Devon Toews 1024620.2
Kaedan Korczak Jonas Siegenthaler 11134-10.09
Tobias Bjornfot Jonas Siegenthaler 2000-40
Scot Kleinendorst Kaedan Korczak 102240
Yegor Zaitsev Devon Toews 405580
Yegor Zaitsev Jacob Trouba 2071118110.35
Yegor Zaitsev Jonas Siegenthaler 902250
Jacob Trouba Tobias Bjornfot 303350
Jonas Siegenthaler Aaron Ekblad 213410.5
Jacob Trouba Scot Kleinendorst 204460
Scot Kleinendorst Devon Toews 112351

Défenseurs PP

Duos GP G A PTS G/GP
Kaedan Korczak Nathan MacKinnon 252130.08
Jonas Siegenthaler Martin Necas 351450.03
Aaron Ekblad Nathan MacKinnon 2337100.13
Jacob Trouba Martin Necas 150220
Devon Toews Nathan MacKinnon 21010.5
Aaron Ekblad Peyton Krebs 90110
Jonas Siegenthaler Jesse Puljujarvi 120110
Aaron Ekblad Martin Necas 180220
Jonas Siegenthaler Philip Tomasino 40110
Jacob Trouba Philip Tomasino 90220
Jacob Trouba Pavel Zacha 21230.5
Nathan MacKinnon Jonas Siegenthaler 40000
Yegor Zaitsev Martin Necas 40000
Tobias Bjornfot Martin Necas 10000
Otto Koivula Aaron Ekblad 11011