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
Mitchell Dempsey Grigori Denisenko Auston Matthews 97815-30.78
Thomas Novak Aliaksei Protas David Pastrnak 9538-120.56
Kirby Dach Walt Poddubny Jakub Vrana 4134-20.25
Auston Matthews Frazer McLaren Walker Duehr 2014102490.7
Kirby Dach Mitchell Dempsey Grigori Denisenko 65813-40.83
Auston Matthews Aliaksei Protas Walt Poddubny 324640.67
Nikita Pavlychev Jakub Vrana Max Veronneau 6551010.83
Aliaksei Protas Walt Poddubny David Pastrnak 122462
Kirby Dach Jakub Vrana Steve Gatzos 1011-20
Kirby Dach Walt Poddubny Steve Gatzos 323550.67
Aliaksei Protas Mitchell Dempsey Grigori Denisenko 991928191
Thomas Novak Auston Matthews Kirby Dach 10121224151.2
Nikita Pavlychev Walt Poddubny Jakub Vrana 11581350.45
Max Veronneau Auston Matthews Walker Duehr 11751210.64
Auston Matthews Mitchell Dempsey Kirby Dach 6381100.5
Thomas Novak Walt Poddubny David Pastrnak 771320221
Aliaksei Protas Grigori Denisenko Steve Gatzos 100000
Walker Duehr Walt Poddubny Grigori Denisenko 2000-60
Auston Matthews Frazer McLaren Jakub Vrana 412330.25
Auston Matthews Walt Poddubny Kirby Dach 322400.67
Ethan Phillips Frazer McLaren Jakub Vrana 1000-10
Thomas Novak Auston Matthews David Pastrnak 1112-11
Thomas Novak Auston Matthews Aliaksei Protas 100000
Aliaksei Protas Mitchell Dempsey David Pastrnak 581321251.6
Ethan Phillips Walt Poddubny Grigori Denisenko 2112-10.5
Ethan Phillips Aliaksei Protas Jakub Vrana 202200
Walker Duehr Frazer McLaren David Pastrnak 201120
Auston Matthews Mitchell Dempsey Aliaksei Protas 322400.67
Thomas Novak Walt Poddubny Grigori Denisenko 111201
Aliaksei Protas Mitchell Dempsey Kirby Dach 2123-60.5
Auston Matthews Walt Poddubny Grigori Denisenko 3336-31
Ethan Phillips Jakub Vrana Steve Gatzos 200000
Kirby Dach Aliaksei Protas Steve Gatzos 202230
Ethan Phillips Aliaksei Protas Grigori Denisenko 211230.5
Walker Duehr Frazer McLaren Jakub Vrana 2000-60
Auston Matthews Nikita Pavlychev Max Veronneau 202200
Thomas Novak Grigori Denisenko Kirby Dach 210100.5
Auston Matthews Frazer McLaren Max Veronneau 2101-20.5
Thomas Novak Mitchell Dempsey Walt Poddubny 100000
Auston Matthews Aliaksei Protas Grigori Denisenko 1000-30
David Pastrnak Nikita Pavlychev Walt Poddubny 100000
Walker Duehr Jakub Vrana David Pastrnak 100000
Thomas Novak Mitchell Dempsey Aliaksei Protas 1000-50

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
Mitchell Dempsey Grigori Denisenko Aliaksei Protas 70000
Thomas Novak Auston Matthews Kirby Dach 94370.44
Mitchell Dempsey David Pastrnak Auston Matthews 31120.33
Aliaksei Protas Walt Poddubny David Pastrnak 10000
Kirby Dach Aliaksei Protas Walt Poddubny 40000
Auston Matthews Mitchell Dempsey Kirby Dach 40000
Auston Matthews Mitchell Dempsey Aliaksei Protas 40000
Thomas Novak Walt Poddubny Grigori Denisenko 20000
Aliaksei Protas Mitchell Dempsey David Pastrnak 70000
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 10000
Thomas Novak Grigori Denisenko Kirby Dach 20000
Thomas Novak Aliaksei Protas Walt Poddubny 10000
Thomas Novak Auston Matthews David Pastrnak 20000
Auston Matthews Walt Poddubny Kirby Dach 30000

Défenseurs 5vs5

Duos GP G A PTS DIFF G/GP
Matias Samuelson Paul Coffey 3221719-110.06
Moe Mantha Conor Timmins 302131560.07
Nicolas Beaudin Eric Roy 363710-30.08
Paul Coffey Conor Timmins 2852025110.18
Eddie Wittchow Paul Coffey 502210
Matias Samuelson Nicolas Beaudin 4101-20.25
Moe Mantha Matias Samuelson 400000
Eddie Wittchow Eric Roy 211210.5
Paul Coffey Moe Mantha 1451015260.36
Matias Samuelson Conor Timmins 13088120

Défenseurs PP

Duos GP G A PTS G/GP
Matias Samuelson Paul Coffey 160000
Moe Mantha Conor Timmins 240440
Moe Mantha Paul Coffey 100000
Nicolas Beaudin Conor Timmins 50000
Kirby Dach Paul Coffey 21010.5
Walt Poddubny Conor Timmins 30330
Nicolas Beaudin Paul Coffey 60000
Conor Timmins Paul Coffey 50000
Moe Mantha Matias Samuelson 50000
Paul Coffey Grigori Denisenko 10000
Matias Samuelson Conor Timmins 50110
Paul Coffey Eddie Wittchow 20000