(יצירת דף עם התוכן "{{#cargo_query: tables=Games_Catalog, Games_Events |join on=Games_Catalog._pageID = Games_Events._PageID |where=1=1 AND Team=1 AND EventType IN (3, 4) AND SubTyp...") |
אין תקציר עריכה |
||
| (גרסת ביניים אחת של אותו משתמש אינה מוצגת) | |||
| שורה 1: | שורה 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables= | tables=Football_Games, Games_Events, Competitions | ||
|join on= | |join on=Football_Games._pageID = Games_Events._PageID, | ||
Football_Games.Competition = Competitions.OriginalName | |||
|where=1=1 | |where=1=1 | ||
AND Team=1 | AND Team=1 | ||
AND EventType IN (3, 4) | AND EventType IN (3, 4) | ||
AND SubType !=33 <!-- Without own goal --> | AND SubType !=33 <!-- Without own goal --> | ||
AND | AND Competitions.Official=1 | ||
|group by=Games_Events.PlayerName, Games_Events._pageName, Games_Events.Date | |group by=Games_Events.PlayerName, Games_Events._pageName, Games_Events.Date | ||
|having=COUNT(*)>2 | |having=COUNT(*)>2 | ||
|fields= | |fields=Football_Games._pageName=עמוד המשחק, | ||
Football_Games.Date=תאריך, | |||
CONCAT( '[[', Games_Events.PlayerName, ']]' )=שחקן, | CONCAT( '[[', Games_Events.PlayerName, ']]' )=שחקן, | ||
COUNT(*)=כמות שערים שהיה מעורב | COUNT(*)=כמות שערים שהיה מעורב | ||
|order by= | |order by=Football_Games.Date DESC | ||
|format=table | |format=table | ||
|limit=200 | |limit=200 | ||
}} | }} | ||