(Remove day in week in the result table) |
(Join to player events (second clone) only when needed) תגית: שוחזרה |
||
| שורה 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 | ||
{{#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 | ||
גרסה מ־00:25, 17 במרץ 2025
ערכו את הדף כדי לצפות בטקסט התבנית.