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 Colunga

Entrenador: Pablo Pantiga

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA FEDERACIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	UD Llanera	31	96	22	78
2	Sporting	31	58	13	67
3	UC Ceares	31	47	24	61
4	L´Entregu	31	49	29	61
5	Lealtad	31	48	24	59
6	CD Praviano	31	32	21	53
7	CD Tuilla	31	50	39	45
8	Urraca CF	31	30	31	42
9	CD Colunga	31	36	38	41
10	Caudal	31	31	31	39
11	Lenense	31	28	44	33
12	Llanes	31	33	50	33
13	Avilés	31	28	41	32
14	Real	31	39	59	30
15	Condal	31	24	48	30
16	Luarca CF	31	36	65	25
17	Gijón	31	29	61	24
18	Barcia CF	31	23	77	9

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

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

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

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

TEMPORADA 2013/2014

PRIMERA RFFPA
Equipo		PJ	GF	GC	Puntos
1	TSK Roces	38	75	32	77
2	Llanes	38	86	41	76
3	Astur	38	71	38	76
4	Mosconia	38	78	38	70
5	CD Colunga	38	68	44	66
6	Rayo	38	67	50	61
7	Navarro	38	47	35	61
8	Valdesoto	38	59	46	55
9	Atlético	38	56	53	52
10	Llano 2000	38	46	44	52
11	Tineo	38	38	47	51
12	UD Llanera	38	58	56	50
13	Muros	38	56	54	50
14	U.Comercial	38	50	52	49
15	CD Turón	38	68	69	47
16	Boal CF	38	51	59	46
17	Campomanes	38	54	65	45
18	Nalón CF	38	34	54	39
19	Pumarín CF	38	53	65	31
20	Navia CF	38	21	194	3

TEMPORADA 2012/2013

PRIMERA RFFPA
Equipo		PJ	GF	GC	Puntos
1	Real Avilés	37	69	32	73
2	Lenense	37	69	53	71
3	Andés	37	69	43	70
4	Astur	37	60	32	69
5	Muros	38	83	37	68
6	Pumarín Cf	38	57	36	65
7	Valdesoto	38	53	48	60
8	TSK Roces	38	53	37	59
9	Tineo	38	60	45	59
10	Llano 2000	38	64	41	57
11	Mosconia	38	48	44	55
12	Atlético	38	51	42	51
13	Campomanes	38	53	49	48
14	Unión	38	54	60	48
15	CD Colunga	38	48	64	46
16	CD Turón	38	60	74	45
17	Nalón CF	37	55	63	43
18	Sd Colloto	37	32	49	43
19	Narcea	38	31	106	11
20	La Caridad	38	27	141	11

Competiciones que juega

Tercera Federación Grupo 2

Pos	Equipos		Pts
1		UD Llanera	78
2		Sporting Atlético	67
3		UC Ceares	61
4		L´Entregu CF	61
5		Lealtad Villaviciosa	59
6		CD Praviano	53
7		CD Tuilla	45
8		Urraca CF	42
9		CD Colunga	41
10		Caudal Deportivo	39
11		SD Lenense Proinastur	33
12		Llanes	33
13		Avilés Stadium	32
14		Real Titánico	30
15		Condal	30
16		Luarca CF	25
17		UD Gijón Industrial	24
18		Barcia CF	9

	Ascenso : UD Llanera
	Playoff Ascenso : Sporting Atlético, UC Ceares, L´Entregu CF, Lealtad Villaviciosa
	Descenso : Luarca CF, UD Gijón Industrial, Barcia CF

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.

USO DE MEMORIA

6,935,784 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.7459
Total Execution Time	0.7471

CADENA URL

/historico/Cd-Colunga-Senior

GET DATOS

$_GET['/historico/Cd-Colunga-Senior']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0154	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-Colunga-Senior' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0145	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9417 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9417 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9417 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0293	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 = 72261
0.0291	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 = 72568
0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9417 AND type_rel = 2
0.0146	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9417 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147	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 (87329,453450,822157,831531,886617) ORDER BY n.cover_points DESC, update_date DESC
0.0149	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 = '9417' ORDER BY l.year DESC,cat.coefficient DESC
0.0149	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 = '9417' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147	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 = '9417' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147	SELECT t.id,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 = 72568 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 72261 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149	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=9417 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146	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 (72568,72261) 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 = 72261 AND teamId = 9417
0.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 72568 AND teamId = 9417
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 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 = 72261 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0150	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 = '9417' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9417' 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 = '9417' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0156	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72261 WHERE rp.league_id = 72261 AND rp.teamId = 9417 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.0158	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 = 72261 WHERE rp.league_id = 72261 AND rp.teamId = 9417 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154	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 = 72261 WHERE rp.league_id = 72261 AND rp.teamId = 9417 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 9417 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72261 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.0150	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.0293	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 = 62386 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.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* `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.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* `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.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* `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 = 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.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* `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.0153	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.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* `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 = 2589 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* `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 = 1978 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

CD Colunga

CD Colunga

Selecciona un equipo

Competiciones que juega

Tercera Federación Grupo 2

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.