Player Profile for Dave Allston
Men's Gym - Alta Vista (Sun)
| GP | G | A | P | PPG | SHG | GWG | PIM | Stars | P/G |
|---|---|---|---|---|---|---|---|---|---|
| 101 | 106 | 95 | 201 | 3 | 0 | 9 | 8 | 42 | 1.99 |
| Team | Season | GP | G | A | P | PPG | SHG | GWG | PIM | Stars | P/G |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Blue Belugas | 19W | 10 | 21 | 9 | 30 | 1 | 0 | 2 | 2 | 6 | 3.00 |
| The Usual Suspects | 17F | 11 | 14 | 13 | 27 | 0 | 0 | 0 | 0 | 12 | 2.45 |
| Bacon Pancakes | 15F | 11 | 12 | 9 | 21 | 2 | 0 | 1 | 2 | 3 | 1.91 |
| Bacon Pancakes | 17W | 11 | 11 | 7 | 18 | 0 | 0 | 1 | 0 | 5 | 1.64 |
| The Usual Suspects | 18W | 8 | 8 | 8 | 16 | 0 | 0 | 0 | 2 | 3 | 2.00 |
| Blue Belugas | 20W | 5 | 7 | 8 | 15 | 0 | 0 | 0 | 0 | 1 | 3.00 |
| Blue Belugas | 19F | 10 | 6 | 8 | 14 | 0 | 0 | 1 | 2 | 6 | 1.40 |
| Bacon Pancakes | 16W | 8 | 2 | 12 | 14 | 0 | 0 | 1 | 0 | 0 | 1.75 |
| Bacon Pancakes | 16F | 9 | 7 | 5 | 12 | 0 | 0 | 1 | 0 | 0 | 1.33 |
| Blue Belugas | 18F | 5 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0.60 |
| Team | Season | GP | G | A | P | PPG | SHG | GWG | PIM | Stars | P/G |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Blue Belugas | 19W | 3 | 6 | 5 | 11 | 0 | 0 | 1 | 0 | 3 | 3.67 |
| Bacon Pancakes | 17W | 3 | 6 | 1 | 7 | 0 | 0 | 1 | 0 | 3 | 2.33 |
| Bacon Pancakes | 16W | 1 | 1 | 3 | 4 | 0 | 0 | 0 | 0 | 0 | 4.00 |
| The Usual Suspects | 17F | 1 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 3.00 |
| Blue Belugas | 19F | 1 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2.00 |
| Bacon Pancakes | 16F | 1 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 2.00 |
| Bacon Pancakes | 15F | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0.50 |
| The Usual Suspects | 18W | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1.00 |
| League | GP | G | A | P | PPG | SHG | GWG | PIM | Stars | P/G |
|---|---|---|---|---|---|---|---|---|---|---|
| Coed Gym - Carling (Mon) | 118 | 295 | 160 | 455 | 7 | 0 | 16 | 25 | 137 | 3.86 |
| Men's Gym - Hintonburg (Sun) | 183 | 222 | 163 | 385 | 17 | 0 | 23 | 18 | 100 | 2.10 |
| Men's Gym - Alta Vista (Sun) | 101 | 106 | 95 | 201 | 3 | 0 | 9 | 8 | 42 | 1.99 |
| Coed Arena - Belltown Dome | 16 | 18 | 10 | 28 | 0 | 0 | 0 | 6 | 11 | 1.75 |
| Men's Arena - Dulude/McNabb/St Laurent (Mon/Wed) | 22 | 8 | 18 | 26 | 0 | 0 | 1 | 0 | 11 | 1.18 |
| Men's Arena - Dulude/Pinecrest (Thurs) | 11 | 4 | 5 | 9 | 1 | 0 | 0 | 0 | 0 | 0.82 |
| Men's Arena - St Laurent (Sun) | 9 | 4 | 5 | 9 | 0 | 0 | 0 | 2 | 1 | 1.00 |
| Men's Gym - Kanata (Mon/Wed) | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0.50 |
| Men's Vanier - Saturday | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 |
| Totals | 463 | 657 | 457 | 1114 | 28 | 0 | 49 | 59 | 302 | 2.41 |
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 = 'Dave' AND LastName = 'Allston' AND GP > 0 GROUP BY PlayerTeam.PlayerId