
אין תקציר עריכה |
|||
שורה 1: | שורה 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Games_Events | |||
| | |where=1=1 | ||
| | AND Team=1 | ||
AND EventType=3 | |||
AND DATE_FORMAT( "2018-12-27" , "%d %m") = DATE_FORMAT(Date, "%d %m") | |||
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 --> | |||
|having=COUNT(*)>2 | |||
|fields=_pageName=עמוד המשחק, CONCAT( '[[', PlayerName, ']]' )=שחקן, COUNT(*)=כמות שערים | |||
|order by=Date DESC | |||
|format=table | |||
|limit=200 | |||
}} | }} | ||