אורן המתעפץ (שיחה | תרומות) (יצירת דף עם התוכן "<includeonly><!-- --><div class="section"> <div class="title">הניצחונות הגדולים</div> <div class="content table four-columns-second-grow"> <div class="table-header"><!-- --><span>עונה</span><!-- --><span>מסגרת</span><!-- --><span>הפרש</span><!-- --><span>קישור</span><!-- --></div><!-- --><div class="table-content"> {{#cargo_query: tables=Volleyball_Games=vg, Volleyball_Games_Referees=vgr |join on=vg._pageName=vgr._pageNam...") |
אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה |
||
| שורה 15: | שורה 15: | ||
tables=Volleyball_Games=vg, Volleyball_Games_Referees=vgr | tables=Volleyball_Games=vg, Volleyball_Games_Referees=vgr | ||
|join on=vg._pageName=vgr._pageName | |join on=vg._pageName=vgr._pageName | ||
|where=vg.ResultOpt=1 AND vgr.AssistantReferees HOLDS "{{{שם להצגה|}}}" | |where=vg.ResultOpt=1 AND vgr.AssistantReferees HOLDS "{{{שם להצגה|}}}" | ||
|fields=vg._pageName=PageName, vg.Season, vg.Competition, vg.Leg, vg.TotalPointsMaccabi=PointsMaccabi, vg.TotalPointsOpponent=PointsOpponent | |fields=vg._pageName=PageName, vg.Season, vg.Competition, vg.Leg, vg.TotalPointsMaccabi=PointsMaccabi, vg.TotalPointsOpponent=PointsOpponent | ||
|order by=(vg.TotalSetsMaccabi-vg.TotalSetsOpponent) DESC, (vg.TotalPointsMaccabi-vg.TotalPointsOpponent) DESC | |order by=(vg.TotalSetsMaccabi-vg.TotalSetsOpponent) DESC, (vg.TotalPointsMaccabi-vg.TotalPointsOpponent) DESC | ||