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
Tobias Rieder Ondrej Kase Mason Marchment 2000-160
Mark Jankowski Jesperi Kotkaniemi Fabian Zetterlund 107916130.7
Ryan Poehling Dimitri Voronkov Evan Rodrigues 55324173450.58
Mason Marchment Jonas Rondbjerg Jim Harris 44182038-160.41
Mark Jankowski Mason Marchment Fabian Zetterlund 953830.56
Jesperi Kotkaniemi Tobias Rieder Ondrej Kase 13111122220.85
Evan Rodrigues Ondrej Kase Mason Marchment 7101-80.14
Ryan Poehling Dimitri Voronkov Tobias Rieder 6325-10.5
Mason Marchment Ondrej Kase Fabian Zetterlund 11581320.45
Jesperi Kotkaniemi Mark Jankowski Tobias Rieder 117815-110.64
Mark Jankowski Jonas Rondbjerg Jim Harris 10358-30.3
Jonas Rondbjerg Jesperi Kotkaniemi Mason Marchment 20151530-130.75
Mark Jankowski Tobias Rieder Denis Cyr 2000-30
Aapeli Rasanen Mason Marchment Tanner Kaspick 11561140.45
Mark Jankowski Tobias Rieder Ondrej Kase 27222850140.81
Jesperi Kotkaniemi Mason Marchment Fabian Zetterlund 15212849281.4
Mark Jankowski Dimitri Voronkov Ondrej Kase 645930.67
Ryan Poehling Tobias Rieder Evan Rodrigues 13561120.38
Mark Jankowski Mason Marchment Denis Cyr 2033-40
Mark Jankowski Dimitri Voronkov Fabian Zetterlund 636930.5
Jesperi Kotkaniemi Mason Marchment Ondrej Kase 75611-130.71
Mason Marchment Tanner Kaspick Denis Cyr 9314-30.33
Aapeli Rasanen Dimitri Voronkov Evan Rodrigues 3112-30.33
Aapeli Rasanen Mason Marchment Jonas Rondbjerg 322440.67
Mason Marchment Jesperi Kotkaniemi Tobias Rieder 302230
Mark Jankowski Ondrej Kase Fabian Zetterlund 321360.67
Mark Jankowski Mason Marchment Jim Harris 2112-10.5
Mason Marchment Jonas Rondbjerg Tanner Kaspick 5123-50.2
Mark Jankowski Mason Marchment Ondrej Kase 2000-90
Jesperi Kotkaniemi Dimitri Voronkov Tobias Rieder 2000-120
Ryan Poehling Evan Rodrigues Denis Cyr 100000
Ryan Poehling Tobias Rieder Denis Cyr 2000-30
Val Nussbaumer Dimitri Voronkov Evan Rodrigues 1000-30
Jesperi Kotkaniemi Tobias Rieder Jim Harris 1000-40
Mason Marchment Dimitri Voronkov Ondrej Kase 1000-30
Mark Jankowski Evan Rodrigues Fabian Zetterlund 1123-61
Mason Marchment Mark Jankowski Evan Rodrigues 1011-110
Ryan Poehling Ondrej Kase Denis Cyr 100000

Attaquants PP

Trios GP G A PTS G/GP
Mason Marchment Fabian Zetterlund Jesperi Kotkaniemi 230110
Mark Jankowski Ondrej Kase Tobias Rieder 394590.1
Ondrej Kase Fabian Zetterlund Mason Marchment 172350.12
Jesperi Kotkaniemi Mark Jankowski Tobias Rieder 171450.06
Jesperi Kotkaniemi Mason Marchment Denis Cyr 165270.31
Jesperi Kotkaniemi Tobias Rieder Mason Marchment 151230.07
Mark Jankowski Evan Rodrigues Ondrej Kase 152130.13
Ryan Poehling Dimitri Voronkov Evan Rodrigues 91120.11
Dimitri Voronkov Jesperi Kotkaniemi Mason Marchment 111120.09
Mark Jankowski Tobias Rieder Denis Cyr 20000

Défenseurs 5vs5

Duos GP G A PTS DIFF G/GP
Brett Kulak Rasmus Sandin 606660
Matthew Beattie Travis Sanheim 152218810970.14
Brett Kulak Tarmo Reunanen 75104555290.13
Brett Kulak Nicolas Hague 52113647150.21
Rasmus Sandin Matthew Beattie 11022-210
Brett Kulak Travis Sanheim 12391290.25
Nikita Okhotyuk Tarmo Reunanen 4000-70
Brett Kulak Nikita Okhotyuk 15189-70.07
Matthew Beattie Nicolas Hague 1000-60

Défenseurs PP

Duos GP G A PTS G/GP
Nicolas Hague Brett Kulak 53211130.04
Matthew Beattie Travis Sanheim 582570.03
Matthew Beattie Ondrej Kase 30000
Travis Sanheim Brett Kulak 150110
Rasmus Sandin Matthew Beattie 150220
Rasmus Sandin Brett Kulak 20000
Ondrej Kase Brett Kulak 60110
Matthew Beattie Tobias Rieder 60110
Brett Kulak Evan Rodrigues 60000