Template:TeamLeaderStats: Difference between revisions
From UFFL Wiki
(WIP) |
m (test) |
||
| Line 9: | Line 9: | ||
db=ufflData | db=ufflData | ||
|from=PlayerSeasonStats | |from=PlayerSeasonStats | ||
|where= Season='{{{season}}}' AND Team = '{{{team}}}' | |where= Season='{{{season|}}}' AND Team = '{{{team|}}}' | ||
|limit = 1 | |limit = 1 | ||
|order by = PassYds DESC | |order by = PassYds DESC | ||
| Line 16: | Line 16: | ||
db=ufflData | db=ufflData | ||
|from=PlayerSeasonStats | |from=PlayerSeasonStats | ||
|where= Season='{{{season}}}' AND Team = '{{{team}}}' | |where= Season='{{{season|}}}' AND Team = '{{{team|}}}' | ||
|limit = 1 | |limit = 1 | ||
|order by = PassTD DESC | |order by = PassTD DESC | ||
| Line 23: | Line 23: | ||
db=ufflData | db=ufflData | ||
|from=PlayerSeasonStats | |from=PlayerSeasonStats | ||
|where= Season='{{{season}}}' AND Team = '{{{team}}}' | |where= Season='{{{season|}}}' AND Team = '{{{team|}}}' | ||
|limit = 1 | |limit = 1 | ||
|order by = RushYds DESC | |order by = RushYds DESC | ||
| Line 30: | Line 30: | ||
db=ufflData | db=ufflData | ||
|from=PlayerSeasonStats | |from=PlayerSeasonStats | ||
|where= Season='{{{season}}}' AND Team = '{{{team}}}' | |where= Season='{{{season|}}}' AND Team = '{{{team|}}}' | ||
|limit = 1 | |limit = 1 | ||
|order by = RushTD DESC | |order by = RushTD DESC | ||
| Line 37: | Line 37: | ||
db=ufflData | db=ufflData | ||
|from=PlayerSeasonStats | |from=PlayerSeasonStats | ||
|where= Season='{{{season}}}' AND Team = '{{{team}}}' | |where= Season='{{{season|}}}' AND Team = '{{{team|}}}' | ||
|limit = 1 | |limit = 1 | ||
|order by = Catches DESC | |order by = Catches DESC | ||
| Line 44: | Line 44: | ||
db=ufflData | db=ufflData | ||
|from=PlayerSeasonStats | |from=PlayerSeasonStats | ||
|where= Season='{{{season}}}' AND Team = '{{{team}}}' | |where= Season='{{{season|}}}' AND Team = '{{{team|}}}' | ||
|limit = 1 | |limit = 1 | ||
|order by = RecYds DESC | |order by = RecYds DESC | ||
| Line 51: | Line 51: | ||
db=ufflData | db=ufflData | ||
|from=PlayerSeasonStats | |from=PlayerSeasonStats | ||
|where= Season='{{{season}}}' AND Team = '{{{team}}}' | |where= Season='{{{season|}}}' AND Team = '{{{team|}}}' | ||
|limit = 1 | |limit = 1 | ||
|order by = RecTD DESC | |order by = RecTD DESC | ||
| Line 58: | Line 58: | ||
db=ufflData | db=ufflData | ||
|from=PlayerSeasonStats | |from=PlayerSeasonStats | ||
|where= Season='{{{season}}}' AND Team = '{{{team}}}' | |where= Season='{{{season|}}}' AND Team = '{{{team|}}}' | ||
|limit = 1 | |limit = 1 | ||
|order by = Points DESC | |order by = Points DESC | ||
| Line 65: | Line 65: | ||
db=ufflData | db=ufflData | ||
|from=PlayerSeasonStats | |from=PlayerSeasonStats | ||
|where= Season='{{{season}}}' AND Team = '{{{team}}}' | |where= Season='{{{season|}}}' AND Team = '{{{team|}}}' | ||
|limit = 1 | |limit = 1 | ||
|order by = KickoffReturnYds DESC | |order by = KickoffReturnYds DESC | ||
| Line 72: | Line 72: | ||
db=ufflData | db=ufflData | ||
|from=PlayerSeasonStats | |from=PlayerSeasonStats | ||
|where= Season='{{{season}}}' AND Team = '{{{team}}}' | |where= Season='{{{season|}}}' AND Team = '{{{team|}}}' | ||
|limit = 1 | |limit = 1 | ||
|order by = PuntReturnYds DESC | |order by = PuntReturnYds DESC | ||
| Line 79: | Line 79: | ||
db=ufflData | db=ufflData | ||
|from=PlayerSeasonStats | |from=PlayerSeasonStats | ||
|where= Season='{{{season}}}' AND Team = '{{{team}}}' | |where= Season='{{{season|}}}' AND Team = '{{{team|}}}' | ||
|limit = 1 | |limit = 1 | ||
|order by = Tackles DESC | |order by = Tackles DESC | ||
| Line 86: | Line 86: | ||
db=ufflData | db=ufflData | ||
|from=PlayerSeasonStats | |from=PlayerSeasonStats | ||
|where= Season='{{{season}}}' AND Team = '{{{team}}}' | |where= Season='{{{season|}}}' AND Team = '{{{team|}}}' | ||
|limit = 1 | |limit = 1 | ||
|order by = Sacks DESC | |order by = Sacks DESC | ||
| Line 93: | Line 93: | ||
db=ufflData | db=ufflData | ||
|from=PlayerSeasonStats | |from=PlayerSeasonStats | ||
|where= Season='{{{season}}}' AND Team = '{{{team}}}' | |where= Season='{{{season|}}}' AND Team = '{{{team|}}}' | ||
|limit = 1 | |limit = 1 | ||
|order by = ForcedFumbles DESC | |order by = ForcedFumbles DESC | ||
| Line 100: | Line 100: | ||
db=ufflData | db=ufflData | ||
|from=PlayerSeasonStats | |from=PlayerSeasonStats | ||
|where= Season='{{{season}}}' AND Team = '{{{team}}}' | |where= Season='{{{season|}}}' AND Team = '{{{team|}}}' | ||
|limit = 1 | |limit = 1 | ||
|order by = Ints DESC | |order by = Ints DESC | ||
Revision as of 21:46, 30 January 2021
| Team Leaders | ||
|---|---|---|
| Category | Player(s) | Value |
| Passing Yards | {{{playerName1}}} | {{{passYds}}} |
| Touchdown Passes | {{{playerName2}}} | {{{passTDs}}} |
| Rushing Yards | {{{playerName3}}} | {{{rushYds}}} |
| Touchdown Runs | {{{playerName4}}} | {{{rushTDs}}} |
| Receptions | {{{playerName5}}} | {{{receptions}}} |
| Receiving Yards | {{{playerName6}}} | {{{recYds}}} |
| Touchdown Catches | {{{playerName7}}} | {{{recTDs}}} |
| Points Scored | {{{playerName8}}} | {{{points}}} |
| Kick Return Yards | {{{playerName9}}} | {{{kickRetYds}}} |
| Punt Return Yards | {{{playerName10}}} | {{{puntRetYds}}} |
| Tackles | {{{playerName11}}} | {{{tackles}}} |
| Sacks | {{{playerName12}}} | {{{sacks}}} |
| Forced Fumbles | {{{playerName13}}} | {{{forcedFumbles}}} |
| Interceptions | {{{playerName14}}} | {{{interceptions}}} |
