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

Attaquants PP

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

Défenseurs 5vs5

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

Défenseurs PP

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