|
string(3476) "SELECT MainTable.*, PlayerProStat.*, ROUND(CAST((MainTable.SumOfG + PlayerProStat.G) AS REAL) / CAST((MainTable.SumOfShots + PlayerProStat.Shots) AS REAL) *100,2) AS TotalShotsPCT,ROUND(CAST((MainTable.SumOfSecondPlay+ PlayerProStat.SecondPlay) AS REAL) / 60 / CAST((MainTable.SumOfGP + PlayerProStat.GP) AS REAL),2) AS TotalAMG, ROUND(CAST((MainTable.SumOfFaceOffWon+ PlayerProStat.FaceOffWon) AS REAL) / CAST((MainTable.SumOfFaceOffTotal + PlayerProStat.FaceOffTotal) AS REAL) *100,2) as TotalFaceoffPCT, ROUND(CAST((MainTable.SumOfP+ PlayerProStat.P) AS REAL) / CAST((MainTable.SumOfSecondPlay + PlayerProStat.SecondPlay) AS REAL) * 60 * 20,2) AS TotalP20 FROM (SELECT Name AS SumOfName, Name, Sum(PlayerProStatCareer.GP) AS SumOfGP, Sum(PlayerProStatCareer.Shots) AS SumOfShots, Sum(PlayerProStatCareer.G) AS SumOfG, Sum(PlayerProStatCareer.A) AS SumOfA, Sum(PlayerProStatCareer.P) AS SumOfP, Sum(PlayerProStatCareer.PlusMinus) AS SumOfPlusMinus, Sum(PlayerProStatCareer.Pim) AS SumOfPim, Sum(PlayerProStatCareer.Pim5) AS SumOfPim5, Sum(PlayerProStatCareer.ShotsBlock) AS SumOfShotsBlock, Sum(PlayerProStatCareer.OwnShotsBlock) AS SumOfOwnShotsBlock, Sum(PlayerProStatCareer.OwnShotsMissGoal) AS SumOfOwnShotsMissGoal, Sum(PlayerProStatCareer.Hits) AS SumOfHits, Sum(PlayerProStatCareer.HitsTook) AS SumOfHitsTook, Sum(PlayerProStatCareer.GW) AS SumOfGW, Sum(PlayerProStatCareer.GT) AS SumOfGT, Sum(PlayerProStatCareer.FaceOffWon) AS SumOfFaceOffWon, Sum(PlayerProStatCareer.FaceOffTotal) AS SumOfFaceOffTotal, Sum(PlayerProStatCareer.PenalityShotsScore) AS SumOfPenalityShotsScore, Sum(PlayerProStatCareer.PenalityShotsTotal) AS SumOfPenalityShotsTotal, Sum(PlayerProStatCareer.EmptyNetGoal) AS SumOfEmptyNetGoal, Sum(PlayerProStatCareer.SecondPlay) AS SumOfSecondPlay, Sum(PlayerProStatCareer.HatTrick) AS SumOfHatTrick, Sum(PlayerProStatCareer.PPG) AS SumOfPPG, Sum(PlayerProStatCareer.PPA) AS SumOfPPA, Sum(PlayerProStatCareer.PPP) AS SumOfPPP, Sum(PlayerProStatCareer.PPShots) AS SumOfPPShots, Sum(PlayerProStatCareer.PPSecondPlay) AS SumOfPPSecondPlay, Sum(PlayerProStatCareer.PKG) AS SumOfPKG, Sum(PlayerProStatCareer.PKA) AS SumOfPKA, Sum(PlayerProStatCareer.PKP) AS SumOfPKP, Sum(PlayerProStatCareer.PKShots) AS SumOfPKShots, Sum(PlayerProStatCareer.PKSecondPlay) AS SumOfPKSecondPlay, Sum(PlayerProStatCareer.GiveAway) AS SumOfGiveAway, Sum(PlayerProStatCareer.TakeAway) AS SumOfTakeAway, Sum(PlayerProStatCareer.PuckPossesionTime) AS SumOfPuckPossesionTime, Sum(PlayerProStatCareer.FightW) AS SumOfFightW, Sum(PlayerProStatCareer.FightL) AS SumOfFightL, Sum(PlayerProStatCareer.FightT) AS SumOfFightT, Sum(PlayerProStatCareer.Star1) AS SumOfStar1, Sum(PlayerProStatCareer.Star2) AS SumOfStar2, Sum(PlayerProStatCareer.Star3) AS SumOfStar3, ROUND((CAST(Sum(PlayerProStatCareer.G) AS REAL) / (Sum(PlayerProStatCareer.Shots)))*100,2) AS SumOfShotsPCT, ROUND((CAST(Sum(PlayerProStatCareer.SecondPlay) AS REAL) / 60 / (Sum(PlayerProStatCareer.GP))),2) AS SumOfAMG, ROUND((CAST(Sum(PlayerProStatCareer.FaceOffWon) AS REAL) / (Sum(PlayerProStatCareer.FaceOffTotal)))*100,2) as SumOfFaceoffPCT, ROUND((CAST(Sum(PlayerProStatCareer.P) AS REAL) / (Sum(PlayerProStatCareer.SecondPlay)) * 60 * 20),2) AS SumOfP20 FROM PlayerProStatCareer WHERE (TeamName = 'ANA' OR TeamName = 'Ducks') AND Playoff = 'False' GROUP BY PlayerProStatCareer.UniqueID) AS MainTable LEFT JOIN PlayerProStat ON MainTable.SumOfName = PlayerProStat.UniqueID ORDER BY (MainTable.SumOfGP) DESC LIMIT 1 "
|
|
|
|
Pacific Division
Metropolitan Division
SimonT Hockey Simulator (STHS) for Michael Green - Version Française du Site Web - The database was created : 6/14/2026 6:08:46 PM