אין תקציר עריכה |
(No own goals) |
||
| שורה 33: | שורה 33: | ||
SUM(CASE when Games_Events.EventType IN (1,5) then 1 else 0 end)=GamesPlayed, | SUM(CASE when Games_Events.EventType IN (1,5) then 1 else 0 end)=GamesPlayed, | ||
SUM(CASE when Games_Events.EventType=5 then 1 else 0 end)=Substitutions, | SUM(CASE when Games_Events.EventType=5 then 1 else 0 end)=Substitutions, | ||
SUM(CASE when Games_Events.EventType=3 then 1 else 0 end)=Goals, | SUM(CASE when Games_Events.EventType=3 AND Games_Events.SubType!=33 then 1 else 0 end)=Goals, | ||
SUM(CASE when Games_Events.SubType=35 then 1 else 0 end)=GoalsPenalties, | SUM(CASE when Games_Events.SubType=35 then 1 else 0 end)=GoalsPenalties, | ||
SUM(CASE when Games_Events.EventType=4 then 1 else 0 end)=Assists, | SUM(CASE when Games_Events.EventType=4 then 1 else 0 end)=Assists, | ||
| שורה 69: | שורה 69: | ||
SUM(CASE when Games_Events.EventType IN (1,5) then 1 else 0 end)=GamesPlayed, | SUM(CASE when Games_Events.EventType IN (1,5) then 1 else 0 end)=GamesPlayed, | ||
SUM(CASE when Games_Events.EventType=5 then 1 else 0 end)=Substitutions, | SUM(CASE when Games_Events.EventType=5 then 1 else 0 end)=Substitutions, | ||
SUM(CASE when Games_Events.EventType=3 then 1 else 0 end)=Goals, | SUM(CASE when Games_Events.EventType=3 AND Games_Events.SubType!=33 then 1 else 0 end)=Goals, | ||
SUM(CASE when Games_Events.SubType=35 then 1 else 0 end)=GoalsPenalties, | SUM(CASE when Games_Events.SubType=35 then 1 else 0 end)=GoalsPenalties, | ||
SUM(CASE when Games_Events.EventType=4 then 1 else 0 end)=Assists, | SUM(CASE when Games_Events.EventType=4 then 1 else 0 end)=Assists, | ||