GML Top 100: Sack Pct. (Lowest) |
RANK | PLAYER | Sack Pct. (Lowest) | TEAMSELECT 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' |
|