Player Profile for Scott McLachlan
Men's Gym - Orleans (Sun)

 

Career Men's Gym - Orleans (Sun) Scoring Stats

GP	G	A	P	PPG	SHG	GWG	PIM	Stars	P/G
1	1	0	1	0	0	0	2	0	1.00

 

Men's Gym - Orleans (Sun) Regular Season Scoring Stats

Team	Season	GP	G	A	P	PPG	SHG	GWG	PIM	Stars	P/G
Snow Kings	14F	1	1	0	1	0	0	0	2	0	1.00

 

Overall HTBHL Scoring Stats

League	GP	G	A	P	PPG	SHG	GWG	PIM	Stars	P/G
Men's Arena - Dulude/McNabb/St Laurent (Mon/Wed)	23	12	7	19	2	0	3	16	10	0.83
Men's Orleans - Tuesday	8	4	2	6	1	0	0	14	2	0.75
Men's Gym - Orleans (Sun)	1	1	0	1	0	0	0	2	0	1.00
Totals	32	17	9	26	3	0	3	32	12	0.81

 

SELECT 'thuma' AS League, CONCAT(FirstName, ' ', LastName) AS Name, Player.PlayerId, Sum(PlayerTeam.GP) AS GP, Sum(PlayerTeam.GW) AS GW, Sum(PlayerTeam.GL) AS GL, Sum(PlayerTeam.GGA) AS GA, (Sum(PlayerTeam.GGA)/Sum(PlayerTeam.GP)) AS GAA, Sum(PlayerTeam.GSA) AS SA, ((Sum(PlayerTeam.GSA)-Sum(PlayerTeam.GGA))/Sum(PlayerTeam.GSA)*100) AS SaveP, Sum(PlayerTeam.SO) AS SO, Sum(PlayerTeam.A) AS A, Sum(PlayerTeam.PIM) AS PIM, Sum(PlayerTeam.Star) AS Star FROM htbhl_thuma.Player, htbhl_thuma.PlayerTeam WHERE Player.PlayerId = PlayerTeam.PlayerId AND PlayerTeam.GP > 0 AND PlayerTeam.Goalie = 'y' AND FirstName = 'Scott' AND LastName = 'McLachlan' AND GP > 0 GROUP BY PlayerTeam.PlayerId