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

VHLQ

Virtual Hockey League of Quebec 2040

Statistiques des trios (Séries) - Detroit

Attaquants 5vs5

Trios	GP	G	A	PTS	DIFF	G/GP
Aliaksei Protas Mitchell Dempsey David Pastrnak	2	0	2	2	-3	0
Thomas Novak Auston Matthews Walt Poddubny	2	1	-1	0	1	0.5
Kirby Dach Grigori Denisenko Jakub Vrana	2	0	0	0	-6	0
Nikita Pavlychev Frazer McLaren David Pastrnak	5	0	1	1	-3	0
Auston Matthews Mitchell Dempsey David Pastrnak	2	1	1	2	-3	0.5
Thomas Novak Aliaksei Protas Grigori Denisenko	2	3	3	6	9	1.5
Kirby Dach Walt Poddubny Jakub Vrana	2	0	0	0	0	0
Auston Matthews Mitchell Dempsey Grigori Denisenko	1	1	1	2	2	1
Thomas Novak Walt Poddubny David Pastrnak	1	0	0	0	-3	0
Kirby Dach Aliaksei Protas Jakub Vrana	1	0	0	0	-6	0

Attaquants PP

Trios	GP	G	A	PTS	G/GP
Auston Matthews Mitchell Dempsey Grigori Denisenko	1	0	0	0	0
Thomas Novak Walt Poddubny David Pastrnak	1	0	0	0	0
Auston Matthews Mitchell Dempsey David Pastrnak	2	0	0	0	0
Thomas Novak Aliaksei Protas Grigori Denisenko	2	0	0	0	0
Aliaksei Protas Mitchell Dempsey David Pastrnak	2	0	0	0	0
Thomas Novak Auston Matthews Walt Poddubny	2	1	2	3	0.5

Défenseurs 5vs5

Duos	GP	G	A	PTS	DIFF	G/GP
Paul Coffey Moe Mantha	3	0	1	1	0	0
Eddie Wittchow Conor Timmins	1	0	0	0	-2	0
Matias Samuelson Seth Jones	1	0	0	0	-3	0
Paul Coffey Conor Timmins	7	0	3	3	-4	0
Moe Mantha Matias Samuelson	4	0	2	2	3	0
Eddie Wittchow Eric Roy	2	0	0	0	0	0
Nicolas Beaudin Seth Jones	1	0	0	0	-2	0
Eric Roy Seth Jones	1	0	0	0	-2	0

Défenseurs PP

Duos	GP	G	A	PTS	G/GP
Paul Coffey Grigori Denisenko	2	0	0	0	0
Moe Mantha Seth Jones	2	0	0	0	0
Grigori Denisenko Moe Mantha	2	0	0	0	0
Paul Coffey Conor Timmins	2	0	0	0	0
Paul Coffey David Pastrnak	1	0	0	0	0
Moe Mantha Aliaksei Protas	1	0	0	0	0