SELECT GL.*, E.joueur FROM game_lines GL, joueurequipe E, joueur J WHERE GL.FK_team = 20 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 - LasVegas

Attaquants 5vs5

Trios GP G A PTS DIFF G/GP
Nikita Kucherov Travis Konecny Adrian Kempe 664663109-140.7
Ygor Sharangovic Casey Mittelstadt Andrei Kuzmenko 63304777-900.48
Kole Lind Jaret Dolan Kevin Labanc 25121325-230.48
Adam Edstrom Greg Terrion Jonatan Berggren 41101121-240.24
Jaret Dolan Rodrigo Abols Kevin Labanc 37142539-90.38
Kole Lind Greg Terrion Jonatan Berggren 13101-130.08
Rodrigo Abols Wade Allison Kevin Labanc 156915-140.4
Ygor Sharangovic Nikita Kucherov Travis Konecny 1612122400.75
Adrian Kempe Casey Mittelstadt Andrei Kuzmenko 169817-200.56
Kole Lind Greg Terrion Carl Grundstrom 20781590.35
Adam Edstrom Greg Terrion Evgeny Svechnikov 6000-60
Jaret Dolan Kevin Labanc 3000-20
Ygor Sharangovic Jonatan Berggren Andrei Kuzmenko 3101-130.33
Rodrigo Abols Jonatan Berggren Kevin Labanc 2000-30
Adam Edstrom Greg Terrion Wade Allison 200000

Attaquants PP

Trios GP G A PTS G/GP
Nikita Kucherov Travis Konecny Ygor Sharangovic 8238110.04
Andrei Kuzmenko Casey Mittelstadt Kevin Labanc 791218300.15
Andrei Kuzmenko Jonatan Berggren Kevin Labanc 30000

Défenseurs 5vs5

Duos GP G A PTS DIFF G/GP
Miska Kukkonen Adam Fox 81124254-120.15
Josh Morrissey Mark Shoemaker 6682230-900.12
Billy Schoenfeld Eric Roy 6622123-360.03
Josh Morrissey Vlad Yeryomenko 6691524-610.14
Vlad Yeryomenko Mark Shoemaker 16000-220
Billy Schoenfeld Josh Morrissey 16257-110.13
Vlad Yeryomenko Eric Roy 16369-80.19
Adam Fox Mark Shoemaker 100000

Défenseurs PP

Duos GP G A PTS G/GP
Adrian Kempe Adam Fox 823580.04
Mark Shoemaker Eric Roy 140330
Josh Morrissey Eric Roy 681560.01