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 = 2038 AND GL.season = 2038 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
Anthony Cirelli Karch Bachman Joel ErikssonEk 1514203430.93
Pierre-Luc Dubois Kirill Marchenko Vasily Podkolzin 1000-30
Yakov Trenin Mikhail Maltsev Tanner Kero 311200.33
Joachim Nermark Joel ErikssonEk Andrel Altybar 3011-50
Pierre-Luc Dubois Kevin Elgestal Kirill Marchenko 76713-130.86
Mikhail Maltsev Brad Palmer Brian Gibbons 4224-30.5
Pierre-Luc Dubois Joachim Nermark Tanner Kero 412320.25
Joel ErikssonEk Anthony Cirelli Patrik Siikanen 10437-110.4
Karch Bachman Pierre-Luc Dubois Kevin Elgestal 24131730140.54
Joachim Nermark Mikhail Maltsev Kirill Marchenko 36131932-10.36
Pierre-Luc Dubois Josiah Slavin Brian Gibbons 1045950.4
Karch Bachman Joel ErikssonEk Kevin Elgestal 105813-10.5
Pierre-Luc Dubois Josiah Slavin Anthony Cirelli 4224-90.5
Karch Bachman Brian Gibbons Josh Wilkins 136111790.46
Patrik Siikanen Pierre-Luc Dubois Kevin Elgestal 5538-61
Joel ErikssonEk Josiah Slavin Brian Gibbons 11691510.55
Joachim Nermark Joel ErikssonEk Anthony Cirelli 1331215-230.23
Mikhail Maltsev Josiah Slavin Kirill Marchenko 1710717150.59
Karch Bachman David Gustafsson Brian Gibbons 12235-50.17
Pierre-Luc Dubois Joel ErikssonEk Karch Bachman 15121224-210.8
Joachim Nermark Kevin Elgestal Anthony Cirelli 5358-40.6
Joel ErikssonEk Tanner Kero Brian Gibbons 137714-40.54
Josiah Slavin Joel ErikssonEk Karch Bachman 117815100.64
Pierre-Luc Dubois Kirill Marchenko Anthony Cirelli 4101-120.25
Mikhail Maltsev Joachim Nermark Vasily Podkolzin 3000-40
Patrik Siikanen Mikhail Maltsev Kirill Marchenko 20-1-1-40
Joachim Nermark Vasily Podkolzin Tanner Kero 2101-10.5
Dillon Hamaliuk Anthony Cirelli Andrel Altybar 211210.5
Mikhail Maltsev Joachim Nermark Tanner Kero 2011-30
Josiah Slavin Kevin Elgestal Anthony Cirelli 10661260.6
Anthony Cirelli Joel ErikssonEk Pierre-Luc Dubois 324660.67
Karch Bachman Patrik Siikanen Kevin Elgestal 3461091.33
Patrik Siikanen Pierre-Luc Dubois Karch Bachman 1000-30
Joel ErikssonEk Kevin Elgestal Anthony Cirelli 1000-30
Mikhail Maltsev Joel ErikssonEk Anthony Cirelli 1000-60
Joachim Nermark Josiah Slavin Kirill Marchenko 1000-30
Pierre-Luc Dubois Kevin Elgestal Anthony Cirelli 67714131.17
Joachim Nermark Tanner Kero Brian Gibbons 214540.5
Pierre-Luc Dubois Joachim Nermark Anthony Cirelli 8358-60.38
Mikhail Maltsev Brad Palmer Kirill Marchenko 51-1020.2
Mikhail Maltsev Brian Gibbons Kirill Marchenko 6011-110
Brian Gibbons Kevin Elgestal Karch Bachman 122452
Yakov Trenin Mikhail Maltsev Kirill Marchenko 100000
Karch Bachman Filip Hallander Tanner Kero 1011-10
Karch Bachman Josh Wilkins Andrel Altybar 2022-10
Mikhail Maltsev Vasily Podkolzin Kirill Marchenko 1000-40
Joel ErikssonEk Joachim Nermark Tanner Kero 2000-10
Mikhail Maltsev Joachim Nermark Brian Gibbons 212300.5
Yakov Trenin Joel ErikssonEk Tanner Kero 2000-30
Patrik Siikanen Joel ErikssonEk Karch Bachman 2011-50
Josiah Slavin Brian Gibbons Karch Bachman 101100
Pierre-Luc Dubois Anthony Cirelli Brian Gibbons 100000
Joachim Nermark Filip Hallander Brian Gibbons 110111
Anthony Cirelli Joel ErikssonEk Kirill Marchenko 100000
Yakov Trenin Karch Bachman Tanner Kero 110101
Joachim Nermark Mikhail Maltsev Kevin Elgestal 1000-30

Attaquants PP

Trios GP G A PTS G/GP
Pierre-Luc Dubois Karch Bachman Joel ErikssonEk 791413270.18
Pierre-Luc Dubois Josiah Slavin Kevin Elgestal 20710170.35
Pierre-Luc Dubois Kevin Elgestal Mikhail Maltsev 91120.11
Joachim Nermark Kevin Elgestal Mikhail Maltsev 17610160.35
Patrik Siikanen Kevin Elgestal Mikhail Maltsev 21310130.14
Pierre-Luc Dubois Josiah Slavin Mikhail Maltsev 61120.17
Pierre-Luc Dubois Brad Palmer Kevin Elgestal 42350.5
Josiah Slavin Kevin Elgestal Mikhail Maltsev 10000
Karch Bachman Joel ErikssonEk Patrik Siikanen 20110
Joachim Nermark Mikhail Maltsev Patrik Siikanen 20000
Karch Bachman Joel ErikssonEk Joachim Nermark 10000
Brian Gibbons Mikhail Maltsev Kevin Elgestal 10000
Pierre-Luc Dubois Mikhail Maltsev Joachim Nermark 10110

Défenseurs 5vs5

Duos GP G A PTS DIFF G/GP
Vladislav Gavrikov Miro Heiskanen 4992433-270.18
Nick Ebert Yegor Zaitsev 17145-110.06
Vladislav Gavrikov Santtu Kinnunen 298122050.28
Nathan Clurman Miro Heiskanen 272111340.07
Nick Ebert Santtu Kinnunen 2821012-30.07
Vladislav Gavrikov Yegor Zaitsev 1025730.2
Nick Ebert Dmitry Semykin 9268-10.22
Santtu Kinnunen Miro Heiskanen 192810-130.11
Vladislav Gavrikov Nathan Clurman 38156-180.03
Nathan Clurman Yegor Zaitsev 321350.67
David Musil Miro Heiskanen 512300.2
Nick Ebert Miro Heiskanen 305101500.17
Yegor Zaitsev Miro Heiskanen 2441317-80.17
Dmitry Semykin Miro Heiskanen 3000-50
Yegor Zaitsev Dmitry Semykin 3022-10
Vladislav Gavrikov Nick Ebert 8044-100
David Musil Nathan Clurman 500000
Vladislav Gavrikov Michael Kesselring 6112-40.17
David Musil Dmitry Semykin 1000-20
Vladislav Gavrikov Dmitry Semykin 5101-20.2
Nick Ebert Nathan Clurman 413410.25
Vladislav Gavrikov Tony Feltrin 201120
Nathan Clurman Santtu Kinnunen 302220

Défenseurs PP

Duos GP G A PTS G/GP
Santtu Kinnunen Anthony Cirelli 441450.02
Kirill Marchenko Miro Heiskanen 45414180.09
Miro Heiskanen Anthony Cirelli 3428100.06
Kirill Marchenko Santtu Kinnunen 51120.2
Dmitry Semykin Anthony Cirelli 20000
Kirill Marchenko Dmitry Semykin 60000
Yegor Zaitsev Anthony Cirelli 20000
Kirill Marchenko Nick Ebert 2059140.25
Kirill Marchenko Vladislav Gavrikov 61010.17