08 Jun 07	Finalizado	Boca Juniors	3 - 0	Cúcuta Deportivo	4
01 Jun 07	Finalizado	Cúcuta Deportivo	3 - 1	Boca Juniors	2
23 May 07	Finalizado	Nacional	2 - 2	Cúcuta Deportivo	0
16 May 07	Finalizado	Cúcuta Deportivo	2 - 0	Nacional	0
09 May 07	Finalizado	Toluca	2 - 0	Cúcuta Deportivo	0
04 May 07	Finalizado	Cúcuta Deportivo	5 - 1	Toluca	0
25 Abr 07	Finalizado	Deportes Tolima	3 - 4	Cúcuta Deportivo	0
12 Abr 07	Finalizado	Cúcuta Deportivo	3 - 1	Grêmio	0
21 Mar 07	Finalizado	Cerro Porteño	2 - 1	Cúcuta Deportivo	0
14 Mar 07	Finalizado	Cúcuta Deportivo	1 - 1	Cerro Porteño	0
28 Feb 07	Finalizado	Grêmio	0 - 0	Cúcuta Deportivo	0
14 Feb 07	Finalizado	Cúcuta Deportivo	0 - 0	Deportes Tolima	0

Apertura Colombia »

12 May 07	Finalizado	Cúcuta Deportivo	1 - 0	Deportivo Pereira
06 May 07	Finalizado	Deportivo Cali	2 - 1	Cúcuta Deportivo
02 May 07	Finalizado	Cúcuta Deportivo	0 - 1	Independiente Medellín
25 Abr 07	Finalizado	Cúcuta Deportivo	2 - 0	Atlético Huila
21 Abr 07	Finalizado	Santa Fe	3 - 3	Cúcuta Deportivo
15 Abr 07	Finalizado	Cúcuta Deportivo	3 - 1	La Equidad
11 Abr 07	Finalizado	Boyacá Chicó	1 - 0	Cúcuta Deportivo
08 Abr 07	Finalizado	Cúcuta Deportivo	2 - 0	Atlético Bucaramanga
01 Abr 07	Finalizado	Atlético Bucaramanga	1 - 2	Cúcuta Deportivo
25 Mar 07	Finalizado	América de Cali	1 - 2	Cúcuta Deportivo
17 Mar 07	Finalizado	Cúcuta Deportivo	1 - 1	At. Nacional
11 Mar 07	Finalizado	Junior	2 - 1	Cúcuta Deportivo
07 Mar 07	Finalizado	Millonarios	1 - 1	Cúcuta Deportivo
04 Mar 07	Finalizado	Cúcuta Deportivo	2 - 1	Deportes Tolima
18 Feb 07	Finalizado	Cúcuta Deportivo	2 - 0	Deportivo Pasto
11 Feb 07	Finalizado	Deportes Quindío	0 - 1	Cúcuta Deportivo
04 Feb 07	Finalizado	Cúcuta Deportivo	4 - 1	Once Caldas

Clausura Colombia - Play Offs »

13 Dic 07	Finalizado	Cúcuta Deportivo	1 - 1	América de Cali
09 Dic 07	Finalizado	At. Nacional	2 - 2	Cúcuta Deportivo
06 Dic 07	Finalizado	Once Caldas	1 - 2	Cúcuta Deportivo
02 Dic 07	Finalizado	Cúcuta Deportivo	0 - 1	Once Caldas
29 Nov 07	Finalizado	Cúcuta Deportivo	1 - 2	At. Nacional
25 Nov 07	Finalizado	América de Cali	1 - 0	Cúcuta Deportivo

Clausura Colombia »

11 Nov 07	Finalizado	Deportivo Pereira	2 - 2	Cúcuta Deportivo
08 Nov 07	Finalizado	Cúcuta Deportivo	1 - 1	Deportivo Cali
04 Nov 07	Finalizado	Independiente Medellín	1 - 1	Cúcuta Deportivo
26 Oct 07	Finalizado	Atlético Huila	2 - 2	Cúcuta Deportivo
21 Oct 07	Finalizado	Cúcuta Deportivo	4 - 1	Santa Fe
07 Oct 07	Finalizado	La Equidad	1 - 0	Cúcuta Deportivo
30 Sep 07	Finalizado	Cúcuta Deportivo	5 - 1	Boyacá Chicó
23 Sep 07	Finalizado	Atlético Bucaramanga	1 - 2	Cúcuta Deportivo
16 Sep 07	Finalizado	Cúcuta Deportivo	3 - 1	Atlético Bucaramanga
09 Sep 07	Finalizado	Cúcuta Deportivo	2 - 0	América de Cali
03 Sep 07	Finalizado	At. Nacional	0 - 1	Cúcuta Deportivo
26 Ago 07	Finalizado	Cúcuta Deportivo	2 - 0	Junior
18 Ago 07	Finalizado	Deportes Tolima	2 - 0	Cúcuta Deportivo
12 Ago 07	Finalizado	Cúcuta Deportivo	2 - 2	Millonarios
05 Ago 07	Finalizado	Deportivo Pasto	3 - 0	Cúcuta Deportivo
29 Jul 07	Finalizado	Cúcuta Deportivo	2 - 0	Deportes Quindío
22 Jul 07	Finalizado	Once Caldas	1 - 0	Cúcuta Deportivo

Apertura Colombia - Play Offs »

10 Jun 07	Finalizado	Independiente Medellín	0 - 0	Cúcuta Deportivo
03 Jun 07	Finalizado	Cúcuta Deportivo	4 - 0	Atlético Huila
27 May 07	Finalizado	Cúcuta Deportivo	3 - 1	Millonarios
24 May 07	Finalizado	Millonarios	2 - 0	Cúcuta Deportivo
20 May 07	Finalizado	Atlético Huila	1 - 1	Cúcuta Deportivo
17 May 07	Finalizado	Cúcuta Deportivo	1 - 1	Independiente Medellín

Estadísticas

GOLEADORES

AMARILLAS

Plantilla del Cúcuta Deportivo Temporada 2006/2007

		Edad	Altura	Peso
Portero
1	R. Zapata	45	183	80	-	-	1
Defensa
	B. García	37	183	81	-	-	-
21	E. González	42	173	70	-	-	1
2	J. Hurtado	44	192	86	-	-	1
	J. Raguá	43	-	-	-	-	-
	P. Portocarrero	46	194	82	-	-	-
13	R. Bustos	42	-	-	2	-	1
3	W. Moreno	45	182	81	-	-	1
Centrocampista
	A. Del Castillo	47	-	-	1	-	3
6	C. Castro	45	175	74	1	-	-
25	D. Córdoba	43	-	-	-	-	1
24	D. Rueda	51	-	-	-	-	5
	L. Henry	46	-	-	-	-	-
10	M. Torres	39	170	72	1	-	1
4	Nelson Florez	50	174	66	-	-	-
Delantero
9	B. Pérez	43	187	78	3	-	2
	Bobadilla	49	171	67	-	-	-
23	J. Martínez	38	173	72	3	-	-
11	L. Pajoy	42	185	74	1	-	1
7	V. Cortés	48	168	68	-	-	-

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»

USO DE MEMORIA

6,075,400 bytes

BENCHMARKS

Loading Time Base Classes	0.0026
Controller Execution Time ( Home / Category )	0.8769
Total Execution Time	0.8795

CADENA URL

/Cucuta-Deportivo/2007

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (51)

0.0128	SELECT type FROM routes WHERE alias = 'cucuta-deportivo'
0.0149	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 = 2007 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.0125	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.0125	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.0125	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.0125	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.0125	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.0254	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 = 11301
0.0254	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 = 11332
0.0252	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 = 12998
0.0254	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 = 13000
0.0252	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 = 13037
0.0130	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 = 13045
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=870 AND type_rel = 2
0.0127	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.0129	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.0136	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' ORDER BY l.year DESC,cat.coefficient DESC
0.0131	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 = 2007 ORDER BY l.year DESC,cat.coefficient DESC
0.0131	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.0128	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 = 11301 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135	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 = 13000 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134	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 = 13045 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133	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 = 13037 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135	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 = 12998 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149	(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 calendars2007 as c ON c.league_id = l.id WHERE (c.datateam1 = 870 or c.datateam2 = 870) AND l.year = 2007 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0188	(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 calendars2007 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 = 2007 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0155	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2007 as c ON c.league_id = l.id INNER JOIN events2007 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 = 2007)
0.0136	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 (2006,2007,2008) 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 (13045,13037,13000,12998,11363) 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.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 12998 AND teamId = 870
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 13000 AND teamId = 870
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 11363 AND teamId = 870
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 13037 AND teamId = 870
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 13045 AND teamId = 870
0.0126	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 11301 AND t.round = 4 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127	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.0129	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '870' and rp.type = 4
0.0130	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.0133	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 events2007 e ON e.player_id = p.id AND e.league_id = 11301 WHERE rp.league_id = 11301 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.0134	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 events2007 e ON e.player_id = p.id AND e.league_id = 11301 WHERE rp.league_id = 11301 AND rp.teamId = 870 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136	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 events2007 e ON e.player_id = p.id AND e.league_id = 11301 WHERE rp.league_id = 11301 AND rp.teamId = 870 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130	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 = 11301 AND l.year= 2007 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0131	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=175578 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0130	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=175578
0.0147	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 events2007 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=175578 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.0146	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 events2007 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=175578 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0128	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 events2007 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=175578 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0127	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 events2007 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=175578 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0130	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 events2007 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=175578 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

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 2006/2007

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

RIVALES EN Copa Libertadore.

RIVALES EN Clausura Colombi.

RIVALES EN Clausura Colombi.

RIVALES EN Apertura Colombi.

RIVALES EN Apertura Colombi.