Template:PlayerSeasonStats: Difference between revisions

From UFFL Wiki
mNo edit summary
m (testing join on statement)
Line 2: Line 2:
{{#get_db_data:
{{#get_db_data:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from= PlayerSeasonStats=statistics,Players=players
  |where= Season='{{{season|}}}' AND PassYds <> '0'
  |where= statistics.Season='{{{season|}}}' AND statistics.PassYds <> '0'
|join on = statistics.PlayerID = players.PlayerID
  |limit = 60
  |limit = 60
  |order by= PassYds DESC
  |order by= statistics.PassYds DESC
  |data=playerID=PlayerID,team=Team,games=G,gameStarts=GS,passAtt=PassAtt,passComp=PassCmp,passYds=PassYds,passCmpPct=PassPct,longestpass=PassLong,touchdowns=PassTD,interceptions=PassInt,qbrating=PassRating
  |data=position=Position,playerID=statistics.PlayerID,team=statistics.Team,games=statistics.G,gameStarts=statistics.GS,passAtt=statistics.PassAtt,passComp=statistics.PassCmp,passYds=statistics.PassYds,passCmpPct=statistics.PassPct,longestpass=statistics.PassLong,touchdowns=statistics.PassTD,interceptions=statistics.PassInt,qbrating=statistics.PassRating
}}
}}
{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
|-
|-
! colspan="12"|{{{season|}}} Passing Statistics
! colspan="13"|{{{season|}}} Passing Statistics
|-
|-
! Name
! Name
! Pos
! Team
! Team
! G
! G

Revision as of 01:40, 28 January 2021


Passing Statistics
Name Pos Team G GS PA PC Yds % Lng TD Int Rating


Rushing Statistics
Name Team G Att Yds Avg Lng TD Fum


Receiving Statistics
Name Team G No Yds Avg Lng TD Fum


Defensive Statistics
Name Team G Tck TFL FF/FR Sck Int PD Sfty TD Blk P/XP/FG


Offensive Line Statistics
Name Team G Pancakes Sacks Allowed


Kicking Statistics
Name Team G XPM XPA XP% FGM FGA FG% <20 20-29 30-39 40-49 50+ Lng Pts


Punting Statistics
Name Team G Punts Yds Avg Inside 20 Long


Special Teams Statistics
Name Team G KR KR Yds KR Avg KR Lng KR TD PR PR Yds PR Avg PR Lng PR TD