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 = 2037 AND GL.season = 2037 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
Joachim Nermark Mikhail Maltsev Jakub Vrana 88816-301
Otto Somppi Joel ErikssonEk Brian Gibbons 14491340.29
Karch Bachman Pierre-Luc Dubois Anthony Cirelli 7661210.86
Joel ErikssonEk Kirill Marchenko Jakub Vrana 43811-10.75
Joel ErikssonEk Anthony Cirelli Karch Bachman 55611111
Otto Somppi Jakub Vrana Brian Gibbons 10268-50.2
Joel ErikssonEk Jakub Vrana Karch Bachman 7268-10.29
Joachim Nermark Anthony Cirelli Dmitrij Jaskin 7527-40.71
Pierre-Luc Dubois Joel ErikssonEk Karch Bachman 4257-10.5
Karch Bachman Mikhail Maltsev Anthony Cirelli 234741.5
Joachim Nermark Mikhail Maltsev Karch Bachman 224661
Rodrigo Abols Joachim Nermark Karch Bachman 333641
Patrik Siikanen Mikhail Maltsev Anthony Cirelli 324680.67
Rodrigo Abols Mikhail Maltsev Jaret Dolan 11235-90.18
Rodrigo Abols Mikhail Maltsev Klim Kostin 2235-11
Joachim Nermark Mikhail Maltsev Jaret Dolan 422400.5
Rodrigo Abols Anthony Cirelli Jaret Dolan 4134-40.25
Pierre-Luc Dubois Joel ErikssonEk Jakub Vrana 1314-13
Patrik Siikanen Joachim Nermark Karch Bachman 222431
Otto Somppi Karch Bachman Jaret Dolan 231441.5
Rodrigo Abols Anthony Cirelli Karch Bachman 122462
David Gustafsson Mikhail Maltsev Kirill Marchenko 121312
Rodrigo Abols Dmitrij Jaskin Anthony Cirelli 112301
Dmitrij Jaskin Jaret Dolan Joel ErikssonEk 112321
Anthony Cirelli Joel ErikssonEk Jakub Vrana 1112-41
Joachim Nermark Anthony Cirelli Jakub Vrana 2112-20.5
Rodrigo Abols Dmitrij Jaskin Jaret Dolan 2112-50.5
Joachim Nermark Joel ErikssonEk Jakub Vrana 2112-100.5
Rodrigo Abols Joel ErikssonEk Jaret Dolan 111231
Joachim Nermark Jakub Vrana Dmitrij Jaskin 102220
Joel ErikssonEk Rodrigo Abols Brian Gibbons 201100
Joel ErikssonEk Jakub Vrana Dmitrij Jaskin 6011-60
Rodrigo Abols Karch Bachman Brian Gibbons 1011-30
Jaret Dolan Joel ErikssonEk Brian Gibbons 3101-20.33
Anthony Cirelli Dmitrij Jaskin Jakub Vrana 110101
Joachim Nermark Kirill Marchenko Jakub Vrana 210130.5
David Gustafsson Rodrigo Abols Brian Gibbons 210100.5
Klim Kostin Joachim Nermark Jaret Dolan 101100
Otto Somppi Jakub Vrana Andrel Altybar 1011-40
Joachim Nermark Pierre-Luc Dubois Karch Bachman 1000-70
Patrik Siikanen Joel ErikssonEk Jakub Vrana 1000-30
Karch Bachman Joachim Nermark Dmitrij Jaskin 1000-30
Rodrigo Abols Mikhail Maltsev Anthony Cirelli 200000
Jaret Dolan Jakub Vrana Brian Gibbons 3000-60
Joel ErikssonEk Joachim Nermark Karch Bachman 1000-20
Joachim Nermark Anthony Cirelli Karch Bachman 1000-30
Rodrigo Abols David Gustafsson Jaret Dolan 100000
Otto Somppi Rodrigo Abols Brian Gibbons 100000
Mikhail Maltsev Joel ErikssonEk Jakub Vrana 1000-10
Anthony Cirelli Mikhail Maltsev Dmitrij Jaskin 1000-30
Jaret Dolan Rodrigo Abols Brian Gibbons 100010
Rodrigo Abols Jakub Vrana Karch Bachman 100000
Joel ErikssonEk Mikhail Maltsev Jaret Dolan 1000-10
Brian Gibbons Rodrigo Abols Pierre-Luc Dubois 10-1-100

Attaquants PP

Trios
GP
G
A
PTS
G/GP
Joachim Nermark Dmitrij Jaskin Mikhail Maltsev 210660
Joachim Nermark Anthony Cirelli Kirill Marchenko 41230.25
Anthony Cirelli Jakub Vrana Joel ErikssonEk 231230.04
Joachim Nermark Jaret Dolan Mikhail Maltsev 91230.11
Pierre-Luc Dubois Jakub Vrana Joel ErikssonEk 130220
Joachim Nermark Kirill Marchenko Jakub Vrana 21010.5
Joachim Nermark David Gustafsson Mikhail Maltsev 10000
Joachim Nermark Anthony Cirelli Mikhail Maltsev 20000
Mikhail Maltsev Joachim Nermark Karch Bachman 10000

Défenseurs 5vs5

Duos
GP
G
A
PTS
DIFF
G/GP
Miro Heiskanen Devon Toews 2831821-210.11
Miro Heiskanen Mirco Mueller 1741216-120.24
Yegor Zaitsev Devon Toews 263121590.12
Santtu Kinnunen Mirco Mueller 1811011-70.06
Devon Toews Mirco Mueller 826870.25
Yegor Zaitsev Mirco Mueller 14156-70.07
Santtu Kinnunen Alec Regula 11134-30.09
Santtu Kinnunen David Musil 503340
David Musil Devon Toews 302200
Yegor Zaitsev Santtu Kinnunen 4022-40
Timothy Liljegren Miro Heiskanen 4011-40
Alec Regula Miro Heiskanen 3011-40
Alec Regula Devon Toews 2011-20
Miro Heiskanen David Musil 2011-40
Santtu Kinnunen Devon Toews 101100
Alec Regula Mirco Mueller 3000-40
Santtu Kinnunen Miro Heiskanen 100010
David Musil Mirco Mueller 1000-30
Santtu Kinnunen Ian Mitchell 100000

Défenseurs PP

Duos
GP
G
A
PTS
G/GP
Karch Bachman Mirco Mueller 346060.18
Jaret Dolan Miro Heiskanen 81230.13
Rodrigo Abols Santtu Kinnunen 41230.25
Jakub Vrana Miro Heiskanen 160000
Patrik Siikanen Miro Heiskanen 60000
Rodrigo Abols Miro Heiskanen 20000
Karch Bachman Miro Heiskanen 40000
Ian Mitchell Jakub Vrana 10000
Miro Heiskanen Anthony Cirelli 10000