CCFL HOMELAST THREE LEAGUE CHAMPIONS |
2051-2053 TOP QB PERFORMERS |
2051-2053 YARDS FROM SCRIMMAGE |
2051-2053 RECEIVING YARDS |
2051-2053 TOP OFFENSIVE LINEMEN |
2051-2053 TOP DEFENSIVE PERFORMERS |
SELECT a.team as teamid, darkrgb, lightrgb, sum(defensescore) as defensescore, last_name, first_name, playerid, a.position_group
FROM statsbyseason s
JOIN fof7_player_record a on a.player_id=s.playerid
JOIN fof_teams t on t.id=a.team
JOIN fof7_player_information i on i.player_id=s.playerid
join woof_colors_rgb rgb on rgb.teamid=a.team
where year>(SELECT curyear-3 FROM fof7_gameinfo)
group by playerid
order by defensescore desc
LIMIT 5 User 'fofbelco_primary' has exceeded the 'max_questions' resource (current value: 1)
|
|