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 El Nacional

Entrenador: Marcelo Zuleta

Temporada 2023/2024

TEMPORADA 2023/2024

SERIE A - SEGUNDA ETAPA
Equipo		PJ	GF	GC	Puntos
1	Aucas	0	0	0	0
2	Barcelona	0	0	0	0
3	Nacional	0	0	0	0
4	CS Emelec	0	0	0	0
5	Cumbayá	0	0	0	0
6	Delfín	0	0	0	0
7	Deportivo	0	0	0	0
8	Imbabura	0	0	0	0
9	Independient	0	0	0	0
10	Libertad FC	0	0	0	0
11	Liga Quito	0	0	0	0
12	Macará	0	0	0	0
13	Mushuc Runa	0	0	0	0
14	Orense	0	0	0	0
15	Técnico	0	0	0	0
16	Universidad	0	0	0	0

TEMPORADA 2022/2023

SERIE A - SEGUNDA ETAPA
Equipo		PJ	GF	GC	Puntos
1	Liga Quito	15	21	4	36
2	Barcelona	15	24	15	32
3	Aucas	15	22	15	25
4	Delfín	15	19	12	24
5	Nacional	15	25	19	23
6	CS Emelec	15	14	8	22
7	Universidad	15	15	12	22
8	Independient	15	18	15	21
9	Técnico	15	20	17	19
10	Mushuc Runa	15	14	19	19
11	Orense	15	15	15	16
12	Deportivo	15	12	16	16
13	Libertad FC	15	12	18	15
14	Guayaquil	15	5	18	10
15	Cumbayá	15	14	26	9
16	Gualaceo	15	9	30	7

TEMPORADA 2021/2022

SERIE B - ECUADOR
Equipo		PJ	GF	GC	Puntos
1	Nacional	36	54	37	63
2	Independient	36	44	33	56
3	Libertad FC	36	42	38	56
4	América	36	41	31	54
5	Imbabura	36	47	51	47
6	Chacaritas	36	30	38	43
7	Búhos ULVR	36	33	38	42
8	Manta	36	29	39	42
9	Atlético	36	31	36	39
10	CD Olmedo	36	33	43	38

TEMPORADA 2020/2021

SERIE B - ECUADOR
Equipo		PJ	GF	GC	Puntos
1	Cumbayá	36	47	36	67
2	Gualaceo	36	46	31	60
3	Nacional	36	49	36	59
4	Chacaritas	36	35	34	49
5	América	36	41	33	47
6	Búhos ULVR	36	41	53	47
7	Independient	36	45	46	43
8	Atlético	36	37	44	42
9	Atlético	36	46	64	39
10	Portoviejo	36	42	52	37

TEMPORADA 2019/2020

SERIE A - SEGUNDA ETAPA
Equipo		PJ	GF	GC	Puntos
1	Barcelona	15	22	7	29
2	Guayaquil	15	23	17	26
3	CS Emelec	14	24	14	25
4	Liga Quito	15	31	20	24
5	Deportivo	15	18	21	23
6	Independient	15	26	21	22
7	Orense	15	12	19	21
8	Universidad	15	16	14	20
9	Delfín	15	22	19	20
10	Técnico	15	11	11	20
11	Macará	15	15	20	20
12	Aucas	15	33	32	19
13	Portoviejo	15	20	29	17
14	Mushuc Runa	15	17	23	13
15	CD Olmedo	14	15	23	13
16	Nacional	15	10	25	12

TEMPORADA 2018/2019

SERIE A - ECUADOR
Equipo		PJ	GF	GC	Puntos
1	Macará	30	47	17	62
2	Barcelona	30	56	38	55
3	Universidad	30	48	29	53
4	Delfín	30	46	33	53
5	Independient	30	41	29	52
6	Liga Quito	30	46	30	49
7	Aucas	30	48	44	49
8	CS Emelec	30	43	30	46
9	Nacional	30	41	34	44
10	Deportivo	30	44	46	42
11	CD Olmedo	30	34	44	34
12	Guayaquil	30	35	48	31
13	Mushuc Runa	30	36	58	30
14	Técnico	30	40	60	29
15	América	30	26	41	25
16	Fuerza	30	24	74	6

TEMPORADA 2017/2018

SERIE A - SEGUNDA ETAPA
Equipo		PJ	GF	GC	Puntos
1	CS Emelec	22	35	17	41
2	Macará	22	31	24	38
3	Liga Quito	22	32	19	37
4	Delfín	22	34	22	36
5	Barcelona	22	28	21	35
6	Independient	22	31	24	33
7	Aucas	22	25	25	33
8	Universidad	22	29	32	27
9	Técnico	22	33	38	27
10	Deportivo	22	23	31	23
11	Nacional	22	29	47	16
12	Guayaquil	22	19	49	14

TEMPORADA 2016/2017

SERIE A - SEGUNDA ETAPA
Equipo		PJ	GF	GC	Puntos
1	CS Emelec	22	39	20	45
2	Nacional	22	46	26	41
3	Macará	22	28	17	37
4	Delfín	22	30	20	37
5	Liga Quito	22	41	32	35
6	Independient	22	41	30	34
7	Barcelona	22	26	20	32
8	Deportivo	22	27	26	32
9	Guayaquil	22	15	31	19
10	Universidad	22	23	41	17
11	Clan Juvenil	22	31	56	17
12	Fuerza	22	17	45	12

TEMPORADA 2015/2016

SERIE A - PRIMERA ETAPA
Equipo		PJ	GF	GC	Puntos
1	Barcelona	22	51	19	47
2	CS Emelec	22	37	23	43
3	Nacional	22	32	28	36
4	Deportivo	22	29	25	34
5	Independient	22	28	28	34
6	Liga Quito	22	20	23	31
7	Universidad	22	27	27	28
8	Guayaquil	22	29	35	27
9	Fuerza	22	22	28	24
10	Delfín	22	23	30	23
11	Aucas	22	21	34	19
12	Mushuc Runa	22	19	38	15

TEMPORADA 2014/2015

SERIE A - PRIMERA ETAPA
Equipo		PJ	GF	GC	Puntos
1	Liga Quito	22	28	10	47
2	CS Emelec	22	41	18	45
3	Independient	22	35	24	42
4	Barcelona	22	33	24	32
5	Dep. Quito	22	33	37	29
6	Nacional	22	28	24	28
7	Guayaquil	22	27	32	26
8	Mushuc Runa	22	25	38	26
9	Deportivo	22	25	37	23
10	Aucas	22	32	34	22
11	Universidad	22	22	31	21
12	LDU Loja	22	17	37	16

TEMPORADA 2013/2014

SERIE A - SEGUNDA ETAPA
Equipo		PJ	GF	GC	Puntos
1	Barcelona	22	33	16	48
2	Independient	22	42	18	46
3	CS Emelec	22	40	22	44
4	Liga Quito	22	38	22	40
5	Nacional	22	23	26	29
6	Universidad	22	25	30	28
7	Deportivo	22	23	29	28
8	LDU Loja	22	21	31	22
9	Mushuc Runa	22	19	30	21
10	Manta	22	25	35	20
11	Dep. Quito	22	17	32	20
12	CD Olmedo	22	18	33	16

TEMPORADA 2012/2013

SERIE A - PRIMERA ETAPA
Equipo		PJ	GF	GC	Puntos
1	CS Emelec	22	28	17	45
2	Liga Quito	22	26	19	41
3	Independient	22	37	25	39
4	Dep. Quito	22	41	24	38
5	Barcelona	22	33	19	38
6	Universidad	22	34	35	33
7	Nacional	22	29	33	26
8	Deportivo	22	29	36	25
9	Deportivo	22	26	34	23
10	Manta	22	26	33	22
11	LDU Loja	22	21	33	17
12	Macará	22	14	36	16

Competiciones que juega

Grupo 2

Serie A - Primera Etapa

Pos	Equipos		Pts
1		Aucas	23
2		Independiente del Valle	22
3		Universidad Católica	18
4		Liga de Quito	18
5		CS Emelec	17
6		Barcelona SC	15
7		Macará	14
8		CD El Nacional	12
9		Técnico Universitario	12
10		Orense	9
11		Deportivo Cuenca	8
12		Mushuc Runa	8
13		Imbabura	8
14		Cumbayá	8
15		Delfín	6
16		Libertad FC	2

	Series Finales : Aucas

RIVALES EN Fase Previa Copa.

RIVALES EN Serie A - Segund.

RIVALES EN Serie A - Primer.

USO DE MEMORIA

6,304,280 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6254
Total Execution Time	0.6266

CADENA URL

/historico/Cd-El-Nacional

GET DATOS

$_GET['/historico/Cd-El-Nacional']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5585 AND type_rel = 2
0.0148	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5585 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0149	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 (2413,36717,42579,45970,46911) ORDER BY n.cover_points DESC, update_date DESC
0.0163	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 = '5585' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74906 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0155	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=5585 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 (75177,75066,74906,67320) 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.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 75066 AND teamId = 5585
0.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 75177 AND teamId = 5585
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 74906 AND teamId = 5585
0.0153	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 5585
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 = 75066 WHERE rp.league_id = 75066 AND rp.teamId = 5585 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.0161	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 = 75066 WHERE rp.league_id = 75066 AND rp.teamId = 5585 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152	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 = 75066 WHERE rp.league_id = 75066 AND rp.teamId = 5585 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154	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 = 5585 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0149	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 = 75177 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 70963 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 70989 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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 = 66932 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 61763 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 53546 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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 = 53547 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 48704 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 42559 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 44213 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 37745 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 38974 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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 = 31047 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 20247 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 15436 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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 = 9060 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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 = 3511 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 4048 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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 = 2411 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

CD El Nacional

CD El Nacional

Selecciona un equipo

Competiciones que juega

Serie A - Primera Etapa

RIVALES EN Fase Previa Copa.

RIVALES EN Serie A - Segund.

RIVALES EN Serie A - Primer.