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 = 2038 AND GL.season = 2038 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
Morgan Frost Mitchell Dempsey David Pastrnak 6161791401271
Thomas Novak Auston Matthews Ethan Phillips 1371219-90.54
Nikita Pavlychev Matthew Strome Todd Burgess 71273966220.38
Tyson Jost Mitchell Dempsey Hunter Smith 66434790470.65
Thomas Novak Auston Matthews Grigori Denisenko 210100.5
Thomas Novak Auston Matthews Kirby Dach 45323264220.71
Tyson Jost Auston Matthews Hunter Smith 732500.43
Morgan Frost Mitchell Dempsey Kirby Dach 1915223760.79
Thomas Novak Auston Matthews David Pastrnak 1613193250.81
Hunter Smith Matthew Strome Filip Sveningsson 2000-10
Todd Burgess Aleksi Saarela David Pastrnak 220221
Todd Burgess Matthew Strome Filip Sveningsson 522410.4
Thomas Novak Auston Matthews Hunter Smith 1000-30
Tyson Jost Mitchell Dempsey Ethan Phillips 100000
Auston Matthews Grigori Denisenko David Pastrnak 335881
Nikita Pavlychev Filip Sveningsson Todd Burgess 2000-90
Aleksi Saarela Mitchell Dempsey Hunter Smith 2011-20
Ethan Phillips Mitchell Dempsey Hunter Smith 2101-10.5
Morgan Frost Mitchell Dempsey Ethan Phillips 221331
Thomas Novak Grigori Denisenko David Pastrnak 2235-21
Nikita Pavlychev Aleksi Saarela Todd Burgess 2000-30
Hunter Smith Mitchell Dempsey Filip Sveningsson 111231
Hunter Smith Aleksi Saarela David Pastrnak 1000-30

Attaquants PP

Trios GP G A PTS G/GP
David Pastrnak Morgan Frost Mitchell Dempsey 7597160.12
Thomas Novak Auston Matthews Kirby Dach 571016260.18
Thomas Novak Auston Matthews Ethan Phillips 152350.13
Thomas Novak Auston Matthews Hunter Smith 10000
Morgan Frost Mitchell Dempsey Kirby Dach 70000
Auston Matthews Grigori Denisenko David Pastrnak 30000
Thomas Novak Auston Matthews Grigori Denisenko 20000
Thomas Novak Grigori Denisenko David Pastrnak 20110
Thomas Novak Auston Matthews David Pastrnak 20000

Défenseurs 5vs5

Duos GP G A PTS DIFF G/GP
Paul Coffey Conor Timmins 82164359840.2
Nicolas Beaudin Shayne Gostisbehere 2151823140.24
Gustav Forsling Carson Soucy 527162360.13
Paul Coffey Shayne Gostisbehere 71147488690.2
Samuel Morin Shayne Gostisbehere 9101-100.11
Nicolas Beaudin Conor Timmins 3731518130.08
Samuel Morin Conor Timmins 2134790.14
Nicolas Beaudin Carson Soucy 243121550.13
Nicolas Beaudin Samuel Morin 3000-20
Christian Jaros Carson Soucy 100000
Carson Soucy Samuel Morin 4000-40
Shayne Gostisbehere Conor Timmins 1000-10
Alex Lintuniemi Carson Soucy 1000-10
Paul Coffey Samuel Morin 1000-10

Défenseurs PP

Duos GP G A PTS G/GP
Paul Coffey Shayne Gostisbehere 611890.02
Nicolas Beaudin Conor Timmins 5738110.05
Conor Timmins Paul Coffey 250110
Nicolas Beaudin Shayne Gostisbehere 141230.07
Shayne Gostisbehere David Pastrnak 40000
Nicolas Beaudin David Pastrnak 30000