HOME

LEAGUE
About CCFL
Files
Upload Status
Conscriptor
Draft Class
Forum
Team/Owner List
Chemistry Chart
Chemistry Search
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
FOF HINTS
FOFC
Solecismic

AFC North
AFC South
AFC East
AFC West
NFC North
NFC South
NFC East
NFC West
POSITION GROUP:
CCFL CAREER BLOCKING LEADERS (TE Shawn Bailey)
Passing
Rushing
Receiving
Blocking
Defense
Punting/Kicking
Special Teams
Misc.
DAWGPOINTS--BLOCKING
TEAM
NAME
TOTAL
select h.position, last_name as lastname, first_name as firstname, s.playerid, sum(blockscore) AS score, yearretired, min(year) AS firstyear from statsbyseason s JOIN fof7_player_information h ON h.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 order by score desc LIMIT 30
Unknown column 'm.id' in 'where clause'