| Query Template: /football/league/index-flash.cfm:20 Execution Time: 8.31 ms Record Count: 12 Cached: No Lazy: No SQL: select t.team, t.name, 0 AS remaining, isnull(g1.total_points,0) AS week_1, isnull(g2.total_points,0) AS week_2, isnull(g1.total_points,0)+ isnull(g2.total_points,0)+ +0 AS total_score from teams t left join games g1 on t.team=g1.team and g1.period=202411 left join games g2 on t.team=g2.team and g2.period=202412 where t.league='FL2' and t.year=2024 order by total_score desc | |||||||
| team | name | remaining | week_1 | week_2 | total_score | ||
| 1 | 3027 | The Leftovers 2 - F | 0 | 206.30 | 188.02 | 394.32 | |
| 2 | 3025 | Mike Hurford - F | 0 | 207.62 | 175.58 | 383.20 | |
| 3 | 3026 | Aaron McClelland - F | 0 | 200.84 | 179.52 | 380.36 | |
| 4 | 3017 | 506 PIR - F | 0 | 186.74 | 180.50 | 367.24 | |
| 5 | 3024 | Steve Rockmael - F | 0 | 179.64 | 162.46 | 342.10 | |
| 6 | 3022 | Tom Huegin - F | 0 | 158.48 | 166.10 | 324.58 | |
| 7 | 3019 | Temple of Doom C2 - F | 0 | 156.88 | 156.32 | 313.20 | |
| 8 | 3021 | Krupa/Gough - F | 0 | 163.52 | 134.70 | 298.22 | |
| 9 | 3023 | John Russo - F | 0 | 123.34 | 168.92 | 292.26 | |
| 10 | 3018 | Alan Moskoff - F | 0 | 155.94 | 124.36 | 280.30 | |
| 11 | 3020 | Paul Telesco - F | 0 | 146.08 | 128.98 | 275.06 | |
| 12 | 3016 | Marc Fazzio - F | 0 | 127.98 | 122.88 | 250.86 | |
| Scoring Summary | |||
| Team | Week 1 | Week 2 | Total |
| The Leftovers 2 - F | 206.30 | 188.02 | 394.32 |
| Mike Hurford - F | 207.62 | 175.58 | 383.20 |
| Aaron McClelland - F | 200.84 | 179.52 | 380.36 |
| 506 PIR - F | 186.74 | 180.50 | 367.24 |
| Steve Rockmael - F | 179.64 | 162.46 | 342.10 |
| Tom Huegin - F | 158.48 | 166.10 | 324.58 |
| Temple of Doom C2 - F | 156.88 | 156.32 | 313.20 |
| Krupa/Gough - F | 163.52 | 134.70 | 298.22 |
| John Russo - F | 123.34 | 168.92 | 292.26 |
| Alan Moskoff - F | 155.94 | 124.36 | 280.30 |
| Paul Telesco - F | 146.08 | 128.98 | 275.06 |
| Marc Fazzio - F | 127.98 | 122.88 | 250.86 |