Statistics/sandbox: Difference between revisions
From UFFL Wiki
mNo edit summary |
mNo edit summary |
||
| Line 5: | Line 5: | ||
db=ufflData | db=ufflData | ||
|from=PlayerSeasonStats | |from=PlayerSeasonStats | ||
|where= Season=' | |where= Season='{{{season|}}}' AND PassYds <> '0' | ||
|limit = 60 | |limit = 60 | ||
|order by= PassYds DESC | |order by= PassYds DESC | ||
| Line 24: | Line 24: | ||
{{#display_external_table:template=PlayerSeasonStats}} | {{#display_external_table:template=PlayerSeasonStats}} | ||
|} | |} | ||
{{#clear_external_data:}} | |||
<!--- TEAM ANNUAL STATISTICS FOR TEAM PAGES: Further work would be needed to make this a fully automated template. | <!--- TEAM ANNUAL STATISTICS FOR TEAM PAGES: Further work would be needed to make this a fully automated template. | ||
Revision as of 20:55, 26 January 2021
Mad is using this sandbox to review a variety of ways data can be imported from the DDSPF2021 MDB file (via MySQL) into meaningful information for the Wiki.
A specific problem for this table: it looks like MTL should be ABI in 2015. Minor issue, though.
| Passing | |||||||
|---|---|---|---|---|---|---|---|
| Name | Team | G | GS | PA | PC | Yds | |
