אין תקציר עריכה |
אין תקציר עריכה |
||
| שורה 18: | שורה 18: | ||
We use the hacky way of concating all player related params in order to "turn on" the check for Team=1, | 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) | 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). | ||
-->check: {{{Player|}}}{{{PlayerAction|}}}{{{PlayerActionMinute|}}}{{{PlayerSubAction|}}}{{{PlayerSubActionMinute|}}}{{{Player2|}}}{{{PlayerAction2|}}}{{{PlayerActionMinute2|}}}{{{PlayerSubAction2|}}}{{{PlayerSubActionMinute2 | Without 'PlayersEventsInSameMinute', because that param will be 'False' as default (so it contains data). | ||
-->check: {{{Player|}}}{{{PlayerAction|}}}{{{PlayerActionMinute|}}}{{{PlayerSubAction|}}}{{{PlayerSubActionMinute|}}}{{{Player2|}}}{{{PlayerAction2|}}}{{{PlayerActionMinute2|}}}{{{PlayerSubAction2|}}}{{{PlayerSubActionMinute2|}}}{{#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 | ||
|join on=Games_Catalog.Competition = Competitions_Catalog.CompID | |join on=Games_Catalog.Competition = Competitions_Catalog.CompID | ||
| שורה 28: | שורה 29: | ||
,Games_Events._pageID = Events2._pageID | ,Games_Events._pageID = Events2._pageID | ||
|where=1=1 | |where=1=1 | ||
{{#if: {{{Player|}}}{{{PlayerAction|}}}{{{PlayerActionMinute|}}}{{{PlayerSubAction|}}}{{{PlayerSubActionMinute|}}}{{{Player2|}}}{{{PlayerAction2|}}}{{{PlayerActionMinute2|}}}{{{PlayerSubAction2|}}}{{{PlayerSubActionMinute2 | {{#if: {{{Player|}}}{{{PlayerAction|}}}{{{PlayerActionMinute|}}}{{{PlayerSubAction|}}}{{{PlayerSubActionMinute|}}}{{{Player2|}}}{{{PlayerAction2|}}}{{{PlayerActionMinute2|}}}{{{PlayerSubAction2|}}}{{{PlayerSubActionMinute2|}}}| 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:33, 28 באוגוסט 2020
ערכו את הדף כדי לצפות בטקסט התבנית.