אין תקציר עריכה |
אין תקציר עריכה |
||
| שורה 5: | שורה 5: | ||
AND Team=1 | AND Team=1 | ||
AND EventType=3 | AND EventType=3 | ||
AND SubType | AND SubType=32 <!-- Without own goal --> | ||
|group by=_pageName, Date <!-- group by date also so we can show and order by it at fields section --> | |||
|group by= | |having=COUNT(*)>3 | ||
|having=COUNT(*)> | |||
|fields=_pageName=עמוד המשחק, CONCAT( '[[', PlayerName, ']]' )=שחקן, COUNT(*)=כמות שערים | |fields=_pageName=עמוד המשחק, CONCAT( '[[', PlayerName, ']]' )=שחקן, COUNT(*)=כמות שערים | ||
|order by=Date DESC | |order by=Date DESC | ||