 | | 2144 | TEAM INFORMATION/HISTORY| GENERAL MANAGER: | |
| 2144 RECORD: | |
| POWER RATING: | 69.73 (#32) |
| DIVISION: | |
| ALL-TIME RECORD: | |
| PLAYOFF APPEARANCES: | |
| POSTSEASON RECORD: | |
| BOWL RECORD: | |
| 2144 TEAM STATISTICS| TOTAL OFFENSE: | 292.9 ypg (#32) | | RUSHING OFFENSE: | 18.9 ypg (#32) | | PASSING OFFENSE: | 162.9 ypg (#32) | | SCORING OFFENSE: | 14.6 ppg (#32) | | TOTAL DEFENSE: | 392.6 ypg (#32) | | RUSHING DEFENSE: | 145.7 ypg (#32) | | PASSING DEFENSE: | 267.7 ypg (#32) | | SCORING DEFENSE: | 27.1 ppg (#32) |
| COACHING STAFF
| HEAD COACH: | | | OFFENSIVE COORDINATOR: | | | DEFENSIVE COORDINATOR: | | | ASSISTANT COACH: | | | STRENGTH COACH: | |
|
| SELECT h.position, m.id AS posid, first_name as firstname, h.nickname AS playernick, last_name as lastname, tm.cityname, tm.nickname AS teamnick, s.team, s.playerid, sum(passcompletions) AS cmp, sum(passattempts) AS att,
sum(passyards) AS passyds, sum(tdpasses) AS tdpasses, sum(intthrown) AS picks, sum(passplays) AS passplays,
sum(pat) AS xp, sum(patattempted) AS xpa, sum(puntin20) AS in20, sum(rushattempts) AS rushatt,
sum(rushingyards) AS rushyds, sum(rushtd) AS rushtd, sum(catches) AS catches, sum(receivingyards) AS recyds,
sum(receivingtds) AS rectds, sum(passtargets) AS tgts, sum(keyrunblock) AS krb, sum(keyrunblockopportunites) AS krbo,
sum(pancakeblocks) AS pancakes, sum(tackles) AS tkl, sum(assists) as ast, sum(ints) AS ints,
sum(passesdefended) AS pasdef, sum(passescaught) AS catchallowed, sum(sacks/10) AS sacks,
sum(qbhurries) AS hurries, sum(fgattempted) AS fga, sum(fgmade) AS fg, sum(punts) AS punts,
sum(puntyards) AS puntyds, sum(puntnetyards) AS puntnet,
(LEAST(((((sum(s.passcompletions)/sum(s.passattempts)) * 100) -30) / 20), 2.375) +
LEAST((((sum(s.tdpasses)/sum(s.passattempts)) * 100) / 5), 2.375) +
LEAST(((9.5 - ((sum(s.intthrown)/sum(s.passattempts)) * 100)) / 4), 2.375) +
LEAST((((sum(s.passyards)/sum(s.passattempts)) - 3) / 4), 2.375)) / .06 AS qb_rating,
(sum(rushscore)+sum(passscore)+sum(recscore)+sum(blockscore)) AS offensescore, sum(defensescore) AS defensescore, n.positiongroup AS posgrp, sum(sacksallowed) as sacksallowed, sum(fumbles) as fumbles,
sum(stscore) as stscore, sum(fg40plusattempts) as fg40plusattempts, sum(fg40plusmade) as fg40plusmade, sum(passescaught) as passescaught, min(s.year) as beginyear, max(s.year) as endyear
FROM statsbyseason s
JOIN fof7_player_information h ON h.player_id=s.playerid
JOIN fof_mappings m on m.position=h.position
JOIN fof_positions p on p.position=m.id
join fof_mappings n on n.id=p.positiongroup
join fof_teams tm ON tm.id=s.team
WHERE p.positiongroup=1 and s.team=
group by playerid
ORDER BY offensescore DESC LIMIT 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group by playerid
ORDER BY offensescore DESC LIMIT 1' at line 23 |
|
