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

Attaquants 5vs5

Trios GP G A PTS DIFF G/GP
Isac Lundestrom Alex Tuch Bo Horvat 311200.33
Lias Andersson Arthur Kaliyev Elias Lindholm 312300.33
Brent Sutter Sam Steel Ivan Chekhovich 10279-90.2
Brett Howden Rudolfs Balcers Nate Schnarr 76161733180.21
Brent Sutter Lias Andersson Alex Tuch 655482136510.83
Bo Horvat Arthur Kaliyev Elias Lindholm 675562117530.82
Isac Lundestrom Sam Steel Ivan Chekhovich 6021305140.35
Lias Andersson Alex Tuch Bo Horvat 11426-10.36
Isac Lundestrom Arthur Kaliyev Elias Lindholm 771017151
Nate Schnarr Sam Steel Ivan Chekhovich 6369-10.5
Brett Howden Michael Pezzetta Rudolfs Balcers 6123-10.17
Sam Steel Arthur Kaliyev Elias Lindholm 4314-140.75
Brent Sutter Isac Lundestrom Ivan Chekhovich 632510.5
Bo Horvat Lias Andersson Elias Lindholm 100000
Brent Sutter Arthur Kaliyev Alex Tuch 1000-30
Sam Steel Lias Andersson Alex Tuch 2000-60

Attaquants PP

Trios GP G A PTS G/GP
Arthur Kaliyev Alex Tuch Bo Horvat 821312250.16
Lias Andersson Sam Steel Elias Lindholm 821420340.17

Défenseurs 5vs5

Duos GP G A PTS DIFF G/GP
Leon Gawanke Victor Mete 69124456550.17
Brett Pesce Martin Fehervary 73154459290.21
Calen Addison Maxim Noreau 73102535-20.14
Maxim Noreau Brett Pesce 7914486230.18
Leon Gawanke Brett Pesce 1016720.1
Martin Fehervary Victor Mete 6055-50
Calen Addison Jacob Bryson 301100
Brett Pesce Calen Addison 2000-50
Maxim Noreau Victor Mete 211220.5
Martin Fehervary Leon Gawanke 2101-30.5
Calen Addison Leon Gawanke 302210
Jacob Bryson Maxim Noreau 303330
Maxim Noreau Martin Fehervary 1000-30
Calen Addison Victor Mete 101110
Victor Mete Jacob Bryson 100000

Défenseurs PP

Duos GP G A PTS G/GP
Martin Fehervary Brett Pesce 350440
Leon Gawanke Maxim Noreau 320330
Maxim Noreau Brett Pesce 471450.02
Calen Addison Martin Fehervary 70220
Calen Addison Victor Mete 240220
Leon Gawanke Martin Fehervary 190110