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

Salamanca UDS B

Temporada 2023/2024

TEMPORADA 2023/2024

PREFERENTE C. LEÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ciudad	29	51	23	65
2	Mansillés	29	42	14	64
3	Unionistas	29	59	20	60
4	CD Mojados	29	57	28	60
5	La Bañeza	29	57	28	54
6	Betis CF	29	41	29	47
7	Béjar	29	47	42	47
8	Zamora B	29	40	49	40
9	Cisterniga	29	38	44	37
10	Onzonilla	29	42	45	33
11	Ribert	29	34	50	31
12	Benavente	29	31	33	29
13	Gimnástica	29	37	51	25
14	Salamanca	29	31	49	23
15	Veguellina	29	28	54	22
16	Bovedana	29	21	97	8

TEMPORADA 2022/2023

PREFERENTE C. LEÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	CD Laguna	33	63	29	72
2	Villaralbo	33	66	35	65
3	Zamora B	33	54	32	61
4	La Bañeza	33	58	39	57
5	CD Mojados	33	58	42	54
6	Ciudad	33	47	38	52
7	Ribert	33	46	43	50
8	Mansillés	33	56	45	49
9	Onzonilla	33	51	45	47
10	Betis CF	33	45	49	47
11	Salamanca	33	51	41	47
12	Benavente	33	53	56	46
13	Unionistas	33	50	36	45
14	Cisterniga	33	36	50	41
15	Villa	33	27	63	25
16	La Pedraja	33	32	73	20
17	Peñaranda	33	24	79	12
18	CD Fabero	17	18	40	9

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Guijuelo	32	61	16	75
2	SD Almazán	32	51	28	64
3	Real Ávila	32	45	25	58
4	Mirandés B	32	36	24	55
5	Atlético	32	37	28	54
6	Júpiter	32	55	37	54
7	Arandina	32	39	22	53
8	Palencia CF	32	45	36	47
9	Atl. Astorga	32	33	37	42
10	Atl.	32	32	40	40
11	Virgen	32	28	34	39
12	Numancia B	32	40	48	36
13	Santa Marta	32	37	49	35
14	Ribert	32	34	49	32
15	Salamanca	32	22	51	30
16	Ciudad	32	29	65	20
17	DiocesÁvila	32	21	56	19

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Palencia	20	29	11	44
2	Atl. Astorga	20	26	11	35
3	Júpiter	20	25	18	35
4	Virgen	20	22	18	31
5	Atlético	20	21	22	26
6	Atl.	20	17	20	26
7	La Bañeza	20	23	23	25
8	Salamanca	20	17	26	22
9	Santa Marta	20	14	17	21
10	Peñaranda	20	13	28	16
11	Becerril	20	10	23	15
12	Gimnástica	22	54	10	57
13	Burgos CF B	22	33	15	40
14	Numancia B	22	40	34	39
15	Arandina	22	41	31	36
16	Mirandés B	22	30	21	33
17	Real Ávila	22	25	23	31
18	SD Almazán	22	26	31	31
19	DiocesÁvila	22	19	42	23
20	Granja	22	24	30	22
21	Real Burgos	22	18	37	19
22	Cebrereña	22	18	36	19
23	Burgalés	22	17	35	17

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Zamora	28	63	15	73
2	Gimnástica	29	57	20	70
3	Arandina	28	44	17	59
4	Numancia B	28	51	18	57
5	Burgos CF B	29	45	21	55
6	Palencia	28	40	18	51
7	Atl. Astorga	28	46	26	50
8	Real Ávila	28	35	28	44
9	Salamanca	29	37	39	42
10	SD Almazán	29	36	40	38
11	Real Burgos	29	36	39	36
12	Júpiter	29	40	50	35
13	Burgalés	29	26	33	34
14	Santa Marta	29	24	32	32
15	Becerril	28	30	46	32
16	Virgen	29	33	54	30
17	Atlético	28	27	40	25
18	La Bañeza	29	20	56	21
19	Mirandés B	29	24	54	20
20	Atl.	28	17	40	19
21	Granja	29	25	70	16

TEMPORADA 2018/2019

PREFERENTE C. LEÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Salamanca	34	72	28	76
2	Peñaranda	34	68	38	67
3	Ponferradina	34	57	24	64
4	Villaralbo	34	62	32	62
5	Ribert	34	66	54	62
6	Villa	34	66	52	59
7	Béjar	34	68	57	56
8	Universidad	34	55	64	52
9	Benavente	34	55	58	50
10	CD Mojados	34	48	51	46
11	Ciudad	34	46	40	44
12	Cisterniga	34	46	51	44
13	Betis CF	34	62	60	43
14	Hergar	34	51	59	37
15	Onzonilla	34	40	52	34
16	Toralense	34	36	81	26
17	CD Ejido	34	33	68	21
18	Navarrés	34	33	95	21

TEMPORADA 2017/2018

1ª CASTILLA Y LEÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Ribert	24	87	24	63
2	Salamanca	24	94	23	62
3	Helmántico	24	65	26	49
4	CD Navega	24	68	46	42
5	Helmántica	24	48	43	37
6	Real	24	33	41	34
7	Chamberi	24	39	45	28
8	Guijuelo B	24	38	53	26
9	Villares	24	34	56	26
10	Villamayor	24	28	54	23
11	Capuchinos	24	41	73	19
12	Pizarrales	24	27	51	17
13	Alai Bolivar	24	26	93	10

TEMPORADA 2016/2017

1ª CASTILLA Y LEÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Hergar	22	78	20	53
2	Salamanca	22	76	19	53
3	Real	22	67	36	44
4	Helmántico	22	78	33	40
5	Helmántica	22	59	42	40
6	Villamayor	22	54	38	39
7	Guijuelo B	22	43	46	25
8	Villares	22	35	57	25
9	Alba Tormes	22	36	51	23
10	Pizarrales	22	49	54	21
11	Capuchinos	22	32	75	15
12	Cristo	22	20	156	4
13	Sporting	0	0	0	0

Competiciones que juega

Preferente C. León Grupo 2

Pos	Equipos		Pts
1		Ciudad Rodrigo	65
2		A. Mansillés	64
3		Unionistas Salamanca B	60
4		CD Mojados	60
5		La Bañeza	54
6		Betis CF	47
7		Béjar Industrial	47
8		Zamora B	40
9		La Cisterniga	37
10		CD Onzonilla	33
11		Ribert	31
12		Benavente	29
13		Gimnástica Medinense	25
14		Salamanca UDS B	23
15		Veguellina CF	22
16		Bovedana	8

	Ascenso : Ciudad Rodrigo
	Playoff Ascenso : A. Mansillés, Unionistas Salamanca B
	Descenso : Gimnástica Medinense, Salamanca UDS B, Veguellina CF, Bovedana

RIVALES EN Preferente C. Le.

USO DE MEMORIA

5,855,552 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.4822
Total Execution Time	0.4835

CADENA URL

/historico/Salmantino-B-Senior

GET DATOS

$_GET['/historico/Salmantino-B-Senior']

POST DATOS

No hay datos POST existentes

CONSULTAS (25)

0.0153	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 = 'Salmantino-B-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.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=92160 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=92160 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=92160 AND type_rel = 2
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 = '92160' ORDER BY l.year DESC,cat.coefficient DESC
0.0147	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 = '92160' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0146	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 = '92160' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147	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=92160 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145	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 (73529) 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.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 73529 AND teamId = 92160
0.0146	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 = '92160' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '92160' and rp.type = 4
0.0146	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 = '92160' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0156	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 = 73529 WHERE rp.league_id = 73529 AND rp.teamId = 92160 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.0156	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 = 73529 WHERE rp.league_id = 73529 AND rp.teamId = 92160 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 = 73529 WHERE rp.league_id = 73529 AND rp.teamId = 92160 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149	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 = 92160 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73529 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.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* `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 = 68799 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.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* `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 = 62392 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.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 = 58587 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* `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 = 50276 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.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* `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 = 44675 AND t.round = 34 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* `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 = 39780 AND t.round = 26 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 = 34573 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Salamanca UDS B

Salamanca UDS B

Selecciona un equipo

Competiciones que juega

Preferente C. León Grupo 2

RIVALES EN Preferente C. Le.