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

Hoyo de Pinares

Temporada 2023/2024

TEMPORADA 2023/2024

1ª CASTILLA Y LEÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Popular Rayo	23	69	21	56
2	Las Navas	23	73	25	52
3	Candeleda	23	61	24	47
4	Atlético	23	77	40	46
5	Bosco	23	57	32	46
6	Cebrereña	23	68	51	40
7	Hoyo Pinares	23	59	43	37
8	CD Sotillo	23	33	46	29
9	Casillas	23	47	53	26
10	Piedralaves	23	37	50	26
11	Navatalgordo	23	36	65	25
12	Ramacastaña	23	19	45	18
13	Burgohondo	23	28	72	11
14	Mijares	23	28	125	5

TEMPORADA 2022/2023

1ª CASTILLA Y LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Deportivo	26	62	23	62
2	Popular Rayo	26	59	26	56
3	Atlético	26	82	26	53
4	Casillas	26	69	38	51
5	Hoyo Pinares	25	67	29	48
6	Cebrereña	26	50	43	43
7	Candeleda	26	54	45	42
8	Bosco	26	40	30	36
9	Lanzahita	26	49	49	35
10	Ramacastaña	26	36	51	31
11	CD Sotillo	26	42	77	20
12	Burgohondo	26	40	81	18
13	La Adrada	25	29	87	12
14	Mijares	26	29	103	5

TEMPORADA 2021/2022

1ª CASTILLA Y LEÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Las Navas	20	91	27	55
2	Hoyo Pinares	20	49	29	40
3	El Tiemblo	18	45	22	33
4	Popular Rayo	20	42	39	31
5	Bosco	19	47	30	30
6	Cebrereña	19	32	22	29
7	Atlético	19	40	38	28
8	Burgohondo	20	32	61	19
9	Navaluenga	20	32	77	16
10	Arevalo CF	20	30	63	13
11	Navatalgordo	19	26	58	10

TEMPORADA 2019/2020

1ª CASTILLA Y LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Sotillo	24	87	41	52
2	Lanzahita	24	75	28	51
3	Bosco	23	81	32	50
4	Piedralaves	24	69	36	49
5	Deportivo	24	68	23	48
6	Ramacastaña	24	103	44	45
7	Atlético	24	64	36	45
8	Hoyo Pinares	24	68	48	44
9	Las Navas	24	73	40	41
10	Mijares	24	94	58	40
11	El Tiemblo	24	43	66	34
12	Burgohondo	24	67	52	32
13	Navaluenga	24	56	76	28
14	Guisando	24	40	89	23
15	Navatalgordo	23	36	75	18
16	La Adrada	24	40	107	11
17	Deportivo	22	21	102	4
18	Pedro	24	18	150	2

TEMPORADA 2018/2019

1ª CASTILLA Y LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Candeleda	26	74	31	59
2	Lanzahita	26	87	32	56
3	Deportivo	26	82	33	56
4	El Tiemblo	26	67	37	50
5	Mijares	26	79	50	49
6	Ramacastaña	26	59	39	48
7	Cuevas A	26	54	54	34
8	CD Sotillo	26	45	49	33
9	Hoyo Pinares	26	47	64	31
10	Atlético	26	56	71	29
11	Burgohondo	26	71	90	28
12	Guisando	26	56	88	22
13	Navaluenga	26	51	105	19
14	Casillas	26	19	104	8

TEMPORADA 2017/2018

1ª CASTILLA Y LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	El Tiemblo	28	110	20	66
2	Bosco	28	69	35	59
3	Burgohondo	28	94	62	56
4	Lanzahita	28	71	34	54
5	Mijares	28	68	65	54
6	D. Arenas	28	77	49	49
7	Candeleda	28	43	29	49
8	CD Sotillo	28	69	68	40
9	Navaluenga	28	56	56	37
10	Ramacastaña	28	52	59	32
11	Hoyo Pinares	28	39	64	28
12	Cuevas A	28	46	84	27
13	Atlético	28	44	68	25
14	Guisando	28	49	99	16
15	Casillas	28	25	120	7
16	Deportivo	0	0	0	0

TEMPORADA 2016/2017

1ª CASTILLA Y LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Deportivo	23	78	29	65
2	El Tiemblo	24	82	30	56
3	Lanzahita	23	81	48	45
4	Guisando	24	80	51	45
5	Ramacastaña	24	52	39	41
6	Sotillo	24	69	40	40
7	Mijares	24	53	52	38
8	Deportivo	21	46	56	24
9	Burgohondo	24	53	86	24
10	Navaluenga	24	47	76	20
11	Hoyo Pinares	23	44	72	16
12	Candeleda	24	28	71	15
13	Casillas	22	26	89	3

TEMPORADA 2015/2016

1ª CASTILLA Y LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	DiocesÁvila	27	129	11	77
2	Lanzahita	28	93	36	64
3	Deportivo	27	85	20	59
4	Candeleda	28	75	34	55
5	Guisando	27	89	44	53
6	Mijares	28	80	57	47
7	Sotillo	28	37	72	42
8	El Tiemblo	28	55	49	38
9	Deportivo	27	64	63	35
10	Navaluenga	28	51	70	32
11	Burgohondo	28	45	82	30
12	Ramacastaña	27	38	95	24
13	Hoyo Pinares	28	41	74	22
14	Casillas	27	45	113	17
15	Pedro	28	24	131	4

TEMPORADA 2014/2015

1ª CASTILLA Y LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Mombeltran	28	81	25	73
2	DiocesÁvila	28	133	17	66
3	Lanzahita	28	94	31	65
4	Deportivo	28	70	49	56
5	El Tiemblo	28	81	56	49
6	Candeleda	28	63	43	49
7	Mijares	28	71	61	44
8	Piedralaves	28	56	80	34
9	Guisando	28	63	80	33
10	Hoyo Pinares	28	32	64	28
11	Deportivo	28	43	76	28
12	Burgohondo	28	39	106	22
13	Ramacastaña	28	29	79	21
14	Casillas	28	40	78	16
15	Atlético	28	37	87	13

Competiciones que juega

Grupo 7

1ª Castilla y León Grupo 7

Pos	Equipos		Pts
1		Popular Rayo Abulense	56
2		Las Navas	52
3		A. Candeleda	47
4		Atlético Barraco	46
5		Bosco de Arévalo	46
6		Cebrereña B	40
7		Hoyo de Pinares	37
8		CD Sotillo	29
9		Casillas	26
10		Piedralaves	26
11		Navatalgordo	25
12		Ramacastañas	18
13		Burgohondo	11
14		Mijares	5

	Ascenso : Popular Rayo Abulense
	Playoff Ascenso : Las Navas

RIVALES EN 1ª Castilla y Le.

USO DE MEMORIA

5,696,208 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.4317
Total Execution Time	0.4329

CADENA URL

/historico/Fc-El-Hoyo-De-Pinares-Senior

GET DATOS

$_GET['/historico/Fc-El-Hoyo-De-Pinares-Senior']

POST DATOS

No hay datos POST existentes

CONSULTAS (24)

0.0278	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 = 73784
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=53291 AND type_rel = 2
0.0135	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 = '53291' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0132	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 = 73784 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136	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=53291 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0133	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 (73784) 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.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 73784 AND teamId = 53291
0.0129	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 = 73784 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126	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 = '53291' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127	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 = '53291' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2024 e ON e.player_id = p.id AND e.league_id = 73784 WHERE rp.league_id = 73784 AND rp.teamId = 53291 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.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 events2024 e ON e.player_id = p.id AND e.league_id = 73784 WHERE rp.league_id = 73784 AND rp.teamId = 53291 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132	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 = 73784 WHERE rp.league_id = 73784 AND rp.teamId = 53291 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139	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 = 53291 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0143	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 = 73784 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.0146	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 = 69046 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141	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 = 65694 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.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* `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 = 51309 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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 = 45156 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 39776 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 34569 AND t.round = 26 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* `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 = 16871 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 7718 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126	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 = 73784 ORDER BY nameShow LIMIT 100

Hoyo de Pinares

Hoyo de Pinares

Selecciona un equipo

Competiciones que juega

1ª Castilla y León Grupo 7

RIVALES EN 1ª Castilla y Le.