(Count secondYellow as RedCard as well) |
(Count only played games) |
||
| שורה 30: | שורה 30: | ||
SUM(CASE when Games_Events.EventType IN (1,5) AND Football_Games.ResultOpt=3 then 1 else 0 end)=Losses, | SUM(CASE when Games_Events.EventType IN (1,5) AND Football_Games.ResultOpt=3 then 1 else 0 end)=Losses, | ||
{{#ifeq: {{{שוער|}}}| כן| | {{#ifeq: {{{שוער|}}}| כן| | ||
SUM(Football_Games.ResultOpponent)=GoalsAgainstMaccabi, | SUM(CASE when Games_Events.EventType IN (1,5) then Football_Games.ResultOpponent else 0)=GoalsAgainstMaccabi, | ||
SUM(CASE when Football_Games.ResultOpponent=0 then 1 else 0 end)=CleanSheet, | SUM(CASE when Games_Events.EventType IN (1,5) AND Football_Games.ResultOpponent=0 then 1 else 0 end)=CleanSheet, | ||
SUM(CASE when Games_Events.SubType=83 then 1 else 0 end)=PenaltySaves, | SUM(CASE when Games_Events.SubType=83 then 1 else 0 end)=PenaltySaves, | ||
}} | }} | ||