CCFL 2054 Draft ClassRemove Drafted Players From List2054 CCFL Draft ClassClick on column headers to sort |
RNK | TEAM | PICK | NAME | SIMILAR PLAYERS | POS | HT | WT | RAW | ADJ | DASH | SOL | BENCH | AGI | BRJU | POS | %DEV | VOL | AGE | COLLEGE | BDAY | GRP | 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
|