אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה |
אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה |
||
| שורה 16: | שורה 16: | ||
tables=Football_Games=fg,Games_Referees=gr | tables=Football_Games=fg,Games_Referees=gr | ||
|join on=fg._pageID = gr._pageID | |join on=fg._pageID = gr._pageID | ||
|where=gr.AssistantReferees HOLDS "{{{שם להצגה|}}}" AND ResultOpt=3 | |where=gr.AssistantReferees HOLDS "{{{שם להצגה|}}}" AND fg.ResultOpt=3 | ||
|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 | ||
|order by=(fg.ResultOpponent-fg.ResultMaccabi) DESC | |order by=(fg.ResultOpponent-fg.ResultMaccabi) DESC | ||