WCHLSIM.com - West Coast Hockey League

WCHLSIM.com - West Coast Hockey League

Dernière mise à jour: 2024-04-25 18:59:52

YEARS	SEASON	TEAM	POSITION	COUNTRY	STATUS	REPORT
							SEARCH ›

JOUEUR

TEAM

PAYS

POS

FO% Unknown column 'joueurs2006.totalSHT' in 'order clause'
SELECT *, sum((PFOW / PFOT) *100) as totalFO, sum(`Pro Minutes Played` / `Pro GP`) as totalMPG, sum((`Pro G` / `Pro Shots`) * 100) as totalSHT, sum(PFOT - PFOW) AS PFOL, sum(`Pro Shots` / `Pro GP`) AS SPG, sum(PFOT / ((FOTOZ + FOTDZ + FOTNZ)) *100) AS totalFOTeam, sum(`Pro 5Pim` / 5) AS major, sum(`Pro G` - `Pro PP` - `Pro SH`) AS eveng, sum(`Pro A` - ProPPA - ProSHA) AS evena, sum(joueurs2006.pts - `Pro PP` - ProPPA- ProSHA - `Pro SH`) AS evenpts, sum(`Pro Shots` - ProPPShots - ProSHShots) AS evensht, sum(`Pro PP` + ProPPA) AS PPPTS, sum(`Pro SH` + ProSHA) AS SHPTS, sum(`Pro Minutes Played` - ProPPMIN - ProSHMIN) AS eventoi, sum((`Pro Minutes Played` - ProPPMIN - ProSHMIN) / `Pro GP`) AS eventoig, sum(ProPPMIN / `Pro GP`) AS PPTOIG, sum(ProSHMIN / `Pro GP`) AS SHTOIG FROM joueurs2006, teams WHERE Team = tnumber AND TeamName LIKE '' AND Rookie != '0' AND joueurs2006.year = '2021-2022' AND PosD != '' AND Country LIKE '%' AND `Pro GP` != 0 GROUP BY Name ORDER BY joueurs2006.`totalSHT` DESC, `Pro GP` ASC, `Pro G` DESC LIMIT 0, 50