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

CD Coria

Entrenador: Miguel Avila

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA FEDERACIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Benito	31	60	13	69
2	CD Coria	31	57	19	65
3	CD Azuaga	31	45	31	55
4	Villafranca	31	41	24	49
5	Castuera	31	41	35	46
6	Diocesano	31	45	43	45
7	Moralo	31	47	42	44
8	CF Jaraíz	31	45	45	42
9	Calamonte	31	37	44	41
10	Arroyo	31	33	33	41
11	Jerez	31	38	46	39
12	Olivenza	31	29	34	38
13	Pueblonuevo	31	29	42	36
14	Trujillo	31	29	36	34
15	Álvaro	31	28	45	31
16	Montehermoso	31	33	50	31
17	Racing	31	29	54	26
18	Fuente	31	25	55	23

TEMPORADA 2022/2023

SEGUNDA FEDERACIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	UD Melilla	34	41	15	66
2	Atlético B	34	60	33	65
3	Navalcarnero	34	46	28	62
4	Cacereño	34	35	23	55
5	Gimnástica	34	48	44	52
6	Villanovense	34	29	25	50
7	Guadalajara	34	49	35	48
8	CD Estepona	34	35	26	47
9	Unión	34	43	43	46
10	Cerdanyola	34	28	45	41
11	Atlético	34	38	39	41
12	UD Montijo	34	33	47	39
13	CD Coria	34	31	43	39
14	Leganés B	34	31	39	37
15	Alcorcón B	34	34	42	35
16	Diocesano	34	33	43	34
17	Yugo	34	25	41	33
18	Benito	34	19	47	32

TEMPORADA 2021/2022

SEGUNDA FEDERACIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Córdoba CF	34	86	29	82
2	AD Mérida	34	49	26	62
3	Cacereño	34	48	37	61
4	AD Ceuta FC	34	46	32	54
5	CD Coria	34	42	40	53
6	Roque Lepe	34	39	28	52
7	Cádiz	34	36	35	50
8	Villanovense	34	39	28	50
9	UD Montijo	34	37	38	47
10	Xerez	34	28	40	47
11	Vélez CF	34	39	42	46
12	Antequera	34	36	37	44
13	Benito	34	43	42	41
14	Mensajero	34	35	47	35
15	Palmas	34	41	61	31
16	Fernando	34	30	55	29
17	Panadería	34	32	61	25
18	Tamaraceite	34	36	64	25

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	UD Montijo	20	34	5	49
2	CD Coria	20	36	14	45
3	Moralo	20	28	9	42
4	Extremadura	20	28	17	32
5	Plasencia	20	27	14	30
6	Aceuchal	20	22	25	26
7	Calamonte	20	23	25	23
8	Chinato	20	17	32	15
9	Campanario	20	13	35	15
10	CP Valdivia	20	14	44	13
11	AD Lobón	20	10	32	12
12	Cacereño	20	43	9	50
13	Diocesano	20	37	12	44
14	Jerez	20	23	16	36
15	Miajadas	20	21	19	28
16	Arroyo	20	15	24	25
17	CD Azuaga	20	18	25	23
18	Llerenense	20	14	26	22
19	Trujillo	20	25	28	19
20	Racing	20	13	33	19
21	Olivenza	20	20	26	18
22	Fuente	20	18	29	16

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Villanovense	28	56	19	66
2	CD Coria	28	54	23	65
3	Cacereño	27	63	20	62
4	Extremadura	28	42	27	52
5	Moralo	28	53	32	52
6	Jerez	28	35	26	44
7	Trujillo	28	39	41	43
8	Arroyo	28	33	33	42
9	Aceuchal	27	41	37	41
10	Diocesano	28	48	34	40
11	CD Azuaga	28	36	35	39
12	Olivenza	28	39	52	37
13	Plasencia	28	29	38	35
14	Calamonte	28	36	44	34
15	UD Montijo	28	34	40	31
16	Miajadas	28	27	46	30
17	Fuente	28	29	47	29
18	Llerenense	28	22	38	23
19	Racing	28	19	56	15
20	CP Valdivia	28	18	65	7

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	AD Mérida	38	92	23	91
2	Cacereño	38	71	26	80
3	Moralo	38	63	23	80
4	CD Coria	38	63	23	71
5	Plasencia	38	65	33	70
6	Jerez	38	64	49	61
7	Extremadura	38	55	31	58
8	CD Azuaga	38	46	43	51
9	Diocesano	38	40	45	49
10	Calamonte	38	44	45	49
11	Llerenense	38	43	71	44
12	Olivenza	38	45	60	43
13	CP Valdivia	38	49	66	43
14	UD Montijo	38	41	54	42
15	Arroyo	38	31	44	42
16	Aceuchal	38	35	52	40
17	Racing	38	39	76	38
18	Pueblonuevo	38	20	46	37
19	Castuera	38	43	73	31
20	Valdelacalza	38	22	88	17

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Benito	38	68	18	89
2	Cacereño	38	63	20	87
3	Plasencia	38	75	29	86
4	CD Coria	38	73	23	79
5	Moralo	38	74	30	79
6	Jerez	38	72	50	63
7	Diocesano	38	48	53	52
8	CD Azuaga	38	46	44	51
9	Calamonte	38	44	47	47
10	UD Montijo	38	34	55	45
11	Aceuchal	38	44	55	43
12	Castuera	38	48	70	42
13	Extremadura	38	52	60	41
14	Olivenza	38	38	58	39
15	CP Valdivia	38	23	41	39
16	Pueblonuevo	38	41	61	39
17	Arroyo	38	34	64	36
18	Amanecer	38	37	67	35
19	Trujillo	38	32	64	34
20	Santa Amalia	38	38	75	30

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Cacereño	38	81	16	92
2	CD Badajoz	38	90	17	85
3	Jerez	38	57	26	79
4	CD Azuaga	38	83	42	74
5	CD Coria	38	62	29	72
6	Benito	38	62	26	68
7	Calamonte	38	70	39	62
8	Plasencia	38	59	56	59
9	Moralo	38	57	58	52
10	Olivenza	38	44	54	47
11	UD Montijo	38	41	59	43
12	Amanecer	38	52	58	43
13	Extremadura	38	49	55	40
14	CP Valdivia	38	34	63	39
15	Arroyo	38	31	64	37
16	Santa Amalia	38	34	82	36
17	Pueblonuevo	38	34	64	35
18	Fuente	38	42	69	34
19	Diter Zafra	38	34	95	24
20	Estrella	38	34	78	22

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Extremadura	38	106	25	90
2	CD Badajoz	38	90	25	87
3	Arroyo	38	78	23	84
4	Jerez	38	69	24	83
5	Benito	38	53	39	66
6	CD Azuaga	38	75	47	64
7	Calamonte	38	68	66	62
8	Pueblonuevo	38	49	41	57
9	CD Coria	38	56	44	55
10	Diter Zafra	38	45	65	47
11	José	38	39	59	46
12	Moralo	38	53	58	44
13	Fuente	38	46	66	43
14	CP Valdivia	38	34	63	42
15	Olivenza	38	38	61	36
16	Amanecer	38	35	66	33
17	Santa Amalia	38	35	70	31
18	Sanvicenteñ	38	36	83	31
19	Valdelacalza	38	29	71	27
20	Deportivo	38	42	80	25

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	AD Mérida	38	101	20	98
2	Extremadura	38	86	24	87
3	Jerez	38	70	18	81
4	CD Badajoz	38	71	31	77
5	CD Coria	38	55	40	66
6	Moralo	38	65	44	65
7	Benito	38	48	37	64
8	CD Azuaga	38	44	44	55
9	Pueblonuevo	38	50	42	52
10	Santa Amalia	38	44	50	51
11	Diter Zafra	38	51	48	50
12	Fuente	38	39	61	42
13	José	38	48	75	42
14	Olivenza	38	46	69	40
15	CP Valdivia	38	43	73	37
16	Sanvicenteñ	38	34	61	34
17	Deportivo	38	46	93	33
18	Castuera	38	39	68	33
19	Plasencia	38	49	83	27
20	Hernán	38	35	83	27

TEMPORADA 2013/2014

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Villanovense	40	77	17	100
2	AD Mérida	40	88	27	94
3	Jerez	40	77	21	94
4	Deportivo	40	84	17	94
5	CD Coria	40	81	35	87
6	Extremadura	40	78	36	74
7	Benito	40	52	35	59
8	Diter Zafra	40	68	60	53
9	Pueblonuevo	40	66	54	53
10	Plasencia	40	66	63	52
11	CD Azuaga	40	68	78	52
12	José	40	48	49	52
13	Olivenza	40	38	49	46
14	Hernán	40	28	49	46
15	Santa Amalia	40	43	69	45
16	Castuera	40	51	68	45
17	Fuente	40	48	61	41
18	Cacereño	40	32	81	31
19	Miajadas	40	42	110	24
20	Valverdeño	40	48	103	20
21	Ciudad	40	27	128	9

TEMPORADA 2012/2013

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Extremadura	38	75	14	89
2	Deportivo	38	67	24	80
3	Benito	38	55	23	79
4	Diter Zafra	38	57	23	77
5	Jerez Cf	38	51	37	59
6	AD Mérida	38	47	38	56
7	Ciudad	38	50	38	55
8	Plasencia	38	55	47	55
9	Santa Amalia	37	49	51	52
10	CD Coria	38	48	49	51
11	José	38	44	58	48
12	Pueblonuevo	38	41	60	43
13	Cd Miajadas	37	37	53	42
14	Valverdeño	38	40	56	42
15	Hernán	38	37	65	41
16	Cacereño	38	48	57	40
17	Fuente	38	42	68	39
18	Moralo	38	33	52	38
19	Emérita	38	44	77	31
20	Valdelacalza	38	35	65	28

TEMPORADA 2011/2012

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Arroyo	38	100	22	95
2	Diter Zafra	38	63	38	81
3	Extremadura	38	75	23	78
4	Benito	38	63	29	78
5	Jerez	38	56	34	69
6	Miajadas	38	52	52	56
7	Deportivo	38	53	49	53
8	Mérida UD	38	42	43	53
9	CD Coria	38	49	55	50
10	Ciudad	38	45	46	45
11	Valdelacalza	38	31	42	45
12	Plasencia	38	41	62	45
13	Santa Amalia	38	53	67	44
14	Hernán	38	28	39	42
15	Pueblonuevo	38	59	83	41
16	Moralo	38	32	43	40
17	José	38	60	67	39
18	Sanvicenteñ	38	45	77	36
19	Villafranca	38	45	74	29
20	Chinato	38	27	74	20

TEMPORADA 2010/2011

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Villanovense	38	83	30	93
2	Sporting	38	81	24	92
3	Arroyo	38	64	37	70
4	Jerez	38	61	32	64
5	Mérida UD	38	48	32	58
6	Santa Amalia	38	56	51	56
7	Benito	38	48	47	56
8	Moralo	38	47	45	54
9	Miajadas	38	38	41	54
10	Sanvicenteñ	38	47	39	51
11	Ciudad	38	41	47	49
12	Diter Zafra	38	45	50	49
13	Plasencia	38	39	48	47
14	CD Coria	38	42	52	47
15	José	38	52	61	44
16	Deportivo	38	53	68	42
17	Valdelacalza	38	38	52	39
18	Santa Marta	38	34	58	35
19	Olivenza	38	39	72	30
20	Imperio	38	28	98	18

TEMPORADA 2009/2010

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	CD Badajoz	38	109	19	101
2	Jerez	38	76	14	89
3	Extremadura	38	77	26	79
4	Arroyo	38	72	43	74
5	Mérida UD	38	55	28	72
6	Villanueva	38	71	50	67
7	Ciudad	38	54	49	57
8	Benito	38	48	50	53
9	Sanvicenteñ	38	47	48	51
10	Imperio	38	59	56	47
11	Olivenza	38	33	45	47
12	Miajadas	38	28	42	44
13	Deportivo	38	54	68	43
14	Moralo	38	40	52	43
15	Valdelacalza	38	35	54	40
16	CD Coria	38	50	76	34
17	Santa Marta	38	43	69	31
18	Montehermoso	38	31	79	30
19	Estrella	38	27	84	27
20	Villafranca	38	30	87	23

TEMPORADA 2008/2009

PREFERENTE EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Coria	38	124	44	88
2	Montehermoso	38	84	33	84
3	Arroyo	38	105	45	78
4	Ciudad	38	72	33	75
5	Amanecer	38	59	39	69
6	Castuera	38	74	57	62
7	Gimnástico	37	57	39	61
8	Trujillo	38	66	60	55
9	Hernán	38	54	54	52
10	Sagrada Cena	38	72	74	51
11	Chinato	38	61	74	50
12	Talayuela	38	45	74	45
13	Moraleja	38	56	74	44
14	Santa Amalia	38	55	66	43
15	Gargáligas	38	51	76	41
16	Orellana	37	44	69	39
17	Malpartida	38	43	68	39
18	Ciudad	38	48	82	34
19	Zurbarán	38	46	81	33
20	Brocense	38	21	95	19

TEMPORADA 2006/2007

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Jerez	38	47	16	82
2	Benito	38	77	25	82
3	Imperio	38	67	28	81
4	Cacereño	38	71	31	75
5	Diter Zafra	38	57	21	73
6	Villanueva	38	60	24	67
7	CD Badajoz	38	50	34	58
8	Miajadas	38	62	64	57
9	Extremadura	38	44	39	56
10	Villafranca	38	51	49	55
11	Estrella	38	45	49	48
12	Moralo	38	42	43	47
13	Plasencia	38	48	44	45
14	Santa Amalia	38	46	58	43
15	Sanvicenteñ	38	40	60	43
16	Olivenza	38	30	47	41
17	CD Coria	38	46	63	38
18	Castuera	38	30	67	28
19	Monesterio	38	19	71	20
20	Moraleja	38	38	137	12

TEMPORADA 2005/2006

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Villanovense	40	75	35	90
2	Cerro Reyes	40	93	28	88
3	Benito	40	86	32	82
4	Villanueva	40	67	35	81
5	Miajadas	40	68	64	65
6	Jerez	40	61	50	62
7	Imperio	40	57	49	61
8	Plasencia	40	57	55	59
9	Cacereño	40	54	50	57
10	Estrella	40	42	51	57
11	Santa Amalia	40	44	52	51
12	Extremadura	40	56	69	47
13	CD Coria	40	57	83	46
14	Villafranca	40	46	60	45
15	Moralo	40	38	54	45
16	Olivenza	40	43	62	44
17	Monesterio	40	38	58	40
18	Amanecer	40	39	56	39
19	Alburquerque	40	46	65	39
20	Santa Marta	40	34	67	37
21	CP Valdivia	40	38	64	31

TEMPORADA 2004/2005

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Mérida UD	38	69	12	93
2	Villanovense	38	99	33	86
3	Cerro Reyes	38	90	27	86
4	Moralo	38	62	32	76
5	Imperio	38	58	29	73
6	Sporting	38	59	36	68
7	Cacereño	38	51	33	62
8	Plasencia	38	61	46	58
9	Extremadura	38	56	57	49
10	CD Coria	38	50	68	48
11	Miajadas	38	52	66	45
12	Villafranca	38	50	56	43
13	Estrella	38	36	53	43
14	Santa Amalia	38	32	43	38
15	Olivenza	38	34	60	38
16	Monesterio	38	26	63	36
17	Amanecer	38	34	68	34
18	Badajoz	38	37	58	32
19	Burguillos	38	31	95	25
20	Arroyo	38	36	88	19

TEMPORADA 2003/2004

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Benito	38	83	16	87
2	Diter Zafra	38	67	25	78
3	Plasencia	38	63	35	75
4	Cerro Reyes	38	72	28	74
5	Badajoz	38	49	29	63
6	Santa Amalia	38	57	38	62
7	Extremadura	38	60	58	61
8	Villanueva	38	53	41	59
9	Cacereño B	38	49	51	55
10	Burguillos	38	56	57	52
11	CD Coria	38	56	69	50
12	Moralo	38	48	43	47
13	Villafranca	38	39	43	47
14	Estrella	38	29	50	43
15	Amanecer	38	33	58	41
16	Arroyo	38	37	58	41
17	Monesterio	38	38	75	38
18	Alburquerque	38	37	61	34
19	UD Montijo	38	28	61	30
20	Ciudad	38	33	91	17

Competiciones que juega

Tercera Federación Grupo 14

Pos	Equipos		Pts
1		CD Don Benito	69
2		CD Coria	65
3		CD Azuaga	55
4		Villafranca	49
5		Castuera	46
6		CD Diocesano	45
7		Moralo	44
8		CF Jaraíz	42
9		Calamonte	41
10		Arroyo	41
11		Jerez	39
12		Olivenza	38
13		Pueblonuevo	36
14		Trujillo	34
15		CD Don Álvaro	31
16		Montehermoso	31
17		Racing Valverdeño	26
18		UD Fuente de Cantos	23

	Ascenso : CD Don Benito
	Playoff Ascenso : CD Coria, CD Azuaga, Villafranca, Castuera
	Descenso : Montehermoso, Racing Valverdeño, UD Fuente de Cantos

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.

USO DE MEMORIA

8,391,352 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6390
Total Execution Time	0.6402

CADENA URL

/historico/Cd-Coria

GET DATOS

$_GET['/historico/Cd-Coria']

POST DATOS

No hay datos POST existentes

CONSULTAS (37)

0.0264	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72676
0.0127	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=677 AND type_rel = 2
0.0136	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 677 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0131	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 (343583,427710,428153,428205,637063) ORDER BY n.cover_points DESC, update_date DESC
0.0134	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 = '677' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 72676 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131	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=677 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127	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 (72676,72274,71699,71432,69563,67969) 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.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 67969 AND teamId = 677
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 72274 AND teamId = 677
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 69563 AND teamId = 677
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 71699 AND teamId = 677
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 72676 AND teamId = 677
0.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 677
0.0137	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 = 72274 WHERE rp.league_id = 72274 AND rp.teamId = 677 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.0135	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 = 72274 WHERE rp.league_id = 72274 AND rp.teamId = 677 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135	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 = 72274 WHERE rp.league_id = 72274 AND rp.teamId = 677 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135	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 = 677 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0135	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 = 72274 AND t.round = 32 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137	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 = 67969 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.0146	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 = 58593 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.0145	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 = 50282 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.0145	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 = 44402 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144	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 = 39038 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* `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 = 33364 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0171	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 = 15456 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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 = 3923 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 2563 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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 = 1958 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139	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 = 1450 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136	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 = 1125 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 814 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 296 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 99 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136	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 = 22126 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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* `tables2005` 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 = 22107 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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* `tables2004` 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 = 22091 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

CD Coria

CD Coria

Selecciona un equipo

Competiciones que juega

Tercera Federación Grupo 14

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.