אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה |
אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה |
||
| שורה 13: | שורה 13: | ||
--><div class="table-content"> | --><div class="table-content"> | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Football_Games=fg,Games_Referees=gr | tables=Football_Games=fg,Games_Referees=gr, Football_Games_Metadata=fgm | ||
|join on=fg._pageID = gr._pageID | |join on=fg._pageName=fgm._pageName, fg._pageID = gr._pageID | ||
|where=gr.AssistantReferees HOLDS "{{{שם להצגה|}}}" AND fg.ResultOpt=1 | |where=1=1 AND gr.AssistantReferees HOLDS "{{{שם להצגה|}}}" AND fg.ResultOpt=1 | ||
|fields=fg._pageName=PageName, fg.Season=Season, fg.Competition=Competition, fg.Leg=Leg, fg.ResultOpt=ResultOpt, fg.ResultMaccabi=ResultMaccabi, fg.ResultOpponent=ResultOpponent, fg.Penalties=Penalties, fg.Technical=Technical | |fields=fg._pageName=PageName, fg.Season=Season, fg.Competition=Competition, fg.Leg=Leg, fg.ResultOpt=ResultOpt, fg.ResultMaccabi=ResultMaccabi, fg.ResultOpponent=ResultOpponent, fg.Penalties=Penalties, fg.Technical=Technical, fgm.PenaltiesResultOpponent=PenaltiesResultOpponent | ||
|order by=(fg.ResultMaccabi-fg.ResultOpponent) DESC | |order by=(fg.ResultMaccabi-fg.ResultOpponent) DESC | ||
|default= | |default= | ||