תבנית:QueryGamesTemplate: הבדלים בין גרסאות בדף
מתוך מכביפדיה
(Allow to search by player number)
(Check that the second player if from maccabi)
שורה 30: שורה 30:
         ,Games_Catalog._pageID = Football_Games_Uniforms._pageID
         ,Games_Catalog._pageID = Football_Games_Uniforms._pageID
|where=1=1
|where=1=1
{{#if: {{{Player|}}}{{{PlayerAction|}}}{{{PlayerActionMinute|}}}{{{PlayerSubAction|}}}{{{PlayerSubActionMinute|}}}{{{Player2|}}}{{{PlayerAction2|}}}{{{PlayerActionMinute2|}}}{{{PlayerSubAction2|}}}{{{PlayerSubActionMinute2|}}}| And Games_Events.Team = 1}}
{{#if: {{{Player|}}}{{{PlayerNumber|}}}{{{PlayerAction|}}}{{{PlayerActionMinute|}}}{{{PlayerSubAction|}}}{{{PlayerSubActionMinute|}}}| And Games_Events.Team = 1}}
{{#if: {{{Player2|}}}{{{PlayerNumber2|}}}{{{PlayerAction2|}}}{{{PlayerActionMinute2|}}}{{{PlayerSubAction2|}}}{{{PlayerSubActionMinute2|}}}| And Events2.Team = 1}}


{{#if: {{{Competition|}}} |  AND Games_Catalog.Competition IN ({{#var: SameCompetitions}}) }}<!-- the "()" around the SameCompetition required for "IN" operator -->
{{#if: {{{Competition|}}} |  AND Games_Catalog.Competition IN ({{#var: SameCompetitions}}) }}<!-- the "()" around the SameCompetition required for "IN" operator -->

גרסה מ־02:02, 16 באוקטובר 2020

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

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