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

Statistiques des trios - LongIsland

Attaquants 5vs5

Trios GP G A PTS DIFF G/GP
Kevin Elgestal Joel ErikssonEk Pierre-Luc Dubois 25272855181.08
Karch Bachman Brad Palmer Jason Robertson 56915121.2
Patrik Siikanen Mikhail Maltsev Kirill Marchenko 7325-20.43
Pierre-Luc Dubois Chris Tierney Brian Gibbons 2619183790.73
Mikhail Maltsev Karch Bachman Jason Robertson 20171734190.85
Patrik Siikanen Brad Palmer Kirill Marchenko 2091322120.45
Chris Tierney Mikhail Maltsev Brian Gibbons 1000-30
Pierre-Luc Dubois Jason Robertson Joel ErikssonEk 222401
Patrik Siikanen Kevin Elgestal Karch Bachman 322420.67
Mikhail Maltsev Brad Palmer Kirill Marchenko 6437-30.67
Joel ErikssonEk Chris Tierney Brian Gibbons 7156-60.14
Kevin Elgestal Karch Bachman Pierre-Luc Dubois 5235-100.4
Joel ErikssonEk Patrik Siikanen Jason Robertson 823510.25
Mikhail Maltsev Brad Palmer Pierre-Luc Dubois 1112-21
Len Hachborn Brian Gibbons Kirill Marchenko 1000-30
Chris Tierney Brad Palmer Ben McCartney 1011-20
Joel ErikssonEk Brad Palmer Karch Bachman 222401
Patrik Siikanen Kevin Elgestal Jason Robertson 3134-50.33
Mikhail Maltsev Dan Bourbonnais Kirill Marchenko 100000
Karch Bachman Chris Tierney Brian Gibbons 635840.5
Pierre-Luc Dubois Brad Palmer Kevin Elgestal 2000-90
Len Hachborn Mikhail Maltsev Kirill Marchenko 440471
Chris Tierney Brad Palmer Brian Gibbons 100000
Karch Bachman Brad Palmer Pierre-Luc Dubois 333621
Joel ErikssonEk Kirill Marchenko Jason Robertson 1000-80
Len Hachborn Patrik Siikanen Denis Cyr 1000-30
Joel ErikssonEk Brad Palmer Jason Robertson 345981.33
Mikhail Maltsev David Gustafsson Kirill Marchenko 221341
Joel ErikssonEk Pierre-Luc Dubois Karch Bachman 1101-31

Attaquants PP

Trios GP G A PTS G/GP
Pierre-Luc Dubois Karch Bachman Joel ErikssonEk 32311140.09
Mikhail Maltsev Patrik Siikanen Brad Palmer 35617230.17
Brad Palmer Karch Bachman Joel ErikssonEk 40110
Mikhail Maltsev Patrik Siikanen Jason Robertson 50110
Joel ErikssonEk Pierre-Luc Dubois Kirill Marchenko 60000
Patrik Siikanen Denis Cyr Brad Palmer 10000
Mikhail Maltsev Patrik Siikanen Pierre-Luc Dubois 10000

Défenseurs 5vs5

Duos GP G A PTS DIFF G/GP
Maxim Noreau Miro Heiskanen 153811-30.2
Santtu Kinnunen Ryan Graves 3000-50
Michael Kesselring Miro Heiskanen 314530.33
Maxim Noreau Ryan Graves 182171990.11
Ryan Graves Miro Heiskanen 3842529-120.11
Santtu Kinnunen Maxim Noreau 2231417150.14
Tony Feltrin Michael Kesselring 1205550
Santtu Kinnunen Miro Heiskanen 1722426150.12
Vladislav Gavrikov Michael Kesselring 2026840.1
Ryan Graves Michael Kesselring 3011-40
Vladislav Gavrikov Tony Feltrin 713440.14
Vladislav Gavrikov Nathan Clurman 2000-20
Vladislav Gavrikov Miro Heiskanen 811112130.13

Défenseurs PP

Duos GP G A PTS G/GP
Miro Heiskanen Jason Robertson 425270.12
Kevin Elgestal Santtu Kinnunen 245160.21
Kevin Elgestal Miro Heiskanen 41010.25
Kevin Elgestal Maxim Noreau 100000
Maxim Noreau Santtu Kinnunen 40220