אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה |
מ (החלפת טקסט – "Games_Catalog" ב־"Football_Games") |
||
| שורה 7: | שורה 7: | ||
שליפת מספר ספיגות | שליפת מספר ספיגות | ||
-->{{#number_format: {{#cargo_query: | -->{{#number_format: {{#cargo_query: | ||
tables= | tables= Football_Games, Games_Events | ||
|join on= | |join on= Football_Games._pageID = Games_Events._pageID | ||
|where= 1 = 1 | |where= 1 = 1 | ||
AND PlayerName = "{{#var:שוער}}" | AND PlayerName = "{{#var:שוער}}" | ||
AND Team = 1 | AND Team = 1 | ||
AND EventType IN (1, 5) | AND EventType IN (1, 5) | ||
{{#if: {{{מפעל|}}} | AND | {{#if: {{{מפעל|}}} | AND Football_Games.Competition IN ({{#var:SameCompetitions}}) }}<!-- the "()" around the SameCompetition required for "IN" operator, list is wrapped with () --> | ||
{{#if: {{{עונה|}}} | AND | {{#if: {{{עונה|}}} | AND Football_Games.Season = "{{{עונה}}}" }} | ||
|fields=SUM(ResultOpponent) | |fields=SUM(ResultOpponent) | ||
|no html | |no html | ||