אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה |
אין תקציר עריכה |
||
| (גרסת ביניים אחת של משתמש אחר אחד אינה מוצגת) | |||
| שורה 1: | שורה 1: | ||
<includeonly> | <includeonly><!-- | ||
{{#cargo_query: | |||
We use SUM(Score)/COUNT(*) instead of AVG(Score) because AVG didn't work well with empty values | |||
-->{{#cargo_query: | |||
table=Volleyball_Players_Game_Events=vpge, Volleyball_Games=vg | table=Volleyball_Players_Game_Events=vpge, Volleyball_Games=vg | ||
|join on=vpge._pageName = vg._pageName | |join on=vpge._pageName = vg._pageName | ||
|fields=vg.Season=Season, SUM(vpge.PlayerScore)=SeasonSum , | |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 | ||
|group by=vg.Season | |group by=vg.Season | ||