אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה |
אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה |
||
| שורה 27: | שורה 27: | ||
{{#ifeq: {{{קטגוריית מפעל|}}}| יתר-רשמיים| AND (c.Official = 1 AND c.League = 0 AND c.Trophy = 0 AND c.International = 0) }} | {{#ifeq: {{{קטגוריית מפעל|}}}| יתר-רשמיים| AND (c.Official = 1 AND c.League = 0 AND c.Trophy = 0 AND c.International = 0) }} | ||
|fields=fg.Season=Season, | |fields=fg.Season=Season, | ||
COUNT( | COUNT(DISTINCT fg._pageName)=Total Games, | ||
COUNT(CASE WHEN fg.Technical=-1 AND ((ge.Team=1 AND ge.EventType=3 AND ge.SubType!=33) OR ge.Team=0 AND ge.SubType=33) THEN 1 ELSE NULL END)=Total Goals, | COUNT(CASE WHEN fg.Technical=-1 AND ((ge.Team=1 AND ge.EventType=3 AND ge.SubType!=33) OR ge.Team=0 AND ge.SubType=33) THEN 1 ELSE NULL END)=Total Goals, | ||
COUNT(CASE WHEN ge.SubType=35 AND ge.Team=1 THEN 1 ELSE NULL END)=Penalty Goals, | COUNT(CASE WHEN ge.SubType=35 AND ge.Team=1 THEN 1 ELSE NULL END)=Penalty Goals, | ||