אין תקציר עריכה |
אין תקציר עריכה |
||
| שורה 1: | שורה 1: | ||
<includeonly> | <includeonly><!-- | ||
-->{{#cargo_query: | -->{{#cargo_query: | ||
tables=Games_Events | tables=Games_Events | ||
|where=1=1 | |where=1=1 | ||
{{#if: {{{תאריך|}}}|AND DATE_FORMAT({{{תאריך|}}}, {{{פורמט תאריך|"%d %m %y"}}}) = DATE_FORMAT(Date, {{{פורמט תאריך|"%d %m %y"}}}) }} | |||
AND Team=1 | AND Team=1 | ||
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 --> | |group by=PlayerName, _pageName, Date <!-- group by date also so we can show and order by it at fields section --> | ||
|having=COUNT(*)>2 | |having=COUNT(*)>2 | ||