אין תקציר עריכה |
אין תקציר עריכה |
||
| שורה 20: | שורה 20: | ||
There are some games without any maccabi players, we dont want to avoid querying them if we can avoid it (means we search for the game data and not players data). | There are some games without any maccabi players, we dont want to avoid querying them if we can avoid it (means we search for the game data and not players data). | ||
-->{{#cargo_query: | -->{{#cargo_query: | ||
tables=Games_Catalog, Competitions_Catalog, Games_Results, Games_Events, Games_Events=Events2, Days_In_Week, Games_Videos, Football_Games_Uniforms | tables=Games_Catalog, Competitions_Catalog, Games_Results, Games_Events, Games_Events=Events2, Days_In_Week, Games_Videos, Football_Games_Uniforms, Opponents | ||
|join on=Games_Catalog.Competition = Competitions_Catalog.CompID | |join on=Games_Catalog.Competition = Competitions_Catalog.CompID | ||
,Games_Catalog.ResultOpt = Games_Results.ResultType | ,Games_Catalog.ResultOpt = Games_Results.ResultType | ||
| שורה 27: | שורה 27: | ||
,Games_Catalog._pageID = Games_Videos._pageID | ,Games_Catalog._pageID = Games_Videos._pageID | ||
,Games_Events._pageID = Events2._pageID | ,Games_Events._pageID = Events2._pageID | ||
,Games_Catalog._pageID = Football_Games_Uniforms._pageID | ,Games_Catalog._pageID = Football_Games_Uniforms._pageID, | ||
,Games_Catalog.Opponent = Opponents.OriginalName | |||
|where=1=1 | |where=1=1 | ||
{{#if: {{{Player|}}}{{{PlayerNumber|}}}{{{PlayerAction|}}}{{{PlayerActionMinute|}}}{{{PlayerSubAction|}}}{{{PlayerSubActionMinute|}}}| And Games_Events.Team = 1}} | {{#if: {{{Player|}}}{{{PlayerNumber|}}}{{{PlayerAction|}}}{{{PlayerActionMinute|}}}{{{PlayerSubAction|}}}{{{PlayerSubActionMinute|}}}| And Games_Events.Team = 1}} | ||
| שורה 35: | שורה 36: | ||
{{#if: {{{Stadium|}}} | AND Games_Catalog.Stadium IN ({{#var: SameStadiums}}) }}<!-- the "()" around the SameStadiums required for "IN" operator --> | {{#if: {{{Stadium|}}} | AND Games_Catalog.Stadium IN ({{#var: SameStadiums}}) }}<!-- the "()" around the SameStadiums required for "IN" operator --> | ||
{{#if: {{{Opponent|}}} | AND Games_Catalog.Opponent IN ({{#var: SameOpponents}}) }}<!-- the "()" around the SameOpponents required for "IN" operator --> | {{#if: {{{Opponent|}}} | AND Games_Catalog.Opponent IN ({{#var: SameOpponents}}) }}<!-- the "()" around the SameOpponents required for "IN" operator --> | ||
{{#if: {{{OpponentCountry|}}} | AND | {{#if: {{{OpponentCountry|}}} | AND Opponents.Country="{{{OpponentCountry}}}" }} | ||
{{#if: {{{Coach|}}} | AND Games_Catalog.CoachMaccabi="{{{Coach}}}" }} | {{#if: {{{Coach|}}} | AND Games_Catalog.CoachMaccabi="{{{Coach}}}" }} | ||
{{#if: {{{CoachOpponent|}}} | AND Games_Catalog.CoachOpponent="{{{CoachOpponent}}}" }} | {{#if: {{{CoachOpponent|}}} | AND Games_Catalog.CoachOpponent="{{{CoachOpponent}}}" }} | ||
גרסה מ־03:51, 14 במרץ 2022
ערכו את הדף כדי לצפות בטקסט התבנית.