18 Sep 14	Finalizado	Santa Fe	2 - 0	Cúcuta Deportivo
11 Sep 14	Finalizado	Cúcuta Deportivo	1 - 2	Santa Fe
27 Ago 14	Finalizado	Patriotas Boyacá	1 - 1	Cúcuta Deportivo
21 Ago 14	Finalizado	Cúcuta Deportivo	0 - 0	Atlético Bucaramanga
13 Ago 14	Finalizado	Cúcuta Deportivo	3 - 0	Real Santander
08 Ago 14	Finalizado	Boyacá Chicó	1 - 1	Cúcuta Deportivo
31 Jul 14	Finalizado	Cúcuta Deportivo	1 - 1	Alianza FC
25 Jul 14	Finalizado	Cúcuta Deportivo	1 - 1	Patriotas Boyacá
12 Jul 14	Finalizado	Alianza FC	0 - 2	Cúcuta Deportivo
09 Jul 14	Finalizado	Atlético Bucaramanga	0 - 2	Cúcuta Deportivo
06 Jul 14	Finalizado	Real Santander	1 - 2	Cúcuta Deportivo
03 Jul 14	Finalizado	Cúcuta Deportivo	0 - 1	Boyacá Chicó

Apertura Primera B Colombia »

11 May 14	Finalizado	Cúcuta Deportivo	2 - 2	Bogotá	0
04 May 14	Finalizado	Jaguares FC	2 - 0	Cúcuta Deportivo	0
01 May 14	Finalizado	Cúcuta Deportivo	1 - 1	Tigres FC	0
27 Abr 14	Finalizado	Atlético Bucaramanga	0 - 1	Cúcuta Deportivo	1
20 Abr 14	Finalizado	Universitario Popayán	0 - 2	Cúcuta Deportivo	3
15 Abr 14	Finalizado	Cúcuta Deportivo	1 - 0	Deportes Quindío	1
08 Abr 14	Finalizado	Atlético Fútbol Club	3 - 0	Cúcuta Deportivo	5
30 Mar 14	Finalizado	Cúcuta Deportivo	1 - 0	Real Cundinamarca	2
23 Mar 14	Finalizado	Llaneros	1 - 0	Cúcuta Deportivo	2
16 Mar 14	Finalizado	Cúcuta Deportivo	1 - 0	Barranquilla	1
13 Mar 14	Finalizado	Cúcuta Deportivo	2 - 0	Real Santander	2
04 Mar 14	Finalizado	Real Cartagena	1 - 3	Cúcuta Deportivo	0
23 Feb 14	Finalizado	Cúcuta Deportivo	2 - 1	Deportivo Rionegro	0
16 Feb 14	Finalizado	Barranquilla	1 - 2	Cúcuta Deportivo	0
12 Feb 14	Finalizado	Cúcuta Deportivo	0 - 1	Internacional Palmira	2
07 Feb 14	Finalizado	Deportivo Pereira	1 - 1	Cúcuta Deportivo	2
04 Feb 14	Finalizado	Cúcuta Deportivo	0 - 1	América de Cali	11
28 Ene 14	Finalizado	Unión Magdalena	3 - 1	Cúcuta Deportivo	0

Apertura Primera B Colombia - Play Offs »

	21 May 14	Finalizado	Llaneros	1 - 1	Cúcuta Deportivo			0
	17 May 14	Finalizado	Cúcuta Deportivo	0 - 2	Llaneros			3

Clausura Primera B Colombia »

26 Oct 14	Finalizado	Bogotá	0 - 1	Cúcuta Deportivo	0
19 Oct 14	Finalizado	Cúcuta Deportivo	1 - 0	Jaguares FC	2
16 Oct 14	Finalizado	Tigres FC	0 - 0	Cúcuta Deportivo	0
14 Oct 14	Finalizado	Cúcuta Deportivo	0 - 0	Atlético Bucaramanga	3
05 Oct 14	Finalizado	Cúcuta Deportivo	2 - 1	Universitario Popayán	1
30 Sep 14	Finalizado	Deportes Quindío	3 - 0	Cúcuta Deportivo	0
25 Sep 14	Finalizado	Cúcuta Deportivo	5 - 0	Atlético Fútbol Club	0
21 Sep 14	Finalizado	Real Cundinamarca	0 - 1	Cúcuta Deportivo	0
14 Sep 14	Finalizado	Cúcuta Deportivo	2 - 2	Llaneros	0
08 Sep 14	Finalizado	Barranquilla	0 - 1	Cúcuta Deportivo	0
04 Sep 14	Finalizado	Real Santander	1 - 1	Cúcuta Deportivo	0
02 Sep 14	Finalizado	Cúcuta Deportivo	1 - 0	Real Cartagena	0
23 Ago 14	Finalizado	Deportivo Rionegro	1 - 2	Cúcuta Deportivo	0
17 Ago 14	Finalizado	Cúcuta Deportivo	0 - 0	Barranquilla	0
10 Ago 14	Finalizado	Internacional Palmira	3 - 1	Cúcuta Deportivo	0
05 Ago 14	Finalizado	Cúcuta Deportivo	0 - 1	Deportivo Pereira	0
29 Jul 14	Finalizado	América de Cali	2 - 1	Cúcuta Deportivo	0
22 Jul 14	Finalizado	Cúcuta Deportivo	2 - 1	Unión Magdalena	0

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del Cúcuta Deportivo Temporada 2013/2014

		Edad	Altura	Peso
Portero
	B. Córdoba	27	188	82	-	-	-
	M. Vargas	34	187	83	-	-	-
	W. Mosquera	39	194	80	-	-	-
Defensa
	D. Gómez	36	172	72	-	-	-
	E. Del Castillo	40	-	-	1	-	-
	J. García	34	186	75	1	-	-
	L. Vergara	33	184	82	-	1	-
	M. Duarte	31	171	69	-	2	1
	P. Escobar	37	184	72	1	-	-
	S. Castañeda Velásquez	31	168	63	-	-	-
Centrocampista
	A. Arboleda	37	182	80	1	-	-
	B. Perlaza	31	187	82	3	-	-
	C. Caicedo	32	-	-	-	-	-
	D. Espinel	36	170	72	-	-	-
	Diego Valdés	42	179	80	-	-	-
	G. Ruiz	33	-	-	-	-	-
	J. Ulloque	37	175	66	1	-	-
	L. Lázaro	31	173	70	2	-	-
	M. Marín	38	182	77	2	-	-
Delantero
	C. Lasso	33	180	68	-	1	1
	J. Hinestroza	28	175	70	3	1	-
	J. Largacha	37	-	-	-	-	-
	Jonathan Palacios	32	179	73	1	-	-
	M. Pérez	31	183	74	-	-	-
	V. Uribe	36	-	-	2	-	-
	Y. Franco	39	184	82	2	1	-

Noticias del Cúcuta Deportivo

Ver últimas noticias

Cúcuta desciende a Segunda por cuarta vez en su historia

BeSoccer - Lunes, 19 Octubre 2015

1 764

El colofón final a una temporada donde todo ha salido mal ha llegado a Cúcuta, que descenderá por cuarta vez tras caer derrotado ante Once Caldas en Colombia.

Santa Fe golea a Cúcuta y es líder

BeSoccer - Lunes, 20 Julio 2015

0 375

El equipo del Norte de Santander se queda como colista en la Clausura de la Liga Águila tras el severo correctivo encajado ante el club de Santa Fe (5-0).

Liga Águila II cuenta con 53 extranjeros que aportan su talento al torneo

Manuel Gutiérrez - Domingo, 19 Julio 2015

1 2.080

La legión argentina, liderada por Ómar Pérez, es la más numerosa en el FPC. El único club que no tiene foráneos es Cortuluá. Hay un europeo y un norteamericano. Mira todo el listado.

Las nuevas novedades de la Liga Aguila II

BeSoccer - Martes, 07 Julio 2015

0 722

Vuelve a disputarse la máxima competición colombiana y para ello se debe conocer el reglamento en el que se basará la competición.

Dimayor publica los primeros horarios de la Liga Águila

Jaime Velasco - Lunes, 06 Julio 2015

0 306

La competición arrancará el día 11 de julio con la disputa del Alianza Petrolera - Uniautónoma.

Ver más noticias del equipo»

Pos	Equipos	Pts
1		Atlético Bucaramanga	34
2		Llaneros	33
3		América de Cali	32
4		Jaguares FC	31
5		Deportes Quindío	30
6		Cúcuta Deportivo	30
7		Deportivo Rionegro	29
8		Unión Magdalena	28
9		Real Cundinamarca	27
10		Real Cartagena	27
11		Universitario Popayán	26
12		Barranquilla	22
13		Real Santander	22
14		Internacional de Palmira	19
15		Bogotá	17
16		Tigres FC	14
17		Deportivo Pereira	13
18		Atlético Fútbol Club	12

USO DE MEMORIA

6,087,560 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.2041
Total Execution Time	0.2060

CADENA URL

/Cucuta-Deportivo/2014

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (50)

0.0017	SELECT type FROM routes WHERE alias = 'cucuta-deportivo'
0.0040	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 = 2014 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=870 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=870 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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.0019	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.0019	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.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=870 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	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 = 3477
0.0042	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 = 3209
0.0038	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 = 5258
0.0038	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 = 42736
0.0039	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 = 3686
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=870 AND type_rel = 2
0.0021	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.0023	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.0030	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 = 2014 ORDER BY l.year DESC,cat.coefficient DESC
0.0026	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.0019	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 = 42736 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020	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 = 3686 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019	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 = 3209 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020	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 = 3477 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	(SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2014 as c ON c.league_id = l.id WHERE (c.datateam1 = 870 or c.datateam2 = 870) AND l.year = 2014 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0029	(SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2014 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 870 or c.datateam2 = 870) AND l.year = 2014 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0027	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2014 as c ON c.league_id = l.id INNER JOIN events2014 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 870 or c.datateam2 = 870) AND l.year = 2014)
0.0027	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 (2013,2014,2015) 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 (42747,15429,9440,9011,7068,3477,3209) 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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 9440 AND teamId = 870
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 15429 AND teamId = 870
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 3477 AND teamId = 870
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 3209 AND teamId = 870
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 42747 AND teamId = 870
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 7068 AND teamId = 870
0.0038	SELECT count(id) as num_players from rel_players WHERE league_id = 9011 AND teamId = 870
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '870' 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 = '870' 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 = '870' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0035	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 events2014 e ON e.player_id = p.id AND e.league_id = 3477 WHERE rp.league_id = 3477 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.0038	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 events2014 e ON e.player_id = p.id AND e.league_id = 3477 WHERE rp.league_id = 3477 AND rp.teamId = 870 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 events2014 e ON e.player_id = p.id AND e.league_id = 3477 WHERE rp.league_id = 3477 AND rp.teamId = 870 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023	SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 870 AND rp.league_id = 3477 AND l.year= 2014 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0034	SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=65460 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0019	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=65460
0.0025	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=65460 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0028	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=65460 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0024	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=65460 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0025	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=65460 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0029	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=65460 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0023	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 3477 ORDER BY nameShow LIMIT 100

Cúcuta Deportivo

Información sobre Cúcuta Deportivo

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Apertura Colombia

Copa Colombia

Clausura Colombia

Clausura Colombia - Play Offs

Copa Libertadores Grupo 0

Apertura Colombia - Play Offs

Primera B Colombia Grupo 1

Apertura Primera B Colombia - Play Offs

Clausura Primera B Colombia - Play Offs

Clausura Primera B Colombia

Apertura Primera B Colombia

Partidos Amistosos

Partidos del Cúcuta Deportivo

Estadísticas

Plantilla del Cúcuta Deportivo Temporada 2013/2014

Noticias del Cúcuta Deportivo

Cúcuta desciende a Segunda por cuarta vez en su historia

Santa Fe golea a Cúcuta y es líder

Liga Águila II cuenta con 53 extranjeros que aportan su talento al torneo

Las nuevas novedades de la Liga Aguila II

Dimayor publica los primeros horarios de la Liga Águila

Cúcuta Deportivo

Selecciona un equipo

Competiciones que juega

Apertura Primera B Colombia

RIVALES EN Copa Colombia

RIVALES EN Apertura Primera.

RIVALES EN Clausura Primera.

RIVALES EN Apertura Primera.