(Join to player events (second clone) only when needed) תגית: שוחזרה |
אין תקציר עריכה |
||
| (גרסת ביניים אחת של אותו משתמש אינה מוצגת) | |||
| שורה 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|}}} }} }}<!-- | ||
| שורה 24: | שורה 25: | ||
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 | ||
|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: | שורה 31: | ||
,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 | |||
,Football_Games._pageID = Football_Games_Uniforms._pageID | ,Football_Games._pageID = Football_Games_Uniforms._pageID | ||
,Football_Games.Opponent = Opponents.CanonicalName | ,Football_Games.Opponent = Opponents.CanonicalName | ||
| שורה 60: | שורה 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}}}" }} | ||
גרסה אחרונה מ־20:21, 4 ביולי 2025
ערכו את הדף כדי לצפות בטקסט התבנית.