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:
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
2040
2041
2042
2043
2044
2045
2046
2047
2048
2049
2050
2051
2052
2053
END YEAR:
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
2040
2041
2042
2043
2044
2045
2046
2047
2048
2049
2050
2051
2052
2053
CCFL 2016-2053 LEAGUE HISTORY
CCFL OVERALL PERFORMANCES
LOGO
TEAM
DIVISION
RECORD
WIN PCT
PLAYOFFS
DIV TITLES
WCs EARNED
BYES EARNED
BOWLS
BOWL WINS
BOWL LOSSES
SCORE
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