אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה |
אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה |
||
| שורה 31: | שורה 31: | ||
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, | ||
COUNT(CASE WHEN ge.EventType=4 AND ge.Team=1 THEN 1 ELSE NULL END)=Assists, | COUNT(CASE WHEN ge.EventType=4 AND ge.Team=1 THEN 1 ELSE NULL END)=Assists, | ||
COUNT(CASE WHEN ge.SubType=35 AND ge.Team=0 THEN 1 ELSE NULL END)=Total Opponent Penalty 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 AND 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, | ||