תבנית:פרופיל/סטטיסטיקות/שחקן/הצגת קטגוריית מפעל - היסטוריית גרסאות

Kosh ב־21:51, 3 בספטמבר 2023

2023-09-03T21:51:53Z

→ הגרסה הקודמת		גרסה מ־00:51, 4 בספטמבר 2023
שורה 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(CASE when Games_Events.EventType IN (1,5) then Football_Games.ResultOpponent else 0)=GoalsAgainstMaccabi,		SUM(CASE when Games_Events.EventType IN (1,5) then Football_Games.ResultOpponent else 0 end)=GoalsAgainstMaccabi,
	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.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,

Kosh: Count only played games

2023-09-03T21:51:19Z

Count only played games

→ הגרסה הקודמת		גרסה מ־00:51, 4 בספטמבר 2023
שורה 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,
	}}		}}

Kosh: Count secondYellow as RedCard as well

2023-01-14T18:41:10Z

Count secondYellow as RedCard as well

→ הגרסה הקודמת		גרסה מ־21:41, 14 בינואר 2023
שורה 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=73 then 1 else 0 end)=RedCards,		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,

Kosh ב־23:49, 14 בספטמבר 2022

2022-09-14T23:49:18Z

→ הגרסה הקודמת		גרסה מ־02:49, 15 בספטמבר 2022
שורה 36:		שורה 36:

	\|format=template		\|format=template
	\|~~templateפרופיל~~/סטטיסטיקות/שחקן/הצגת קטגוריית מפעל/הצגת נתונים		\|template=פרופיל/סטטיסטיקות/שחקן/הצגת קטגוריית מפעל/הצגת נתונים

	\|named args=yes		\|named args=yes

Kosh ב־23:46, 14 בספטמבר 2022

2022-09-14T23:46:37Z

→ הגרסה הקודמת		גרסה מ־02:46, 15 בספטמבר 2022
שורה 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="{{{שחקן}}}"

שורה 32:		שורה 32:
	SUM(Football_Games.ResultOpponent)=GoalsAgainstMaccabi,		SUM(Football_Games.ResultOpponent)=GoalsAgainstMaccabi,
	SUM(CASE when Football_Games.ResultOpponent=0 then 1 else 0 end)=CleanSheet,		SUM(CASE when Football_Games.ResultOpponent=0 then 1 else 0 end)=CleanSheet,
			SUM(CASE when Games_Events.SubType=83 then 1 else 0 end)=PenaltySaves,
	}}		}}

Kosh: יצירת דף עם התוכן "{{#cargo_query: tables=Football_Games, Games_Events, Games_Referees, Competitions |join on=Football_Games._pageID=Games_Events._pageID, Foo..."

2022-09-14T23:42:08Z

יצירת דף עם התוכן "<includeonly>{{#cargo_query: tables=Football_Games, Games_Events, Games_Referees, Competitions |join on=Football_Games._pageID=Games_Events._pageID, Foo..."

דף חדש

<includeonly>{{#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=
Football_Games.Season=Season,
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 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.EventType=4 then 1 else 0 end)=Assists,
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=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,
{{#ifeq: {{{שוער|}}}| כן|
SUM(Football_Games.ResultOpponent)=GoalsAgainstMaccabi,
SUM(CASE when Football_Games.ResultOpponent=0 then 1 else 0 end)=CleanSheet,
}}

|format=template
|templateפרופיל/סטטיסטיקות/שחקן/הצגת קטגוריית מפעל/הצגת נתונים

|named args=yes
}}</includeonly>