Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Pforzheim

Temporada 2006/2007

TEMPORADA 2006/2007

OBERLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Sandhausen	34	91	36	77
2	Ulm	34	84	29	76
3	Heidenheim	34	75	36	72
4	Villingen	34	66	56	56
5	Freiberg	34	54	44	54
6	Crailsheim	34	65	53	53
7	Freiburg II	34	62	43	52
8	Hoffenheim	34	62	53	51
9	Stuttgarter	34	61	61	49
10	Waldhof	34	43	39	48
11	Normannia	34	36	51	40
12	Bahlinger	34	51	63	39
13	Sonnenhof	34	46	73	39
14	Nottingen	34	42	54	37
15	Mannheim	34	45	60	35
16	Pforzheim	34	27	66	29
17	Emmendingen	34	26	65	26
18	Bonlanden	34	20	74	22

TEMPORADA 2002/2003

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Stuttgart	34	72	24	78
2	Ulm	34	71	44	69
3	Freiburg II	34	52	23	65
4	Sandhausen	34	59	46	56
5	SpVgg	34	57	49	50
6	Lauda	34	42	40	49
7	Stuttgarter	34	37	41	49
8	Nottingen	34	50	47	47
9	Bonlanden	34	49	46	47
10	Waldhof	34	44	49	43
11	Freiberg	34	51	57	41
12	Pforzheim	34	52	69	41
13	SpVgg Au	34	44	44	39
14	Bahlinger	34	41	57	39
15	Karlsruher	34	49	56	38
16	FC Teningen	34	43	69	35
17	Villingen	34	36	68	33
18	Sportfreunde	34	37	57	29

TEMPORADA 2001/2002

OBERLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Pfullendorf	34	82	35	80
2	Sandhausen	34	63	32	68
3	Pforzheim	34	70	52	58
4	SpVgg Au	34	64	49	55
5	SpVgg	34	61	51	53
6	Waldhof	34	61	54	47
7	Freiburg II	34	49	43	47
8	Stuttgarter	34	56	56	46
9	Bahlinger	34	60	62	46
10	Lauda	34	35	36	45
11	Karlsruher	34	43	51	44
12	Sportfreunde	34	50	51	43
13	Freiberg	34	57	62	43
14	Villingen	34	46	64	41
15	Heilbronn	34	39	60	39
16	Weinheim	34	51	75	38
17	Ditzingen	34	38	59	33
18	Denzlingen	34	36	69	25

TEMPORADA 2000/2001

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Hoffenheim	34	80	33	72
2	Pforzheim	34	88	47	70
3	Heilbronn	34	65	56	62
4	Sandhausen	34	69	44	57
5	Lauda	34	47	50	52
6	Freiburg II	34	59	45	50
7	Sportfreunde	34	57	58	48
8	Karlsruher	34	55	52	47
9	SpVgg Au	34	58	58	47
10	SpVgg	34	56	67	47
11	Stuttgarter	34	70	64	43
12	Bahlinger	34	51	56	42
13	Denzlingen	34	40	53	41
14	Ditzingen	34	48	64	41
15	Heidelberg	34	53	68	38
16	Bonlanden	34	42	62	36
17	Kirchheim/Te	34	49	58	34
18	FC Teningen	34	39	91	15

TEMPORADA 1999/2000

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Sandhausen	30	68	24	70
2	Lauda	30	49	30	56
3	Heidelberg	30	62	42	52
4	SpVgg	30	55	43	51
5	SpVgg Au	30	51	43	47
6	Freiburg II	30	42	28	46
7	Pforzheim	30	54	43	46
8	Kirchheim/Te	30	43	43	43
9	Bahlinger	30	53	57	41
10	Heilbronn	30	48	47	40
11	Bonlanden	30	40	36	39
12	Denzlingen	30	41	45	35
13	FV Biberach	30	35	55	30
14	Ravensburg	30	35	66	25
15	Weinheim	30	26	64	20
16	Singen 04	30	27	63	17

TEMPORADA 1998/1999

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	VfR Aalen	30	51	26	60
2	Sandhausen	30	44	23	59
3	Pforzheim	30	49	32	50
4	Lauda	30	50	35	48
5	Freiburg II	30	57	39	45
6	Bahlinger	30	58	54	45
7	Kirchheim/Te	30	40	38	45
8	Heidelberg	30	47	43	42
9	SpVgg	30	51	48	39
10	Singen 04	30	43	46	38
11	Bonlanden	30	30	42	38
12	Ravensburg	30	41	54	36
13	FV Biberach	30	38	45	32
14	Sportfreunde	30	36	44	32
15	Böblingen	30	31	50	31
16	Steinen-Höl	30	23	70	14

TEMPORADA 1997/1998

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Stuttgart	30	63	23	71
2	Pfullendorf	30	50	32	57
3	SpVgg	30	47	29	53
4	FV Biberach	30	46	35	51
5	Pforzheim	30	53	42	48
6	VfR Aalen	30	42	31	45
7	Sandhausen	30	52	45	44
8	Bahlinger	30	56	53	44
9	Singen 04	30	38	46	39
10	Böblingen	30	45	44	37
11	Bonlanden	30	35	50	35
12	Lauda	30	37	41	32
13	Steinen-Höl	30	40	51	30
14	Wäldenbronn	30	30	54	25
15	Heilbronn	30	38	66	24
16	Bammental	30	42	72	24

TEMPORADA 1996/1997

OBERLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Kirchheim/Te	30	58	16	66
2	Pforzheim	30	65	20	64
3	Stuttgart	30	49	17	57
4	Sandhausen	30	58	31	54
5	Bahlinger	30	42	48	44
6	Pfullendorf	30	60	58	42
7	Bonlanden	30	46	39	40
8	Wäldenbronn	30	53	52	40
9	FV Biberach	30	44	48	40
10	VfR Aalen	30	50	43	38
11	Bammental	30	45	73	38
12	Böblingen	30	40	42	37
13	Heidelberg	30	40	47	34
14	Linx	30	38	57	30
15	ASV Durlach	30	42	62	27
16	Oftersheim	30	27	104	11

TEMPORADA 1995/1996

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Karlsruher	30	56	27	62
2	Stuttgart	30	53	31	60
3	Pforzheim	30	52	31	59
4	VfR Aalen	30	42	28	52
5	Pfullendorf	30	33	21	50
6	Linx	30	45	40	41
7	Bonlanden	30	45	38	39
8	Wäldenbronn	30	48	46	39
9	Kirchheim/Te	30	39	43	39
10	Bammental	30	56	64	39
11	FV Biberach	30	42	52	35
12	ASV Durlach	30	39	52	34
13	FC Wangen	30	43	47	32
14	Gaggenau	30	33	53	29
15	Geislingen	30	43	64	28
16	Amicitia	30	38	70	18

TEMPORADA 1966/1967

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Bayern Hof	34	81	44	71
2	Kickers	34	65	33	70
3	Greuther	34	80	36	68
4	Stuttgarter	34	85	48	65
5	Mannheim	34	61	43	57
6	Reutlingen	34	59	44	56
7	Freiburger	34	62	50	52
8	Hessen	34	61	62	50
9	Schweinfurt	34	43	47	50
10	Schwaben	34	64	63	47
11	Waldhof	34	50	57	45
12	Opel	34	51	60	40
13	Frankfurt	34	37	58	40
14	Villingen	34	47	76	36
15	Darmstadt	34	45	55	35
16	FC Augsburg	34	49	73	35
17	Germania	34	28	73	21
18	Pforzheim	34	26	72	16

TEMPORADA 1965/1966

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Schweinfurt	34	74	39	71
2	Kickers	34	78	48	68
3	Waldhof	34	78	60	57
4	Greuther	34	70	52	54
5	Stuttgarter	34	65	52	51
6	Hessen	34	70	62	49
7	Pforzheim	34	48	46	49
8	Reutlingen	34	60	50	48
9	Opel	34	58	61	47
10	Darmstadt	34	54	71	47
11	Bayern Hof	34	71	63	46
12	Schwaben	34	66	62	46
13	Frankfurt	34	61	76	46
14	Mannheim	34	55	60	43
15	Ingolstadt	34	63	75	41
16	Freiburger	34	55	59	40
17	Weiden	34	51	64	37
18	Pforzheim	34	45	122	15

TEMPORADA 1964/1965

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Bayern	36	146	32	79
2	Reutlingen	36	87	45	75
3	Kickers	36	91	63	67
4	Waldhof	36	74	50	65
5	Hessen	36	74	52	57
6	Mannheim	36	66	53	55
7	Greuther	36	72	62	55
8	Stuttgarter	36	69	59	55
9	Bayern Hof	36	65	58	52
10	Frankfurt	36	52	59	51
11	Ingolstadt	36	55	65	47
12	Schweinfurt	36	49	55	46
13	Freiburger	36	60	68	46
14	Pforzheim	36	47	61	46
15	Darmstadt	36	49	66	44
16	Schwaben	36	61	73	41
17	Wacker	36	54	86	37
18	Ulm	36	53	90	33
19	Emmendingen	36	31	158	5

TEMPORADA 1963/1964

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hessen	38	116	61	80
2	Bayern	38	115	61	74
3	Kickers	38	96	66	71
4	Schwaben	38	77	56	68
5	Reutlingen	38	76	61	66
6	Mannheim	38	68	50	63
7	Ulm	38	73	74	62
8	Schweinfurt	38	82	55	60
9	Greuther	38	68	61	53
10	Freiburger	38	58	61	51
11	Waldhof	38	56	60	51
12	Ingolstadt	38	61	81	47
13	Bayern Hof	38	61	64	45
14	Stuttgarter	38	54	74	45
15	Pforzheim	38	51	75	45
16	Frankfurt	38	69	85	44
17	Neu-Isenburg	38	49	80	38
18	FC Augsburg	38	48	90	35
19	Borussia	38	53	77	34
20	Amicitia	38	47	86	30

Competiciones que juega

Oberliga Grupo 7

Pos	Equipos		Pts
1		Sandhausen	77
2		Ulm	76
3		Heidenheim	72
4		Villingen	56
5		Freiberg	54
6		Crailsheim	53
7		Freiburg II	52
8		Hoffenheim II	51
9		Stuttgarter Kickers II	49
10		Waldhof Mannheim	48
11		Normannia Gmünd	40
12		Bahlinger SC	39
13		SG Sonnenhof Großaspach	39
14		Nottingen	37
15		VfR Mannheim	35
16		Pforzheim	29
17		FC Emmendingen	26
18		Bonlanden	22

RIVALES EN Oberliga

USO DE MEMORIA

6,612,912 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.8390
Total Execution Time	0.8402

CADENA URL

/historico/Pforzheim

GET DATOS

$_GET['/historico/Pforzheim']

POST DATOS

No hay datos POST existentes

CONSULTAS (56)

0.0131	SELECT dt.,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM* `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Pforzheim' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0143	SELECT dt.,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM* `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Pforzheim' ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0131	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=65529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0139	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 19881
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65529 AND type_rel = 2
0.0129	SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '65529' AND l.year = 2007 ORDER BY l.year DESC,cat.coefficient DESC
0.0128	SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '65529' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128	SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '65529' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 19881 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128	SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=65529 AND l.year in (2006,2007,2008) ORDER BY l.id DESC, l.year DESC ;
0.0125	SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (19881) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 19881 AND teamId = 65529
0.0130	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2007` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 19881 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0136	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2007 e ON e.player_id = p.id AND e.league_id = 19881 WHERE rp.league_id = 19881 AND rp.teamId = 65529 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2007 e ON e.player_id = p.id AND e.league_id = 19881 WHERE rp.league_id = 19881 AND rp.teamId = 65529 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2007 e ON e.player_id = p.id AND e.league_id = 19881 WHERE rp.league_id = 19881 AND rp.teamId = 65529 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 65529 AND l.year <= 2007 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0132	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2007` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 19881 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2003` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 28309 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2002` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 28308 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2001` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 28319 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2000` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 28338 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1999` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 28347 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1998` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 28349 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1997` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 28365 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1996` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 28372 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1967` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 22860 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1966` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 22865 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1965` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 22897 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1964` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 22890 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Pforzheim

Pforzheim

Selecciona un equipo

Competiciones que juega

Oberliga Grupo 7

RIVALES EN Oberliga