אין תקציר עריכה |
אין תקציר עריכה |
||
| שורה 1: | שורה 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Games_Events | tables=Games_Catalog, Games_Events | ||
|join on=Games_Catalog._pageID = Games_Events._PageID | |||
|where=1=1 | |where=1=1 | ||
{{#if: {{{תאריך|}}}| AND DATE_FORMAT({{{תאריך}}}, {{{פורמט תאריך|"%d %m %y"}}}) = DATE_FORMAT(Date, {{{פורמט תאריך|"%d %m %y"}}}) }} | {{#if: {{{תאריך|}}}| AND DATE_FORMAT({{{תאריך}}}, {{{פורמט תאריך|"%d %m %y"}}}) = DATE_FORMAT(Date, {{{פורמט תאריך|"%d %m %y"}}}) }} | ||
| שורה 7: | שורה 8: | ||
AND EventType=3 | AND EventType=3 | ||
AND SubType !=33 <!-- Without own goal --> | AND SubType !=33 <!-- Without own goal --> | ||
|group by=PlayerName, _pageName, Date <!-- group by date also so we can show and order by it at fields section --> | AND Games_Catalog.Competition NOT IN (19, 21) <!-- Only official games --> | ||
|group by=Games_Events.PlayerName, Games_Events._pageName, Games_Events.Date <!-- group by date also so we can show and order by it at fields section --> | |||
|having=COUNT(*)>2 | |having=COUNT(*)>2 | ||
|fields=_pageName=עמוד המשחק, | |fields=Games_Events._pageName=עמוד המשחק, | ||
PlayerName=שחקן, | Games_Events.PlayerName=שחקן, | ||
Count(*)=שערים | Count(*)=שערים | ||
|order by=Date DESC | |order by=Games_Events.Date DESC | ||
|format=table | |format=table | ||
|limit=200 | |limit=200 | ||
}} | }} | ||
גרסה מ־21:25, 2 באוגוסט 2021
שגיאה: הטבלה Games_Catalog לא נמצאה.