אין תקציר עריכה |
אין תקציר עריכה |
||
| שורה 7: | שורה 7: | ||
AND EventType=3 | AND EventType=3 | ||
AND SubType !=33 <!-- Without own goal --> | AND SubType !=33 <!-- Without own goal --> | ||
{{#if: {{{תאריך|}}}|DATE_FORMAT({{{תאריך|}}}, {{{פורמט תאריך|"%d %m %y"}}}) = DATE_FORMAT(Date, {{{פורמט תאריך|"%d %m %y"}}}) }} | {{#if: {{{תאריך|}}}|AND DATE_FORMAT({{{תאריך|}}}, {{{פורמט תאריך|"%d %m %y"}}}) = DATE_FORMAT(Date, {{{פורמט תאריך|"%d %m %y"}}}) }} | ||
|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 | ||