HOME

LEAGUE
About GML
Files
Upload Status
Conscriptor
Draft Class
Forum
Team/Owner List
Chemistry Search
Chemistry Chart
League Settings And Rules

SEASON
Standings
Individual Leaders
Award Leaders
Change Tracking
Team Offense
Team Defense
Penalties

FINANCES
Profit Report
Biggest Cap Hits
Top Salaries

ALMANAC
League History
Career Leaders
Single-Season Records
Staff/Former Players
Stats By Season
SoleHTML


Player Search
ANALYSIS
Pass Distances
Penalties

LINKS
FOFC
Solecismic

AFC North
AFC South
AFC East
AFC West
NFC North
NFC South
NFC East
NFC West
POSITION GROUP:
GML Top 100: Sack Pct. (Lowest)
SELECT last_name as lastname, first_name as firstname, nickname, s.playerid, 100*sum(SacksAllowed)/sum(passplays) AS leader, yearretired, h.position, a.team, min(year) AS firstyear FROM statsbyseason s JOIN fof7_player_information h ON h.player_id=s.playerid LEFT JOIN fof7_player_record a ON a.player_id=s.playerid LEFT JOIN ben_retired r on r.playerid=s.playerid WHERE last_name<>"" AND m.id>6 AND m.id<12 GROUP BY s.playerid HAVING sum(passplays)>2559 ORDER BY leader LIMIT 100
Unknown column 'm.id' in 'where clause'
RANK
PLAYER
Sack Pct. (Lowest)
TEAM