תבנית:QueryGamesTemplate - היסטוריית גרסאות

Kosh ב־23:40, 30 בנובמבר 2025

2025-11-30T23:40:36Z

→ הגרסה הקודמת		גרסה מ־02:40, 1 בדצמבר 2025
שורה 33:		שורה 33:
	,Games_Events._pageID = Events2._pageID		,Games_Events._pageID = Events2._pageID
	,Football_Games._pageID = Football_Games_Uniforms._pageID		,Football_Games._pageID = Football_Games_Uniforms._pageID
	,Football_Games.Opponent = Opponents.~~CanonicalName~~		,Football_Games.Opponent = Opponents.OriginalName
	,Games_Events.PlayerName = Profiles._pageName		,Games_Events.PlayerName = Profiles._pageName
	,Profiles._ID=Profiles__Position._rowID		,Profiles._ID=Profiles__Position._rowID

Kosh ב־18:21, 4 ביולי 2025

2025-07-04T18:21:09Z

→ הגרסה הקודמת		גרסה מ־21:21, 4 ביולי 2025
שורה 10:		שורה 10:
	-->{{#vardefine: GoalsForOpponentOperator\| {{#בחר:{{{OpponentGoalsAction\|}}}\|מתחת ל=<\|בדיוק==\|מעל ל=> }} }}<!--		-->{{#vardefine: GoalsForOpponentOperator\| {{#בחר:{{{OpponentGoalsAction\|}}}\|מתחת ל=<\|בדיוק==\|מעל ל=> }} }}<!--
	-->{{#vardefine: GoalsDiffForMaccabiOperator\| {{#בחר:{{{MaccabiGoalsDifferentAction\|}}}\|מתחת ל=<\|בדיוק==\|מעל ל=> }} }}<!--		-->{{#vardefine: GoalsDiffForMaccabiOperator\| {{#בחר:{{{MaccabiGoalsDifferentAction\|}}}\|מתחת ל=<\|בדיוק==\|מעל ל=> }} }}<!--
			-->{{#vardefine: GoalsDiffForOpponentOperator\| {{#בחר:{{{OpponentGoalsDifferentAction\|}}}\|מתחת ל=<\|בדיוק==\|מעל ל=> }} }}<!--
	-->{{#vardefine: PlayerEvent\|{{המרות/תיאור אירוע לשליפת משחקים למספר אירוע\| אירוע={{{PlayerAction\|}}} }} }}<!--		-->{{#vardefine: PlayerEvent\|{{המרות/תיאור אירוע לשליפת משחקים למספר אירוע\| אירוע={{{PlayerAction\|}}} }} }}<!--
	-->{{#vardefine: PlayerSubEvent\|{{תבנית: המרות/תיאור תת אירוע למספר תת אירוע\| תת אירוע={{{PlayerSubAction\|}}} }} }}<!--		-->{{#vardefine: PlayerSubEvent\|{{תבנית: המרות/תיאור תת אירוע למספר תת אירוע\| תת אירוע={{{PlayerSubAction\|}}} }} }}<!--
שורה 58:		שורה 59:
	{{#if: {{{MaccabiGoalsDifferent\|}}} \| AND Football_Games.ResultMaccabi - Football_Games.ResultOpponent {{#var: GoalsDiffForMaccabiOperator}} {{{MaccabiGoalsDifferent}}} }}		{{#if: {{{MaccabiGoalsDifferent\|}}} \| AND Football_Games.ResultMaccabi - Football_Games.ResultOpponent {{#var: GoalsDiffForMaccabiOperator}} {{{MaccabiGoalsDifferent}}} }}
	{{#if: {{{OpponentGoals\|}}} \| AND Football_Games.ResultOpponent {{#var: GoalsForOpponentOperator}} {{{OpponentGoals}}} }}		{{#if: {{{OpponentGoals\|}}} \| AND Football_Games.ResultOpponent {{#var: GoalsForOpponentOperator}} {{{OpponentGoals}}} }}
			{{#if: {{{OpponentGoalsDifferent\|}}} \| AND Football_Games.ResultOpponent - Football_Games.ResultMaccabi {{#var: GoalsDiffForOpponentOperator}} {{{OpponentGoalsDifferent}}} }}
	{{#if: {{{GameResult\|}}} \| AND Games_Results.ResultString = "{{{GameResult}}}" }}		{{#if: {{{GameResult\|}}} \| AND Games_Results.ResultString = "{{{GameResult}}}" }}
	{{#if: {{{Uniforms\|}}} \| AND Football_Games_Uniforms.KitName = "{{{Uniforms}}}" }}		{{#if: {{{Uniforms\|}}} \| AND Football_Games_Uniforms.KitName = "{{{Uniforms}}}" }}

Kosh: ביטול גרסה 164456 של Kosh (שיחה)

2025-03-16T21:27:02Z

ביטול גרסה 164456 של Kosh (שיחה)

Kosh: Join to player events (second clone) only when needed

2025-03-16T21:25:39Z

Join to player events (second clone) only when needed

Kosh: Remove day in week in the result table

2025-03-11T08:14:44Z

Remove day in week in the result table

→ הגרסה הקודמת		גרסה מ־11:14, 11 במרץ 2025
שורה 112:		שורה 112:
	,CONCAT('[[כדורגל:', Football_Games.Refs, ' (שופט)\|', Football_Games.Refs, ']]')=שופט		,CONCAT('[[כדורגל:', Football_Games.Refs, ' (שופט)\|', Football_Games.Refs, ']]')=שופט
	,Crowd=קהל		,Crowd=קהל
	~~,Days_In_Week.DayString=יום המשחק בשבוע~~
	,CONCAT('[', Games_Videos.FullGame, ' לינק]')=משחק מלא		,CONCAT('[', Games_Videos.FullGame, ' לינק]')=משחק מלא
	,CONCAT('[', Games_Videos.Highlights, ' לינק]')=תקציר		,CONCAT('[', Games_Videos.Highlights, ' לינק]')=תקציר

Kosh: Use new referee page format

2024-09-28T21:08:07Z

Use new referee page format

→ הגרסה הקודמת		גרסה מ־00:08, 29 בספטמבר 2024
שורה 110:		שורה 110:
	,CONCAT('[[', Football_Games.CoachMaccabi, ']]')=מאמן מכבי		,CONCAT('[[', Football_Games.CoachMaccabi, ']]')=מאמן מכבי
	,Football_Games.CoachOpponent=מאמן יריבה		,Football_Games.CoachOpponent=מאמן יריבה
	,CONCAT('[[כדורגל:', Football_Games.Refs, '(שופט)\|', Football_Games.Refs, ']]')=שופט		,CONCAT('[[כדורגל:', Football_Games.Refs, ' (שופט)\|', Football_Games.Refs, ']]')=שופט
	,Crowd=קהל		,Crowd=קהל
	,Days_In_Week.DayString=יום המשחק בשבוע		,Days_In_Week.DayString=יום המשחק בשבוע

Kosh: Use new referee page format

2024-09-28T21:07:18Z

Use new referee page format

→ הגרסה הקודמת		גרסה מ־00:07, 29 בספטמבר 2024
שורה 110:		שורה 110:
	,CONCAT('[[', Football_Games.CoachMaccabi, ']]')=מאמן מכבי		,CONCAT('[[', Football_Games.CoachMaccabi, ']]')=מאמן מכבי
	,Football_Games.CoachOpponent=מאמן יריבה		,Football_Games.CoachOpponent=מאמן יריבה
	,CONCAT('[[~~שופט~~:', Football_Games.Refs, '\|', Football_Games.Refs, ']]')=שופט		,CONCAT('[[כדורגל:', Football_Games.Refs, '(שופט)\|', Football_Games.Refs, ']]')=שופט
	,Crowd=קהל		,Crowd=קהל
	,Days_In_Week.DayString=יום המשחק בשבוע		,Days_In_Week.DayString=יום המשחק בשבוע

Kosh ב־11:04, 2 בספטמבר 2023

2023-09-02T11:04:05Z

→ הגרסה הקודמת		גרסה מ־14:04, 2 בספטמבר 2023
שורה 116:		שורה 116:
	,CONCAT('[', Games_Videos.Highlights, ' לינק]')=תקציר		,CONCAT('[', Games_Videos.Highlights, ' לינק]')=תקציר
	,CONCAT('[[', 'מדי עונת ', Football_Games_Uniforms.Season, '\|', Football_Games_Uniforms.KitName, ']]' )=מדים		,CONCAT('[[', 'מדי עונת ', Football_Games_Uniforms.Season, '\|', Football_Games_Uniforms.KitName, ']]' )=מדים
	Opponents.Country=מדינה		,Opponents.Country=מדינה
	{{#if: {{#var: Player1Defined}} \| ,Games_Events.PlayerName=1שחקן, Games_Events.PlayerNumber=1מספר, Games_Events.Minute=דקה1 }}		{{#if: {{#var: Player1Defined}} \| ,Games_Events.PlayerName=1שחקן, Games_Events.PlayerNumber=1מספר, Games_Events.Minute=דקה1 }}
	{{#if: {{#var: Player2Defined}} \| ,Events2.PlayerName=2שחקן, Events2.PlayerNumber=2מספר, Events2.Minute=דקה2 }}		{{#if: {{#var: Player2Defined}} \| ,Events2.PlayerName=2שחקן, Events2.PlayerNumber=2מספר, Events2.Minute=דקה2 }}

Kosh ב־11:03, 2 בספטמבר 2023

2023-09-02T11:03:39Z

→ הגרסה הקודמת		גרסה מ־14:03, 2 בספטמבר 2023
שורה 116:		שורה 116:
	,CONCAT('[', Games_Videos.Highlights, ' לינק]')=תקציר		,CONCAT('[', Games_Videos.Highlights, ' לינק]')=תקציר
	,CONCAT('[[', 'מדי עונת ', Football_Games_Uniforms.Season, '\|', Football_Games_Uniforms.KitName, ']]' )=מדים		,CONCAT('[[', 'מדי עונת ', Football_Games_Uniforms.Season, '\|', Football_Games_Uniforms.KitName, ']]' )=מדים
	~~,CONCAT('[[',~~ Opponents.Country~~, ']]')~~=מדינה		Opponents.Country=מדינה
	{{#if: {{#var: Player1Defined}} \| ,Games_Events.PlayerName=1שחקן, Games_Events.PlayerNumber=1מספר, Games_Events.Minute=דקה1 }}		{{#if: {{#var: Player1Defined}} \| ,Games_Events.PlayerName=1שחקן, Games_Events.PlayerNumber=1מספר, Games_Events.Minute=דקה1 }}
	{{#if: {{#var: Player2Defined}} \| ,Events2.PlayerName=2שחקן, Events2.PlayerNumber=2מספר, Events2.Minute=דקה2 }}		{{#if: {{#var: Player2Defined}} \| ,Events2.PlayerName=2שחקן, Events2.PlayerNumber=2מספר, Events2.Minute=דקה2 }}

Kosh: Add team country for games seach

2023-09-02T11:02:15Z

Add team country for games seach

→ הגרסה הקודמת		גרסה מ־14:02, 2 בספטמבר 2023
שורה 116:		שורה 116:
	,CONCAT('[', Games_Videos.Highlights, ' לינק]')=תקציר		,CONCAT('[', Games_Videos.Highlights, ' לינק]')=תקציר
	,CONCAT('[[', 'מדי עונת ', Football_Games_Uniforms.Season, '\|', Football_Games_Uniforms.KitName, ']]' )=מדים		,CONCAT('[[', 'מדי עונת ', Football_Games_Uniforms.Season, '\|', Football_Games_Uniforms.KitName, ']]' )=מדים
			,CONCAT('[[', Opponents.Country, ']]')=מדינה
	{{#if: {{#var: Player1Defined}} \| ,Games_Events.PlayerName=1שחקן, Games_Events.PlayerNumber=1מספר, Games_Events.Minute=דקה1 }}		{{#if: {{#var: Player1Defined}} \| ,Games_Events.PlayerName=1שחקן, Games_Events.PlayerNumber=1מספר, Games_Events.Minute=דקה1 }}
	{{#if: {{#var: Player2Defined}} \| ,Events2.PlayerName=2שחקן, Events2.PlayerNumber=2מספר, Events2.Minute=דקה2 }}		{{#if: {{#var: Player2Defined}} \| ,Events2.PlayerName=2שחקן, Events2.PlayerNumber=2מספר, Events2.Minute=דקה2 }}

→ הגרסה הקודמת		גרסה מ־21:21, 4 ביולי 2025
שורה 10:		שורה 10:
	-->{{#vardefine: GoalsForOpponentOperator\| {{#בחר:{{{OpponentGoalsAction\|}}}\|מתחת ל=<\|בדיוק==\|מעל ל=> }} }}<!--		-->{{#vardefine: GoalsForOpponentOperator\| {{#בחר:{{{OpponentGoalsAction\|}}}\|מתחת ל=<\|בדיוק==\|מעל ל=> }} }}<!--
	-->{{#vardefine: GoalsDiffForMaccabiOperator\| {{#בחר:{{{MaccabiGoalsDifferentAction\|}}}\|מתחת ל=<\|בדיוק==\|מעל ל=> }} }}<!--		-->{{#vardefine: GoalsDiffForMaccabiOperator\| {{#בחר:{{{MaccabiGoalsDifferentAction\|}}}\|מתחת ל=<\|בדיוק==\|מעל ל=> }} }}<!--
			-->{{#vardefine: GoalsDiffForOpponentOperator\| {{#בחר:{{{OpponentGoalsDifferentAction\|}}}\|מתחת ל=<\|בדיוק==\|מעל ל=> }} }}<!--
	-->{{#vardefine: PlayerEvent\|{{המרות/תיאור אירוע לשליפת משחקים למספר אירוע\| אירוע={{{PlayerAction\|}}} }} }}<!--		-->{{#vardefine: PlayerEvent\|{{המרות/תיאור אירוע לשליפת משחקים למספר אירוע\| אירוע={{{PlayerAction\|}}} }} }}<!--
	-->{{#vardefine: PlayerSubEvent\|{{תבנית: המרות/תיאור תת אירוע למספר תת אירוע\| תת אירוע={{{PlayerSubAction\|}}} }} }}<!--		-->{{#vardefine: PlayerSubEvent\|{{תבנית: המרות/תיאור תת אירוע למספר תת אירוע\| תת אירוע={{{PlayerSubAction\|}}} }} }}<!--
שורה 58:		שורה 59:
	{{#if: {{{MaccabiGoalsDifferent\|}}} \| AND Football_Games.ResultMaccabi - Football_Games.ResultOpponent {{#var: GoalsDiffForMaccabiOperator}} {{{MaccabiGoalsDifferent}}} }}		{{#if: {{{MaccabiGoalsDifferent\|}}} \| AND Football_Games.ResultMaccabi - Football_Games.ResultOpponent {{#var: GoalsDiffForMaccabiOperator}} {{{MaccabiGoalsDifferent}}} }}
	{{#if: {{{OpponentGoals\|}}} \| AND Football_Games.ResultOpponent {{#var: GoalsForOpponentOperator}} {{{OpponentGoals}}} }}		{{#if: {{{OpponentGoals\|}}} \| AND Football_Games.ResultOpponent {{#var: GoalsForOpponentOperator}} {{{OpponentGoals}}} }}
			{{#if: {{{OpponentGoalsDifferent\|}}} \| AND Football_Games.ResultOpponent - Football_Games.ResultMaccabi {{#var: GoalsDiffForOpponentOperator}} {{{OpponentGoalsDifferent}}} }}
	{{#if: {{{GameResult\|}}} \| AND Games_Results.ResultString = "{{{GameResult}}}" }}		{{#if: {{{GameResult\|}}} \| AND Games_Results.ResultString = "{{{GameResult}}}" }}
	{{#if: {{{Uniforms\|}}} \| AND Football_Games_Uniforms.KitName = "{{{Uniforms}}}" }}		{{#if: {{{Uniforms\|}}} \| AND Football_Games_Uniforms.KitName = "{{{Uniforms}}}" }}

→ הגרסה הקודמת		גרסה מ־00:27, 17 במרץ 2025
שורה 24:		שורה 24:
	Moreover, It seems that writing "Profiles.Position HOLDS Players_Positions.PositionType" on the join clause is doing right join and therefore disable the ability to query games without players, so we have to follow the plain SQL way to do it: https://www.mediawiki.org/wiki/Extension:Cargo/Querying_data#The_"HOLDS"_command		Moreover, It seems that writing "Profiles.Position HOLDS Players_Positions.PositionType" on the join clause is doing right join and therefore disable the ability to query games without players, so we have to follow the plain SQL way to do it: https://www.mediawiki.org/wiki/Extension:Cargo/Querying_data#The_"HOLDS"_command
	-->{{#cargo_query:		-->{{#cargo_query:
	tables=Football_Games, Competitions, Games_Results, Games_Events,		tables=Football_Games, Competitions, Games_Results, Games_Events, Games_Events=Events2, Days_In_Week, Games_Videos, Football_Games_Uniforms, Opponents, Profiles, Profiles__Position, Players_Positions
	~~{{#if: {{#var: Player2Defined}}\|~~ Games_Events=Events2,}}
	Days_In_Week, Games_Videos, Football_Games_Uniforms, Opponents, Profiles, Profiles__Position, Players_Positions
	\|join on=Football_Games.Competition = Competitions.OriginalName		\|join on=Football_Games.Competition = Competitions.OriginalName
	,Football_Games.ResultOpt = Games_Results.ResultType		,Football_Games.ResultOpt = Games_Results.ResultType
שורה 32:		שורה 30:
	,Football_Games.MatchDay = Days_In_Week.DayNumber		,Football_Games.MatchDay = Days_In_Week.DayNumber
	,Football_Games._pageID = Games_Videos._pageID		,Football_Games._pageID = Games_Videos._pageID
	~~{{#if: {{#var: Player2Defined}}\|~~ ,Games_Events._pageID = Events2._pageID }}		,Games_Events._pageID = Events2._pageID
	,Football_Games._pageID = Football_Games_Uniforms._pageID		,Football_Games._pageID = Football_Games_Uniforms._pageID
	,Football_Games.Opponent = Opponents.CanonicalName		,Football_Games.Opponent = Opponents.CanonicalName

→ הגרסה הקודמת		גרסה מ־00:25, 17 במרץ 2025
שורה 24:		שורה 24:
	Moreover, It seems that writing "Profiles.Position HOLDS Players_Positions.PositionType" on the join clause is doing right join and therefore disable the ability to query games without players, so we have to follow the plain SQL way to do it: https://www.mediawiki.org/wiki/Extension:Cargo/Querying_data#The_"HOLDS"_command		Moreover, It seems that writing "Profiles.Position HOLDS Players_Positions.PositionType" on the join clause is doing right join and therefore disable the ability to query games without players, so we have to follow the plain SQL way to do it: https://www.mediawiki.org/wiki/Extension:Cargo/Querying_data#The_"HOLDS"_command
	-->{{#cargo_query:		-->{{#cargo_query:
	tables=Football_Games, Competitions, Games_Results, Games_Events, Games_Events=Events2, Days_In_Week, Games_Videos, Football_Games_Uniforms, Opponents, Profiles, Profiles__Position, Players_Positions		tables=Football_Games, Competitions, Games_Results, Games_Events,
			{{#if: {{#var: Player2Defined}}\| Games_Events=Events2,}}
			Days_In_Week, Games_Videos, Football_Games_Uniforms, Opponents, Profiles, Profiles__Position, Players_Positions
	\|join on=Football_Games.Competition = Competitions.OriginalName		\|join on=Football_Games.Competition = Competitions.OriginalName
	,Football_Games.ResultOpt = Games_Results.ResultType		,Football_Games.ResultOpt = Games_Results.ResultType
שורה 30:		שורה 32:
	,Football_Games.MatchDay = Days_In_Week.DayNumber		,Football_Games.MatchDay = Days_In_Week.DayNumber
	,Football_Games._pageID = Games_Videos._pageID		,Football_Games._pageID = Games_Videos._pageID
	,Games_Events._pageID = Events2._pageID		{{#if: {{#var: Player2Defined}}\| ,Games_Events._pageID = Events2._pageID }}
	,Football_Games._pageID = Football_Games_Uniforms._pageID		,Football_Games._pageID = Football_Games_Uniforms._pageID
	,Football_Games.Opponent = Opponents.CanonicalName		,Football_Games.Opponent = Opponents.CanonicalName