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

Statistiques des trios - Edmonton

Attaquants 5vs5

Trios GP G A PTS DIFF G/GP
Yegor Milovzorov Mike Bullard Tim Stutzle 13101323-40.77
Steve Kasper Rem Pitlick Jason Dickinson 20172340-130.85
Daniel Sprong Tyler Benson Blade Jenkins 8101323101.25
Brian O'Neill Vincent Trocheck Martins Dzierkals 611230.17
Vincent Trocheck Tyler Benson Blade Jenkins 722400.29
Brian O'Neill Joel Kellman Daniel Sprong 200000
Steve Kasper Tim Stutzle Yegor Milovzorov 5213-190.4
Rem Pitlick Mike Bullard Tyler Benson 100000
Jason Dickinson Vincent Trocheck Blade Jenkins 2112-20.5
Brian O'Neill Martins Dzierkals Daniel Sprong 724660.29
Rem Pitlick Mike Bullard Jason Dickinson 3459-21.33
Blade Jenkins Steve Kasper Tim Stutzle 100000
Tyler Benson Vincent Trocheck Daniel Sprong 122432
Brian O'Neill Joel Kellman Martins Dzierkals 300000
Brian O'Neill Tim Stutzle Joel Kellman 110131
Steve Kasper Rem Pitlick Tyler Benson 1123-91
Blade Jenkins Rem Pitlick Mike Bullard 2123-90.5
Tyler Benson Jason Dickinson Vincent Trocheck 2000-60
Vincent Trocheck Daniel Sprong Blade Jenkins 1123-11
Brian O'Neill Martins Dzierkals Tyler Benson 100000
Mike Bullard Tim Stutzle Vincent Trocheck 2112-120.5
Daniel Sprong Joel Kellman Martins Dzierkals 100000
Joel Kellman Vincent Trocheck Martins Dzierkals 1000-10
Yegor Milovzorov Blade Jenkins Tim Stutzle 6551020.83
Daniel Sprong Tyler Benson Mike Bullard 100000
Daniel Sprong Mike Bullard Vincent Trocheck 50-1-1-110
Martins Dzierkals Tyler Benson Joel Kellman 5213-50.4
Blade Jenkins Rem Pitlick Steve Kasper 100000
Yegor Milovzorov Shane Pinto Tim Stutzle 1022-30
Jason Dickinson Vincent Trocheck Mike Bullard 1000-30
Martins Dzierkals Daniel Sprong Tyler Benson 111231

Attaquants PP

Trios GP G A PTS G/GP
Steve Kasper Tim Stutzle Yegor Milovzorov 30000
Mike Bullard Blade Jenkins Jason Dickinson 30000
Vincent Trocheck Mike Bullard Tim Stutzle 100000
Blade Jenkins Jason Dickinson Daniel Sprong 20110
Mike Bullard Tim Stutzle Yegor Milovzorov 61120.17
Blade Jenkins Jason Dickinson Steve Kasper 61120.17
Rem Pitlick Jason Dickinson Daniel Sprong 70000
Steve Kasper Jason Dickinson Daniel Sprong 11121
Mike Bullard Tim Stutzle Blade Jenkins 31010.33
Vincent Trocheck Jason Dickinson Daniel Sprong 30000
Rem Pitlick Blade Jenkins Tim Stutzle 61120.17
Jason Dickinson Daniel Sprong Mike Bullard 52350.4
Jason Dickinson Shane Pinto Mike Bullard 10000

Défenseurs 5vs5

Duos GP G A PTS DIFF G/GP
Jakub Zboril Connor Clifton 11088-20
Timothy Liljegren Dustyn McFaul 11213-210.18
Xavier Bouchard Janis Moser 200000
Sebastien Aho Dustyn McFaul 301130
Janis Moser Dustyn McFaul 13088-110
Timothy Liljegren Connor Clifton 4022-40
Jakub Zboril Dustyn McFaul 15189-100.07
Arber Xhekaj Xavier Bouchard 2000-20
Xavier Bouchard Connor Clifton 12481210.33
Sebastien Aho Timothy Liljegren 6055-40
Dustyn McFaul Xavier Bouchard 1131114-60.27
Sebastien Aho Arber Xhekaj 404420
Sebastien Aho Xavier Bouchard 513400.2
Sebastien Aho Jakub Zboril 7123-60.14
Janis Moser Timothy Liljegren 201100
Xavier Bouchard Jakub Zboril 201100
Connor Clifton Dustyn McFaul 1000-20
Timothy Liljegren Xavier Bouchard 100020

Défenseurs PP

Duos GP G A PTS G/GP
Vincent Trocheck Dustyn McFaul 10000
Rem Pitlick Connor Clifton 40000
Connor Clifton Steve Kasper 70220
Rem Pitlick Dustyn McFaul 111230.09
Sebastien Aho Dustyn McFaul 50000
Connor Clifton Sebastien Aho 110110
Steve Kasper Dustyn McFaul 110000
Connor Clifton Vincent Trocheck 50000
Yegor Milovzorov Connor Clifton 10000