Player Profile for Daniel Walcott
Men's Arena - Dulude/McNabb/St Laurent (Mon/Wed)
GP | G | A | P | PPG | SHG | GWG | PIM | Stars | P/G |
---|---|---|---|---|---|---|---|---|---|
69 | 9 | 10 | 19 | 2 | 0 | 1 | 2 | 3 | 0.28 |
Team | Season | GP | G | A | P | PPG | SHG | GWG | PIM | Stars | P/G |
---|---|---|---|---|---|---|---|---|---|---|---|
Sacred Blue | 18S | 16 | 3 | 5 | 8 | 0 | 0 | 0 | 0 | 1 | 0.50 |
Sacred Blue | 23S | 13 | 3 | 3 | 6 | 1 | 0 | 0 | 0 | 1 | 0.46 |
Sacred Blue | 19S | 16 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0.12 |
Sacred Blue | 22S | 6 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0.17 |
Sacred Blue | 24S | 9 | 0 | 1 | 1 | 0 | 0 | 0 | 2 | 0 | 0.11 |
Team | Season | GP | G | A | P | PPG | SHG | GWG | PIM | Stars | P/G |
---|---|---|---|---|---|---|---|---|---|---|---|
Sacred Blue | 18S | 3 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0.33 |
Sacred Blue | 19S | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 |
Sacred Blue | 22S | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 |
Sacred Blue | 23S | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 |
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 = 'Daniel' AND LastName = 'Walcott' AND GP > 0 GROUP BY PlayerTeam.PlayerId