אורן המתעפץ (שיחה | תרומות) (יצירת דף עם התוכן "<includeonly> {{#cargo_query: tables=Basketball_Games=bg, Basketball_Player_Game_Events_Summary=bpges, Basketball_Competitions=bc |join on=bg._pageName=bpges._pageName, bg.Competition=bc.OriginalName |where=1=1 AND bg.CoachMaccabi="{{{שם|}}}" AND bc.Official=true AND bpges.Team=1 |fields=bg._pageID=pageID, bg.Date=Date, bg.Opponent=Opponent, SUM(bpges.Assists)=TotalAssists |limit=1 |order by=TotalAssists DESC |no html |format=template |template=פרופי...") |
אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה |
||
| (2 גרסאות ביניים של אותו משתמש אינן מוצגות) | |||
| שורה 3: | שורה 3: | ||
tables=Basketball_Games=bg, Basketball_Player_Game_Events_Summary=bpges, Basketball_Competitions=bc | tables=Basketball_Games=bg, Basketball_Player_Game_Events_Summary=bpges, Basketball_Competitions=bc | ||
|join on=bg._pageName=bpges._pageName, bg.Competition=bc.OriginalName | |join on=bg._pageName=bpges._pageName, bg.Competition=bc.OriginalName | ||
|where= | |where=bg.CoachMaccabi="{{{שם|}}}" AND bc.Official="1" AND bpges.Team=1 | ||
|fields=bg._pageID=pageID, bg.Date=Date, bg.Opponent=Opponent, SUM(bpges.Assists)= | |fields=bg._pageID=pageID, bg.Date=Date, bg.Opponent=Opponent, SUM(bpges.Assists)=Record | ||
|group by=bg._pageID, bg.Date, bg.Opponent | |||
|order by=SUM(bpges.Assists) DESC | |||
|limit=1 | |limit=1 | ||
|no html | |no html | ||
|format=template | |format=template | ||