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
Tim Stutzle Steve Kasper Blade Jenkins 20-1-1-30
Shane Pinto Yegor Milovzorov Rem Pitlick 344831.33
Mike Bullard Tyler Benson Jason Dickinson 20-1-1-10
Dylan Gambrell Timur Ibragimov Pavel Shen 3101-20.33
Steve Kasper Blade Jenkins Rem Pitlick 8145-70.13
Shane Pinto Tim Stutzle Yegor Milovzorov 44314980-100.7
Mike Bullard Vincent Trocheck Jason Dickinson 421320.5
Brian O'Neill Tyler Benson Daniel Sprong 6224-50.33
Mike Bullard Jason Dickinson Steve Kasper 22221941-71
Dylan Gambrell Blade Jenkins Brian O'Neill 177142130.41
German Rubtsov Yegor Milovzorov Pavel Shen 174610-100.24
Mike Bullard Jason Dickinson Brian O'Neill 3347-91
Dylan Gambrell Tyler Benson Pavel Shen 84610120.5
Martins Dzierkals Tyler Benson Daniel Sprong 411200.25
Mike Bullard Rem Pitlick Steve Kasper 71-10-90.14
Blade Jenkins Tyler Benson Jason Dickinson 733630.43
Martins Dzierkals Daniel Sprong Dylan Gambrell 212330.5
Mike Bullard Tim Stutzle Yegor Milovzorov 13101323-40.77
Steve Kasper Jason Dickinson Rem Pitlick 20172340-130.85
Blade Jenkins Tyler Benson Vincent Trocheck 722400.29
Joel Kellman Daniel Sprong Brian O'Neill 200000
Blade Jenkins Tyler Benson Daniel Sprong 8101323101.25
Martins Dzierkals Vincent Trocheck Brian O'Neill 611230.17
Mike Bullard Tim Stutzle Vincent Trocheck 2112-120.5
Martins Dzierkals Joel Kellman Brian O'Neill 300000
Blade Jenkins Tim Stutzle Yegor Milovzorov 6551020.83
Mike Bullard Vincent Trocheck Daniel Sprong 50-1-1-110
Martins Dzierkals Tyler Benson Joel Kellman 5213-50.4
Brian O'Neill Daniel Sprong Dylan Gambrell 300000
Blade Jenkins Vincent Trocheck Steve Kasper 635800.5
Mike Bullard Rem Pitlick Jason Dickinson 119132270.82
Brian O'Neill Daniel Sprong Pavel Shen 2000-30
Blade Jenkins Tyler Benson Brian O'Neill 6011-120
Dylan Gambrell Tim Stutzle Pavel Shen 4134-50.25
Mike Bullard Yegor Milovzorov Steve Kasper 3101-20.33
Shane Pinto Tim Stutzle Rem Pitlick 4437101
Blade Jenkins Jason Dickinson Daniel Sprong 3123-20.33
Yegor Milovzorov Tim Stutzle Steve Kasper 5213-190.4
Mike Bullard Blade Jenkins Rem Pitlick 2123-90.5
Vincent Trocheck Tyler Benson Jason Dickinson 2000-60
Martins Dzierkals Daniel Sprong Brian O'Neill 824660.25
Blade Jenkins Yegor Milovzorov Steve Kasper 4224-100.5
Mike Bullard Tim Stutzle Rem Pitlick 3224-100.67
Shane Pinto Tyler Benson Jason Dickinson 200000
Shane Pinto Tyler Benson Yegor Milovzorov 111201
Blade Jenkins Normand Leveille Brian O'Neill 1000-40
Dylan Gambrell Yegor Milovzorov Pavel Shen 3022-40
Martins Dzierkals Vincent Trocheck Joel Kellman 1000-10
Mike Bullard Tyler Benson Daniel Sprong 100000
Jason Dickinson Tim Stutzle Steve Kasper 2022-40
Blade Jenkins Tyler Benson Steve Kasper 225701
Dylan Gambrell Daniel Sprong Pavel Shen 2000-60
Mike Bullard Jason Dickinson Daniel Sprong 111231
Steve Kasper Tyler Benson Rem Pitlick 1123-91
Blade Jenkins Jason Dickinson Vincent Trocheck 2112-20.5
Brian O'Neill Joel Kellman Tim Stutzle 110131
Blade Jenkins Vincent Trocheck Daniel Sprong 1123-11
Brian O'Neill Martins Dzierkals Tyler Benson 100000
Tyler Benson Daniel Sprong Vincent Trocheck 122432
Shane Pinto Jason Dickinson Brian O'Neill 1011-30
Martins Dzierkals Daniel Sprong Joel Kellman 100000
Mike Bullard Tyler Benson Rem Pitlick 100000

Attaquants PP

Trios GP G A PTS G/GP
Tim Stutzle Blade Jenkins Rem Pitlick 141340.07
Mike Bullard Daniel Sprong Jason Dickinson 52350.4
Shane Pinto Mike Bullard Yegor Milovzorov 190110
Steve Kasper Blade Jenkins Jason Dickinson 253690.12
Tim Stutzle Vincent Trocheck Mike Bullard 100000
Steve Kasper Daniel Sprong Jason Dickinson 11121
Shane Pinto Tim Stutzle Yegor Milovzorov 271230.04
Steve Kasper Rem Pitlick Jason Dickinson 101120.1
Mike Bullard Tim Stutzle Yegor Milovzorov 61120.17
Mike Bullard Tyler Benson Jason Dickinson 20220
Rem Pitlick Daniel Sprong Jason Dickinson 70000
Blade Jenkins Tyler Benson Jason Dickinson 112240.18
Steve Kasper Mike Bullard Jason Dickinson 31010.33
Mike Bullard Shane Pinto Jason Dickinson 92350.22
Blade Jenkins Daniel Sprong Jason Dickinson 20110
Steve Kasper Tim Stutzle Yegor Milovzorov 30000
Mike Bullard Blade Jenkins Jason Dickinson 30000
Mike Bullard Tim Stutzle Blade Jenkins 31010.33
Vincent Trocheck Daniel Sprong Jason Dickinson 30000
Blade Jenkins Rem Pitlick Jason Dickinson 10110

Défenseurs 5vs5

Duos GP G A PTS DIFF G/GP
Connor Clifton Jakub Zboril 2221416-70.09
Dustyn McFaul Janis Moser 13088-110
Sebastien Aho Timothy Liljegren 14257-50.14
Dustyn McFaul Timothy Liljegren 3131215-180.1
Xavier Bouchard Connor Clifton 2061723150.3
Arber Xhekaj Sebastien Aho 904400
Dustyn McFaul Xavier Bouchard 1131114-60.27
Dustyn McFaul Sebastien Aho 20268-70.1
Janis Moser Timothy Liljegren 201100
Dustyn McFaul Jakub Zboril 2421416-120.08
Jakub Zboril Sebastien Aho 1527900.13
Connor Clifton Dustyn McFaul 1831316-70.17
Timothy Liljegren Xavier Bouchard 100020
Connor Clifton Timothy Liljegren 2211112-230.05
Xavier Bouchard Sebastien Aho 21189-70.05
Xavier Bouchard Jakub Zboril 27358-110.11
Dustyn McFaul Arber Xhekaj 121101120.08
Jakub Zboril Arber Xhekaj 1212330.08
Jakub Zboril Timothy Liljegren 3071623-90.23
Arber Xhekaj Xavier Bouchard 2000-20
Janis Moser Xavier Bouchard 200000

Défenseurs PP

Duos GP G A PTS G/GP
Sebastien Aho Dustyn McFaul 262790.08
Rem Pitlick Connor Clifton 40000
Steve Kasper Connor Clifton 243360.13
Rem Pitlick Dustyn McFaul 111230.09
Mike Bullard Connor Clifton 40000
Sebastien Aho Connor Clifton 110110
Steve Kasper Dustyn McFaul 110000
Mike Bullard Sebastien Aho 91120.11
Connor Clifton Dustyn McFaul 271120.04
Tim Stutzle Sebastien Aho 171120.06
Sebastien Aho Tyler Benson 70110
Connor Clifton Blade Jenkins 60220
Vincent Trocheck Connor Clifton 50000
Yegor Milovzorov Connor Clifton 10000
Vincent Trocheck Dustyn McFaul 10000