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

Statistiques des trios - Winnipeg

Attaquants 5vs5

Trios
GP
G
A
PTS
DIFF
G/GP
Viktor Arvidsson Jonathan Dahlen Kirill Kaprizov 12151631131.25
Jonathan Drouin Nikolay Prokhorkin Jonathan Dahlen 68715-121.33
Drake Batherson Nikolay Prokhorkin Viktor Arvidsson 94101450.44
Drake Batherson Filip Zadina Viktor Arvidsson 74913-10.57
Vincent Hinostroza Daniel Carr Filip Zadina 63811100.5
Jonathan Drouin Kirill Kaprizov Filip Zadina 84711-80.5
Jonathan Drouin Joonas Kemppainen Alexander Kadeykin 6551070.83
Jonathan Drouin Kirill Kaprizov Nikolay Prokhorkin 64610-20.67
Jonathan Drouin Mathias From Daniel Carr 12461050.33
Viktor Arvidsson Drake Batherson Kirill Kaprizov 5549-61
Jonathan Drouin Kirill Kaprizov Jonathan Dahlen 134793
Nikolay Prokhorkin Jonathan Drouin Filip Zadina 10336-110.3
Drake Batherson Mathias From Daniel Carr 1033610.3
Alexander Kadeykin Joonas Kemppainen Vincent Hinostroza 8145-150.13
Jonathan Dahlen Kirill Kaprizov Nikolay Prokhorkin 123562
Jonathan Drouin Mathias From Alexander Kadeykin 721300.29
Vincent Hinostroza Kirill Kaprizov Viktor Arvidsson 202210
Drake Batherson Nikolay Prokhorkin Filip Zadina 310110.33
Vincent Hinostroza Daniel Carr Joonas Kemppainen 5000-50
Jonathan Dahlen Alexander Kadeykin Vincent Hinostroza 14000-300
Jonathan Dahlen Daniel Carr Joonas Kemppainen 100000
Joonas Kemppainen Daniel Carr Filip Zadina 1000-30

Attaquants PP

Trios
GP
G
A
PTS
G/GP
Vincent Hinostroza Jonathan Drouin Jonathan Dahlen 61450.17
Vincent Hinostroza Kirill Kaprizov Jonathan Dahlen 51230.2
Drake Batherson Jonathan Drouin Jonathan Dahlen 50220
Nikolay Prokhorkin Viktor Arvidsson Jonathan Drouin 101120.1
Drake Batherson Kirill Kaprizov Jonathan Dahlen 51120.2
Drake Batherson Vincent Hinostroza Jonathan Dahlen 71120.14
Kirill Kaprizov Viktor Arvidsson Jonathan Drouin 81010.13
Drake Batherson Vincent Hinostroza Alexander Kadeykin 40110
Nikolay Prokhorkin Viktor Arvidsson Kirill Kaprizov 141010.07
Drake Batherson Kirill Kaprizov Viktor Arvidsson 30000
Nikolay Prokhorkin Jonathan Drouin Jonathan Dahlen 20000
Jonathan Dahlen Nikolay Prokhorkin Vincent Hinostroza 10000

Défenseurs 5vs5

Duos
GP
G
A
PTS
DIFF
G/GP
Shea Theodore Aaron Ekblad 315303570.16
Aaron Ekblad Jakub Galvas 2331720160.13
Shea Theodore Troy Stecher 1341216-50.31
Shea Theodore Jakub Galvas 8381150.38
Shea Theodore Jordan Harris 182810-80.11
Aaron Ekblad Troy Stecher 825700.25
Troy Stecher Jakub Galvas 414540.25
Jordan Harris Dmitriy Zaitsev 17044-150
Troy Stecher Dmitriy Zaitsev 14314-120.21
Derrick Pouliot Dmitriy Zaitsev 4202-10.5

Défenseurs PP

Duos
GP
G
A
PTS
G/GP
Troy Stecher Jordan Harris 242240.08
Jordan Harris Jonathan Dahlen 40110
Shea Theodore Aaron Ekblad 240110
Troy Stecher Aaron Ekblad 20110
Shea Theodore Nikolay Prokhorkin 80000
Shea Theodore Jordan Harris 20000
Jordan Harris Aaron Ekblad 50000
Shea Theodore Troy Stecher 10000