(יצירת דף עם התוכן "<includeonly><!-- -->{{#cargo_query: tables=Football_Games, Games_Events, Games_Referees, Competitions |join on=Football_Games._pageID=Games_Events._pageID, Foo...") |
אין תקציר עריכה |
||
| (4 גרסאות ביניים של אותו משתמש אינן מוצגות) | |||
| שורה 8: | שורה 8: | ||
|where=1=1 | |where=1=1 | ||
AND Team=1 | AND Team=1 | ||
AND Games_Events.EventType IN (1, 3, 4, 5, 7) | AND Games_Events.EventType IN (1, 3, 4, 5, 7, 8) | ||
AND Games_Events.PlayerName="{{{שחקן}}}" | AND Games_Events.PlayerName="{{{שחקן}}}" | ||
| שורה 25: | שורה 25: | ||
SUM(CASE when Games_Events.SubType=44 then 1 else 0 end)=AssistByPenalty, | SUM(CASE when Games_Events.SubType=44 then 1 else 0 end)=AssistByPenalty, | ||
SUM(CASE when Games_Events.SubType=71 then 1 else 0 end)=YellowCards, | SUM(CASE when Games_Events.SubType=71 then 1 else 0 end)=YellowCards, | ||
SUM(CASE when Games_Events.SubType | SUM(CASE when Games_Events.SubType IN (72,73) then 1 else 0 end)=RedCards, | ||
SUM(CASE when Games_Events.EventType IN (1,5) AND Football_Games.ResultOpt=1 then 1 else 0 end)=Wins, | SUM(CASE when Games_Events.EventType IN (1,5) AND Football_Games.ResultOpt=1 then 1 else 0 end)=Wins, | ||
SUM(CASE when Games_Events.EventType IN (1,5) AND Football_Games.ResultOpt=2 then 1 else 0 end)=Ties, | SUM(CASE when Games_Events.EventType IN (1,5) AND Football_Games.ResultOpt=2 then 1 else 0 end)=Ties, | ||
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 end)=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, | |||
}} | }} | ||
|format=template | |format=template | ||
| | |template=פרופיל/סטטיסטיקות/שחקן/הצגת קטגוריית מפעל/הצגת נתונים | ||
|named args=yes | |named args=yes | ||