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

Deportivo Arenas

Temporada 2023/2024

TEMPORADA 2023/2024

PREFERENTE C. LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Briviesca	29	59	20	57
2	Villamuriel	28	46	25	53
3	Turégano	29	55	37	52
4	José	29	50	36	47
5	Vista Alegre	29	38	26	46
6	Villarcayo	29	36	29	44
7	Numancia B	29	38	32	42
8	SC Uxama	28	35	40	41
9	Racing	29	25	35	40
10	Calasanz	29	42	36	39
11	Cebrereña	29	38	41	39
12	UP Palencia	29	27	29	36
13	Belorado	29	43	60	34
14	Unami CP	28	32	45	25
15	Deportivo	29	29	45	25
16	Carejas	28	16	73	11

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 4
Equipo		PJ	GF	GC	Puntos
1	Deportivo	19	77	17	46
2	Ramacastaña	20	51	24	46
3	Lanzahita	20	49	17	41
4	Piedralaves	20	66	25	40
5	CD Sotillo	19	64	37	34
6	Casillas	20	39	46	25
7	Mijares	19	46	56	24
8	Guisando	19	32	48	23
9	La Adrada	20	32	57	12
10	Pedro	19	21	81	11
11	Deportivo	19	17	86	4

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 2016/2017

1ª CASTILLA Y LEÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Ponferradina	26	63	11	62
2	Toralense	26	61	37	57
3	Francisco	26	43	20	51
4	Fabero	26	41	29	42
5	Toreno	26	36	40	35
6	Santa	26	42	51	35
7	CD Bosco	26	47	36	34
8	Veguellina	26	43	41	34
9	Virgen	26	35	43	31
10	Villadepalos	26	22	37	31
11	Mansillés	26	30	37	30
12	A. Paramés	26	34	41	29
13	Halterofilia	26	39	54	29
14	Laciana	26	36	40	28
15	Deportivo	26	30	44	28
16	Fútbol	26	14	55	17

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 1

Preferente C. León Grupo 1

Pos	Equipos		Pts
1		CF Briviesca	57
2		CD Villamuriel	53
3		Turégano	52
4		CD San José	47
5		Vista Alegre CD	46
6		Villarcayo Nela	44
7		Numancia B	42
8		SC Uxama	41
9		Racing Lermeño CF	40
10		Calasanz de Soria	39
11		Cebrereña	39
12		UP Palencia	36
13		Belorado	34
14		Unami CP	25
15		Deportivo Arenas	25
16		Carejas Paredes	11

	Ascenso : CF Briviesca
	Playoff Ascenso : CD Villamuriel, Turégano
	Descenso : Belorado, Unami CP, Deportivo Arenas, Carejas Paredes

RIVALES EN Preferente C. Le.

USO DE MEMORIA

5,655,576 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.4813
Total Execution Time	0.4833

CADENA URL

/historico/Arenas-Cf-Senior

GET DATOS

$_GET['/historico/Arenas-Cf-Senior']

POST DATOS

No hay datos POST existentes

CONSULTAS (29)

0.0134	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 = 'Arenas-Cf-Senior' 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.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=53278 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=53278 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=53278 AND type_rel = 2
0.0131	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 = '53278' ORDER BY l.year DESC,cat.coefficient DESC
0.0128	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 = '53278' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0127	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 = '53278' 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 = 73528 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127	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=53278 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (73528,69046) 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.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 73528 AND teamId = 53278
0.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 69046 AND teamId = 53278
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 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 = 73528 AND t.round = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0129	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 = '53278' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0131	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 = '53278' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0145	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 = 73528 WHERE rp.league_id = 73528 AND rp.teamId = 53278 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.0143	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 = 73528 WHERE rp.league_id = 73528 AND rp.teamId = 53278 AND (e.action = 4 or e.action = 5) 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 events2024 e ON e.player_id = p.id AND e.league_id = 73528 WHERE rp.league_id = 73528 AND rp.teamId = 53278 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 = 53278 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73528 AND t.round = 29 ORDER BY team.conference ASC,t.position 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* `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.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* `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 = 65695 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.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* `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.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* `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.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* `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* `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 = 34571 AND t.round = 26 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* `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.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* `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.0127	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 = 73528 ORDER BY nameShow LIMIT 100

Deportivo Arenas

Deportivo Arenas

Selecciona un equipo

Competiciones que juega

Preferente C. León Grupo 1

RIVALES EN Preferente C. Le.