שאילתת Cargo
מוצגות עד 100 תוצאות בין המספרים 21 ו־120:
צפייה ב: (100 הקודמים | 100 הבאים) (20 | 50 | 100 | 250 | 500)
| שם שחקן | מספר העונות שהשחקן בישל שער |
|---|---|
| 7 | |
| 7 | |
| 7 | |
| 7 | |
| 7 | |
| 7 | |
| 7 | |
| 7 | |
| 6 | |
| 6 | |
| 6 | |
| 6 | |
| 6 | |
| 6 | |
| 6 | |
| 6 | |
| 6 | |
| 6 | |
| 6 | |
| 5 | |
| 5 | |
| 5 | |
| 5 | |
| 5 | |
| 5 | |
| 5 | |
| 5 | |
| 5 | |
| 5 | |
| 5 | |
| 5 | |
| 5 | |
| 5 | |
| 5 | |
| 5 | |
| 5 | |
| 5 | |
| 5 | |
| 5 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 |
צפייה ב: (100 הקודמים | 100 הבאים) (20 | 50 | 100 | 250 | 500)
{{#cargo_query:
tables=Football_Games, Games_Events, Competitions
|fields=CONCAT('[[', Games_Events.PlayerName, ']]')=שם שחקן, Count(DISTINCT Football_Games.Season)=מספר העונות שהשחקן בישל שער
|where=1=1
AND Team=1
AND Competitions.Official=1
AND EventType = 4
|join on=Football_Games._pageID = Games_Events._PageID,
Football_Games.Competition = Competitions.OriginalName
|group by=Games_Events.PlayerName
|order by=`מספר העונות שהשחקן בישל שער` DESC
|format=auto
|offset=20
|limit=100
}}