(Opponents_Catalog->Opponents (tables)) |
(Game_Events_Catalog->Games_Events) |
||
| שורה 13: | שורה 13: | ||
-->{{#vardefine: PlayerEvent|{{תבנית: המרות/תיאור אירוע למספר אירוע| אירוע={{{PlayerAction|}}} }} }}<!-- | -->{{#vardefine: PlayerEvent|{{תבנית: המרות/תיאור אירוע למספר אירוע| אירוע={{{PlayerAction|}}} }} }}<!-- | ||
-->{{#cargo_query: | -->{{#cargo_query: | ||
tables=Games_Catalog, Opponents, Competitions_Catalog, Stadiums_Catalog, Games_Results_Catalog, | tables=Games_Catalog, Opponents, Competitions_Catalog, Stadiums_Catalog, Games_Results_Catalog, Games_Events, Days_In_Week | ||
|join on=Games_Catalog.Opponent = Opponents._ID | |join on=Games_Catalog.Opponent = Opponents._ID | ||
,Games_Catalog.Competition = Competitions_Catalog.CompID | ,Games_Catalog.Competition = Competitions_Catalog.CompID | ||
,Games_Catalog.Stadium = Stadiums_Catalog.StadiumID | ,Games_Catalog.Stadium = Stadiums_Catalog.StadiumID | ||
,Games_Catalog.ResultOpt = Games_Results_Catalog.ResultType | ,Games_Catalog.ResultOpt = Games_Results_Catalog.ResultType | ||
,Games_Catalog. | ,Games_Catalog._pageID=Games_Events._pageID | ||
,Games_Catalog.MatchDay=Days_In_Week.DayNumber | ,Games_Catalog.MatchDay=Days_In_Week.DayNumber | ||
|where=1=1 | |where=1=1 | ||
And | 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 --> | ||
{{#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 --> | ||
| שורה 34: | שורה 34: | ||
{{#if: {{{OpponentGoals|}}} | AND Games_Catalog.ResultOpponent {{#var: GoalsForOpponentOperator}} {{{OpponentGoals}}} }} | {{#if: {{{OpponentGoals|}}} | AND Games_Catalog.ResultOpponent {{#var: GoalsForOpponentOperator}} {{{OpponentGoals}}} }} | ||
{{#if: {{{GameResult|}}} | AND Games_Results_Catalog.ResultString = "{{{GameResult}}}" }} | {{#if: {{{GameResult|}}} | AND Games_Results_Catalog.ResultString = "{{{GameResult}}}" }} | ||
{{#if: {{{Player|}}} | AND | {{#if: {{{Player|}}} | AND Games_Events.PlayerName= "{{{Player}}}" }} | ||
{{#if: {{{PlayerAction|}}} | AND | {{#if: {{{PlayerAction|}}} | AND Games_Events.EventType IN ({{#var: PlayerEvent}}) }} | ||
{{#if: {{{GameDayInWeek|}}} | AND Games_Catalog.MatchDay = {{{GameDayInWeek}}} }}<!-- | {{#if: {{{GameDayInWeek|}}} | AND Games_Catalog.MatchDay = {{{GameDayInWeek}}} }}<!-- | ||
גרסה מ־01:52, 11 בדצמבר 2018
ערכו את הדף כדי לצפות בטקסט התבנית.