Query
Template: /football/league/index-flash.cfm:20
Execution Time: 14.3 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(g3.total_points,0) AS week_3,
isnull(g4.total_points,0) AS week_4,
isnull(g1.total_points,0)+
isnull(g2.total_points,0)+
isnull(g3.total_points,0)+
isnull(g4.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
left join games g3 on t.team=g3.team and g3.period=202413
left join games g4 on t.team=g4.team and g4.period=202414
where t.league='FL1' and t.year=2024
order by total_score desc
teamnameremainingweek_1week_2week_3week_4total_score
13007Anthony Pulanco - F 0196.42183.50156.80214.86751.58
23012Mike Hurford - F 0213.44173.90169.46138.16694.96
33005Ryan Servanty - F 0139.28170.78163.82208.98682.86
43015Chris Gilley - F 0166.04171.26132.64211.80681.74
53009Jeremy Ramos - F 0193.76194.56175.30113.30676.92
63008Jason Abbey - F 0173.58146.32185.18163.32668.40
73010Temple of Doom C1 - F 0171.14156.86174.42161.12663.54
83014Get Em 0152.38147.18168.26181.74649.56
93013Marc Fazzio - F 0150.78129.58207.08149.52636.96
103004Jimmy Bradley - F 0157.00136.22144.92150.00588.14
113006John Russo - F 0166.56110.70111.26128.00516.52
123011Under Fire - F 0116.88139.48160.6894.36511.40
11,12,13,14 17 Mr. Sports

Flash League 1

4 Weeks

Last Updated: 12/30/24 10:34:41 PM Central
Scoring Summary
Team Week 1 Week 2 Week 3 Week 4 Total
Anthony Pulanco - F 196.42 183.50 156.80 214.86 751.58
Mike Hurford - F 213.44 173.90 169.46 138.16 694.96
Ryan Servanty - F 139.28 170.78 163.82 208.98 682.86
Chris Gilley - F 166.04 171.26 132.64 211.80 681.74
Jeremy Ramos - F 193.76 194.56 175.30 113.30 676.92
Jason Abbey - F 173.58 146.32 185.18 163.32 668.40
Temple of Doom C1 - F 171.14 156.86 174.42 161.12 663.54
Get Em 152.38 147.18 168.26 181.74 649.56
Marc Fazzio - F 150.78 129.58 207.08 149.52 636.96
Jimmy Bradley - F 157.00 136.22 144.92 150.00 588.14
John Russo - F 166.56 110.70 111.26 128.00 516.52
Under Fire - F 116.88 139.48 160.68 94.36 511.40