אין תקציר עריכה |
אין תקציר עריכה |
||
| שורה 1: | שורה 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Games_Events | |||
|where=1=1 | |where=1=1 | ||
AND | {{#if: {{{תאריך|}}}| AND DATE_FORMAT({{{תאריך}}}, {{{פורמט תאריך|"%d %m %y"}}}) = DATE_FORMAT(Date, {{{פורמט תאריך|"%d %m %y"}}}) }} | ||
AND | AND Team=1 | ||
AND EventType=3 | |||
AND SubType !=33 <!-- Without own goal --> | |||
|group by= | |group by=PlayerName, _pageName, Date <!-- group by date also so we can show and order by it at fields section --> | ||
|having= | |having=COUNT(*)>2 | ||
|order by= | |fields=_pageName | ||
|format= | |order by=Date DESC | ||
|format=table | |||
|limit=200 | |||
}} | }} | ||