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
BEGIN YEAR:
END YEAR:
CCFL 2016-2053 LEAGUE HISTORY
CCFL OVERALL PERFORMANCES
select sum(note="Won Division") as divisiontitles, t.id, cityname, nickname, conferenceabbrev, divisionname, sum(s.wins) as wins, sum(s.losses) as losses, sum(s.ties) as ties, sum(note!="None") as playoff_appearances, sum(playoff_performance="Won Conference")+sum(playoff_performance="Champion") as bowl_appearances, sum(playoff_performance="Champion") as bowl_wins, playoff_wins, playoff_losses, round((sum(s.wins)+.5*sum(s.ties))/(sum(s.wins)+sum(s.losses)+sum(s.ties)),3) as winpct, sum(playoff_performance="Won Conference") as bowl_losses, sum(note="Wild Card") as wildcard, round(sum(s.wins)*.666+sum(s.ties)*.333+sum(note="Won Division")*1.5+sum(note="Wild Card")+sum(playoff_performance="Conference")*2+sum(playoff_performance="Won Conference")*3.5+sum(playoff_performance="Champion")*5+count(b.teamid),1) as score, count(b.teamid) as byes FROM fof_teams t JOIN fof7_standings s on s.team=t.id JOIN divisions d on d.divisionid=t.division and d.conferenceid=t.conference join fof7_team_yearly_information i on i.teamid=s.team and i.year=s.year join fof7_team_information ti on ti.team=t.id left join ben_byeweeks b on b.year=s.year and b.teamid=s.team where s.year between 2016 and 2053 GROUP BY t.id ORDER BY score desc, winpct desc, abbrev
Table 'fofbelco_ccfl.ben_byeweeks' doesn't exist
LOGO
TEAM
DIVISION
RECORD
WIN PCT
PLAYOFFS
DIV TITLES
WCs EARNED
BYES EARNED
BOWLS
BOWL WINS
BOWL LOSSES
SCORE