| 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: | |
|
| GML: HistoryYR | TEAM NAME | OWNER | RECORD | POSTSEASON | PASS LEADER | RUSH LEADER | RECV LEADER | TKL LEADER | HEAD COACH | OFFENSIVE COORDINATOR | SCHEME | DEFENSIVE COORDINATOR | SCHEME | ASSISTANT COACH | STRENGTH COORDINATORSELECT i.year, o.owner, wins, losses, ties, playoff_performance as playoffs, points_scored as pointsfor, points_allowed as pointsagainst, division_wins as divwin,
division_losses as divloss, division_ties as divtie, conference_wins as confwins,
conference_losses as confloss, conference_ties as confties, overall_performance, top_quarterback, top_rusher, top_receiver, top_tackler, coach, quarterback_passing_yardage, rusher_yardage, receiver_yardage, tackles, note, cityname, nickname, abbrev
FROM fof7_team_yearly_information i
JOIN fof7_standings s on s.team=i.teamid and s.year=i.year
LEFT JOIN ben_ownerhistory o on o.teamid=i.teamid and i.year>=beginyear and i.year<=endyear
join ben_teamhistory t on t.teamid=i.teamid and i.year between beginyr and endyr
WHERE i.teamid= and s.team=
group by i.year
order by year 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 'and s.team=
group by i.year
order by year DESC' at line 8 |
|
|