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

Attaquants 5vs5

Trios GP G A PTS DIFF G/GP
Anthony Beauvillier Brock Boeser Josh Norris 19152641200.79
Tomas Hertl Otto Koivula Philip Tomasino 20131629-30.65
Mitchell Mattson Aleksi Heponiemi Dillon Dube 5000-40
Tomas Hertl Martins Dzierkals Nikolay Goldobin 9851370.89
Mitchell Mattson Timothy Gettinger Nikolay Goldobin 146814-80.43
Martins Dzierkals Dillon Dube Brock Boeser 132101260.15
Brock Boeser Tomas Hertl Josh Norris 1511162710.73
Philip Tomasino Otto Koivula Aleksi Heponiemi 5123-90.2
Martins Dzierkals Timothy Gettinger Nikolay Goldobin 10471180.4
Tomas Hertl Aleksi Saarela Dillon Dube 4325-60.75
Morgan Geekie Anthony Beauvillier Josh Norris 1181018-20.73
Philip Tomasino Lucas Raymond Brock Boeser 117916140.64
Mason Shaw Nikolay Goldobin Alex Barabanov 12581320.42
Martins Dzierkals Anthony Beauvillier Timothy Gettinger 2202-21
Brock Boeser Josh Norris Otto Koivula 311210.33
Anthony Beauvillier Nikolay Goldobin Philip Tomasino 353821.67
Martins Dzierkals Aleksi Heponiemi Dillon Dube 14661280.43
Aleksi Saarela Timothy Gettinger Brock Boeser 302210
Anthony Beauvillier Timothy Gettinger Dillon Dube 2716153150.59
Anthony Beauvillier Otto Koivula Philip Tomasino 1610182880.63
Tomas Hertl Aleksi Saarela Nikolay Goldobin 8314-70.38
Lucas Raymond Anthony Beauvillier Josh Norris 1913518-130.68
Morgan Geekie Philip Tomasino Brock Boeser 167162350.44
Mitchell Mattson Mason Shaw Alex Barabanov 153710-70.2
Tomas Hertl Brandon Duhaime Nikolay Goldobin 3213-20.67
Anthony Beauvillier Otto Koivula Brock Boeser 123552
Mitchell Mattson Josh Norris Philip Tomasino 100000
Aleksi Heponiemi Dillon Dube Brock Boeser 524660.4
Mitchell Mattson Josh Norris Brock Boeser 322430.67
Aleksi Saarela Dillon Dube Brock Boeser 3145-10.33
Mitchell Mattson Anthony Beauvillier Brock Boeser 4347110.75
Josh Norris Aleksi Heponiemi Dillon Dube 4213-60.5
Mitchell Mattson Roope Hintz Brock Boeser 234761.5
Otto Koivula Nikolay Goldobin Philip Tomasino 200000
Martins Dzierkals Aleksi Heponiemi Nikolay Goldobin 210130.5
Anthony Beauvillier Morgan Geekie Lucas Raymond 344861.33
Philip Tomasino Josh Norris Brock Boeser 3123-100.33
Mitchell Mattson Alex Barabanov Timothy Gettinger 322420.67
Anthony Beauvillier Nikolay Goldobin Dillon Dube 342611.33
Tomas Hertl Otto Koivula Brock Boeser 21-10-110.5
Anthony Beauvillier Josh Norris Philip Tomasino 2101-110.5
Philip Tomasino Otto Koivula Brock Boeser 3000-60
Roope Hintz Timothy Gettinger Nikolay Goldobin 1000-30
Mitchell Mattson Dillon Dube Brock Boeser 1000-10
Anthony Beauvillier Josh Norris Tomas Hertl 2101-20.5
Tomas Hertl Dillon Dube Aleksi Heponiemi 124652

Attaquants PP

Trios GP G A PTS G/GP
Anthony Beauvillier Alex Barabanov Brock Boeser 3046100.13
Morgan Geekie Josh Norris Lucas Raymond 3058130.17
Anthony Beauvillier Brock Boeser Tomas Hertl 3757120.14
Josh Norris Otto Koivula Philip Tomasino 4579160.16
Anthony Beauvillier Brock Boeser Aleksi Heponiemi 60000
Anthony Beauvillier Josh Norris Brock Boeser 10000
Aleksi Heponiemi Otto Koivula Philip Tomasino 10000
Philip Tomasino Anthony Beauvillier Brock Boeser 30000
Josh Norris Otto Koivula Aleksi Heponiemi 30000
Anthony Beauvillier Roope Hintz Brock Boeser 32020.67
Otto Koivula Josh Norris Lucas Raymond 30220
Tomas Hertl Aleksi Heponiemi Brock Boeser 20000

Défenseurs 5vs5

Duos GP G A PTS DIFF G/GP
Joakim Ryan Noah Dobson 305202580.17
Sean Durzi Matt Mackenzie 4582432-20.18
Jordan Subban Lassi Thomson 4631821-10.07
Matt Mackenzie Joakim Ryan 80104656120.13
Joakim Ryan Sean Durzi 3832427-110.08
Noah Dobson Matt Mackenzie 16156-40.06
Lassi Thomson Matt Mackenzie 235101510.22
Jordan Subban Jacob Moverare 34691530.18
Lassi Thomson Joakim Ryan 1114570.09
Noah Dobson Lassi Thomson 210130.5
Jordan Subban Justin Barron 210120.5
Justin Barron Joakim Ryan 101120

Défenseurs PP

Duos GP G A PTS G/GP
Matt Mackenzie Noah Dobson 230000
Sean Durzi Joakim Ryan 441230.02
Lassi Thomson Matt Mackenzie 462790.04
Joakim Ryan Noah Dobson 231120.04
Justin Barron Noah Dobson 20000
Lassi Thomson Joakim Ryan 130000
Sean Durzi Matt Mackenzie 120110
Jordan Subban Matt Mackenzie 10000