(Make sure we check for maccabi players stats (but only if needed, We may want to query a game without any players)) |
אין תקציר עריכה |
||
| שורה 15: | שורה 15: | ||
-->{{#vardefine: PlayerEvent2|{{המרות/תיאור אירוע לשליפת משחקים למספר אירוע| אירוע={{{PlayerAction2|}}} }} }}<!-- | -->{{#vardefine: PlayerEvent2|{{המרות/תיאור אירוע לשליפת משחקים למספר אירוע| אירוע={{{PlayerAction2|}}} }} }}<!-- | ||
-->{{#vardefine: PlayerSubEvent2|{{תבנית: המרות/תיאור תת אירוע למספר תת אירוע| תת אירוע={{{PlayerSubAction2|}}} }} }}<!-- | -->{{#vardefine: PlayerSubEvent2|{{תבנית: המרות/תיאור תת אירוע למספר תת אירוע| תת אירוע={{{PlayerSubAction2|}}} }} }}<!-- | ||
We use the hacky way of concating all player related params in order to "turn on" the check for Team=1, | |||
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 | tables=Games_Catalog, Competitions_Catalog, Games_Results, Games_Events, Games_Events=Events2, Days_In_Week, Games_Videos | ||
| שורה 24: | שורה 28: | ||
,Games_Events._pageID = Events2._pageID | ,Games_Events._pageID = Events2._pageID | ||
|where=1=1 | |where=1=1 | ||
{{#if: {{{Player|}}} And Games_Events.Team = 1}} | {{#if: {{{Player|}}}{{{PlayerAction|}}}{{{PlayerActionMinute|}}}{{{PlayerSubAction|}}}{{{PlayerSubActionMinute|}}}{{{Player2|}}}{{{PlayerAction2|}}}{{{PlayerActionMinute2|}}}{{{PlayerSubAction2|}}}{{{PlayerSubActionMinute2|}}}{{{PlayersEventsInSameMinute|}}}| And Games_Events.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:31, 28 באוגוסט 2020
ערכו את הדף כדי לצפות בטקסט התבנית.