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

Statistiques des trios - Colombus

Attaquants 5vs5

Trios GP G A PTS DIFF G/GP
Fabian Zetterlund Ondrej Kase Mark Jankowski 321360.67
Tobias Rieder Mason Marchment Jesperi Kotkaniemi 302230
Evan Rodrigues Ryan Poehling Dimitri Voronkov 19152035380.79
Jim Harris Mason Marchment Jonas Rondbjerg 184711-130.22
Ondrej Kase Mason Marchment Jesperi Kotkaniemi 1000-30
Mark Jankowski Fabian Zetterlund Evan Rodrigues 1123-61
Tobias Rieder Ryan Poehling Dimitri Voronkov 6325-10.5
Tobias Rieder Ondrej Kase Mason Marchment 2000-160
Mark Jankowski Jesperi Kotkaniemi Fabian Zetterlund 107916130.7
Fabian Zetterlund Mason Marchment Ondrej Kase 11581320.45
Tobias Rieder Mark Jankowski Jesperi Kotkaniemi 117815-110.64
Ondrej Kase Mason Marchment Evan Rodrigues 7101-80.14
Jim Harris Mark Jankowski Jonas Rondbjerg 10358-30.3
Denis Cyr Tobias Rieder Ryan Poehling 2000-30
Dimitri Voronkov Ondrej Kase Mason Marchment 1000-30
Tobias Rieder Ryan Poehling Evan Rodrigues 100000
Mark Jankowski Fabian Zetterlund Mason Marchment 320220.67
Jesperi Kotkaniemi Tobias Rieder Ondrej Kase 3371061

Attaquants PP

Trios GP G A PTS G/GP
Mason Marchment Jesperi Kotkaniemi Tobias Rieder 151230.07
Mark Jankowski Evan Rodrigues Ondrej Kase 152130.13
Ondrej Kase Mason Marchment Fabian Zetterlund 131230.08
Mark Jankowski Jesperi Kotkaniemi Tobias Rieder 131340.08

Défenseurs 5vs5

Duos GP G A PTS DIFF G/GP
Brett Kulak Nicolas Hague 115914130.45
Matthew Beattie Travis Sanheim 4551823-170.11
Brett Kulak Tarmo Reunanen 2452025350.21
Rasmus Sandin Matthew Beattie 11022-210
Travis Sanheim Brett Kulak 113912110.27
Nikita Okhotyuk Tarmo Reunanen 4000-70
Brett Kulak Rasmus Sandin 606660

Défenseurs PP

Duos GP G A PTS G/GP
Travis Sanheim Brett Kulak 150110
Rasmus Sandin Matthew Beattie 150220
Nicolas Hague Brett Kulak 110110
Travis Sanheim Matthew Beattie 131230.08
Rasmus Sandin Brett Kulak 20000