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

Cúcuta Deportivo

Entrenador: Federico Barrionuevo

Temporada 2023/2024

TEMPORADA 2023/2024

APERTURA PRIMERA B COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Atlético	13	21	6	33
2	Cúcuta	13	18	11	25
3	Llaneros	13	19	10	23
4	Real	13	18	9	23
5	Tigres FC	13	18	10	22
6	Unión	13	22	16	22
7	Deportes	13	16	13	20
8	Orsomarso	13	19	16	19
9	Real	13	19	19	16
10	Barranquilla	13	15	16	15
11	Boca Juniors	13	11	16	15
12	Leones	13	16	19	13
13	Internaciona	13	13	17	13
14	Bogotá	13	13	30	10
15	Real	13	14	26	8
16	Atlético	13	5	23	5

TEMPORADA 2022/2023

CLAUSURA PRIMERA B COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Fortaleza	16	24	9	39
2	Llaneros	16	19	10	27
3	Cúcuta	16	22	15	27
4	Real	16	20	15	27
5	Barranquilla	16	20	19	26
6	Leones	16	28	23	24
7	Atlético	16	19	19	24
8	Boca Juniors	16	13	14	22
9	Patriotas	16	19	19	21
10	Real	16	18	19	21
11	Deportes	16	13	18	18
12	Internaciona	16	17	15	17
13	Bogotá	16	11	17	16
14	Orsomarso	16	11	20	15
15	Real	16	13	19	14
16	Tigres FC	16	12	28	9

TEMPORADA 2021/2022

CLAUSURA PRIMERA B COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Fortaleza	16	23	11	28
2	Deportes	16	24	16	28
3	Atlético	16	32	22	25
4	Barranquilla	16	23	19	25
5	Llaneros	16	18	14	25
6	Tigres FC	16	19	19	25
7	Boyacá	16	16	10	24
8	Real	16	18	15	24
9	Bogotá	16	21	20	23
10	Atlético	16	14	18	23
11	Cúcuta	16	19	18	22
12	Leones	16	22	24	19
13	Boca Juniors	16	17	20	19
14	Real	16	18	26	16
15	Real	16	18	27	10
16	Orsomarso	16	7	30	7

TEMPORADA 2019/2020

APERTURA COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Santa Fe	20	34	17	40
2	Deportes	20	30	16	37
3	Nacional	20	39	31	35
4	Deportivo	20	32	23	34
5	Deportivo	20	27	19	34
6	América	20	31	22	33
7	Junior	20	27	17	33
8	La Equidad	20	30	23	32
9	Águilas	20	27	21	31
10	Millonarios	20	29	21	30
11	Once Caldas	20	23	20	29
12	Envigado	20	22	25	23
13	Atlético	20	16	26	21
14	Independient	20	22	28	20
15	Alianza FC	20	22	35	19
16	Deportivo	20	17	24	18
17	Jaguares FC	20	21	30	17
18	Patriotas	20	10	21	17
19	Boyacá	20	13	33	15
20	Cúcuta	20	18	38	14

TEMPORADA 2018/2019

CLAUSURA COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Nacional	20	30	17	35
2	América	20	29	26	35
3	Deportivo	20	34	25	34
4	Junior	20	16	9	33
5	Santa Fe	20	22	12	32
6	Deportes	20	24	16	32
7	Alianza FC	20	17	14	32
8	Cúcuta	20	28	28	32
9	Independient	20	32	26	31
10	Once Caldas	20	26	20	28
11	Millonarios	20	24	27	28
12	Atlético	20	23	23	25
13	Águilas	20	25	27	24
14	Deportivo	20	24	25	23
15	Patriotas	20	19	20	23
16	Envigado	20	23	28	23
17	La Equidad	20	19	24	20
18	Atlético	20	13	24	16
19	Jaguares FC	20	11	34	15
20	Unión	20	14	28	14

TEMPORADA 2017/2018

PRIMERA B COLOMBIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Cúcuta	6	9	3	13
2	Internaciona	6	8	9	9
3	Llaneros	6	7	9	7
4	Real	6	7	10	6
5	Unión	6	13	4	16
6	Deportes	6	10	7	10
7	Deportivo	6	10	10	9
8	Real	6	1	13	0

TEMPORADA 2016/2017

CLAUSURA PRIMERA B COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Barranquilla	16	21	10	33
2	Deportivo	16	23	13	30
3	Deportes	16	28	19	30
4	Leones	16	20	15	30
5	Cúcuta	16	30	20	27
6	Llaneros	16	26	23	25
7	Real	16	20	20	24
8	Orsomarso	16	16	14	23
9	Boyacá	16	16	15	23
10	Unión	16	20	22	20
11	Atlético	16	13	25	18
12	Bogotá	16	10	19	14
13	Real	16	14	28	14
14	Real	16	21	25	14
15	Fortaleza	16	14	19	12
16	Universitari	16	13	18	12

TEMPORADA 2015/2016

PRIMERA B COLOMBIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Deportivo	32	58	28	70
2	América	32	48	24	60
3	Real	32	47	36	57
4	Leones	32	43	31	49
5	Universitari	32	37	35	49
6	Tigres FC	32	26	24	48
7	Deportes	32	36	33	44
8	Bogotá	32	37	39	44
9	Real	32	34	37	44
10	Cúcuta	32	35	31	42
11	Orsomarso	32	35	48	40
12	Barranquilla	32	31	37	35
13	Unión	32	30	39	35
14	Real	32	33	51	33
15	Llaneros	32	31	42	31
16	Atlético	32	19	45	25

TEMPORADA 2014/2015

CLAUSURA COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Nacional	20	33	7	45
2	Junior	20	31	23	36
3	Deportes	20	23	14	35
4	Independient	20	23	18	35
5	Once Caldas	20	25	14	34
6	Alianza FC	20	18	12	33
7	Deportivo	20	30	28	32
8	Santa Fe	20	26	15	31
9	Patriotas	20	24	19	31
10	Deportivo	20	25	26	30
11	Millonarios	20	20	16	28
12	La Equidad	20	22	27	28
13	Envigado	20	18	18	25
14	Águilas	20	17	16	24
15	Internaciona	20	20	20	24
16	Uniautónoma	20	18	26	22
17	Boyacá	20	10	29	17
18	Atlético	20	12	28	16
19	Cúcuta	20	15	37	12
20	Jaguares FC	20	18	35	10

TEMPORADA 2013/2014

CLAUSURA PRIMERA B COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Jaguares FC	18	27	18	34
2	Deportivo	18	28	15	33
3	Deportes	18	28	17	33
4	Deportivo	18	26	15	33
5	Unión	18	32	20	32
6	Cúcuta	18	21	15	32
7	Atlético	18	23	19	31
8	América	18	25	17	30
9	Real	18	20	18	30
10	Internaciona	18	21	19	25
11	Real	18	16	18	25
12	Llaneros	18	25	25	22
13	Universitari	18	17	29	19
14	Real	18	17	24	18
15	Tigres FC	18	11	20	13
16	Atlético	18	18	35	13
17	Bogotá	18	17	29	11
18	Barranquilla	18	11	30	11

TEMPORADA 2012/2013

CLAUSURA COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Nacional	18	29	12	37
2	Millonarios	18	28	18	31
3	Junior	18	29	24	30
4	Deportivo	18	22	13	28
5	Once Caldas	18	24	17	28
6	Santa Fe	18	24	17	28
7	Deportivo	18	21	20	27
8	Águilas	18	20	20	27
9	Independient	18	24	19	24
10	La Equidad	18	24	21	23
11	Patriotas	18	17	17	23
12	Envigado	18	17	22	22
13	Deportes	18	19	23	21
14	Atlético	18	24	30	20
15	Alianza FC	18	14	24	18
16	Cúcuta	18	19	27	16
17	Boyacá	18	21	29	15
18	Deportes	18	10	33	14

TEMPORADA 2011/2012

CLAUSURA COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Millonarios	18	25	9	37
2	La Equidad	18	26	17	33
3	Junior	18	27	14	32
4	Águilas	18	23	12	32
5	Nacional	18	25	14	30
6	Deportes	18	27	19	29
7	Independient	18	23	18	26
8	Deportivo	18	22	20	25
9	Cúcuta	18	22	22	24
10	Santa Fe	18	18	22	23
11	Deportivo	18	21	22	22
12	Boyacá	18	19	22	22
13	Deportes	18	20	25	22
14	Envigado	18	15	18	21
15	Once Caldas	18	19	27	19
16	Patriotas	18	17	28	17
17	Atlético	18	12	31	12
18	Real	18	13	34	12

Competiciones que juega

Apertura Primera B Colombia

Pos	Equipos		Pts
1		Atlético Huila	33
2		Cúcuta Deportivo	25
3		Llaneros	23
4		Real Cartagena	23
5		Tigres FC	22
6		Unión Magdalena	22
7		Deportes Quindío	20
8		Orsomarso SC	19
9		Real Cundinamarca	16
10		Barranquilla	15
11		Boca Juniors de Cali	15
12		Leones	13
13		Internacional de Palmira	13
14		Bogotá	10
15		Real Santander	8
16		Atlético Fútbol Club	5

	Siguiente Ronda : Atlético Huila, Cúcuta Deportivo, Llaneros, Real Cartagena, Tigres FC, Unión Magdalena, Deportes Quindío, Orsomarso SC

RIVALES EN Copa Colombia

RIVALES EN Apertura Primera.

USO DE MEMORIA

6,558,128 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.7521
Total Execution Time	0.7533

CADENA URL

/historico/Cucuta-Deportivo

GET DATOS

$_GET['/historico/Cucuta-Deportivo']

POST DATOS

No hay datos POST existentes

CONSULTAS (46)

0.0142	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 = 'Cucuta-Deportivo' 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.0126	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=870 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=870 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=870 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255	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 = 74958
0.0132	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 = 75230
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=870 AND type_rel = 2
0.0128	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 870 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128	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 (1735,1874,3016,3133,17902) ORDER BY n.cover_points DESC, update_date DESC
0.0140	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 = '870' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0133	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 = '870' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127	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 = 75230 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127	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 = 74958 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=870 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (75230,74958,74557,71993,71731,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.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 74958 AND teamId = 870
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 71993 AND teamId = 870
0.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 75230 AND teamId = 870
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 74557 AND teamId = 870
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 71731 AND teamId = 870
0.0250	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 870
0.0131	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 = 74958 AND t.round = 14 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0141	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 = 74958 WHERE rp.league_id = 74958 AND rp.teamId = 870 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.0140	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 = 74958 WHERE rp.league_id = 74958 AND rp.teamId = 870 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0163	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 = 74958 WHERE rp.league_id = 74958 AND rp.teamId = 870 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0196	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 = 870 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 74958 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 70905 AND t.round = 16 ORDER BY team.conference ASC,t.position 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* `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 = 71993 AND t.round = 16 ORDER BY team.conference ASC,t.position 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* `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 = 66315 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 53475 AND t.round = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 48381 AND t.round = 20 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* `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 = 48672 AND t.round = 20 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* `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 = 42552 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 46940 AND t.round = 6 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* `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 = 37761 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138	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 = 38802 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141	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 = 20265 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140	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 = 9440 AND t.round = 20 ORDER BY team.conference 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* `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 = 15429 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142	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 = 3477 AND t.round = 18 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* `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 = 3209 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140	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 = 2414 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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 = 2529 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142	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 = 1563 AND t.round = 18 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* `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 = 1542 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Cúcuta Deportivo

Cúcuta Deportivo

Selecciona un equipo

Competiciones que juega

Apertura Primera B Colombia

RIVALES EN Copa Colombia

RIVALES EN Apertura Primera.