BAL at TBY: 2046 WEEK 2 BOX.2046 WEEK 263 Degrees, Sunny. Wind Speed: 10 MPH. Attendance: 73000.
|
|
|
|
|
|
23 | |
|
|
|
|
|
16 | SELECT s.punt_returns * w.puntreturns +
s.punt_return_yards * w.puntreturnyards +
s.punt_returns_touchdowns * w.puntreturntds +
s.kick_returns * w.kickreturns +
s.kick_return_yards * w.kickreturnyards +
s.kick_return_touchdowns * w.kickreturntds +
s.special_teams_tackles * w.specialteamstackles +
s.field_goals_made * w.fgmade +
s.points_after_touchdown * w.pat +
s.pats_attempted * w.patattempted +
s.field_goals_attempted * w.fgattempted +
s.40_field_goals_made * w.fg40plusmade +
s.40_field_goals_attempted * w.fg40plusattempts +
s.50_field_goals_made * w.fg50plusmade +
s.50_field_goals_attempted * w.fg50plusattempts +
s.punts * w.punts +
s.punting_yards * w.puntyards +
s.net_punting_yardage * w.puntnetyards +
s.punts_inside_20 * w.puntin20 AS st_score, cityname, t.nickname as teamnick, first_name as firstname, last_name as lastname, p.nickname as nickname, s.player_id as playerid, p.position as pos
FROM fof7_player_season s
JOIN fof7_player_information p ON p.player_id=s.player_id
JOIN extenderweights w ON w.position = p.positiongroup_id
join fof_teams t on t.id=s.team
WHERE week = 7-5 AND year = 2046 AND ((s.team=2 AND s.opponent=27) OR (s.team=27 AND s.opponent=2))
ORDER BY st_score DESC LIMIT 1 User 'fofbelco_primary' has exceeded the 'max_questions' resource (current value: 1) |