|
JOUEUR |
TEAM |
PAYS |
POS |
MJ
| HIT
| BKS
| GVA
| TKA
| FOW
| FOL
| TOT
| FO%
| %TM
| SHT
| S/G
| PC/G
Unknown column 'joueurs2006.ProGIV' 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 = '2010-2011' AND PosD != '' AND Country LIKE '%' AND `Pro GP` != 0 GROUP BY Name ORDER BY joueurs2006.`ProGIV` DESC, `Pro GP` ASC, `Pro G` DESC LIMIT 0, 50 |
