תבנית:QueryGamesTemplate: הבדלים בין גרסאות בדף
מתוך מכביפדיה
אין תקציר עריכה
אין תקציר עריכה
שורה 32: שורה 32:
         ,Profiles.Position HOLDS Players_Positions.PositionType   
         ,Profiles.Position HOLDS Players_Positions.PositionType   
|where=1=1
|where=1=1
{{#if: {{{Player|}}}{{{PlayerNumber|}}}{{{PlayerAction|}}}{{{PlayerActionMinute|}}}{{{PlayerSubAction|}}}{{{PlayerSubActionMinute|}}}{{{PlayerPosition|}}}| And Games_Events.Team = 1}}
 
{{#if: {{{Player2|}}}{{{PlayerNumber2|}}}{{{PlayerAction2|}}}{{{PlayerActionMinute2|}}}{{{PlayerSubAction2|}}}{{{PlayerSubActionMinute2|}}}{{{PlayerPosition2|}}}| 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 -->
שורה 56: שורה 55:




 
{{#if: {{{Player|}}}{{{PlayerNumber|}}}{{{PlayerAction|}}}{{{PlayerActionMinute|}}}{{{PlayerSubAction|}}}{{{PlayerSubActionMinute|}}}{{{PlayerPosition|}}}| And Games_Events.Team = 1}}
{{#if: {{{Player|}}} |  AND Games_Events.PlayerName= "{{{Player}}}" }}
{{#if: {{{Player|}}} |  AND Games_Events.PlayerName = "{{{Player}}}" }}
{{#if: {{{PlayerNumber|}}} |  AND Games_Events.PlayerNumber= {{{PlayerNumber}}} }}
{{#if: {{{PlayerNumber|}}} |  AND Games_Events.PlayerNumber = {{{PlayerNumber}}} }}
{{#if: {{{PlayerAction|}}} | AND Games_Events.EventType IN ({{#var: PlayerEvent}}) }}
{{#if: {{{PlayerAction|}}} | AND Games_Events.EventType IN ({{#var: PlayerEvent}}) }}
{{#if: {{{PlayerActionMinute|}}} | AND Games_Events.Minute = {{{PlayerActionMinute}}} }}
{{#if: {{{PlayerActionMinute|}}} | AND Games_Events.Minute = {{{PlayerActionMinute}}} }}
שורה 64: שורה 63:
{{#if: {{{PlayerSubActionMinute|}}} | AND Games_Events.Minute = {{{PlayerSubActionMinute}}} }}
{{#if: {{{PlayerSubActionMinute|}}} | AND Games_Events.Minute = {{{PlayerSubActionMinute}}} }}
{{#if: {{{PlayerPosition|}}} | AND Players_Positions.PositionString= "{{{PlayerPosition}}}" }}
{{#if: {{{PlayerPosition|}}} | AND Players_Positions.PositionString= "{{{PlayerPosition}}}" }}
{{#if: {{{Player2|}}} |  AND Events2.PlayerName= "{{{Player2}}}" }}
 
{{#if: {{{PlayerNumber2|}}} |  AND Events2.PlayerNumber= {{{PlayerNumber2}}} }}
 
{{#if: {{{Player2|}}}{{{PlayerNumber2|}}}{{{PlayerAction2|}}}{{{PlayerActionMinute2|}}}{{{PlayerSubAction2|}}}{{{PlayerSubActionMinute2|}}}{{{PlayerPosition2|}}}| And Events2.Team = 1}}
{{#if: {{{Player2|}}} |  AND Events2.PlayerName = "{{{Player2}}}" }}
{{#if: {{{PlayerNumber2|}}} |  AND Events2.PlayerNumber = {{{PlayerNumber2}}} }}
{{#if: {{{PlayerAction2|}}} | AND Events2.EventType IN ({{#var: PlayerEvent2}}) }}
{{#if: {{{PlayerAction2|}}} | AND Events2.EventType IN ({{#var: PlayerEvent2}}) }}
{{#if: {{{PlayerActionMinute2|}}} | AND Events2.Minute = {{{PlayerActionMinute2}}} }}
{{#if: {{{PlayerActionMinute2|}}} | AND Events2.Minute = {{{PlayerActionMinute2}}} }}
{{#if: {{{PlayerSubAction2|}}} | AND Events2.SubType IN ({{#var: PlayerSubEvent2}}) }}
{{#if: {{{PlayerSubAction2|}}} | AND Events2.SubType IN ({{#var: PlayerSubEvent2}}) }}
{{#if: {{{PlayerSubActionMinute2|}}} | AND Events2.Minute = {{{PlayerSubActionMinute2}}} }}
{{#if: {{{PlayerSubActionMinute2|}}} | AND Events2.Minute = {{{PlayerSubActionMinute2}}} }}
{{#if: {{{PlayerPosition2|}}} | AND Players_Positions.PositionString= "{{{PlayerPosition2}}}" }}
{{#if: {{{PlayerPosition2|}}} | AND Players_Positions.PositionString = "{{{PlayerPosition2}}}" }}


{{#ifeq: {{{PlayersEventsInSameMinute|}}}| כן| AND Events2.Minute = Games_Events.Minute }}
{{#ifeq: {{{PlayersEventsInSameMinute|}}}| כן| AND Events2.Minute = Games_Events.Minute }}




שורה 112: שורה 113:
|group by=Games_Catalog._pageName, Games_Catalog.Date <!-- all fields from "fields=" should be here -->
|group by=Games_Catalog._pageName, Games_Catalog.Date <!-- all fields from "fields=" should be here -->
|order by=Games_Catalog.Date DESC
|order by=Games_Catalog.Date DESC
}}{{#if: {{{Player|}}}{{{PlayerNumber|}}}{{{PlayerAction|}}}{{{PlayerActionMinute|}}}{{{PlayerSubAction|}}}{{{PlayerSubActionMinute|}}}{{{PlayerPosition|}}}| And Games_Events.Team = 1}}<!--
}}<!--


Show games count:
Show games count:
{{סטטיסטיקה/שליפות/כמות רשומות| שליפה={{#var: games}} }} משחקים-->
{{סטטיסטיקה/שליפות/כמות רשומות| שליפה={{#var: games}} }} משחקים-->
</includeonly>
</includeonly>

גרסה מ־19:42, 4 במאי 2022

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

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