SELECT GL.*, E.joueur FROM game_lines GL, joueurequipe E, joueur J WHERE GL.FK_team = 22 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 - Tampa Bay

Attaquants 5vs5

Trios GP G A PTS DIFF G/GP
Francis Perron D'Artagnan Joly Nils Hoglander 4235-50.5
Conor Sheary Gerald Mayhew Steve Larmer 211200.5
Dale Hawerchuk Jakob Pelletier Nikolay Prokhorkin 2000-50
William Karlsson Sergei Shumakov Steve Larmer 2011-20
Dale Hawerchuk Steve Larmer Francis Perron 723500.29
Nils Hoglander D'Artagnan Joly William Karlsson 210100.5
Nikolay Prokhorkin Gerald Mayhew Conor Sheary 222431
Sergei Shumakov Jean-Seb Dea Henrik Samuelsson 711200.14
Gerald Mayhew Francis Perron Dale Hawerchuk 210100.5
Steve Larmer D'Artagnan Joly Nils Hoglander 212330.5
William Karlsson Conor Sheary Nikolay Prokhorkin 7235-60.29
Sergei Shumakov Dale Hawerchuk Jean-Seb Dea 157815-30.47
Francis Perron D'Artagnan Joly Dale Hawerchuk 200000
Steve Larmer Nils Hoglander Gerald Mayhew 20-1-1-30
William Karlsson Conor Sheary Jakob Pelletier 3044-30
Steve Larmer Sergei Shumakov Nikolay Prokhorkin 100000
D'Artagnan Joly Steve Larmer Francis Perron 1011-10
Dale Hawerchuk Nils Hoglander Gerald Mayhew 1123-51
Nikolay Prokhorkin Jean-Seb Dea Steve Larmer 210110.5
D'Artagnan Joly Nils Hoglander Gerald Mayhew 5123-40.2
Gerald Mayhew Francis Perron D'Artagnan Joly 111181951
Conor Sheary Nils Hoglander Dale Hawerchuk 12152035221.25
Rasmus Kupari William Karlsson Nikolay Prokhorkin 3011-50
Lukas Reichel William Karlsson Nikolay Prokhorkin 1071118130.7
Gerald Mayhew Conor Sheary Dale Hawerchuk 223501
Dale Hawerchuk Jakob Pelletier Sergei Shumakov 110111
Francis Perron D'Artagnan Joly William Karlsson 1000-30
Nikolay Prokhorkin Lukas Reichel Jakob Pelletier 100000

Attaquants PP

Trios GP G A PTS G/GP
D'Artagnan Joly Nils Hoglander Conor Sheary 72020.29
Dale Hawerchuk Gerald Mayhew Francis Perron 141560.07
Steve Larmer Francis Perron Dale Hawerchuk 10000
Conor Sheary Francis Perron Dale Hawerchuk 70000
D'Artagnan Joly Steve Larmer Nils Hoglander 102570.2
D'Artagnan Joly Dale Hawerchuk Nils Hoglander 80000
Steve Larmer William Karlsson D'Artagnan Joly 10000
Francis Perron D'Artagnan Joly Dale Hawerchuk 30000
Steve Larmer William Karlsson Francis Perron 20000
Francis Perron Dale Hawerchuk Lucas Mercuri 10000
Gerald Mayhew Francis Perron D'Artagnan Joly 20000

Défenseurs 5vs5

Duos GP G A PTS DIFF G/GP
Kevin Bahl Thomas Chabot 2862935-10.21
Michael Anderson Alexandre Carrier 306814180.2
Thomas Chabot Braden Schneider 141111250.07
Braden Schneider Michael Anderson 14268-150.14
Thomas Chabot Miro Karjalainen 1471118-100.5
Michael Anderson Kevin Bahl 301100
Kevin Bahl Alexandre Carrier 913420.11

Défenseurs PP

Duos GP G A PTS G/GP
William Karlsson Thomas Chabot 100000
Michael Anderson Gerald Mayhew 91340.11
Gerald Mayhew Thomas Chabot 20000
Nils Hoglander Michael Anderson 20000
Michael Anderson Conor Sheary 20000
Dale Hawerchuk Thomas Chabot 60000
Michael Anderson Alexandre Carrier 141230.07
Thomas Chabot Conor Sheary 90000
William Karlsson Michael Anderson 10000
Thomas Chabot Nils Hoglander 10000