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

Statistiques des trios - Arizona

Attaquants 5vs5

Trios GP G A PTS DIFF G/GP
Brady Tkachuk Brandon Tanev Mikko Rantanen 74711-70.57
Ron Francis Noah Cates Lucas Raymond 444831
Roope Hintz Jakub Vrana Kaapo Kakko 2041115-60.2
Boone Jenner Nail Yakupov Mikko Rantanen 2010172780.5
Ron Francis Brady Tkachuk Mikko Rantanen 24182543160.75
Roope Hintz Lucas Raymond Brandon Tanev 41-10-90.25
Kaapo Kakko Jakub Vrana Nail Yakupov 6358-10.5
Boone Jenner Riley Barber Mikko Rantanen 14481220.29
Brady Tkachuk Lucas Raymond Mikko Rantanen 16111627100.69
Ron Francis Noah Cates Brandon Tanev 14152439231.07
Kaapo Kakko Brandon Tanev Lucas Raymond 651600.83
Roope Hintz Jakub Vrana Nail Yakupov 10471120.4
Noah Cates Nikolaj Ehlers Mitchell Marner 2123-30.5
Boone Jenner Brandon Tanev Jakub Vrana 4123-40.25
Mikko Rantanen Nail Yakupov Travis Boyd 11651140.55
Noah Cates Brady Tkachuk Mikko Rantanen 10538-50.5
Ron Francis Tomas Hertl Kaapo Kakko 643730.67
Boone Jenner Jakub Vrana Nail Yakupov 17111526210.65
Mikko Rantanen Riley Barber Travis Boyd 27131528220.48
Ron Francis Noah Cates Nikolaj Ehlers 5358-30.6
Mikko Rantanen Brady Tkachuk Mitchell Marner 5336100.6
Mikko Rantanen Brady Tkachuk Kaapo Kakko 100000
Ron Francis Noah Cates Jakub Vrana 3213-10.67
Noah Dobson Tomas Hertl Boone Jenner 100000
Tomas Hertl Noah Cates Kaapo Kakko 221351
Mikko Rantanen Brandon Tanev Kaapo Kakko 112331
Ron Francis Brady Tkachuk Lucas Raymond 2000-30
Noah Cates Lucas Raymond Kaapo Kakko 4437151
Roope Hintz Jakub Vrana Boone Jenner 5101-110.2
Mikko Rantanen Riley Barber Nail Yakupov 3022-60
Noah Cates Roope Hintz Lucas Raymond 522400.4
Kaapo Kakko Jakub Vrana Boone Jenner 542680.8
Mikko Rantanen Brady Tkachuk Jakub Vrana 331471
Ron Francis Noah Cates Kaapo Kakko 322460.67
Boone Jenner Adam Beckman Nail Yakupov 334761
Ron Francis Mitchell Marner Mikko Rantanen 310110.33
Noah Cates Brady Tkachuk Nikolaj Ehlers 4471181
Mikko Rantanen Noah Cates Lucas Raymond 223541
Ron Francis Brady Tkachuk Brandon Tanev 2112-50.5
Mikko Rantanen Adam Beckman Nail Yakupov 4202-40.5
Ron Francis Lucas Raymond Mikko Rantanen 3123-130.33
Kaapo Kakko Brady Tkachuk Brandon Tanev 331481
Ron Francis Jakub Vrana Tomas Hertl 3000-60
Boone Jenner Nail Yakupov Kaapo Kakko 521300.4
Ron Francis Noah Cates Mitchell Marner 523500.4
Boone Jenner Nikolaj Ehlers Jakub Vrana 3112-60.33
Adam Beckman Jakub Vrana Nail Yakupov 221351
Mikko Rantanen Brady Tkachuk Nikolaj Ehlers 211200.5
Ron Francis Roope Hintz Lucas Raymond 1000-30
Mikko Rantanen Boone Jenner Travis Boyd 20-1-1-30
Mikko Rantanen Mitchell Marner Jakub Vrana 1000-20
Ron Francis Mikko Rantanen Kaapo Kakko 222421
Noah Cates Brady Tkachuk Tomas Hertl 222431
Nikolaj Ehlers Noah Cates 110101
Roope Hintz Noah Cates Brandon Tanev 1101-11
Boone Jenner Morgan Barron Nail Yakupov 101110
Ron Francis Noah Cates Tomas Hertl 1000-60
Kaapo Kakko Roope Hintz Nail Yakupov 100000
Mikko Rantanen Brady Tkachuk Tomas Hertl 1011-50

Attaquants PP

Trios GP G A PTS G/GP
Kaapo Kakko Noah Cates Mikko Rantanen 20000
Mikko Rantanen Brady Tkachuk Ron Francis 3166120.19
Kaapo Kakko Noah Cates Lucas Raymond 101340.1
Brandon Tanev Lucas Raymond Roope Hintz 80110
Noah Cates Nikolaj Ehlers Ron Francis 50000
Mikko Rantanen Brady Tkachuk Mitchell Marner 60000
Noah Cates Brandon Tanev Ron Francis 150220
Mikko Rantanen Brady Tkachuk Lucas Raymond 152130.13
Noah Cates Tomas Hertl Kaapo Kakko 80220
Mikko Rantanen Brady Tkachuk Nikolaj Ehlers 50000
Ron Francis Noah Cates Mitchell Marner 51120.2
Ron Francis Brady Tkachuk Lucas Raymond 10000
Mikko Rantanen Kaapo Kakko Brandon Tanev 10000
Ron Francis Noah Cates Kaapo Kakko 20000
Mikko Rantanen Brady Tkachuk Tomas Hertl 10000
Ron Francis Noah Cates Mikko Rantanen 10110
Mikko Rantanen Brady Tkachuk Kaapo Kakko 51230.2
Roope Hintz Brady Tkachuk Brandon Tanev 51120.2
Ron Francis Lucas Raymond Mikko Rantanen 50220
Noah Cates Brady Tkachuk Nikolaj Ehlers 30000
Ron Francis Mikko Rantanen Mitchell Marner 32240.67
Noah Cates Nikolaj Ehlers Mitchell Marner 20000
Noah Cates Brady Tkachuk Tomas Hertl 20000
Ron Francis Mikko Rantanen Kaapo Kakko 20000
Roope Hintz Brady Tkachuk Lucas Raymond 10000
Ron Francis Noah Cates Tomas Hertl 40220
Ron Francis Noah Cates Lucas Raymond 40000
Mikko Rantanen Brady Tkachuk Brandon Tanev 40220
Nikolaj Ehlers Noah Cates 10000
Ron Francis Brady Tkachuk Brandon Tanev 20000
Mikko Rantanen Noah Cates Lucas Raymond 20000
Ron Francis Roope Hintz Lucas Raymond 10000
Noah Cates Brady Tkachuk Mikko Rantanen 12132
Noah Cates Mikko Rantanen Nikolaj Ehlers 10000

Défenseurs 5vs5

Duos GP G A PTS DIFF G/GP
Ivan Provorov Cole Krygier 82146276400.17
Erik Brannstrom Jan Rutta 107195574-70.18
Ivan Provorov Filip Hronek 488324040.17
Ivan Provorov Noah Dobson 1106610
Filip Hronek Jan Rutta 341111270.03
Ivan Provorov Erik Brannstrom 2322224180.09
Noah Dobson Jan Rutta 231121390.04

Défenseurs PP

Duos GP G A PTS G/GP
Noah Dobson Ivan Provorov 341120.03
Erik Brannstrom Noah Dobson 281230.04
Kaapo Kakko Ivan Provorov 341340.03
Erik Brannstrom Jakub Vrana 131120.08
Erik Brannstrom Roope Hintz 323360.09
Ivan Provorov Jakub Vrana 111450.09
Erik Brannstrom Brandon Tanev 70220
Ivan Provorov Erik Brannstrom 30110
Erik Brannstrom Cole Krygier 10000
Erik Brannstrom Kaapo Kakko 10000