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

Attaquants PP

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

Défenseurs 5vs5

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

Défenseurs PP

Duos GP G A PTS G/GP
Paul Coffey Moe Mantha 110000
Nicolas Beaudin Conor Timmins 50000
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
Auston Matthews Moe Mantha 71340.14
Paul Coffey Grigori Denisenko 41010.25
Grigori Denisenko Conor Timmins 80220
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
Conor Timmins David Pastrnak 10000