 | | 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 a.player_id, b.solecismic-a.solecismic+a.dash-b.dash+b.strength-a.strength+a.agility-b.agility+b.jump-a.jump+b.position_specific-a.position_specific as rawchange, r.position, experience, last_name, first_name, a.solecismic as sole1, b.solecismic as sole2, a.dash as dash1, b.dash as dash2, a.strength as strength1, b.strength as strength2, a.agility as agi1, b.agility as agi2, a.jump as jump1, b.jump as jump2, a.position_specific as drill1, b.position_specific as drill2, positiongroup_id, a.player_id, i.nickname as playernick, current_overall as cur, future_overall as fut
FROM ben_combinehistory a
JOIN ben_combinehistory b on b.player_id=a.player_id
join fof7_player_information i on i.player_id=a.player_id
JOIN fof7_player_record r on r.player_id=a.player_id
JOIN fof7_players_personal p on p.player_id=a.player_id
where a.year=2143 and b.year=2144 and a.dash>0 and experience>1 and r.team=
order by positiongroup_id, future_overall desc
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 'order by positiongroup_id, future_overall desc' at line 9 |
|
