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

EI San Martín

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA RFFPA
Equipo		PJ	GF	GC	Puntos
1	Real	31	54	14	69
2	Martín	31	45	14	68
3	Astur	31	46	22	58
4	Mosconia	30	55	24	57
5	TSK Roces	31	51	40	53
6	Club Siero	31	49	34	49
7	Vallobin CD	30	43	31	49
8	Navarro	31	35	34	43
9	U.Comercial	31	46	44	41
10	Muros	31	36	39	41
11	Universidad	31	37	41	39
12	Llaranes CF	31	32	36	37
13	Andés	31	30	42	37
14	Candás CF	31	36	48	35
15	Valdesoto	31	25	36	33
16	Fresneda	31	22	42	32
17	Berrón	31	24	42	28
18	Club	31	30	60	27
19	Atlético	31	38	59	26
20	Colloto	31	22	54	18

TEMPORADA 2022/2023

PRIMERA RFFPA
Equipo		PJ	GF	GC	Puntos
1	Urraca CF	38	61	25	74
2	Gijón	38	58	27	73
3	Lenense	38	53	30	70
4	Barcia CF	38	46	33	62
5	Atlético	38	51	30	62
6	TSK Roces	38	36	28	62
7	Llaranes CF	38	48	43	61
8	Astur	38	38	35	54
9	Candás CF	38	48	49	53
10	Navarro	38	44	47	52
11	Berrón	38	43	43	51
12	Andés	38	47	42	48
13	Martín	38	37	40	45
14	Mosconia	38	30	36	44
15	Colloto	38	38	51	44
16	Vallobin CD	38	41	45	44
17	Universidad	38	45	57	41
18	Tineo	38	31	48	36
19	Langreo	38	41	88	30
20	Lealtad	38	15	54	21

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real Oviedo	38	75	39	75
2	Sporting	38	71	25	74
3	Lealtad	38	55	27	71
4	Llanes	38	50	36	64
5	Caudal	38	55	37	64
6	CD Colunga	38	51	32	61
7	L´Entregu	38	48	39	57
8	CD Praviano	38	51	44	56
9	CD Tuilla	38	53	59	53
10	Covadonga	38	48	44	51
11	Luarca CF	38	36	52	49
12	Real	38	43	44	48
13	Gijón	38	43	52	47
14	Urraca CF	38	31	35	47
15	Martín	38	44	48	47
16	Lenense	38	39	48	46
17	TSK Roces	38	40	62	36
18	Navarro	38	29	55	33
19	Langreo	38	36	80	26
20	Mosconia	38	30	70	24

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	UC Ceares	20	29	16	44
2	Real Avilés	20	33	13	40
3	UD Llanera	20	38	28	38
4	Caudal	20	36	18	38
5	Gijón	20	34	27	27
6	Lenense	20	24	27	25
7	CD Praviano	20	23	28	24
8	Navarro	20	18	26	22
9	Mosconia	20	15	28	20
10	Vallobin CD	20	14	32	17
11	Avilés	20	12	33	12
12	L´Entregu	18	32	13	40
13	Martín	18	31	21	33
14	Llanes	18	29	16	32
15	CD Tuilla	18	25	19	27
16	Real	18	19	25	23
17	Urraca CF	18	9	12	22
18	Condal	18	13	19	22
19	CD Colunga	18	11	17	20
20	Club Siero	18	12	23	15
21	Valdesoto	18	10	26	12

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Lealtad	28	44	12	62
2	UD Llanera	28	48	26	59
3	Covadonga	28	65	33	57
4	Caudal	28	54	21	56
5	CD Tuilla	28	42	25	55
6	Llanes	28	47	30	48
7	Urraca CF	28	34	25	43
8	Gijón	28	42	36	39
9	L´Entregu	28	26	36	34
10	Condal	28	29	37	32
11	CD Praviano	28	37	42	32
12	Mosconia	28	29	33	31
13	Navarro	28	26	35	31
14	Lenense	28	28	48	29
15	UC Ceares	28	28	37	27
16	Real Avilés	28	34	50	25
17	Vallobin CD	28	19	32	25
18	Martín	28	26	49	24
19	CD Colunga	28	25	53	23
20	Club Siero	28	25	48	20

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Lealtad	38	72	16	90
2	Marino	38	77	22	90
3	Caudal	38	72	29	75
4	Covadonga	38	80	42	73
5	UD Llanera	38	65	42	70
6	Llanes	38	52	38	65
7	CD Tuilla	38	67	47	64
8	L´Entregu	38	42	36	57
9	Mosconia	38	51	42	55
10	CD Praviano	38	43	49	51
11	Condal	38	40	48	48
12	CD Colunga	38	38	48	44
13	UC Ceares	38	35	51	44
14	Real Avilés	38	32	65	37
15	Martín	38	35	53	36
16	Club Siero	38	35	60	36
17	Gijón	38	38	64	35
18	Madalena	38	37	70	34
19	Universidad	38	30	61	30
20	Claudio	38	23	81	17

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real Oviedo	38	73	19	82
2	Langreo	38	89	23	78
3	Marino	38	70	21	76
4	Llanes	38	65	48	75
5	Covadonga	38	83	46	72
6	UC Ceares	38	46	30	60
7	CD Tuilla	38	60	41	59
8	CD Praviano	38	45	37	58
9	L´Entregu	38	53	50	53
10	Martín	38	41	50	51
11	Mosconia	38	39	57	50
12	Gijón	38	52	55	47
13	Condal	38	39	67	44
14	CD Colunga	38	44	60	42
15	UD Llanera	38	48	65	39
16	Club Siero	38	34	70	36
17	Real Avilés	38	35	64	32
18	Valdesoto	38	27	55	30
19	Atlético	38	22	68	28
20	TSK Roces	38	29	68	24

TEMPORADA 2016/2017

PRIMERA RFFPA
Equipo		PJ	GF	GC	Puntos
1	TSK Roces	38	58	25	72
2	Gijón	38	65	33	71
3	Martín	38	63	34	70
4	Valdesoto	38	61	31	69
5	Nalón CF	38	67	37	67
6	Rayo	38	46	31	64
7	Claudio	38	58	56	57
8	Ribadesella	38	76	76	55
9	Unión	38	50	51	55
10	Andés	38	57	61	48
11	Navarro	38	44	54	48
12	Astur	38	42	48	47
13	Universidad	38	50	66	47
14	Madalena	38	59	62	45
15	Ribadedeva	38	44	51	44
16	Candás CF	38	42	61	40
17	CD Turón	38	45	69	38
18	Muros	38	45	82	36
19	Luarca CF	38	44	65	33
20	Berrón	38	46	69	33

TEMPORADA 2015/2016

PRIMERA RFFPA
Equipo		PJ	GF	GC	Puntos
1	L´Entregu	38	70	30	78
2	UD Llanera	38	69	28	76
3	Lenense	38	54	28	76
4	Andés	38	60	38	73
5	Martín	38	61	34	72
6	Navarro	38	58	27	71
7	Nalón CF	38	63	38	70
8	CD Turón	38	57	49	60
9	Valdesoto	38	54	50	58
10	Unión	38	51	48	50
11	Luarca CF	38	54	60	50
12	Madalena	38	58	62	48
13	Candás CF	38	48	64	46
14	Claudio	38	46	46	45
15	Universidad	38	34	54	45
16	Berrón	38	48	59	41
17	Rayo	38	47	71	41
18	Campomanes	38	35	66	33
19	Real Avilés	38	26	83	17
20	Fresneda	38	36	94	14

TEMPORADA 2014/2015

PRIMERA RFFPA
Equipo		PJ	GF	GC	Puntos
1	Club Siero	38	69	39	69
2	CD Colunga	38	60	39	69
3	Tineo	38	63	42	68
4	Rayo	38	63	47	67
5	Llano 2000	38	45	23	62
6	Martín	38	59	53	54
7	Valdesoto	38	57	55	53
8	UD Llanera	38	63	61	52
9	Candás CF	38	49	48	51
10	CD Turón	38	50	50	51
11	Campomanes	38	51	56	51
12	Claudio	38	41	42	50
13	Unión	38	35	48	50
14	Madalena	38	52	55	49
15	Luarca CF	38	41	43	48
16	Navarro	38	42	45	48
17	Real Tapia	38	46	58	43
18	Boal CF	38	36	56	38
19	Muros	38	44	62	34
20	CD Raíces	38	36	80	25

Competiciones que juega

Primera RFFPA

Pos	Equipos		Pts
1		Real Sporting C	69
2		EI San Martín	68
3		Astur	58
4		Mosconia	57
5		TSK Roces	53
6		Club Siero	49
7		Vallobin CD	49
8		Navarro	43
9		U.Comercial	41
10		Muros Balompié	41
11		Universidad Oviedo	39
12		Llaranes CF	37
13		Andés	37
14		Candás CF	35
15		Valdesoto	33
16		La Fresneda	32
17		Berrón	28
18		Club Asturias de Blimea	27
19		Atlético de Lugones	26
20		Colloto	18

	Ascenso : Real Sporting C, EI San Martín, Astur
	Descenso : Club Asturias de Blimea, Atlético de Lugones, Colloto

RIVALES EN Primera RFFPA

USO DE MEMORIA

6,467,048 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.5773
Total Execution Time	0.5787

CADENA URL

/historico/Ei-San-Martin

GET DATOS

$_GET['/historico/Ei-San-Martin']

POST DATOS

No hay datos POST existentes

CONSULTAS (26)

0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18990 AND type_rel = 2
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=72 AND type_rel = 3
0.0146	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 72 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147	SELECT /53 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 (865740,698945,420684,366243,365678) ORDER BY n.cover_points DESC, update_date DESC
0.0148	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 = '18990' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146	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 = 73524 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148	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=18990 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 (73524) 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.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 73524 AND teamId = 18990
0.0293	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 = 73524 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147	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 = '18990' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18990' and rp.type = 4
0.0147	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 = '18990' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0179	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 = 73524 WHERE rp.league_id = 73524 AND rp.teamId = 18990 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.0208	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 = 73524 WHERE rp.league_id = 73524 AND rp.teamId = 18990 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0195	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 = 73524 WHERE rp.league_id = 73524 AND rp.teamId = 18990 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0166	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 = 18990 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0302	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 = 68760 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.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* `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 = 58580 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 = 50270 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.0292	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 = 44390 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0292	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 = 39026 AND t.round = 38 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* `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 = 34175 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* `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 = 16699 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* `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 = 4081 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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 = 73524 ORDER BY nameShow LIMIT 100

EI San Martín

EI San Martín

Selecciona un equipo

Competiciones que juega

Primera RFFPA

RIVALES EN Primera RFFPA