| 2144 | TEAM INFORMATION/HISTORYGENERAL MANAGER: | |
2144 RECORD: | |
POWER RATING: | 69.73 (#32) |
DIVISION: | |
ALL-TIME RECORD: | |
PLAYOFF APPEARANCES: | |
POSTSEASON RECORD: | |
BOWL RECORD: | |
| 2144 TEAM STATISTICSTOTAL 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 stage, t.year, transaction,position_group, money, years_original_position, misc, new_position, old_position, t.player_id, i.last_name as playerlast, i.first_name as playerfirst, s.last_name as stafflast, s.first_name as stafffirst, i.position
FROM fof7_transactions t
LEFT JOIN fof7_player_information i on i.player_id=t.player_id
left join fof7_staff s on s.staff_id=t.player_id
WHERE t.year=2145 and team=
order by id 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 id' at line 6 |
|