2010 GTFO Tecmo Super Bowl

Season 37

Commish:
swampc1

Probably the Best League in the World
(it's not debatable)

3.143.7.112

2010 day 802

First game Oct 13th, 2022

games remaining

133 / 135 (98.5%)

Past Champions

2009 DPS (16-4-0)
2008 DPS (13-8-0)
2007 DPS (17-3-0)
2006 iconboxingclub (16-4-0)
2005 iconboxingclub (16-4-0)
2004 eifer (14-7-0)
2003 iconboxingclub (16-5-0)
2002 DPS (17-3-0)
2001 iconboxingclub (17-2-1)
2000 DPS (14-7-0)
1999 nos (16-4-0)
1998 eifer (15-6-0)
1997 nos (16-4-0)
1996 nos (19-1-0)
1995 nos (17-3-0)
1994 iconboxingclub (18-2-0)
1993 iconboxingclub (16-4-0)
1992 iconboxingclub (15-4-0)
1991 swampc1 (15-5-0)
1990 DPS (15-5-1)
1989 nos (17-3-0)
1988 nos (18-2-0)
1987 nos (16-3-1)
1986 Prime (17-2-0)
1985 FastEd (16-4-0)
1984 iconboxingclub (15-4-1)
1983 DPS (17-3-0)
1982 bob sacamano (16-5-0)
1981 AlphaTD (16-4-0)
1980 eifer (14-7-0)
1979 swampc1 (15-6-0)
1978 FastEd (15-5-0)
1977 eifer (15-6-0)
1976 iconboxingclub (13-8-0)
1975 FastEd (12-8-0)
1974 eifer (16-5-0)

2010 Standings

A Team

W-L-T

Div

Last 5

Streak

dps

15-3

7-2

4-1

PF:

25.8

PA:

14.8

+11.1

supko

12-5-1

5-3-1

3-2

PF:

18.1

PA:

12.5

+5.6

iconboxingclub

9-9

5-5

3-2

PF:

24.4

PA:

19.3

+5.1

FastEd

8-9-1

2-5-1

1-3-1

PF:

19.7

PA:

20.9

-1.3

the_shield

5-13

2-6

0-5

PF:

15.2

PA:

24.4

-9.2

B17's

W-L-T

Div

Last 5

Streak

bob sacamano

14-4

8-0

4-1

PF:

24.8

PA:

15.9

+8.9

nellyville

10-8

2-6

4-1

PF:

18.4

PA:

19.6

-1.2

randywags25

9-9

4-4

3-2

PF:

19.6

PA:

16.9

+2.6

lordoftheend

7-11

3-5

2-3

PF:

19.3

PA:

20.5

-1.2

eifer

6-10

3-5

2-3

PF:

19.4

PA:

23.6

-4.3

C Cups

W-L-T

Div

Last 5

Streak

swampc1

10-8

6-2

3-2

PF:

19.6

PA:

21.1

-1.4

birdhas

9-9

5-3

2-3

PF:

17.2

PA:

15.2

+2.1

jpthebowler

7-11

3-5

1-4

PF:

15.8

PA:

20.1

-4.3

SimpleSimon

6-11

3-5

1-4

PF:

15.8

PA:

-5.2

drake

5-12

3-5

1-4

PF:

14.9

PA:

23.4

-8.5

Past Seasons

1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011

Fumbles...the only reason I've ever lost

	Gms	fumbles lost	fumbles lost/game
1	17	18	1.06
2	17	17	1.00
3	18	13	0.72
4	16	11	0.69
5	18	10	0.56
6	18	9	0.50
7	18	9	0.50
8	18	7	0.39
9	18	6	0.33
10	18	5	0.28
11	18	5	0.28
12	18	4	0.22
13	18	4	0.22
14	18	3	0.17
15	18	2	0.11

	Gms	fumbles recoverd	fumbles recoverd/game
1	18	10	0.56
2	18	10	0.56
3	18	10	0.56
4	18	10	0.56
5	18	10	0.56
6	18	9	0.50
7	17	8	0.47
8	18	8	0.44
9	18	8	0.44
10	16	7	0.44
11	18	8	0.44
12	17	7	0.41
13	18	7	0.39
14	18	7	0.39
15	18	4	0.22

2010 Team Fantasy (who's whooping ass...)

	Gms	Off	Off/ Game	Def	Def/ Game	Total	Total/ Game
1	18	1222.2	67.9	205.9	11.4	1428.12	79.3
2	18	1178.3	65.5	171.1	9.5	1349.44	75.0
3	18	1040.4	57.8	187.1	10.4	1227.47	68.2
4	18	1062.4	59.0	163.3	9.1	1225.71	68.1
5	18	987.6	54.9	193.0	10.7	1180.61	65.6
6	16	878.0	54.9	144.3	9.0	1022.30	63.9
7	18	939.9	52.2	155.0	8.6	1094.88	60.8
8	18	877.0	48.7	216.2	12.0	1093.24	60.7
9	18	901.4	50.1	176.8	9.8	1078.22	59.9
10	18	887.9	49.3	146.9	8.2	1034.79	57.5
11	17	781.7	46.0	122.2	7.2	903.91	53.2
12	18	746.2	41.5	163.0	9.1	909.18	50.5
13	17	738.3	43.4	107.0	6.3	845.28	49.7
14	18	738.4	41.0	138.1	7.7	876.49	48.7
15	18	665.4	37.0	174.0	9.7	839.39	46.6

	Gms	Off	Off/ Game	Def	Def/ Game	Total	Total/ Game
1	18	633.3	35.2	120.9	6.7	754.22	41.9
2	18	775.6	43.1	120.3	6.7	895.85	49.8
3	18	808.1	44.9	131.7	7.3	939.84	52.2
4	18	840.0	46.7	181.6	10.1	1021.58	56.8
5	18	893.8	49.7	138.9	7.7	1032.68	57.4
6	18	904.9	50.3	170.8	9.5	1075.74	59.8
7	17	840.3	49.4	200.7	11.8	1040.98	61.2
8	18	881.1	49.0	228.6	12.7	1109.71	61.7
9	18	976.3	54.2	135.5	7.5	1111.83	61.8
10	18	938.7	52.2	186.1	10.3	1124.79	62.5
11	17	924.4	54.4	157.6	9.3	1081.95	63.6
12	18	1022.9	56.8	161.3	9.0	1184.24	65.8
13	18	1121.8	62.3	135.4	7.5	1257.15	69.8
14	18	1026.2	57.0	242.8	13.5	1268.96	70.5
15	16	1057.5	66.1	151.8	9.5	1209.31	75.6

	Gms	tackles	tack/gm	sacks	sack/gm	ints	int/gm
1	18	292	16.22	38	2.11	18	1.00
2	18	288	16.00	46	2.56	17	0.94
3	18	261	14.50	22	1.22	12	0.67
4	18	253	14.06	34	1.89	18	1.00
5	18	246	13.67	23	1.28	14	0.78
6	18	239	13.28	30	1.67	17	0.94
7	18	238	13.22	28	1.56	15	0.83
8	18	235	13.06	32	1.78	13	0.72
9	18	231	12.83	30	1.67	22	1.22
10	18	226	12.56	46	2.56	9	0.50
11	17	213	12.53	16	0.94	12	0.71
12	17	206	12.12	18	1.06	6	0.35
13	18	209	11.61	22	1.22	12	0.67
14	18	206	11.44	33	1.83	17	0.94
15	16	182	11.38	23	1.44	17	1.06

		pos	Gms	tackles	tkls/gm	sacks	ints
1	Ahmed Plummer	DB	18	63	3.50	1	2
2	Charles Woodson	DB	18	55	3.06	3	8
3	Terrell Suggs	LB	18	55	3.06	8	4
4	Brian Urlacher	LB	18	55	3.06	4	3
5	Kieth Adams	LB	18	52	2.89	20	0
6	Lofa Tatupu	LB	18	51	2.83	2	3
7	Keith Rivers	LB	18	48	2.67	11	3
8	Nick Barnett	LB	17	44	2.59	3	0
9	Dunta Robinson	DB	18	46	2.56	0	3
10	Roy Williams	DB	18	46	2.56	0	10
11	Chad Greenway	LB	18	45	2.50	16	0
12	Jason David	DB	18	44	2.44	2	2
13	Lamarr Woodley	LB	16	39	2.44	8	1
14	Sean Weatherspoon	LB	17	41	2.41	4	0
15	Devin McCourty	DB	18	43	2.39	1	1
16	Karlos Dansby	LB	18	42	2.33	4	0
17	Aaron Kampman	DL	18	41	2.28	9	0
18	Sean Taylor	DB	18	41	2.28	0	5
19	Adrian Wilson	DB	18	40	2.22	0	2
20	Lawrence Timmons	LB	18	39	2.17	10	0
21	Clay Matthews Jr	LB	17	36	2.12	8	1
22	Larry Foote	LB	17	35	2.06	5	0
23	William Gay	DB	18	37	2.06	0	3
24	Erik Coleman	DB	18	37	2.06	1	6
25	Joe Haden	DB	18	36	2.00	0	3

	Gms	tackled	tack/gm	sacked	int'd
1	18	181	10.06	20	16
2	18	194	10.78	23	12
3	18	196	10.89	22	9
4	18	197	10.94	15	13
5	18	200	11.11	31	17
6	18	219	12.17	12	18
7	18	221	12.28	56	6
8	18	242	13.44	15	23
9	17	239	14.06	33	10
10	16	229	14.31	24	15
11	17	248	14.59	39	18
12	18	266	14.78	41	10
13	18	284	15.78	23	7
14	18	293	16.28	46	19
15	18	316	17.56	41	26

Invalid query dude : select pUID, first, last, ttAbrev, ttTecmoOrder, sum(gsAttempts) as Attempts, sum(gsComps) as Comps, sum(gsComps)/sum(gsAttempts)*100 as compPerc, sum(gsPassYards) as PassYards, sum(gsPassTDs) as TDs, sum(gsINTs) as INTs, sum(gsPassYards)/sum(gsAttempts) as Avg, ((GREATEST(0, LEAST(2.375,((((SUM(gsComps) / SUM(gsAttempts)) * 100) - 30) * .05))) + GREATEST(0, LEAST(2.375,(((SUM(gsPassYards) / SUM(gsAttempts)) - 3) * .25))) + LEAST(2.375, ((SUM(gsPassTDs) / SUM(gsAttempts)) *20)) + GREATEST(0, (2.375 -((SUM(gsINTs) / SUM(gsAttempts)) * 25))))*50/3) AS nfl_rating, CASE WHEN (pPC>=63 OR (pPC=56 AND pPS>=69 AND pMS>=13) OR (pPC=56 AND pMS>=25)) THEN 'A' WHEN (pPC=50 OR (pPC=56 AND pPS<=63 AND pMS<=19) OR (pPC=44 AND pPS>=69 AND pMS>=13) OR (pPC=44 AND pMS>=25)) THEN 'B' ELSE 'C' END AS Grade , tttID, pNumber, COUNT(DISTINCT(gsgUID)) as gp, pInjured from player_atts, tecmoplayer, standings, game_stats where pUID = pID AND pttUID = ttTecmoOrder AND pUID = gspUID AND plUID = 1 AND gslUID = plUID AND ttlUID = gslUID AND gsSeason = 2010 AND tttID = gsTeam AND psUID = gsSeason AND gsTeam = tttID AND psUID = ttsUID AND gsWeek <= 20 AND pPos = 0 group by gspUID, gsTeam having sum(gsAttempts) > 0 order by desc, nfl_rating desc, compPerc desc

Username:
Password:

Remember Me