תבנית:QueryGamesTemplate: הבדלים בין גרסאות בדף
מתוך מכביפדיה
אין תקציר עריכה
אין תקציר עריכה
שורה 25: שורה 25:
-->{{#cargo_query:
-->{{#cargo_query:
tables=Games_Catalog, Competitions, Games_Results, Games_Events, Games_Events=Events2, Days_In_Week, Games_Videos, Football_Games_Uniforms, Opponents, Profiles, Profiles__Position, Players_Positions
tables=Games_Catalog, Competitions, Games_Results, Games_Events, Games_Events=Events2, Days_In_Week, Games_Videos, Football_Games_Uniforms, Opponents, Profiles, Profiles__Position, Players_Positions
|join on=Games_Catalog.Competition = Competitions.CurrentName
|join on=Games_Catalog.Competition = Competitions.OriginalName
         ,Games_Catalog.ResultOpt = Games_Results.ResultType
         ,Games_Catalog.ResultOpt = Games_Results.ResultType
         ,Games_Catalog._pageID = Games_Events._pageID
         ,Games_Catalog._pageID = Games_Events._pageID
שורה 40: שורה 40:


{{#if: {{{SpecificCompetition|}}} |  AND Competitions.OriginalName = "{{{SpecificCompetition}}}" }}
{{#if: {{{SpecificCompetition|}}} |  AND Competitions.OriginalName = "{{{SpecificCompetition}}}" }}
{{#ifeq: {{{CompetitionCategory|}}} | ליגה| AND League=1 }}
{{#ifeq: {{{CompetitionCategory|}}} | ליגה| AND Competitions.League=1 }}
{{#ifeq: {{{CompetitionCategory|}}} | גביע| AND Trophy=1 }}
{{#ifeq: {{{CompetitionCategory|}}} | גביע| AND Competitions.Trophy=1 }}
{{#ifeq: {{{CompetitionCategory|}}} | בינלאומי| AND International=1 }}
{{#ifeq: {{{CompetitionCategory|}}} | בינלאומי| AND Competitions.International=1 }}
{{#ifeq: {{{CompetitionCategory|}}} | רשמי| AND Official=1 }}
{{#ifeq: {{{CompetitionCategory|}}} | רשמי| AND Competitions.Official=1 }}
{{#ifeq: {{{CompetitionCategory|}}} | לא רשמי| AND Official=0 }}
{{#ifeq: {{{CompetitionCategory|}}} | לא רשמי| AND Competitions.Official=0 }}


{{#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 -->

גרסה מ־22:43, 1 בספטמבר 2022

לינק לעמוד לחיפוש משחקים

ערכו את הדף כדי לצפות בטקסט התבנית.