|
JOUEUR |
TEAM |
PAYS |
GP
| GS
| W
| L
| OTL
| PCT
| GAA
| MP
| PIM
| SO
| GA
| SA
| SV
| A
Unknown column 'goalies2006.goalies.Shutouts' in 'order clause'
SELECT *,sum((goalies2006.SA - goalies2006.GA) / goalies2006.SA) as totalpct, sum(goalies2006.GA / (goalies2006.MIN / 3600)) as totalavg, sum(goalies2006.SA - goalies2006.GA) AS SV FROM goalies2006, teams WHERE Teamg = tnumber AND TeamName LIKE '%' AND Rookie != '0' AND goalies2006.year = '2019-2020' AND Country LIKE '%' AND goalies2006.GP != 0 GROUP BY Nameg ORDER BY goalies2006.`goalies.Shutouts` DESC, goalies2006.GP DESC LIMIT 0, 50 |
