אורן המתעפץ (שיחה | תרומות) (יצירת דף עם התוכן "<includeonly><!-- We use SUM(Score)/COUNT(*) instead of AVG(Score) because AVG didn't work well with empty values -->{{#cargo_query: table=Volleyball_Players_Ga...") |
אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה |
||
| (4 גרסאות ביניים של אותו משתמש אינן מוצגות) | |||
| שורה 3: | שורה 3: | ||
We use SUM(Score)/COUNT(*) instead of AVG(Score) because AVG didn't work well with empty values | We use SUM(Score)/COUNT(*) instead of AVG(Score) because AVG didn't work well with empty values | ||
-->{{#cargo_query: | -->{{#cargo_query: | ||
table=Volleyball_Players_Game_Events=vpge, Volleyball_Games=vg | table=Volleyball_Players_Game_Events=vpge, Volleyball_Games=vg, Volleyball_Competitions=vc | ||
|join on=vpge._pageName = vg._pageName | |join on=vpge._pageName = vg._pageName, vg.Competition=vc.OriginalName | ||
|fields=vg.Season=Season, COUNT(*)=PlayerAppearances, SUM(vpge.PlayerScore)=SeasonSum , SUM(vpge.PlayerScore)/COUNT(*)=SeasonAvg | |fields=vg.Season=Season, COUNT(*)=PlayerAppearances, SUM(vpge.PlayerScore)=SeasonSum , SUM(vpge.PlayerScore)/COUNT(*)=SeasonAvg | ||
|where=vpge.PlayerName="{{{שם|}}}" AND vpge.Team=1 and vpge.isPlayed=true | |where=vpge.PlayerName="{{{שם|}}}" AND vpge.Team=1 and vpge.isPlayed=true AND vc.Official=true | ||
|group by=vg.Season | |group by=vg.Season | ||
|format=template | |format=template | ||
| שורה 12: | שורה 12: | ||
|named args=yes | |named args=yes | ||
|no html | |no html | ||
|default=}} | |default=}}<!-- | ||
</includeonly> | |||
--></includeonly> | |||