Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

Gonsenheim

Temporada 2023/2024

TEMPORADA 2023/2024

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Eintracht	34	105	27	92
2	Gonsenheim	35	88	42	71
3	Pirmasens	35	79	40	65
4	Wormatia	35	71	45	63
5	Kaiserslaute	35	74	58	59
6	Auersmacher	35	61	59	58
7	RW Koblenz	35	64	56	55
8	Engers 07	35	70	54	53
9	Diefflen	35	70	74	52
10	Morlautern	34	57	63	50
11	Karbach	35	64	82	48
12	Arminia	35	55	71	47
13	Mechtersheim	34	59	49	45
14	Cosmos	35	61	65	41
15	Dudenhofen	34	52	56	39
16	Alemannia	35	38	60	37
17	Baumholder	35	53	77	32
18	Pfeddersheim	35	45	86	30
19	SpVgg	35	34	75	26
20	FC Bitburg	35	43	104	17

TEMPORADA 2022/2023

OBERLIGA GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Schott Mainz	30	90	28	70
2	TuS Koblenz	30	59	20	69
3	Pirmasens	30	66	34	62
4	Gonsenheim	30	70	38	53
5	Engers 07	30	57	36	52
6	Mechtersheim	30	55	46	48
7	Kaiserslaute	30	58	43	46
8	Diefflen	30	60	63	46
9	Karbach	30	63	47	44
10	Auersmacher	30	57	52	42

TEMPORADA 2021/2022

OBERLIGA GRUPO 21
Equipo		PJ	GF	GC	Puntos
1	Eintracht	34	83	28	79
2	Wormatia	34	94	26	79
3	Arminia	34	81	59	63
4	Hertha	34	91	63	62
5	Dudenhofen	34	80	50	57
6	Engers 07	34	60	49	57
7	Gonsenheim	34	61	55	51
8	Diefflen	34	66	67	50
9	Alemannia	34	58	58	50
10	Karbach	34	60	63	46
11	Mechtersheim	34	61	64	45
12	TuS Koblenz	34	49	57	40

TEMPORADA 2020/2021

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Eintracht	8	21	2	22
2	Kaiserslaute	8	16	9	16
3	Hassia	9	19	15	16
4	Alemannia	8	16	11	13
5	TuS Koblenz	9	7	10	13
6	Gonsenheim	8	12	8	11
7	Engers 07	6	13	8	10
8	Mülheim-Kä	6	10	13	9
9	Karbach	8	8	17	8
10	Salmrohr	9	8	18	6
11	Sportfreunde	7	5	12	5
12	Emmelshausen	8	6	18	5
13	Wormatia	9	29	8	24
14	Dudenhofen	9	17	11	17
15	Diefflen	9	17	13	14
16	Arminia	9	14	13	13
17	Jägersburg	9	17	24	13
18	Rochling	9	13	13	11
19	Pfeddersheim	9	15	16	11
20	Elversberg	9	9	12	11
21	Mechtersheim	9	8	13	10
22	Hertha	9	24	22	8
23	FV Speyer	8	13	16	8
24	Eppelborn	8	11	26	4

TEMPORADA 2019/2020

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Schott Mainz	21	49	20	42
2	Kaiserslaute	21	47	25	40
3	Elversberg	21	55	37	40
4	TuS Koblenz	21	34	24	39
5	Eintracht	20	33	20	37
6	Dudenhofen	21	43	31	35
7	Wormatia	20	42	33	33
8	Gonsenheim	21	44	36	31
9	Diefflen	21	36	31	29
10	Pfeddersheim	21	45	46	28
11	Engers 07	21	29	30	28
12	Rochling	21	38	45	26
13	Hertha	21	36	48	25
14	Arminia	21	21	36	24
15	Karbach	21	32	50	21
16	Mechtersheim	21	20	34	19
17	Hassia	21	22	46	19
18	Sportfreunde	21	25	59	14

TEMPORADA 2017/2018

OBERLIGA GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Homburg	36	112	20	96
2	Pirmasens	36	97	31	79
3	Kaiserslaute	36	89	29	77
4	Eintracht	36	65	36	71
5	Diefflen	36	81	61	63
6	Jägersburg	36	68	60	55
7	RW Koblenz	36	66	60	52
8	Hertha	36	62	72	48
9	Mechtersheim	36	58	73	47
10	Karbach	36	65	75	44
11	Idar-Oberste	36	53	57	43
12	Pfeddersheim	36	48	66	43
13	Engers 07	36	47	69	42
14	Dudenhofen	36	41	72	40
15	Gonsenheim	36	57	68	39
16	Morlautern	36	46	79	30
17	Salmrohr	36	32	71	28
18	Saar	36	36	74	27
19	Eppelborn	36	51	101	24

TEMPORADA 2016/2017

OBERLIGA GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Schott Mainz	34	110	41	74
2	Rochling	34	83	41	70
3	Hertha	34	95	50	67
4	Mechtersheim	34	78	52	62
5	RW Koblenz	34	65	51	57
6	Karbach	34	82	53	55
7	Saar	34	67	44	52
8	Pirmasens	34	68	52	52
9	Gonsenheim	34	71	60	52
10	Diefflen	34	87	71	51
11	Pfeddersheim	34	75	54	46
12	Morlautern	34	57	49	46
13	Hauenstein	34	65	55	41
14	Jägersburg	34	65	74	38
15	Salmrohr	34	57	68	37
16	Arminia	34	52	72	32
17	Borussia	34	46	71	31
18	Burgbrohl	34	9	255	1

TEMPORADA 2015/2016

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	TuS Koblenz	33	73	23	79
2	Hauenstein	33	55	29	65
3	Karbach	33	53	46	57
4	Borussia	33	57	44	54
5	Hertha	34	65	52	53
6	Pfeddersheim	33	53	40	47
7	Rochling	33	45	41	46
8	Burgbrohl	34	57	62	45
9	Jägersburg	33	52	59	45
10	Salmrohr	33	52	49	44
11	Wirges	33	42	46	44
12	Gonsenheim	33	52	60	44
13	Schott Mainz	33	74	65	42
14	Arminia	33	49	62	41
15	Pirmasens	33	48	47	40
16	Elversberg	33	57	70	37
17	Mehring	33	42	64	31
18	Zweibrücken	19	7	74	3

TEMPORADA 2014/2015

OBERLIGA GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Saar	34	56	22	70
2	Hauenstein	34	60	27	68
3	Pfeddersheim	34	49	28	65
4	Gonsenheim	34	63	42	59
5	Rochling	34	62	47	59
6	Schott Mainz	34	70	59	55
7	Salmrohr	34	58	54	55
8	Wirges	34	55	32	54
9	Elversberg	34	62	52	54
10	Hertha	34	61	56	46
11	Arminia	34	62	64	46
12	Borussia	34	51	47	44
13	Burgbrohl	34	45	53	41
14	Idar-Oberste	34	47	55	39
15	Mechtersheim	34	59	62	37
16	Diefflen	34	44	83	29
17	Saarbrücken	34	40	91	17
18	Betzdorf	34	21	91	16

TEMPORADA 2013/2014

OBERLIGA GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	Pirmasens	34	62	29	65
2	Salmrohr	34	57	32	60
3	Hauenstein	34	55	41	55
4	Arminia	34	62	47	51
5	Elversberg	34	53	51	50
6	Idar-Oberste	34	53	41	48
7	Pfeddersheim	34	50	42	48
8	Hertha	34	62	62	47
9	Gonsenheim	34	51	61	46
10	Burgbrohl	34	54	68	43
11	Saarbrücken	34	43	53	42
12	Betzdorf	34	45	53	41
13	Mechtersheim	34	50	49	40
14	Rochling	34	37	56	40
15	Borussia	34	36	49	39
16	Mehring	34	48	68	39
17	Alemannia	34	50	53	37
18	Roßbach	34	43	56	37

TEMPORADA 2012/2013

OBERLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Zweibrücken	34	70	23	81
2	Salmrohr	34	86	34	73
3	Hauenstein	34	74	51	66
4	Saarbrücken	34	68	45	58
5	Borussia	34	48	39	56
6	Arminia	34	60	50	51
7	Mechtersheim	34	51	52	50
8	Pirmasens	34	50	50	49
9	Betzdorf	34	53	58	47
10	Rochling	34	53	58	46
11	Pfeddersheim	34	46	46	43
12	Roßbach	34	45	57	42
13	Mehring	34	46	55	41
14	Gonsenheim	34	53	65	41
15	Elversberg	34	54	54	38
16	Wirges	34	40	57	38
17	Halberg	34	28	79	18
18	Köllerbach	34	37	89	16

TEMPORADA 2011/2012

OBERLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Homburg	34	71	34	71
2	Zweibrücken	34	52	34	61
3	Pirmasens	34	58	36	60
4	Arminia	34	59	49	57
5	Hauenstein	34	57	52	51
6	Salmrohr	34	63	45	50
7	Borussia	34	55	49	50
8	Gonsenheim	34	53	58	49
9	Saarbrücken	34	49	45	46
10	Wirges	34	41	43	46
11	Mechtersheim	34	37	42	45
12	Elversberg	34	51	52	43
13	Rochling	34	49	54	43
14	Betzdorf	34	51	58	43
15	Roßbach	34	50	64	41
16	Köllerbach	34	48	65	38
17	Alemannia	34	41	57	37
18	Eintracht	34	38	86	20

TEMPORADA 2010/2011

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Idar-Oberste	36	69	35	67
2	Pirmasens	36	51	40	63
3	Betzdorf	36	55	43	60
4	Hauenstein	36	61	53	58
5	Zweibrücken	36	49	32	55
6	Köllerbach	36	57	46	55
7	Borussia	36	60	54	54
8	Mechtersheim	36	62	52	53
9	Elversberg	36	48	51	50
10	Eintracht	36	53	59	47
11	Wirges	36	42	52	47
12	Alemannia	36	58	65	46
13	Roßbach	36	46	55	46
14	Saarbrücken	36	61	54	45
15	Gonsenheim	36	57	62	45
16	Rot-Weiß	36	47	52	44
17	Bad Breisig	36	57	71	37
18	Auersmacher	36	44	79	36
19	Sportfreunde	36	36	58	33

Competiciones que juega

Grupo 8

Oberliga Grupo 8

Pos	Equipos		Pts
1		Eintracht Trier	92
2		Gonsenheim	71
3		FK Pirmasens	65
4		Wormatia Worms	63
5		Kaiserslautern II	59
6		Auersmacher	58
7		RW Koblenz	55
8		Engers 07	53
9		Diefflen	52
10		Morlautern	50
11		Karbach	48
12		Arminia Ludwigshafen	47
13		Mechtersheim	45
14		Cosmos Koblenz	41
15		Dudenhofen	39
16		Alemannia Waldalgesheim	37
17		VfR Baumholder	32
18		Pfeddersheim	30
19		SpVgg Quierschied	26
20		FC Bitburg	17

	Playoff Ascenso : Eintracht Trier
	Descenso : Mechtersheim, Cosmos Koblenz, Dudenhofen, Alemannia Waldalgesheim, VfR Baumholder, Pfeddersheim, SpVgg Quierschied, FC Bitburg

RIVALES EN Oberliga

USO DE MEMORIA

6,741,088 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1229
Total Execution Time	0.1248

CADENA URL

/historico/Gonsenheim

GET DATOS

$_GET['/historico/Gonsenheim']

POST DATOS

No hay datos POST existentes

CONSULTAS (31)

0.0040	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 = 72627
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61563 AND type_rel = 2
0.0022	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 = '61563' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 72627 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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=61563 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (72627,71432) 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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 72627 AND teamId = 61563
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 61563
0.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2024` 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 = 72627 AND t.round = 35 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020	SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '61563' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61563' and rp.type = 4
0.0020	SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '61563' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0041	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 events2024 e ON e.player_id = p.id AND e.league_id = 72627 WHERE rp.league_id = 72627 AND rp.teamId = 61563 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.0032	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 events2024 e ON e.player_id = p.id AND e.league_id = 72627 WHERE rp.league_id = 72627 AND rp.teamId = 61563 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030	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 events2024 e ON e.player_id = p.id AND e.league_id = 72627 WHERE rp.league_id = 72627 AND rp.teamId = 61563 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 61563 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0025	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* `tables2024` 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 = 72627 AND t.round = 35 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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* `tables2023` 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 = 68315 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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* `tables2023` 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 = 71185 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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* `tables2022` 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 = 63289 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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* `tables2022` 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 = 66977 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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* `tables2021` 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 = 57793 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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* `tables2020` 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 = 50467 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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* `tables2018` 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 = 39086 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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* `tables2017` 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 = 34103 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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* `tables2016` 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 = 15544 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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* `tables2015` 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 = 9464 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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* `tables2014` 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 = 9574 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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* `tables2013` 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 = 19812 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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* `tables2012` 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 = 19826 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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* `tables2011` 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 = 19832 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Gonsenheim

Gonsenheim

Selecciona un equipo

Competiciones que juega

Oberliga Grupo 8

RIVALES EN Oberliga