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

Unionistas CF

Entrenador: Dani Ponz

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA FEDERACIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Deportivo	33	56	23	67
2	Barça	34	54	37	64
3	Gimnàstic	34	35	22	60
4	Celta	34	62	35	60
5	Ponferradina	34	34	23	57
6	Cultural	34	33	24	55
7	Arenteiro	33	39	30	49
8	Unionistas	34	33	28	48
9	CD Lugo	34	29	39	43
10	Real	33	39	38	43
11	Osasuna	34	41	46	41
12	SD Tarazona	33	24	27	40
13	Real Unión	34	42	47	39
14	Fuenlabrada	34	29	37	39
15	Sestao River	34	35	45	38
16	CE Sabadell	34	33	51	37
17	CD Teruel	34	28	35	36
18	Cornellà	34	28	36	35
19	Logroñés	34	22	52	28
20	Rayo	34	26	47	25

TEMPORADA 2022/2023

PRIMERA FEDERACIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Racing	38	55	25	75
2	Alcorcón	38	53	23	74
3	RM Castilla	38	58	38	69
4	Deportivo	38	53	29	67
5	Celta	38	48	38	59
6	Linares	38	53	53	59
7	Unionistas	38	38	40	56
8	AD Mérida	38	40	37	54
9	Córdoba CF	38	48	37	54
10	Cultural	38	41	43	48
11	Fuenlabrada	38	32	51	46
12	AD Ceuta FC	38	53	52	45
13	Fernando	38	46	50	45
14	Rayo	38	42	51	45
15	Algeciras	38	36	47	44
16	CD Badajoz	38	35	52	43
17	UD Sanse	38	30	46	43
18	RB Linense	38	31	34	42
19	Pontevedra	38	34	53	36
20	CF Talavera	38	36	63	33

TEMPORADA 2021/2022

PRIMERA FEDERACIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Racing	38	61	31	82
2	Deportivo	38	59	29	74
3	Racing	38	50	26	72
4	Rayo	38	50	47	62
5	Logroñés	38	41	37	62
6	Celta	38	60	46	61
7	Unionistas	38	55	37	61
8	Real Unión	38	51	45	60
9	CD Badajoz	38	40	30	56
10	UD Sanse	38	40	41	53
11	Calahorra	38	48	43	52
12	Cultural	38	61	55	49
13	Logroñés	38	43	43	48
14	Internaciona	38	46	51	46
15	Bilbao Ath.	38	36	46	45
16	CF Talavera	38	39	54	42
17	Zamora	38	30	48	37
18	Real	38	42	64	36
19	Tudelano	38	33	54	28
20	Extremadura	38	22	80	0

TEMPORADA 2020/2021

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Celta	18	22	20	30
2	Unionistas	18	17	10	30
3	Zamora	18	18	17	30
4	Deportivo	18	14	10	29
5	Racing	18	22	17	27
6	Compostela	18	20	16	25
7	Pontevedra	18	19	19	21
8	Coruxo	18	16	23	20
9	Salamanca	18	17	23	19
10	Guijuelo	18	12	22	12
11	Burgos	18	24	12	39
12	Cultural	18	27	15	31
13	Real	18	24	17	30
14	Numancia	18	23	14	25
15	Langreo	18	21	20	25
16	Marino	18	18	22	22
17	Real Oviedo	18	17	27	21
18	Lealtad	18	11	14	20
19	Sporting	18	16	24	16
20	Covadonga	18	21	37	14

TEMPORADA 2019/2020

SEGUNDA DIVISIÓN B GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Logroñés	28	49	19	62
2	Cultural	28	45	28	49
3	Bilbao Ath.	28	55	35	49
4	Real	28	43	28	47
5	Real	28	47	35	44
6	Amorebieta	28	38	38	42
7	Osasuna	28	35	35	40
8	Burgos	28	31	37	39
9	Guijuelo	28	30	26	37
10	Haro	28	29	33	36
11	Deportivo	28	28	31	34
12	Calahorra	28	28	32	34
13	Salamanca	28	30	39	34
14	Barakaldo	28	33	42	32
15	Leioa	28	35	38	31
16	Unionistas	28	39	43	31
17	Real Unión	28	29	33	29
18	Arenas Getxo	28	27	43	28
19	Izarra	28	29	47	28
20	Tudelano	28	26	44	24

TEMPORADA 2018/2019

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Fuenlabrada	38	49	21	71
2	Ponferradina	38	55	27	69
3	Atlético B	38	57	32	68
4	RM Castilla	38	62	45	65
5	Cultural	38	56	34	65
6	Pontevedra	38	45	38	62
7	Guijuelo	38	35	33	59
8	UD Sanse	38	54	45	56
9	Unionistas	38	39	37	52
10	Coruxo	38	38	41	50
11	Real	38	33	40	49
12	Salamanca	38	40	42	49
13	Burgos	38	28	32	48
14	Internaciona	38	47	54	48
15	Palmas	38	26	33	48
16	Celta	38	45	48	46
17	Rápido	38	28	55	38
18	Unión	38	42	62	36
19	Navalcarnero	38	37	70	25
20	Deportivo	38	28	55	24

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Unionistas	38	72	34	80
2	Arandina	38	79	26	77
3	Palencia	38	69	38	74
4	Salamanca	38	74	35	74
5	Atl. Astorga	38	66	34	73
6	Atlético	38	66	40	72
7	La Bañeza	38	53	52	68
8	Numancia B	38	55	30	66
9	Zamora	38	51	41	58
10	Real Ávila	38	50	49	52
11	Virgen	38	41	54	42
12	Cebrereña	38	55	66	42
13	Atl.	38	40	61	38
14	SD Almazán	38	38	51	38
15	Burgalés	38	44	56	37
16	Burgos CF B	38	38	61	35
17	SC Uxama	38	39	61	33
18	Real Burgos	38	31	82	32
19	Becerril	38	42	73	32
20	José	38	26	85	18

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Gimnástica	38	97	22	91
2	Atl. Astorga	38	83	37	80
3	Unionistas	38	77	29	78
4	Palencia	38	73	35	76
5	SD Almazán	38	69	47	68
6	Zamora	38	51	42	60
7	Real Ávila	38	65	55	54
8	Numancia B	38	55	55	53
9	Virgen	38	56	56	50
10	Atl.	38	42	51	48
11	Burgalés	38	53	53	48
12	La Bañeza	38	49	52	47
13	José	38	39	68	45
14	Atlético	38	53	70	44
15	Burgos CF B	38	39	55	43
16	Cebrereña	38	38	55	41
17	SC Uxama	38	37	45	41
18	Villamuriel	38	35	49	37
19	Mirandés B	38	26	49	37
20	Villaralbo	38	27	139	13

TEMPORADA 2015/2016

PREFERENTE C. LEÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Unionistas	34	114	27	88
2	Zamora B	34	70	32	71
3	Villa	34	76	32	64
4	Betis CF	34	64	36	62
5	CD Mojados	34	68	44	62
6	Béjar	34	65	53	59
7	CD Ejido	34	50	47	47
8	Fresno	34	59	78	43
9	Onzonilla	34	41	61	40
10	Peñaranda	34	49	61	40
11	CD Navega	34	41	58	40
12	Carbajosa	34	43	56	39
13	Laguna CD	34	52	59	39
14	Veguellina	34	32	57	37
15	Virgen	34	41	56	35
16	Navarrés	34	61	93	33
17	Rioseco	34	45	81	29
18	U.D.C. Sur	34	50	90	29

TEMPORADA 2014/2015

1ª CASTILLA Y LEÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Unionistas	20	66	9	53
2	Helmántico	20	49	22	38
3	Hergar	20	52	25	37
4	Real	20	35	27	32
5	Alba Tormes	20	36	30	32
6	Villamayor	20	42	40	29
7	Pizarrales	20	27	33	26
8	Guijuelo B	20	20	38	21
9	Helmántica	20	30	66	17
10	Cantalapiedr	20	23	51	13
11	Carbajosa	20	24	63	10
12	Monterrubio	0	0	0	0

Competiciones que juega

Primera Federación Grupo 1

Pos	Equipos		Pts
1		RC Deportivo	67
2		Barça Atlètic	64
3		Gimnàstic Tarragona	60
4		Celta Fortuna	60
5		Ponferradina	57
6		Cultural Leonesa	55
7		Arenteiro	49
8		Unionistas CF	48
9		CD Lugo	43
10		Real Sociedad B	43
11		Osasuna Promesas	41
12		SD Tarazona	40
13		Real Unión Club	39
14		Fuenlabrada	39
15		Sestao River	38
16		CE Sabadell	37
17		CD Teruel	36
18		UE Cornellà	35
19		SD Logroñés	28
20		Rayo Majadahonda	25

	Ascenso : RC Deportivo
	Playoff Ascenso : Barça Atlètic, Gimnàstic Tarragona, Celta Fortuna, Ponferradina
	Descenso : CE Sabadell, CD Teruel, UE Cornellà, SD Logroñés, Rayo Majadahonda

RIVALES EN Copa del Rey

RIVALES EN Primera Federaci.

USO DE MEMORIA

6,724,456 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1230
Total Execution Time	0.1243

CADENA URL

/historico/Cd-Unionistas-Salamanca-Cf-Senior

GET DATOS

$_GET['/historico/Cd-Unionistas-Salamanca-Cf-Senior']

POST DATOS

No hay datos POST existentes

CONSULTAS (29)

0.0029	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 = 'Cd-Unionistas-Salamanca-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.0019	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=54657 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=54657 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=54657 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=54657 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 54657 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024	SELECT /35 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (85520,93130,149156,225942,234064) ORDER BY n.cover_points DESC, update_date DESC
0.0035	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 = '54657' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0039	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=54657 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0024	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 (72358,71759,71432,68343) 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.0036	SELECT count(id) as num_players from rel_players WHERE league_id = 72358 AND teamId = 54657
0.0048	SELECT count(id) as num_players from rel_players WHERE league_id = 71759 AND teamId = 54657
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 68343 AND teamId = 54657
0.0030	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 54657
0.0022	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 = '54657' 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 = '54657' 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 = '54657' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0049	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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 54657 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.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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 54657 AND (e.action = 4 or e.action = 5) 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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 54657 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030	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 = 54657 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 67959 AND t.round = 38 ORDER BY team.conference ASC,t.position 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* `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 = 62378 AND t.round = 38 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* `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 = 58608 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.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* `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 = 50266 AND t.round = 28 ORDER BY team.conference ASC,t.position 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* `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 = 44080 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 39032 AND t.round = 38 ORDER BY team.conference 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* `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 = 16750 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* `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 = 7729 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Unionistas CF

Unionistas CF

Selecciona un equipo

Competiciones que juega

Primera Federación Grupo 1

RIVALES EN Copa del Rey

RIVALES EN Primera Federaci.