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

Montehermoso

Entrenador: Raul Miranda

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA FEDERACIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Benito	33	62	13	73
2	CD Coria	33	58	19	69
3	CD Azuaga	33	47	31	59
4	Villafranca	33	43	26	52
5	Moralo	33	53	44	50
6	Castuera	33	46	37	49
7	Diocesano	33	47	46	46
8	CF Jaraíz	33	48	49	45
9	Calamonte	33	38	46	42
10	Jerez	33	41	49	42
11	Pueblonuevo	33	33	43	42
12	Olivenza	33	32	38	41
13	Arroyo	33	33	37	41
14	Trujillo	33	30	36	38
15	Montehermoso	33	33	54	32
16	Álvaro	33	28	48	31
17	Racing	33	31	56	29
18	Fuente	33	25	56	24

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Llerenense	30	52	22	64
2	CD Azuaga	30	58	29	62
3	Moralo	30	52	24	55
4	Olivenza	30	46	33	53
5	Jerez	30	39	25	49
6	Arroyo	30	30	31	46
7	Trujillo	30	28	28	44
8	Villafranca	30	34	33	43
9	Calamonte	30	38	33	42
10	Fuente	30	23	28	39
11	Pueblonuevo	30	36	41	32
12	Montehermoso	30	31	53	31
13	Álvaro	30	27	54	27
14	Miajadas	30	23	41	26
15	Plasencia	30	31	43	24
16	Estrella	30	30	60	21

TEMPORADA 2021/2022

1ª REGIONAL EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Montehermoso	22	50	11	49
2	Moraleja	22	56	19	45
3	CF Jaraíz	22	44	14	44
4	Amanecer	22	39	25	42
5	Talayuela	22	29	18	41
6	CF Caceres	22	34	24	31
7	Chinato	22	28	30	30
8	Valdefuentes	22	35	40	26
9	Ciudad	22	25	42	24
10	Malpartida	22	22	40	17
11	Piornal	22	19	60	15
12	Cabezuela	22	15	73	8

TEMPORADA 2020/2021

1ª REGIONAL EXTREMADURA GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	CP Cheles	5	8	7	8
2	Montehermoso	5	4	3	8
3	Santa Marta	5	10	6	7
4	Cabeza Buey	5	7	8	7
5	CD Zarceño	5	7	10	7
6	Hurdes	5	6	8	4

TEMPORADA 2019/2020

1ª REGIONAL EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Chinato	25	47	24	57
2	Amanecer	25	55	17	50
3	Montehermoso	25	38	29	48
4	Serván	25	49	40	46
5	Álvaro	25	61	38	44
6	Valdefuentes	25	68	39	43
7	Guareña	25	48	40	38
8	Malpartida	24	39	30	37
9	Talayuela	24	44	38	34
10	Moraleja	24	47	42	33
11	CF Jaraíz	24	34	45	29
12	Calamonte	25	37	51	28
13	Atlético	24	29	55	19
14	Hurdes	25	32	64	19
15	CD Zarceño	25	33	74	17
16	Piornal	24	16	51	16

TEMPORADA 2018/2019

1ª REGIONAL EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Trujillo	30	74	23	74
2	Montehermoso	30	42	18	62
3	Miajadas	30	51	19	60
4	Amanecer	30	60	29	59
5	Chinato	30	56	28	59
6	Santa Amalia	30	70	52	58
7	Talayuela	29	53	22	56
8	Malpartida	30	53	46	43
9	Olympic	30	33	46	34
10	Piornal	30	32	63	34
11	Hernán	30	39	48	30
12	Moraleja	30	44	62	30
13	Valdefuentes	30	46	67	23
14	Jorge	29	50	82	23
15	Hurdes	30	26	70	12
16	Ciudad	30	25	79	9

TEMPORADA 2017/2018

1ª REGIONAL EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Montehermoso	30	58	12	71
2	Miajadas	30	61	23	65
3	Chinato	30	47	26	54
4	Hernán	30	42	26	51
5	Moraleja	30	41	36	49
6	Talayuela	30	59	53	42
7	Álvaro	30	52	53	40
8	Hurdes	30	47	46	38
9	Olympic	30	54	56	38
10	Ciudad	30	36	45	38
11	Malpartida	30	46	51	35
12	Jorge	30	51	57	35
13	Piornal	30	37	55	33
14	Torviscal	30	42	60	31
15	Emérita	30	44	60	26
16	Plus Ultra	30	33	91	16

TEMPORADA 2016/2017

1ª REGIONAL EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Trujillo	30	66	21	72
2	Montehermoso	30	86	33	70
3	Diocesano	30	83	28	69
4	Ciudad	30	60	32	58
5	Miajadas	30	52	30	55
6	Hernán	30	41	42	46
7	Chinato	30	47	33	44
8	Talayuela	30	51	51	40
9	Jorge	30	54	62	37
10	Hurdes	29	33	46	37
11	Olympic	30	45	58	33
12	Plus Ultra	30	51	59	32
13	Moraleja	30	30	69	28
14	CF Jaraíz	29	32	73	21
15	Amanecer B	30	31	72	19
16	Navalmoral	30	38	91	15

TEMPORADA 2015/2016

PREFERENTE EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Plasencia	30	84	29	69
2	Trujillo	30	59	25	66
3	Diocesano	30	57	35	59
4	Ciudad	30	45	29	55
5	Serván	30	54	32	52
6	Miajadas	30	61	35	49
7	Jorge	30	59	48	45
8	Arroyo Cp B	30	48	37	45
9	Montehermoso	30	33	47	38
10	Talayuela	30	35	51	37
11	Hurdes	30	42	62	34
12	Chinato	30	40	55	31
13	Alburquerque	30	31	54	29
14	CF Jaraíz	30	34	63	27
15	Navalmoral	30	34	60	27
16	Ciconia	30	26	80	12

TEMPORADA 2014/2015

PREFERENTE EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Amanecer	30	66	15	75
2	Calamonte	30	83	20	63
3	Cacereño B	30	67	37	61
4	Diocesano	30	57	32	51
5	Jorge	30	60	57	43
6	Navalmoral	30	36	44	42
7	Talayuela	30	47	44	41
8	Arroyo Cp B	30	39	38	40
9	Ciudad	30	29	33	38
10	Chinato	30	42	57	37
11	Montehermoso	30	39	51	35
12	Ciconia	30	34	48	33
13	Trujillo	30	36	60	28
14	Miajadas	30	33	60	27
15	Moraleja	30	30	58	24
16	Malpartida	30	22	66	19

TEMPORADA 2013/2014

PREFERENTE EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sanvicenteñ	30	69	20	74
2	Moralo	30	80	21	71
3	Malpartida	30	55	26	64
4	Alburquerque	30	63	27	62
5	Talayuela	30	61	30	58
6	Arroyo Cp B	30	48	26	55
7	Moraleja	30	32	38	36
8	Montehermoso	30	40	55	36
9	Diocesano	30	46	45	35
10	Amanecer	30	30	56	30
11	Trujillo	30	41	60	30
12	Ciconia	30	30	58	29
13	Hurdes	30	29	67	27
14	Chinato	30	27	50	24
15	Casar	30	31	56	21
16	Valdefuentes	30	20	67	21

TEMPORADA 2012/2013

PREFERENTE EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sanvicenteñ	30	82	21	71
2	Diocesano	30	67	35	64
3	Malpartida	30	61	28	60
4	Montehermoso	30	50	30	59
5	Alburquerque	30	66	30	58
6	Casar	30	54	30	58
7	Arroyo Cp B	30	57	45	41
8	Valdefuentes	30	39	46	38
9	Trujillo	30	38	49	37
10	Cp Amanecer	30	40	51	36
11	Chinato	30	41	53	34
12	Ciconia	30	34	72	29
13	Moralo B	30	35	48	28
14	CF Jaraíz	30	35	74	22
15	CD Coria B	30	31	63	20
16	Talayuela	30	31	86	12

TEMPORADA 2010/2011

PREFERENTE EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Hernán	38	74	27	81
2	Chinato	38	80	32	78
3	Roque	38	73	39	76
4	Castuera	38	74	39	74
5	Cacereño B	38	75	39	73
6	CP Valdivia	38	55	40	73
7	Malpartida	38	60	39	71
8	Montehermoso	38	63	47	66
9	Trujillo	38	70	66	56
10	Navalmoral	38	45	58	53
11	CD Coria B	38	60	61	52
12	Orellana	38	54	54	49
13	Amanecer	38	41	63	40
14	Olympic	38	51	58	39
15	Campanario	38	57	85	39
16	Moraleja	38	44	59	38
17	San Benito	38	50	72	36
18	Ciudad	38	31	71	30
19	Cumbre	38	33	95	25
20	Guareña	38	38	84	20

TEMPORADA 2009/2010

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	CD Badajoz	38	109	19	101
2	Jerez	38	76	14	89
3	Extremadura	38	77	26	79
4	Arroyo	38	72	43	74
5	Mérida UD	38	55	28	72
6	Villanueva	38	71	50	67
7	Ciudad	38	54	49	57
8	Benito	38	48	50	53
9	Sanvicenteñ	38	47	48	51
10	Imperio	38	59	56	47
11	Olivenza	38	33	45	47
12	Miajadas	38	28	42	44
13	Deportivo	38	54	68	43
14	Moralo	38	40	52	43
15	Valdelacalza	38	35	54	40
16	CD Coria	38	50	76	34
17	Santa Marta	38	43	69	31
18	Montehermoso	38	31	79	30
19	Estrella	38	27	84	27
20	Villafranca	38	30	87	23

TEMPORADA 2008/2009

PREFERENTE EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Coria	38	124	44	88
2	Montehermoso	38	84	33	84
3	Arroyo	38	105	45	78
4	Ciudad	38	72	33	75
5	Amanecer	38	59	39	69
6	Castuera	38	74	57	62
7	Gimnástico	37	57	39	61
8	Trujillo	38	66	60	55
9	Hernán	38	54	54	52
10	Sagrada Cena	38	72	74	51
11	Chinato	38	61	74	50
12	Talayuela	38	45	74	45
13	Moraleja	38	56	74	44
14	Santa Amalia	38	55	66	43
15	Gargáligas	38	51	76	41
16	Orellana	37	44	69	39
17	Malpartida	38	43	68	39
18	Ciudad	38	48	82	34
19	Zurbarán	38	46	81	33
20	Brocense	38	21	95	19

Competiciones que juega

Tercera Federación Grupo 14

Pos	Equipos		Pts
1		CD Don Benito	73
2		CD Coria	69
3		CD Azuaga	59
4		Villafranca	52
5		Moralo	50
6		Castuera	49
7		CD Diocesano	46
8		CF Jaraíz	45
9		Calamonte	42
10		Jerez	42
11		Pueblonuevo	42
12		Olivenza	41
13		Arroyo	41
14		Trujillo	38
15		Montehermoso	32
16		CD Don Álvaro	31
17		Racing Valverdeño	29
18		UD Fuente de Cantos	24

	Ascenso : CD Don Benito
	Playoff Ascenso : CD Coria, CD Azuaga, Villafranca, Moralo
	Descenso : CD Don Álvaro, Racing Valverdeño, UD Fuente de Cantos

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.

USO DE MEMORIA

6,826,616 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Home / Category )	0.7440
Total Execution Time	0.7452

CADENA URL

/historico/Montehermoso

GET DATOS

$_GET['/historico/Montehermoso']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0163	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 = 'Montehermoso' 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.0145	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=1723 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=1723 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=1723 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0291	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 = 72676
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1723 AND type_rel = 2
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0150	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 = '1723' ORDER BY l.year DESC,cat.coefficient DESC
0.0148	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 = '1723' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0149	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 = '1723' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148	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 = 72676 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152	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 = 72274 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0157	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=1723 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0149	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 (72676,72274) 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.0154	SELECT count(id) as num_players from rel_players WHERE league_id = 72274 AND teamId = 1723
0.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 72676 AND teamId = 1723
0.0165	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 = 72274 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0152	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 = '1723' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0147	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1723' and rp.type = 4
0.0153	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 = '1723' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0198	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 = 72274 WHERE rp.league_id = 72274 AND rp.teamId = 1723 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.0157	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 = 72274 WHERE rp.league_id = 72274 AND rp.teamId = 1723 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152	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 = 72274 WHERE rp.league_id = 72274 AND rp.teamId = 1723 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150	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 = 1723 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0151	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 = 72274 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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 = 67988 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 63716 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.0151	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 = 59499 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 62272 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158	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 = 51306 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163	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 = 44628 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0168	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 = 39344 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 34427 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 16716 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 4099 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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 = 2689 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 2200 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 1245 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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* `tables2010` 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 = 814 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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* `tables2009` 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 = 296 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Montehermoso

Montehermoso

Selecciona un equipo

Competiciones que juega

Tercera Federación Grupo 14

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.