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

CD Covadonga

Entrenador: David González

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA FEDERACIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ourense CF	32	50	19	67
2	Pontevedra	32	66	29	64
3	Zamora	32	37	19	59
4	Guijuelo	32	35	29	51
5	Langreo	32	29	38	46
6	Rayo	32	45	40	45
7	Compostela	32	31	34	44
8	Coruxo	32	35	45	42
9	Real Avilés	32	39	33	41
10	Real	32	40	50	41
11	Deportivo	32	44	44	40
12	Marino	32	25	22	39
13	Gimnástica	32	37	48	37
14	Villalbés	32	21	31	34
15	Arandina	32	34	43	31
16	Real Oviedo	32	26	39	30
17	Cayón	32	34	45	30
18	Covadonga	32	35	55	29

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Covadonga	30	53	21	65
2	Sporting	30	56	21	64
3	L´Entregu	30	42	28	60
4	UD Llanera	30	49	26	55
5	CD Praviano	30	40	23	53
6	Caudal	30	41	21	50
7	Lealtad	30	31	27	43
8	Llanes	30	36	40	40
9	Real	30	28	44	36
10	CD Colunga	30	35	39	36
11	CD Tuilla	30	39	52	36
12	UC Ceares	30	35	44	34
13	Luarca CF	30	21	32	30
14	Condal	30	20	42	25
15	Avilés	30	25	52	23
16	Valdesoto	30	22	61	14

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

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

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

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sporting	38	112	18	92
2	Real Avilés	38	90	34	85
3	Langreo	38	78	26	84
4	CD Tuilla	38	61	35	84
5	Real Oviedo	38	78	32	75
6	Marino	38	61	36	75
7	Covadonga	38	69	50	63
8	Condal	38	65	50	62
9	UC Ceares	38	47	63	49
10	Llanes	38	53	44	48
11	CD Colunga	38	51	59	48
12	Mosconia	38	38	84	35
13	UD Llanera	38	38	61	35
14	CD Praviano	38	46	78	35
15	L´Entregu	38	27	66	33
16	Club Siero	38	36	83	33
17	Atlético	38	42	78	31
18	Tineo	38	42	71	31
19	Lenense	38	50	84	30
20	Urraca CF	38	32	64	27

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Caudal	38	86	12	98
2	Langreo	38	96	25	90
3	Real Avilés	38	77	18	89
4	Marino	38	55	23	68
5	CD Tuilla	38	66	39	67
6	CD Colunga	38	60	54	66
7	Real Oviedo	38	63	42	62
8	Condal	38	50	47	60
9	Llanes	38	54	47	57
10	UC Ceares	38	42	60	45
11	Covadonga	38	35	51	45
12	Atlético	38	33	55	41
13	Mosconia	38	36	57	40
14	CD Praviano	38	39	65	40
15	Tineo	38	40	63	39
16	Club Siero	38	37	63	38
17	Urraca CF	38	34	47	36
18	Gijón	38	34	68	31
19	Astur	38	34	92	24
20	TSK Roces	38	19	62	22

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Condal	38	67	20	86
2	Caudal	38	68	18	84
3	Real Oviedo	38	82	34	78
4	CD Tuilla	38	67	31	77
5	Covadonga	38	63	39	70
6	UC Ceares	38	51	41	63
7	Llanes	38	61	51	61
8	CD Praviano	38	47	46	51
9	Urraca CF	38	50	47	50
10	Atlético	38	45	49	49
11	Mosconia	38	37	45	47
12	Real Avilés	38	46	53	46
13	Astur	38	39	52	46
14	Gijón	38	42	50	46
15	TSK Roces	38	37	43	45
16	Andés	38	44	60	43
17	L´Entregu	38	34	54	38
18	Lenense	38	38	72	30
19	Universidad	38	30	78	23
20	Cudillero	38	10	75	0

TEMPORADA 2013/2014

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Lealtad	38	62	27	76
2	Langreo	38	62	28	76
3	UC Ceares	38	54	31	74
4	CD Praviano	38	57	36	72
5	Covadonga	38	70	35	71
6	CD Tuilla	38	67	38	64
7	Universidad	38	52	30	64
8	Cudillero	38	59	51	63
9	L´Entregu	38	48	39	59
10	Condal	38	47	34	55
11	Real Avilés	38	51	55	49
12	Real Oviedo	38	46	53	48
13	Urraca CF	38	55	54	46
14	Atlético	38	49	55	46
15	Lenense	38	29	54	38
16	Gijón	38	21	50	36
17	Andés	38	32	77	34
18	Candás CF	38	35	53	34
19	Luarca CF	38	23	66	28
20	Real Tapia	38	23	76	20

TEMPORADA 2012/2013

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	CD Tuilla	38	70	35	81
2	Universidad	38	59	28	75
3	Covadonga	38	58	30	72
4	Langreo	38	54	22	71
5	Real Oviedo	38	51	47	61
6	Lealtad	38	48	42	54
7	L´Entregu	38	42	39	54
8	Condal	38	49	41	54
9	Cudillero	38	46	40	53
10	Luarca CF	38	42	43	51
11	CD Praviano	38	37	50	50
12	UC Ceares	38	43	48	48
13	Urraca CF	38	55	57	45
14	Atlético	38	42	48	43
15	Real Tapia	38	34	43	43
16	Gijón	38	35	42	43
17	Candás CF	38	37	56	42
18	Llanes	38	36	45	42
19	Navia CF	38	35	73	28
20	Navarro	38	26	70	18

TEMPORADA 2011/2012

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Caudal	38	90	21	91
2	Real Avilés	38	84	27	89
3	Langreo	38	60	30	70
4	CD Tuilla	38	50	35	66
5	Condal	38	48	37	62
6	Candás CF	38	51	41	61
7	Luarca CF	38	36	40	56
8	Universidad	38	58	53	56
9	Llanes	38	46	40	55
10	Cudillero	38	53	39	55
11	Covadonga	38	66	54	53
12	Navia CF	38	36	55	46
13	Gijón	38	35	51	45
14	Lealtad	38	41	62	44
15	Navarro	38	44	60	42
16	UC Ceares	38	40	62	40
17	Real Oviedo	38	40	55	40
18	Nalón	38	42	71	37
19	Pumarín CF	38	31	51	37
20	Colloto	38	31	98	12

TEMPORADA 2010/2011

PRIMERA RFFPA
Equipo		PJ	GF	GC	Puntos
1	Covadonga	38	70	18	91
2	Colloto	38	74	41	73
3	Pumarín CF	38	51	23	70
4	Atlético	38	59	39	66
5	Tineo	38	47	38	66
6	Urraca CF	38	64	62	53
7	Narcea	38	39	51	53
8	Valdesoto	38	52	52	52
9	La Caridad	38	47	48	51
10	Campomanes	38	59	51	50
11	Real Avilés	38	50	49	50
12	L´Entregu	38	50	47	48
13	Club Siero	38	49	62	48
14	Universidad	38	52	68	46
15	U.Comercial	38	43	59	45
16	San Martín	38	57	64	44
17	Deportiva	38	43	64	44
18	Mosconia	38	52	70	42
19	Astur	38	45	62	37
20	UD Llanera	38	37	72	26

TEMPORADA 2009/2010

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Caudal	38	73	27	83
2	Marino	38	73	36	80
3	Universidad	38	81	38	76
4	Llanes	38	68	38	70
5	Langreo	38	59	35	66
6	Ribadesella	38	63	44	65
7	CD Tuilla	38	74	56	64
8	Candás CF	38	49	32	59
9	Real Avilés	38	48	41	58
10	Lealtad	38	51	45	57
11	Navarro	38	49	57	45
12	Condal	38	36	59	44
13	UC Ceares	38	39	59	44
14	Cudillero	38	42	63	40
15	Gijón Ind.	38	37	65	39
16	CD Praviano	38	31	51	38
17	Luarca CF	38	31	53	36
18	Colloto	38	34	60	35
19	Covadonga	38	35	61	33
20	Astur	38	30	83	21

TEMPORADA 2008/2009

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real Oviedo	38	100	14	103
2	Universidad	38	68	44	73
3	Candás CF	38	58	37	70
4	Llanes	38	59	41	69
5	Langreo	38	63	39	60
6	CD Tuilla	38	50	43	58
7	Caudal	38	45	35	53
8	Gijón Ind.	38	46	65	51
9	Cudillero	38	53	54	46
10	Lealtad	38	45	49	45
11	Real Avilés	38	45	44	43
12	Condal	38	43	65	43
13	Covadonga	38	43	62	43
14	Ribadesella	38	48	60	42
15	UC Ceares	38	45	57	42
16	Navarro	38	43	59	42
17	Astur	38	49	70	41
18	Nalón	38	49	69	38
19	Club Siero	38	38	61	36
20	Mosconia	38	57	79	34

TEMPORADA 2006/2007

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Caudal	38	58	27	83
2	Lealtad	38	70	34	80
3	Langreo	38	61	30	74
4	Sporting	38	70	37	71
5	CD Tuilla	38	61	42	71
6	Real Avilés	38	52	34	61
7	Ribadesella	38	57	39	59
8	Cudillero	38	50	41	49
9	UC Ceares	38	48	58	48
10	Club Siero	38	43	41	47
11	Condal	38	50	51	46
12	Navarro	38	32	40	42
13	Llanes	38	37	52	42
14	Astur	38	49	70	40
15	Club Hispano	38	41	64	40
16	Covadonga	38	48	58	39
17	Gijón Ind.	38	42	67	38
18	CD Praviano	38	39	56	37
19	Mosconia	38	44	65	35
20	San Martín	38	41	87	29

TEMPORADA 2005/2006

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Universidad	38	74	28	80
2	Langreo	38	57	33	76
3	Ribadesella	38	59	32	72
4	Lealtad	38	70	32	71
5	Caudal	38	53	32	65
6	Astur	38	49	37	64
7	Real Avilés	38	48	43	57
8	Sporting	38	40	37	53
9	Club Siero	38	47	46	51
10	Navarro	38	37	37	50
11	Mosconia	38	42	42	50
12	Covadonga	38	45	46	49
13	Gijón	38	47	44	48
14	Condal	38	40	53	47
15	CD Tuilla	38	32	53	44
16	Club Hispano	38	40	60	40
17	UC Ceares	38	37	51	38
18	Real Tapia	38	43	48	35
19	Berrón	38	38	60	34
20	Real	38	28	112	10

TEMPORADA 2002/2003

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Caudal	38	59	17	85
2	Real	38	71	26	81
3	Sporting	38	71	28	77
4	Real Oviedo	38	67	26	75
5	Universidad	38	71	34	70
6	Lealtad	38	68	34	64
7	Gijón	38	46	36	61
8	Astur	38	52	33	61
9	Club Siero	38	54	47	57
10	Llanes	38	47	36	53
11	Club Hispano	38	47	49	52
12	Condal	38	50	61	45
13	Navia CF	38	44	61	45
14	Mosconia	38	37	45	41
15	Pumarín CF	38	39	67	39
16	Covadonga	38	33	55	35
17	Narcea	38	34	71	32
18	Navarro	38	42	57	32
19	Colloto	38	29	89	25
20	CD Turón	38	22	111	10

TEMPORADA 2000/2001

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Marino	38	77	28	82
2	Real Oviedo	38	66	28	78
3	Langreo	38	75	33	76
4	Lealtad	38	69	40	75
5	Astur	38	60	40	60
6	Navia CF	38	58	50	59
7	Real Avilés	38	56	43	56
8	Real	38	50	55	56
9	San Martín	38	61	47	55
10	CD Turón	38	46	50	50
11	Colloto	38	47	39	47
12	Mosconia	38	53	48	47
13	Pumarín CF	38	37	56	45
14	Valdesoto	38	54	73	44
15	Ribadesella	38	41	64	41
16	CD Trasona	38	36	60	41
17	Deportiva	38	48	62	40
18	Llanes	38	41	69	39
19	CD Tuilla	38	40	69	37
20	Covadonga	38	29	90	20

Competiciones que juega

Segunda Federación Grupo 1

Pos	Equipos		Pts
1		Ourense CF	67
2		Pontevedra	64
3		Zamora	59
4		Guijuelo	51
5		Langreo	46
6		Rayo Cantabria	45
7		SD Compostela	44
8		Coruxo	42
9		Real Avilés Industrial	41
10		Real Valladolid Promesas	41
11		Deportivo Fabril	40
12		Marino de Luanco	39
13		Gimnástica Torrelavega	37
14		RC Villalbés	34
15		Arandina	31
16		Real Oviedo Vetusta	30
17		Cayón	30
18		CD Covadonga	29

	Ascenso : Ourense CF
	Playoff Ascenso : Pontevedra, Zamora, Guijuelo, Langreo
	Playoff Descenso : Gimnástica Torrelavega
	Descenso : RC Villalbés, Arandina, Real Oviedo Vetusta, Cayón, CD Covadonga

RIVALES EN Copa del Rey

RIVALES EN Segunda Federaci.

USO DE MEMORIA

8,412,472 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1529
Total Execution Time	0.1541

CADENA URL

/historico/Covadonga-Juvenil

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0028	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 = '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=3274 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=3274 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=3274 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=3274 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=3274 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3274 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021	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 (1198080,637063,637527,822157,831186) ORDER BY n.cover_points DESC, update_date DESC
0.0026	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 = '3274' ORDER BY l.year DESC,cat.coefficient DESC
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 = '3274' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021	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 = '3274' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022	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=3274 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (72362,71759,71432,68529,67976) 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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 72362 AND teamId = 3274
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 67976 AND teamId = 3274
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 71759 AND teamId = 3274
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 68529 AND teamId = 3274
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 3274
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 = '3274' 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 = '3274' 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 = '3274' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0033	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 = 72362 WHERE rp.league_id = 72362 AND rp.teamId = 3274 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.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 = 72362 WHERE rp.league_id = 72362 AND rp.teamId = 3274 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 72362 WHERE rp.league_id = 72362 AND rp.teamId = 3274 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 3274 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72362 AND t.round = 33 ORDER BY team.conference ASC,t.position 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* `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 = 67976 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.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* `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.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* `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.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* `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.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* `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 = 33352 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 = 15443 AND t.round = 38 ORDER BY team.conference 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* `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 = 3912 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* `tables2014` 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 = 2552 AND t.round = 38 ORDER BY team.conference 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* `tables2013` 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 = 1943 AND t.round = 38 ORDER BY team.conference 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* `tables2012` 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 = 1399 AND t.round = 38 ORDER BY team.conference 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* `tables2011` 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 = 1129 AND t.round = 38 ORDER BY team.conference 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* `tables2010` 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 = 834 AND t.round = 38 ORDER BY team.conference 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* `tables2009` 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 = 132 AND t.round = 38 ORDER BY team.conference 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* `tables2007` 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 = 87 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* `tables2006` 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 = 22114 AND t.round = 38 ORDER BY team.conference 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* `tables2003` 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 = 22063 AND t.round = 38 ORDER BY team.conference 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* `tables2001` 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 = 22031 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

CD Covadonga

CD Covadonga

Selecciona un equipo

Competiciones que juega

Segunda Federación Grupo 1

RIVALES EN Copa del Rey

RIVALES EN Segunda Federaci.