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 = 2040 AND GL.season = 2040 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
Aliaksei Protas Mitchell Dempsey David Pastrnak 31354883671.13
Thomas Novak Auston Matthews Walt Poddubny 19151530100.79
Kirby Dach Grigori Denisenko Jakub Vrana 23182644270.78
Nikita Pavlychev Frazer McLaren David Pastrnak 13121426190.92
Mitchell Dempsey Aliaksei Protas Auston Matthews 96101600.67
Thomas Novak Walt Poddubny David Pastrnak 14101727350.71
Auston Matthews Frazer McLaren Max Veronneau 5112-40.2
Grigori Denisenko Aliaksei Protas Mitchell Dempsey 11102030200.91
Thomas Novak Auston Matthews Kirby Dach 1412132550.86
Nikita Pavlychev Walt Poddubny Jakub Vrana 11581350.45
Walker Duehr Auston Matthews Max Veronneau 12751200.58
Nikita Pavlychev Auston Matthews Max Veronneau 9381110.33
Mitchell Dempsey David Pastrnak Auston Matthews 517820.2
Aliaksei Protas Grigori Denisenko Kirby Dach 100000
Thomas Novak Walt Poddubny Jakub Vrana 212330.5
Auston Matthews Frazer McLaren Walker Duehr 2615112600.58
Grigori Denisenko Kirby Dach Mitchell Dempsey 65813-40.83
Auston Matthews Aliaksei Protas Walt Poddubny 324640.67
Nikita Pavlychev Jakub Vrana Max Veronneau 6551010.83
Auston Matthews Mitchell Dempsey Grigori Denisenko 97815-30.78
Aliaksei Protas Walt Poddubny David Pastrnak 122462
Kirby Dach Jakub Vrana Steve Gatzos 1011-20
Thomas Novak Aliaksei Protas David Pastrnak 9538-120.56
Kirby Dach Walt Poddubny Steve Gatzos 435870.75
Kirby Dach Walt Poddubny Jakub Vrana 93710-20.33
Thomas Novak Grigori Denisenko Kirby Dach 210100.5
Auston Matthews Walt Poddubny Kirby Dach 322400.67
Walker Duehr Frazer McLaren Jakub Vrana 2000-60
Thomas Novak Aliaksei Protas Grigori Denisenko 434740.75
Walker Duehr Frazer McLaren David Pastrnak 702220
Ethan Phillips Walt Poddubny Grigori Denisenko 321320.67
Auston Matthews Frazer McLaren Jakub Vrana 623550.33
Auston Matthews Grigori Denisenko Walt Poddubny 5336-40.6
Kirby Dach Jakub Vrana Linus Karlsson 2000-10
Kirby Dach Frazer McLaren Jakub Vrana 100000
Auston Matthews Mitchell Dempsey Kirby Dach 6381100.5
Walker Duehr Walt Poddubny Grigori Denisenko 2000-60
Ethan Phillips Frazer McLaren Jakub Vrana 1000-10
Aliaksei Protas Grigori Denisenko Steve Gatzos 100000
Thomas Novak Mitchell Dempsey Walt Poddubny 100000
Auston Matthews Aliaksei Protas Grigori Denisenko 1000-30
Thomas Novak Auston Matthews Grigori Denisenko 2213-71
Walker Duehr Jakub Vrana David Pastrnak 2000-40
Ethan Phillips Aliaksei Protas Jakub Vrana 202200
Nikita Pavlychev Walt Poddubny David Pastrnak 100000
Linus Karlsson Walt Poddubny Jakub Vrana 210100.5
Aliaksei Protas Mitchell Dempsey Kirby Dach 2123-60.5
Ethan Phillips Jakub Vrana Steve Gatzos 200000
Kirby Dach Aliaksei Protas Steve Gatzos 202230
Thomas Novak Mitchell Dempsey Aliaksei Protas 1000-50
Nikita Pavlychev Walker Duehr Max Veronneau 1000-30
Aliaksei Protas Frazer McLaren David Pastrnak 1000-30
Nikita Pavlychev Walt Poddubny Grigori Denisenko 1000-30
Kirby Dach Mason Primeau Jakub Vrana 2101-30.5
Ethan Phillips Aliaksei Protas Grigori Denisenko 211230.5
Auston Matthews Grigori Denisenko Kirby Dach 1000-60
Thomas Novak Auston Matthews David Pastrnak 1112-11
Thomas Novak Auston Matthews Aliaksei Protas 100000
Nikita Pavlychev Auston Matthews Walker Duehr 1000-80
Thomas Novak Walt Poddubny Grigori Denisenko 111201

Attaquants PP

Trios GP G A PTS G/GP
Mitchell Dempsey Grigori Denisenko Auston Matthews 131120.08
Thomas Novak Aliaksei Protas David Pastrnak 1655100.31
Auston Matthews Mitchell Dempsey David Pastrnak 91120.11
Aliaksei Protas Grigori Denisenko Kirby Dach 10000
David Pastrnak Aliaksei Protas Mitchell Dempsey 331560.03
Thomas Novak Auston Matthews Walt Poddubny 1946100.21
Thomas Novak Aliaksei Protas Grigori Denisenko 41120.25
Thomas Novak Auston Matthews Kirby Dach 1346100.31
Auston Matthews Grigori Denisenko Walt Poddubny 30000
Mitchell Dempsey Grigori Denisenko Aliaksei Protas 90000
Auston Matthews Walt Poddubny Kirby Dach 30000
Aliaksei Protas Walt Poddubny David Pastrnak 20000
Auston Matthews Mitchell Dempsey Aliaksei Protas 90000
Thomas Novak Walt Poddubny David Pastrnak 51230.2
Kirby Dach Aliaksei Protas Walt Poddubny 40000
Auston Matthews Mitchell Dempsey Kirby Dach 40000
Thomas Novak Walt Poddubny Grigori Denisenko 20000
Kirby Dach Grigori Denisenko Jakub Vrana 10000
Kirby Dach Mitchell Dempsey Grigori Denisenko 30000
Thomas Novak Auston Matthews Aliaksei Protas 10000
Aliaksei Protas Mitchell Dempsey Kirby Dach 10000
Thomas Novak Walt Poddubny Aliaksei Protas 20000
Thomas Novak Auston Matthews Grigori Denisenko 20000
Thomas Novak Grigori Denisenko Kirby Dach 20000
Thomas Novak Auston Matthews David Pastrnak 20000
Auston Matthews Grigori Denisenko Kirby Dach 10000

Défenseurs 5vs5

Duos GP G A PTS DIFF G/GP
Paul Coffey Matias Samuelson 3221719-110.06
Moe Mantha Conor Timmins 302131560.07
Nicolas Beaudin Eric Roy 433710-60.07
Paul Coffey Conor Timmins 46102838140.22
Moe Mantha Matias Samuelson 2642226250.15
Eddie Wittchow Eric Roy 182111390.11
Paul Coffey Eddie Wittchow 502210
Matias Samuelson Nicolas Beaudin 4101-20.25
Eddie Wittchow Conor Timmins 1535870.2
Nicolas Beaudin Seth Jones 1212360.08
Paul Coffey Moe Mantha 63183553530.29
Matias Samuelson Seth Jones 300040
Matias Samuelson Conor Timmins 2009930
Nicolas Beaudin Eddie Wittchow 611230.17
Matias Samuelson Eddie Wittchow 302220
Eric Roy Seth Jones 201100

Défenseurs PP

Duos GP G A PTS G/GP
Paul Coffey Matias Samuelson 160000
Moe Mantha Conor Timmins 240440
Paul Coffey Kirby Dach 82020.25
Walt Poddubny Conor Timmins 81340.13
Paul Coffey Nicolas Beaudin 60000
Walt Poddubny Moe Mantha 40000
Paul Coffey Conor Timmins 182350.11
Moe Mantha Matias Samuelson 60000
Paul Coffey David Pastrnak 51010.2
Grigori Denisenko Moe Mantha 161120.06
Paul Coffey Moe Mantha 110000
Nicolas Beaudin Conor Timmins 50000
Conor Timmins David Pastrnak 10000
Paul Coffey Grigori Denisenko 41010.25
Grigori Denisenko Conor Timmins 80220
Auston Matthews Moe Mantha 71340.14
Matias Samuelson Conor Timmins 60110
Paul Coffey Walt Poddubny 40000
Mitchell Dempsey Moe Mantha 30000
Paul Coffey Aliaksei Protas 10000
Paul Coffey Eddie Wittchow 20000
Paul Coffey Steve Gatzos 10000