אין תקציר עריכה |
אין תקציר עריכה |
||
| שורה 46: | שורה 46: | ||
|format=template | |format=template | ||
|template=פרופיל/מספרים עונתיים/שחקן/הצגת קטגוריית מפעל/שורה אחת | |template=פרופיל/מספרים עונתיים/שחקן/הצגת קטגוריית מפעל/שורה אחת | ||
|named args=yes | |||
}}<!-- | |||
Summary bolded line | |||
-->{{#cargo_query: | |||
tables=Football_Games, Games_Events, Games_Referees, Competitions | |||
|join on=Football_Games._pageID=Games_Events._pageID, | |||
Football_Games._pageID=Games_Referees._pageID, | |||
Football_Games.Competition=Competitions.OriginalName | |||
|where=1=1 | |||
AND Team=1 | |||
AND Games_Events.EventType IN (1, 3, 4, 5, 7) | |||
AND Games_Events.PlayerName="{{{שחקן}}}" | |||
{{#ifeq: {{{קטגוריית מפעל|}}}| ליגה| AND Competitions.League = 1 }} | |||
{{#ifeq: {{{קטגוריית מפעל|}}}| גביע| AND Competitions.Trophy = 1 }} | |||
{{#ifeq: {{{קטגוריית מפעל|}}}| בינלאומי| AND Competitions.International = 1 }} | |||
{{#ifeq: {{{קטגוריית מפעל|}}}| רשמי| AND Competitions.Official = 1 }} | |||
|fields= | |||
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=3 then 1 else 0 end)=Goals, | |||
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=7 then 1 else 0 end)=AllCards, | |||
SUM(CASE when Games_Events.SubType=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=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, | |||
|format=template | |||
|template=פרופיל/מספרים עונתיים/שחקן/הצגת קטגוריית מפעל/שורת סיכום | |||
|named args=yes | |named args=yes | ||
}} | }} | ||
</div> | </div> | ||
--></includeonly> | --></includeonly> | ||