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

Statistiques des trios - Quebec

Attaquants 5vs5

Trios GP G A PTS DIFF G/GP
Peyton Krebs Al Byers Maxim Denezhkin 18141630-110.78
Jesse Puljujarvi Adam Ruzicka Jim Fox 20101424-100.5
Doug Wickenheiser Casey Mittelstadt Valtteri Puustinen 206612-60.3
Brayden Tracey Jesper Boqvist Oskar Lindblom 345712-10.15
Ivan Barbashev Al Byers Maxim Denezhkin 19182442-20.95
Peyton Krebs Jesse Puljujarvi Adam Ruzicka 97916-80.78
Jim Fox Valtteri Puustinen Casey Mittelstadt 92-20-10.22
Ivan Barbashev Jesper Boqvist Oskar Lindblom 535810.6
Casey Mittelstadt Peyton Krebs Jesse Puljujarvi 5336-130.6
Jim Fox Valtteri Puustinen Adam Ruzicka 522460.4
Jim Fox Peyton Krebs Jesse Puljujarvi 5202-60.4
Casey Mittelstadt Valtteri Puustinen Adam Ruzicka 5213-30.4
Paul Cyr Al Byers Maxim Denezhkin 222401

Attaquants PP

Trios GP G A PTS G/GP
Al Byers Maxim Denezhkin Peyton Krebs 161010.06
Casey Mittelstadt Adam Ruzicka Jesse Puljujarvi 161010.06
Peyton Krebs Al Byers Jesse Puljujarvi 50110
Casey Mittelstadt Maxim Denezhkin Jim Fox 54590.8
Maxim Denezhkin Jesse Puljujarvi Al Byers 183470.17
Adam Ruzicka Peyton Krebs Casey Mittelstadt 142350.14
Doug Wickenheiser Peyton Krebs Casey Mittelstadt 11121
Doug Wickenheiser Paul Cyr Casey Mittelstadt 20000
Casey Mittelstadt Adam Ruzicka Doug Wickenheiser 10000

Défenseurs 5vs5

Duos GP G A PTS DIFF G/GP
Will Butcher Jim Pavese 51114455220.22
Rasmus Sandin Jake Christiansen 16145-230.06
Ville Rasanen Lassi Thomson 3921113-100.05
Will Butcher Rasmus Sandin 2311617-140.04
Jim Pavese Jake Christiansen 19257-20.11
Jake Christiansen Justin Barron 4000-50
Will Butcher Justin Barron 4000-30

Défenseurs PP

Duos GP G A PTS G/GP
Will Butcher Ivan Barbashev 191340.05
Jim Fox Jake Christiansen 342460.06
Adam Ruzicka Will Butcher 200000
Jake Christiansen Rasmus Sandin 51120.2