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 2054 Draft Class
Remove Drafted Players From List
2054 CCFL Draft Class
Click on column headers to sort
SELECT a.team, team_name, team_owner, pick_id, r.last_name, r.first_name, r.position_group, r.height, r.weight, round(r.adjustedgrade/(10*wt.weight),1) as grade, round(r.adjustedgrade/10,1) as adjustedgrade, round(dash/100,2) as dash, dash as dashraw, solecismic, strength, round(agility/100,2) as agility, agility as agilraw, jump, position_specific as drill, developed, volatility, 2054-year_born as age, r.college, month_born, day_born, year_born, cityname, t.nickname, i.positiongroup_id as posgrp, r.player_id FROM fof7_rookies r JOIN fof7_player_record a on a.player_id=r.player_id JOIN fof7_player_information i on i.player_id=r.player_id JOIN fof7_positionweights wt on wt.positiongroup=r.position_group LEFT JOIN player pl on pl.player_in_game_id=r.player_id LEFT JOIN pick pi on pi.player_id=pl.player_id LEFT JOIN team tm on tm.team_id=pi.team_id LEFT JOIN fof_teams t on t.id=tm.in_game_id WHERE r.rookieyear=2054 ORDER BY adjustedgrade DESC, posgrp, pick_id
Column 'dash' in field list is ambiguous
RNK
TEAM
PICK
NAME
SIMILAR PLAYERS
POS
HT
WT
RAW
ADJ
DASH
SOL
BENCH
AGI
BRJU
POS
%DEV
VOL
AGE
COLLEGE
BDAY
GRP