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

Ennepetal

Temporada 2023/2024

TEMPORADA 2023/2024

OBERLIGA GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	Sportfreunde	31	80	31	67
2	Türkspor	31	73	39	65
3	Dortmund	31	54	33	61
4	SpVgg	31	72	47	60
5	Gievenbeck	31	57	31	55
6	Preußen	30	58	36	50
7	Siegen	31	62	42	49
8	SpVgg Vreden	31	50	41	49
9	Schermbeck	31	58	59	48
10	Finnentrop/B	31	62	75	40
11	Westfalia	31	41	54	35
12	Ennepetal	31	44	65	34
13	Wattenscheid	31	42	62	31
14	Victoria	31	39	59	29
15	Eintracht	31	43	70	29
16	Bovinghausen	31	38	80	29
17	Brünninghau	30	38	62	25
18	Sprockhövel	31	41	66	22

TEMPORADA 2022/2023

OBERLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Gutersloh	34	67	38	72
2	Preußen	34	82	46	65
3	Paderborn	34	53	23	64
4	Sportfreunde	34	64	43	60
5	Bovinghausen	34	73	59	53
6	Westfalia	34	52	48	52
7	Dortmund	34	51	55	49
8	Victoria	34	53	48	48
9	Finnentrop/B	34	66	56	47
10	Eintracht	34	52	60	46
11	SpVgg Vreden	34	59	67	43
12	Schermbeck	34	43	56	39
13	Gievenbeck	34	48	50	36
14	Siegen	34	50	54	35
15	Sprockhövel	34	48	69	35
16	Ennepetal	34	32	59	35
17	Erndtebrück	34	47	85	34
18	Delbrücker	34	47	71	32

TEMPORADA 2021/2022

OBERLIGA GRUPO 28
Equipo		PJ	GF	GC	Puntos
1	SpVgg Vreden	10	23	12	20
2	Meinerzhagen	10	17	12	19
3	Victoria	10	23	12	18
4	Preußen	10	27	19	16
5	Finnentrop/B	10	24	18	16
6	Holzwickeder	10	21	18	16
7	Ennepetal	10	18	20	14
8	Sprockhövel	10	17	11	13
9	Hammer SpVg	10	15	19	12
10	TuS Haltern	10	9	24	6
11	Westfalia	10	10	39	3

TEMPORADA 2020/2021

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Gutersloh	9	16	3	25
2	Holzwickeder	6	20	4	18
3	Westfalia	8	21	10	18
4	Sprockhövel	7	19	10	18
5	Dortmund	9	21	17	18
6	Kaan-Marienb	7	27	7	16
7	Meinerzhagen	8	18	11	15
8	SpVgg Vreden	9	19	13	14
9	Wattenscheid	9	14	10	14
10	Siegen	10	11	13	14
11	Preußen	9	14	15	12
12	Ennepetal	7	18	14	11
13	TuS Haltern	10	10	25	10
14	Erndtebrück	8	6	14	9
15	Paderborn	8	18	22	8
16	Schermbeck	7	10	14	7
17	Finnentrop/B	10	14	20	7
18	Eintracht	10	14	28	7
19	Victoria	7	9	17	6
20	Westfalia	8	5	20	1
21	Hammer SpVg	8	8	25	0

TEMPORADA 2019/2020

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Wiedenbrück	20	35	23	41
2	Meinerzhagen	20	41	18	39
3	Weiss Ahlen	18	30	17	36
4	Paderborn	22	40	36	34
5	Eintracht	20	38	29	32
6	Holzwickeder	20	39	38	31
7	Kaan-Marienb	21	40	30	30
8	Ennepetal	20	39	34	30
9	Gutersloh	21	28	27	29
10	Schermbeck	21	26	29	29
11	Westfalia	18	28	15	28
12	Preußen	20	30	28	28
13	Dortmund	21	30	30	27
14	Westfalia	21	29	37	24
15	Siegen	19	34	33	22
16	Sprockhövel	21	25	40	19
17	Erndtebrück	21	26	55	14
18	Hammer SpVg	20	15	54	5

TEMPORADA 2018/2019

OBERLIGA GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Schalke	34	93	21	85
2	TuS Haltern	34	63	26	70
3	Dortmund	34	60	37	64
4	Sprockhövel	34	73	53	51
5	Westfalia	34	50	53	49
6	Paderborn	34	70	64	46
7	Westfalia	34	58	60	45
8	Schermbeck	34	43	55	45
9	Weiss Ahlen	34	61	62	44
10	Gutersloh	34	48	61	44
11	Holzwickeder	34	52	55	42
12	Hammer SpVg	34	49	58	42
13	Siegen	34	42	59	42
14	Ennepetal	34	44	57	41
15	Erndtebrück	34	49	56	40
16	Eintracht	34	47	81	40
17	Brünninghau	34	42	62	37
18	Gievenbeck	34	40	64	29

TEMPORADA 2017/2018

OBERLIGA GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Lippstadt	30	56	33	60
2	Kaan-Marienb	30	47	29	60
3	Dortmund	30	70	44	59
4	Hammer SpVg	30	64	31	55
5	TuS Haltern	30	44	36	54
6	Schalke	30	51	24	53
7	Brünninghau	30	62	55	50
8	Eintracht	30	54	62	41
9	Westfalia	30	52	56	37
10	Sprockhövel	30	52	58	35
11	Siegen	30	46	54	33
12	Ennepetal	30	41	59	32
13	Paderborn	30	50	57	29
14	Weiss Ahlen	30	41	58	29
15	Arminia	30	33	67	23
16	Gutersloh	30	24	64	21
17	Marl Hüls	0	0	0	0
18	SC Hassel	0	0	0	0

TEMPORADA 2016/2017

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Erndtebrück	34	73	34	67
2	Westfalia	34	62	41	64
3	Hammer SpVg	34	56	40	62
4	Hüls	34	74	62	56
5	Lippstadt	34	60	43	55
6	Eintracht	34	60	53	54
7	Kaan-Marienb	34	38	40	48
8	Ennepetal	34	40	45	46
9	SC Hassel	34	43	48	45
10	Brünninghau	34	45	47	43
11	Gutersloh	34	53	55	43
12	Paderborn	34	46	50	43
13	Arminia	34	48	42	42
14	Dortmund	34	61	61	41
15	Roland	34	38	56	41
16	Neuenkirchen	34	60	67	41
17	Stadtlohn	34	40	63	31
18	SpVgg	34	33	83	19

TEMPORADA 2015/2016

OBERLIGA GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Siegen	34	59	31	64
2	SpVgg	34	62	38	63
3	Sprockhövel	34	73	48	61
4	Roland	34	67	48	60
5	Westfalia	34	78	50	59
6	Lippstadt	34	58	44	55
7	Eintracht	34	59	54	55
8	Neuenkirchen	34	66	63	52
9	Hüls	34	66	65	48
10	Arminia	34	57	58	43
11	Ennepetal	34	62	60	42
12	Gutersloh	34	52	61	42
13	Stadtlohn	34	49	60	42
14	Hammer SpVg	34	50	65	41
15	Dortmund	34	55	87	38
16	Paderborn	34	49	63	36
17	Schermbeck	34	49	78	31
18	Zweckel	34	40	78	28

TEMPORADA 2014/2015

OBERLIGA GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Erndtebrück	33	71	22	70
2	Weiss Ahlen	33	70	39	67
3	Westfalia	33	72	33	64
4	Roland	33	60	35	64
5	SpVgg	33	53	32	58
6	Lippstadt	33	63	35	57
7	Arminia	33	61	54	48
8	Stadtlohn	33	51	58	48
9	Hammer SpVg	33	43	56	43
10	Ennepetal	33	47	56	42
11	Eintracht	33	50	62	40
12	Dortmund	33	54	71	39
13	Gutersloh	33	37	50	38
14	Neuenkirchen	33	42	65	33
15	Sprockhövel	33	36	62	31
16	Hüls	33	50	73	30
17	Westfalia	33	38	66	28
18	Zweckel	33	30	59	26

TEMPORADA 2013/2014

OBERLIGA GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Arminia	34	87	33	86
2	Rödinghause	34	80	33	72
3	SpVgg	34	78	39	70
4	Neuenkirchen	34	81	50	64
5	Erndtebrück	34	54	44	55
6	Roland	34	50	52	55
7	Westfalia	34	43	38	48
8	Eintracht	34	57	61	48
9	Weiss Ahlen	34	54	62	48
10	Gutersloh	34	49	57	45
11	Sprockhövel	34	48	53	44
12	Ennepetal	34	59	50	43
13	Hammer SpVg	34	56	65	42
14	Zweckel	34	47	65	41
15	Westfalia	34	39	65	29
16	Hüls	34	40	69	29
17	Heven	34	41	88	25
18	Dornberg	34	30	69	16

TEMPORADA 2012/2013

OBERLIGA GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	Lippstadt	34	75	25	75
2	Wattenscheid	34	70	37	73
3	Arminia	34	70	35	66
4	Erndtebrück	34	68	47	63
5	SpVgg	34	63	42	60
6	Westfalia	34	61	52	52
7	Neuenkirchen	34	60	62	47
8	Gutersloh	34	46	48	46
9	Weiss Ahlen	34	51	62	46
10	Sprockhövel	34	41	40	45
11	Roland	34	53	66	44
12	Hammer SpVg	34	46	51	39
13	Heven	34	51	67	38
14	Ennepetal	34	50	64	36
15	Dornberg	34	53	69	33
16	Westfalia	34	44	66	33
17	Schermbeck	34	44	79	31
18	Gievenbeck	34	32	66	18

Competiciones que juega

Grupo 12

Oberliga Grupo 12

Pos	Equipos		Pts
1		Sportfreunde Lotte	67
2		Türkspor Dortmund	65
3		ASC 09 Dortmund	61
4		SpVgg Erkenschwick	60
5		Gievenbeck	55
6		Preußen Münster II	50
7		Siegen Sportfreunde	49
8		SpVgg Vreden	49
9		Schermbeck	48
10		Finnentrop/Bamenohl	40
11		Westfalia Rhynern	35
12		Ennepetal	34
13		Wattenscheid 09	31
14		Victoria Clarholz	29
15		Eintracht Rheine	29
16		TuS Bovinghausen	29
17		Brünninghausen	25
18		Sprockhövel	22

	Ascenso : Sportfreunde Lotte, Türkspor Dortmund
	Descenso : Brünninghausen, Sprockhövel

RIVALES EN Oberliga

USO DE MEMORIA

6,438,640 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1330
Total Execution Time	0.1342

CADENA URL

/historico/Ennepetal

GET DATOS

$_GET['/historico/Ennepetal']

POST DATOS

No hay datos POST existentes

CONSULTAS (30)

0.0041	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 = 72710
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61609 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 = '61609' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022	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 = 72710 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026	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=61609 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (72710,67320) 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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 72710 AND teamId = 61609
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 61609
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 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 = 72710 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021	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 = '61609' 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 = '61609' and rp.type = 4
0.0021	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 = '61609' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0040	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 = 72710 WHERE rp.league_id = 72710 AND rp.teamId = 61609 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.0031	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 = 72710 WHERE rp.league_id = 72710 AND rp.teamId = 61609 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 72710 WHERE rp.league_id = 72710 AND rp.teamId = 61609 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023	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 = 61609 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72710 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 68216 AND t.round = 34 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* `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 = 63363 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.0021	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 = 67305 AND t.round = 11 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* `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 = 57811 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036	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 = 50470 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.0039	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* `tables2019` 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 = 44367 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037	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 = 39085 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044	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 = 33887 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043	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 = 15552 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043	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 = 9468 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0054	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 = 9577 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0073	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 = 19817 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72710 ORDER BY nameShow LIMIT 100

Ennepetal

Ennepetal

Selecciona un equipo

Competiciones que juega

Oberliga Grupo 12

RIVALES EN Oberliga