אורן המתעפץ (שיחה | תרומות) (יצירת דף עם התוכן "<includeonly><!-- --><div class="table-row><!-- --><span>{{#קיים: עונת {{{Season|}}} |[[עונת {{{Season}}}|{{{Season}}}]] |{{{Season|}}} }}</span><!-- --><span>{{{Total Games|}}}</span><!-- --><span>{{{Total Goals|}}} ({{{Penalty Goals|}}})</span><!-- --><span>{{{Assists|}}}</span><!-- --><span>{{{Total Opponent Goals|}}} ({{{Total Opponent Penalty Goals|}}})</span><!-- --><span>{{{Games Without Opponent Goals|}}}</span><!-- --><span>{{{First Ye...") |
אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה |
||
| שורה 1: | שורה 1: | ||
<includeonly><!-- | <includeonly><!-- | ||
-->{{#vardefine: ספיגות |{{#cargo_query: | |||
tables=Football_Games=fg, Competitions=c | |||
|join on=fg.Competition=c.OriginalName | |||
|where=fg.CoachMaccabi="{{#var: שם להצגה}}" | |||
{{#ifeq: {{#var: קטגוריית מפעל}}| ליגה| AND c.League = 1 }} | |||
{{#ifeq: {{#var: קטגוריית מפעל}}| גביע| AND c.Trophy = 1 }} | |||
{{#ifeq: {{#var: קטגוריית מפעל}}| בינלאומי| AND c.International = 1 }} | |||
{{#ifeq: {{#var: קטגוריית מפעל}}| רשמי| AND c.Official = 1 }} | |||
{{#ifeq: {{#var: קטגוריית מפעל}}| יתר-רשמיים| AND (c.Official = 1 AND c.League = 0 AND c.Trophy = 0 AND c.International = 0) }} | |||
|fields=SUM(fg.ResultOpponent) | |||
|group by=Season | |||
|order by=Season DESC | |||
|default=0 | |||
|no html | |||
}} }}<!-- | |||
--><div class="table-row><!-- | --><div class="table-row><!-- | ||
| שורה 6: | שורה 22: | ||
--><span>{{{Total Goals|}}} ({{{Penalty Goals|}}})</span><!-- | --><span>{{{Total Goals|}}} ({{{Penalty Goals|}}})</span><!-- | ||
--><span>{{{Assists|}}}</span><!-- | --><span>{{{Assists|}}}</span><!-- | ||
--><span>{{ | --><span>{{#var: ספיגות}} ({{{Total Opponent Penalty Goals|}}})</span><!-- | ||
--><span>{{{Games Without Opponent Goals|}}}</span><!-- | --><span>{{{Games Without Opponent Goals|}}}</span><!-- | ||
--><span>{{{First Yellow Card|}}} / {{{Second Yellow Card|}}} / {{{Direct Red Card|}}}</span><!-- | --><span>{{{First Yellow Card|}}} / {{{Second Yellow Card|}}} / {{{Direct Red Card|}}}</span><!-- | ||
--></div> | --></div> | ||
</includeonly> | </includeonly> | ||