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
Karch Bachman Kevin Elgestal Jason Robertson 32312960380.97
Patrik Siikanen Brad Palmer Pierre-Luc Dubois 6381150.5
Mikhail Maltsev Paul Cotter Kirill Marchenko 3000-10
Pierre-Luc Dubois Chris Tierney Brian Gibbons 31212243150.68
Joel ErikssonEk Brad Palmer Pierre-Luc Dubois 4257-20.5
Patrik Siikanen Mikhail Maltsev Kirill Marchenko 11761310.64
Pierre-Luc Dubois Paul Cotter Brian Gibbons 165914-10.31
Pierre-Luc Dubois Mikhail Maltsev Brad Palmer 1112-21
Joel ErikssonEk Patrik Siikanen Jason Robertson 823510.25
Len Hachborn Brian Gibbons Kirill Marchenko 1000-30
Chris Tierney Brad Palmer Ben McCartney 1011-20
Patrik Siikanen Joel ErikssonEk Pierre-Luc Dubois 87101740.88
Mikhail Maltsev Brad Palmer Kirill Marchenko 125510-180.42
Joel ErikssonEk Mikhail Maltsev Pierre-Luc Dubois 12131730311.08
Patrik Siikanen Brad Palmer Kirill Marchenko 29121628250.41
Kevin Elgestal Joel ErikssonEk Pierre-Luc Dubois 25272855181.08
Karch Bachman Brad Palmer Jason Robertson 11111829231
Patrik Siikanen Joel ErikssonEk Kirill Marchenko 343781.33
Mikhail Maltsev Brad Palmer Paul Cotter 311240.33
Karch Bachman Chris Tierney Brian Gibbons 11641000.55
Joel ErikssonEk Kirill Marchenko Pierre-Luc Dubois 112331
Len Hachborn Patrik Siikanen Denis Cyr 311200.33
Mikhail Maltsev Karch Bachman Jason Robertson 20171734190.85
Joel ErikssonEk Brad Palmer Karch Bachman 222401
Patrik Siikanen Kevin Elgestal Jason Robertson 3134-50.33
Mikhail Maltsev Dan Bourbonnais Kirill Marchenko 100000
Joel ErikssonEk Chris Tierney Brian Gibbons 9268-30.22
Karch Bachman Pierre-Luc Dubois Kevin Elgestal 5235-100.4
Patrik Siikanen Kevin Elgestal Kirill Marchenko 322450.67
Joel ErikssonEk Paul Cotter Brian Gibbons 200010
Karch Bachman Paul Cotter Brian Gibbons 423520.5
Pierre-Luc Dubois Brad Palmer Kirill Marchenko 211200.5
Aaron Broten Mikhail Maltsev Paul Cotter 211200.5
Pierre-Luc Dubois Brad Palmer Kevin Elgestal 2000-90
Len Hachborn Mikhail Maltsev Kirill Marchenko 440471
Joel ErikssonEk Mikhail Maltsev Kirill Marchenko 323570.67
Patrik Siikanen Brad Palmer Paul Cotter 335841
Patrik Siikanen Chris Tierney Brian Gibbons 3033-20
Karch Bachman Brad Palmer Pierre-Luc Dubois 4336-70.75
Joel ErikssonEk Kirill Marchenko Jason Robertson 2000-140
Mikhail Maltsev Kevin Elgestal Jason Robertson 110131
Aaron Broten Paul Cotter Kirill Marchenko 1000-60
Mikhail Maltsev Aaron Broten Kirill Marchenko 421330.5
Patrik Siikanen Paul Cotter Brian Gibbons 323540.67
Chris Tierney Brad Palmer Brian Gibbons 100000
Joel ErikssonEk Brad Palmer Jason Robertson 345981.33
Patrik Siikanen Kevin Elgestal Karch Bachman 322420.67
Mikhail Maltsev David Gustafsson Kirill Marchenko 221341
Joel ErikssonEk Pierre-Luc Dubois Karch Bachman 1101-31
Joel ErikssonEk Pierre-Luc Dubois Jason Robertson 222401
Chris Tierney Mikhail Maltsev Brian Gibbons 1000-30

Attaquants PP

Trios GP G A PTS G/GP
Pierre-Luc Dubois Karch Bachman Joel ErikssonEk 32311140.09
Mikhail Maltsev Patrik Siikanen Brad Palmer 651024340.15
Joel ErikssonEk Brad Palmer Pierre-Luc Dubois 20000
Joel ErikssonEk Kevin Elgestal Kirill Marchenko 50000
Brad Palmer Pierre-Luc Dubois Kevin Elgestal 80110
Karch Bachman Mikhail Maltsev Patrik Siikanen 51010.2
Pierre-Luc Dubois Joel ErikssonEk Kevin Elgestal 110110
Kirill Marchenko Joel ErikssonEk Pierre-Luc Dubois 191340.05
Joel ErikssonEk Brad Palmer Karch Bachman 40110
Mikhail Maltsev Patrik Siikanen Jason Robertson 50110
Aaron Broten Mikhail Maltsev Patrik Siikanen 10000
Joel ErikssonEk Kevin Elgestal Brad Palmer 10000
Patrik Siikanen Denis Cyr Brad Palmer 30000
Mikhail Maltsev Patrik Siikanen Pierre-Luc Dubois 10000
Karch Bachman Mikhail Maltsev Brad Palmer 22241

Défenseurs 5vs5

Duos GP G A PTS DIFF G/GP
Santtu Kinnunen Miro Heiskanen 1722426150.12
Ryan Graves Maxim Noreau 192182060.11
Vladislav Gavrikov Michael Kesselring 2026840.1
Ryan Graves Miro Heiskanen 75135568330.17
Vladislav Gavrikov Miro Heiskanen 811112130.13
Santtu Kinnunen Maxim Noreau 61133952500.21
Maxim Noreau Miro Heiskanen 163811-100.19
Ryan Graves Michael Kesselring 6033-100
Vladislav Gavrikov Tony Feltrin 713440.14
Tony Feltrin Michael Kesselring 1205550
Vladislav Gavrikov Nathan Clurman 2000-20
Michael Kesselring Brady Skjei 374141820.11
Miro Heiskanen Brady Skjei 35102030200.29
Tony Feltrin Brady Skjei 200000
Santtu Kinnunen Ryan Graves 4011-70
Michael Kesselring Miro Heiskanen 616730.17
Nathan Clurman Ryan Graves 101110

Défenseurs PP

Duos GP G A PTS G/GP
Jason Robertson Miro Heiskanen 8094130.11
Kevin Elgestal Maxim Noreau 100000
Maxim Noreau Santtu Kinnunen 4419100.02
Kevin Elgestal Santtu Kinnunen 245160.21
Kevin Elgestal Miro Heiskanen 41010.25
Jason Robertson Santtu Kinnunen 20000