אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה |
אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה |
||
| שורה 35: | שורה 35: | ||
COUNT(CASE WHEN fg.ResultOpponent=0 THEN 1 ELSE NULL END)=Games Without Opponent Goals, | COUNT(CASE WHEN fg.ResultOpponent=0 THEN 1 ELSE NULL END)=Games Without Opponent Goals, | ||
COUNT(CASE WHEN ge.SubType=71 AND ge.Team=1 THEN 1 ELSE NULL END)=First Yellow Card, | COUNT(CASE WHEN ge.SubType=71 AND ge.Team=1 THEN 1 ELSE NULL END)=First Yellow Card, | ||
COUNT(CASE WHEN ge.SubType=72 ge.Team=1 THEN 1 ELSE NULL END)=Second Yellow Card, | COUNT(CASE WHEN ge.SubType=72 AND ge.Team=1 THEN 1 ELSE NULL END)=Second Yellow Card, | ||
COUNT(CASE WHEN ge.SubType=73 ge.Team=1 THEN 1 ELSE NULL END)=Direct Red Card | COUNT(CASE WHEN ge.SubType=73 AND ge.Team=1 THEN 1 ELSE NULL END)=Direct Red Card | ||
|group by=Season | |group by=Season | ||
|order by=Season DESC | |order by=Season DESC | ||