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

Statistiques des trios - Detroit

Attaquants 5vs5

Trios GP G A PTS DIFF G/GP
David Pastrnak Mitchell Dempsey Auston Matthews 24303565581.25
Thomas Novak Aliaksei Protas Grigori Denisenko 25242246330.96
Ethan Phillips Mason Primeau Andre Burakovsky 7571270.71
Linus Karlsson Walt Poddubny Auston Matthews 4268100.5
Mason Primeau Walt Poddubny Andre Burakovsky 1520210.13
Linus Karlsson Auston Matthews Frazer McLaren 20101525220.5
Mitchell Dempsey Auston Matthews Grigori Denisenko 65914-30.83
Thomas Novak Aliaksei Protas David Pastrnak 513420.2
Ethan Phillips Walt Poddubny Andre Burakovsky 154610-10.27
Linus Karlsson Mason Primeau Auston Matthews 744800.57
David Pastrnak Walt Poddubny Auston Matthews 1000-30
David Pastrnak Linus Karlsson Frazer McLaren 201110
David Pastrnak Aliaksei Protas Andre Burakovsky 1000-90
Thomas Novak Ethan Phillips Walt Poddubny 1000-20
David Pastrnak Linus Karlsson Mason Primeau 331441
David Pastrnak Mitchell Dempsey Aliaksei Protas 5112-70.2
Auston Matthews Thomas Novak Grigori Denisenko 554971
Grigori Denisenko Auston Matthews David Pastrnak 1123-11
Mitchell Dempsey Thomas Novak Aliaksei Protas 10-1-1-100
Mitchell Dempsey Linus Karlsson Mason Primeau 100010
Auston Matthews David Pastrnak Aliaksei Protas 2257-11
Grigori Denisenko Mitchell Dempsey Thomas Novak 212310.5
Andre Burakovsky Linus Karlsson Walt Poddubny 100000
Mitchell Dempsey Mason Primeau Ethan Phillips 1011-30
Mitchell Dempsey Linus Karlsson Ethan Phillips 100000

Attaquants PP

Trios GP G A PTS G/GP
David Pastrnak Mitchell Dempsey Auston Matthews 2847110.14
Grigori Denisenko Aliaksei Protas Thomas Novak 28712190.25
Auston Matthews David Pastrnak Aliaksei Protas 20000
Grigori Denisenko Mitchell Dempsey Thomas Novak 20000
David Pastrnak Mitchell Dempsey Aliaksei Protas 51340.2
Grigori Denisenko Thomas Novak Auston Matthews 51450.2
Auston Matthews David Pastrnak Grigori Denisenko 10000
Mitchell Dempsey Aliaksei Protas Thomas Novak 11121
Grigori Denisenko Mitchell Dempsey Auston Matthews 20000
David Pastrnak Aliaksei Protas Thomas Novak 20000
Grigori Denisenko Aliaksei Protas Andre Burakovsky 10000
Auston Matthews Walt Poddubny David Pastrnak 10000

Défenseurs 5vs5

Duos GP G A PTS DIFF G/GP
Paul Coffey Moe Mantha 58134154540.22
Conor Timmins Marc DelGaizo 10268-20.2
Matias Samuelson Ryan Shea 32381130.09
Eddie Wittchow Marc DelGaizo 16191070.06
Eddie Wittchow Ryan Shea 301110
Conor Timmins Paul Coffey 3112-50.33
Marc DelGaizo Paul Coffey 122911180.17
Moe Mantha Conor Timmins 173710-20.18
Matias Samuelson Marc DelGaizo 504430

Défenseurs PP

Duos GP G A PTS G/GP
Paul Coffey Andre Burakovsky 212680.1
Andre Burakovsky Marc DelGaizo 172460.12
Andre Burakovsky Conor Timmins 61120.17
Moe Mantha Paul Coffey 40000
Conor Timmins Marc DelGaizo 40000
Paul Coffey Conor Timmins 30000
Marc DelGaizo Moe Mantha 30000
Walt Poddubny Paul Coffey 100110
Walt Poddubny Conor Timmins 101010.1