אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה תגית: שוחזרה |
אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה תגית: שוחזרה |
||
| שורה 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, | ||
SUM(fg.ResultOpponent * (ge. | SUM(fg.ResultOpponent * (ge._ID = (SELECT MIN(_ID) FROM ge WHERE ge._pageName=fg._pageName))) = Total Opponent Goals | ||
COUNT(CASE WHEN ge.SubType=35 AND ge.Team=0 THEN 1 ELSE NULL END)=Total Opponent Penalty Goals, | COUNT(CASE WHEN ge.SubType=35 AND ge.Team=0 THEN 1 ELSE NULL END)=Total Opponent Penalty Goals, | ||
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, | ||