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

Resultados de Fútbol

CD Covadonga Sub 19

Entrenador: Federico Díaz

Temporada 2023/2024

TEMPORADA 2023/2024

DIVISIÓN DE HONOR GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Racing	29	63	18	67
2	Deportivo	29	77	27	66
3	Celta	29	77	22	64
4	Real Oviedo	29	54	32	54
5	Real	29	46	37	46
6	Compostela	29	40	40	46
7	Choco	29	34	36	40
8	Miñor	29	40	45	40
9	Covadonga	29	33	47	35
10	Bansander	29	51	66	34
11	Lugo	29	34	39	33
12	Arosa	29	41	48	33
13	Atlético	29	27	53	32
14	Veriña	29	36	42	31
15	Coruxo	29	25	65	18
16	Revilla	29	27	88	14

TEMPORADA 2022/2023

DIVISIÓN DE HONOR GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Celta	30	87	29	75
2	Deportivo	30	65	25	70
3	Real	30	58	22	68
4	Real Oviedo	30	57	28	55
5	Racing	30	51	26	54
6	Arosa	30	38	45	39
7	Bansander	30	29	42	39
8	Lugo	30	53	44	38
9	Covadonga	30	37	52	37
10	Coruxo	30	40	37	34
11	Atlético	30	36	48	34
12	Compostela	30	43	60	31
13	Marina Sport	30	31	61	30
14	Gimnástica	30	32	59	29
15	Deportivo	30	33	63	25
16	Ural	30	23	72	9

TEMPORADA 2021/2022

DIVISIÓN DE HONOR GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Celta	34	144	17	91
2	Deportivo	34	108	29	87
3	Racing	34	79	23	75
4	Lugo	34	51	49	57
5	Real Oviedo	34	65	40	57
6	Real	34	50	46	56
7	Bansander	34	59	50	52
8	Atlético	34	43	44	47
9	Compostela	34	53	71	43
10	Ural	34	34	44	43
11	Marina Sport	34	48	65	39
12	Covadonga	34	39	59	36
13	Pabellón	34	34	63	31
14	Arenal	34	24	64	28
15	Pontevedra	34	29	61	27
16	Bezana	34	33	77	26
17	Miñor	34	35	72	25
18	Real Avilés	34	24	78	24

TEMPORADA 2020/2021

LIGA NACIONAL GRUPO 37
Equipo		PJ	GF	GC	Puntos
1	Real Oviedo	25	65	18	63
2	Covadonga	25	72	24	60
3	Real	23	76	29	49
4	Llano 2000	23	54	38	37
5	Manuel Rubio	23	44	43	35
6	Astur	25	45	39	36
7	TSK Roces B	23	37	38	32
8	Langreo	25	35	43	34
9	Llanera	25	36	62	29
10	Colegio	23	28	40	25

TEMPORADA 2019/2020

LIGA NACIONAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real	26	100	23	64
2	Arenal	26	64	15	62
3	Club	26	56	25	56
4	Real Oviedo	26	44	18	53
5	Lealtad	26	49	43	41
6	Manuel Rubio	26	45	37	39
7	Vallobín	26	49	43	37
8	Llanes	26	38	41	37
9	Llano 2000	26	51	38	36
10	Covadonga	26	56	49	36
11	Caudal	26	62	77	36
12	Astur	26	32	51	31
13	Quirinal	26	34	45	30
14	Veriña	26	28	47	25
15	TSK Roces B	26	38	58	24
16	Colegio	26	40	63	17
17	Navarro	26	34	72	17
18	Romanón	26	18	93	13

TEMPORADA 2018/2019

DIVISIÓN DE HONOR GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Celta	30	78	24	80
2	Real	30	92	22	72
3	Racing	30	75	29	65
4	Ural	30	57	50	54
5	Deportivo	30	63	34	53
6	Lugo	30	52	37	50
7	Real Oviedo	30	45	26	49
8	Bansander	30	45	58	37
9	Atlético	30	46	59	36
10	Racing	30	40	55	35
11	Miñor	30	36	46	33
12	Deportivo	30	44	66	33
13	Pontevedra	30	35	62	29
14	Covadonga	30	30	62	23
15	Colindres	30	23	75	18
16	Alondras	30	20	76	13

TEMPORADA 2017/2018

LIGA NACIONAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real	34	115	22	81
2	Real Oviedo	34	71	21	79
3	Covadonga	34	76	38	68
4	Vallobín	34	64	50	63
5	Astur	34	71	50	56
6	Club	34	65	49	56
7	Llanes	34	60	48	55
8	Real Avilés	34	54	50	45
9	Caudal	34	47	59	45
10	Colegio	34	51	77	42
11	Claudio	34	50	76	41
12	Arenal	34	38	44	40
13	Manuel Rubio	34	51	64	40
14	Veriña	34	43	75	35
15	Llano 2000	34	46	69	34
16	Juventud	34	47	77	31
17	Quirinal	34	36	72	25
18	Andés CF A	34	37	81	24

TEMPORADA 2016/2017

LIGA NACIONAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real	34	132	35	81
2	Llano 2000	34	72	41	72
3	Astur	34	78	39	69
4	Real Oviedo	34	66	36	64
5	Vallobín	34	54	56	53
6	Llanes	34	58	57	52
7	Colegio	34	59	50	51
8	Covadonga	34	71	71	48
9	Andés CF A	34	49	57	46
10	Arenal	34	50	58	45
11	Veriña	34	46	68	41
12	Quirinal	34	52	71	40
13	Juventud	34	59	66	40
14	Club	34	32	45	40
15	Claudio	34	38	63	34
16	TSK Roces B	34	49	62	33
17	Corredoria	34	30	69	32
18	Montevil	34	42	93	19

TEMPORADA 2015/2016

LIGA NACIONAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real Oviedo	34	84	28	79
2	Real	34	91	38	72
3	Real Avilés	34	61	36	66
4	Club	34	69	45	64
5	Veriña	34	58	56	56
6	Quirinal	34	67	57	52
7	Claudio	34	42	48	48
8	Colegio	34	48	46	47
9	Astur	34	61	49	47
10	Llano 2000	34	63	61	43
11	Juventud	34	52	57	39
12	Llanes	34	57	64	39
13	Arenal	34	51	69	38
14	Vallobín	34	37	45	38
15	Alcava	34	50	79	37
16	Caudal	34	47	75	35
17	Covadonga	34	47	55	33
18	Raíces	34	33	110	17

TEMPORADA 2014/2015

LIGA NACIONAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real	34	86	30	81
2	Real Oviedo	34	86	33	76
3	Deportivo	34	75	45	64
4	Covadonga	34	68	44	58
5	Llano 2000	34	65	50	57
6	Quirinal	34	62	54	52
7	Vallobín	34	44	40	50
8	Arenal	34	52	51	46
9	Real Avilés	34	58	67	45
10	Club	34	46	69	45
11	Caudal	34	55	45	44
12	Colegio	34	46	66	40
13	Llanes	34	44	57	40
14	Juventud	34	45	56	40
15	Navarro	34	42	62	35
16	Braña	34	41	68	35
17	Fresneda	34	38	72	24
18	Andés CF A	34	27	71	17

TEMPORADA 2013/2014

LIGA NACIONAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real	34	95	33	79
2	Real Oviedo	34	91	41	71
3	Astur	34	62	31	66
4	Quirinal	34	66	50	63
5	Real Avilés	34	75	48	62
6	Caudal	34	66	46	57
7	Arenal	34	63	42	57
8	Navarro	34	90	57	52
9	Covadonga	34	56	57	50
10	Club	34	39	52	46
11	Ñublense	34	54	63	44
12	Fresneda	34	38	46	42
13	Colegio	34	47	63	39
14	Cd Juventud	34	48	56	37
15	Llanes	34	43	61	36
16	Claudio	34	30	58	33
17	Romanón	34	36	86	24
18	Estudiantes	34	23	132	2

TEMPORADA 2012/2013

LIGA NACIONAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Llano 2000	34	84	31	79
2	Real	34	110	44	73
3	Estudiantes	34	68	26	72
4	Astur	34	75	56	53
5	Real Oviedo	34	56	46	50
6	Fresneda	34	59	66	50
7	Romanón	34	59	55	48
8	Braña	34	39	56	44
9	Covadonga	34	54	60	43
10	Claudio	34	50	62	43
11	Club	34	41	58	43
12	Navarro	34	58	64	41
13	Arenal	34	49	54	40
14	Roces	34	52	84	39
15	Real Avilés	34	46	61	39
16	Llanes	34	44	63	34
17	Andés CF A	33	51	80	33
18	S.D. Narcea	33	44	73	32

TEMPORADA 2011/2012

LIGA NACIONAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Veriña	32	61	24	73
2	Real Oviedo	32	62	40	58
3	Real	32	90	39	58
4	Real Avilés	32	56	40	55
5	Llanes	32	57	53	54
6	Roces	32	65	43	53
7	Covadonga	32	45	37	47
8	Romanón	32	60	56	44
9	Arenal	32	49	42	42
10	Astur	32	50	55	41
11	Club	32	43	46	40
12	Claudio	32	44	55	37
13	Braña	32	49	61	37
14	Estudiantes	32	45	65	35
15	Caudal	32	54	76	34
16	Llanera	32	51	104	27
17	Raíces	32	57	102	22

TEMPORADA 2010/2011

LIGA NACIONAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real Oviedo	28	86	24	68
2	Real	28	90	42	63
3	Astur	28	49	35	50
4	Raíces	28	52	52	47
5	Llanes	28	61	56	42
6	Covadonga	28	48	52	39
7	Caudal	28	42	46	39
8	Braña	28	35	39	37
9	Real Avilés	28	54	47	37
10	Veriña	28	37	46	35
11	Arenal	28	52	63	35
12	Roces	28	36	45	30
13	Juventud	28	37	69	25
14	Navarro	28	40	60	25
15	Alcava	28	37	80	21

TEMPORADA 2009/2010

LIGA NACIONAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Alcázares	26	75	21	63
2	Real Avilés	26	63	39	49
3	Alcava	26	49	43	47
4	Real	26	63	50	43
5	Roces	26	44	37	43
6	Real Oviedo	26	45	36	42
7	La Braña	26	58	46	42
8	Juventud	26	46	46	38
9	Llanes	26	40	35	36
10	Covadonga	26	50	62	32
11	Navarro	26	46	55	28
12	Estudiantes	26	41	59	28
13	Gijon	26	32	77	19
14	Inmaculada	26	40	86	6

TEMPORADA 2008/2009

LIGA NACIONAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Astur	26	56	39	52
2	Real	26	46	29	49
3	La Braña	26	53	37	46
4	C.D.	26	49	30	46
5	Navarro	26	43	39	41
6	Roces	26	47	39	39
7	Real Oviedo	26	43	33	36
8	Estudiantes	26	37	35	35
9	Llanes	26	35	35	32
10	Arenas Club	26	32	38	31
11	Inmaculada	26	36	45	31
12	Covadonga	26	40	48	30
13	Caudal	26	28	54	25
14	Romanón	26	31	75	15

Competiciones que juega

Grupo 1

División de Honor Grupo 1

Pos	Equipos		Pts
1		Racing Sub 19	67
2		Deportivo Sub 19	66
3		RC Celta Sub 19	64
4		Real Oviedo Sub 19	54
5		Real Sporting Sub 19	46
6		SD Compostela Sub 19	46
7		Choco Sub 19	40
8		ED Val Miñor Sub 19	40
9		CD Covadonga Sub 19	35
10		Bansander Sub 19	34
11		CD Lugo Sub 19	33
12		Arosa SC Sub 19	33
13		Atlético Perines Sub 19	32
14		Veriña CF Sub 19	31
15		Coruxo FC Sub 19	18
16		CD Revilla Sub 19	14

	Playoff Título : Racing Sub 19
	Copa del Rey Juvenil : Deportivo Sub 19, RC Celta Sub 19, Real Oviedo Sub 19, Real Sporting Sub 19
	Descenso : Atlético Perines Sub 19, Veriña CF Sub 19, Coruxo FC Sub 19, CD Revilla Sub 19

RIVALES EN División de Hono.

USO DE MEMORIA

6,917,256 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1339
Total Execution Time	0.1351

CADENA URL

/historico/Cd-Covadonga-Juvenil

GET DATOS

$_GET['/historico/Cd-Covadonga-Juvenil']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0030	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-Covadonga-Juvenil' 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.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=4960 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=4960 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4960 AND type_rel = 2
0.0023	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 = '4960' ORDER BY l.year DESC,cat.coefficient DESC
0.0022	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 = '4960' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020	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 = '4960' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 73240 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020	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=4960 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (73240) 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.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 73240 AND teamId = 4960
0.0020	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 = '4960' 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 = '4960' and rp.type = 4
0.0020	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 = '4960' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0030	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 = 73240 WHERE rp.league_id = 73240 AND rp.teamId = 4960 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.0034	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 = 73240 WHERE rp.league_id = 73240 AND rp.teamId = 4960 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029	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 = 73240 WHERE rp.league_id = 73240 AND rp.teamId = 4960 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 4960 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73240 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.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* `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 = 68513 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.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* `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 = 63680 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.0024	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 = 59000 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.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 = 61833 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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_base` 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 = 50781 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.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 = 44576 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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_base` 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 = 39218 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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_base` 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 = 34228 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 16646 AND t.round = 34 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* `tables2015_base` 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 = 4205 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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* `tables2014_base` 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 = 2730 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039	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* `tables2013_base` 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 = 2124 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040	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* `tables2012_base` 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 = 1509 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038	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* `tables2011_base` 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 = 1180 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043	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* `tables2010_base` 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 = 922 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0049	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* `tables2009_base` 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 = 748 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

CD Covadonga Sub 19

CD Covadonga Sub 19

Selecciona un equipo

Competiciones que juega

División de Honor Grupo 1

RIVALES EN División de Hono.