09 May 10	Finalizado	Dundee United	0 - 2	Hibernian FC
05 May 10	Finalizado	Heart of Midlothian	0 - 0	Dundee United
01 May 10	Finalizado	Dundee United	1 - 2	Rangers FC
25 Abr 10	Finalizado	Dundee United	0 - 2	Celtic
18 Abr 10	Finalizado	Motherwell	2 - 3	Dundee United
14 Abr 10	Finalizado	Dundee United	0 - 0	Rangers FC
05 Abr 10	Finalizado	St. Johnstone	0 - 1	Dundee United
31 Mar 10	Finalizado	Hibernian FC	2 - 4	Dundee United
27 Mar 10	Finalizado	Dundee United	3 - 0	Motherwell
20 Mar 10	Finalizado	Aberdeen	2 - 2	Dundee United
07 Mar 10	Finalizado	Dundee United	1 - 0	Heart of Midlothian
27 Feb 10	Finalizado	Dundee United	3 - 0	Falkirk
20 Feb 10	Finalizado	Celtic	1 - 0	Dundee United
13 Feb 10	Finalizado	St. Mirren	1 - 2	Dundee United
10 Feb 10	Finalizado	Dundee United	0 - 2	Hamilton Academical
30 Ene 10	Finalizado	Kilmarnock	4 - 4	Dundee United
27 Ene 10	Finalizado	Dundee United	3 - 3	St. Johnstone
24 Ene 10	Finalizado	Falkirk	1 - 4	Dundee United
16 Ene 10	Finalizado	Dundee United	1 - 0	Hibernian FC
13 Ene 10	Finalizado	Hamilton Academical	0 - 1	Dundee United
02 Ene 10	Finalizado	Dundee United	0 - 1	Aberdeen
30 Dic 09	Finalizado	Rangers FC	7 - 1	Dundee United
26 Dic 09	Finalizado	Dundee United	0 - 0	Kilmarnock
15 Dic 09	Finalizado	Dundee United	0 - 3	Rangers FC
12 Dic 09	Finalizado	Heart of Midlothian	0 - 0	Dundee United
05 Dic 09	Finalizado	Dundee United	3 - 2	St. Mirren
28 Nov 09	Finalizado	Motherwell	2 - 2	Dundee United
22 Nov 09	Finalizado	Dundee United	2 - 1	Celtic
07 Nov 09	Finalizado	Kilmarnock	0 - 2	Dundee United
24 Oct 09	Finalizado	Aberdeen	0 - 2	Dundee United
17 Oct 09	Finalizado	Dundee United	1 - 1	Hamilton Academical
03 Oct 09	Finalizado	Hibernian FC	1 - 1	Dundee United
26 Sep 09	Finalizado	St. Johnstone	2 - 3	Dundee United
19 Sep 09	Finalizado	Dundee United	0 - 1	Motherwell
12 Sep 09	Finalizado	Celtic	1 - 1	Dundee United
29 Ago 09	Finalizado	Dundee United	2 - 1	Falkirk
22 Ago 09	Finalizado	St. Mirren	0 - 0	Dundee United
17 Ago 09	Finalizado	Dundee United	2 - 0	Heart of Midlothian

Copa Escocia »

15 May 10	Finalizado	Ross County FC	0 - 3	Dundee United
11 Abr 10	Finalizado	Dundee United	2 - 0	Raith Rovers
24 Mar 10	Finalizado	Dundee United	1 - 0	Rangers FC
14 Mar 10	Finalizado	Rangers FC	3 - 3	Dundee United
06 Feb 10	Finalizado	St. Johnstone	0 - 1	Dundee United
09 Ene 10	Finalizado	Partick Thistle	0 - 2	Dundee United

Copa de la Liga de Escocia »

27 Oct 09	Finalizado	St. Johnstone	2 - 1	Dundee United
22 Sep 09	Finalizado	Ross County FC	0 - 2	Dundee United
25 Ago 09	Finalizado	Alloa Athletic	0 - 2	Dundee United

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del Dundee United Temporada 2009/2010

		Edad	Altura	Peso
Portero
1	D. Pernis	39	191	86	-	-	-
1	N. Weaver	45	191	83	-	-	-
Defensa
3	A. Webster	42	188	79	3	-	3
5	D. Dods	48	185	82	1	-	4
18	Garry Kenneth	36	193	83	1	-	4
27	K. Watson	34	185	73	-	-	-
4	Lee Wilkie	44	193	83	-	-	-
19	Michael Kovacevic	36	193	88	-	1	3
23	P. Dixon	37	191	71	-	1	3
17	P. Mihadjuks	43	197	87	-	-	1
34	R. Smith	32	195	73	-	-	-
2	S. Dillon	40	180	78	-	-	1
Centrocampista
12	D. Robertson	37	178	64	-	-	1
14	D. Swanson	37	168	59	5	2	3
17	M. Fotheringham	40	180	81	-	-	1
16	M. Gomis	38	175	70	4	1	7
15	P. Buaben	36	178	75	2	2	6
8	S. Robertson	39	183	72	-	1	2
Delantero
20	A. Shala	35	191	78	-	-	-
6	C. Conway	38	178	67	3	-	2
10	D. Cadamarteri	44	175	75	4	-	1
21	D. Casalinuovo	36	182	79	5	-	-
25	D. Goodwillie	35	175	71	9	-	3
38	Dale Hilson	31	172	65	-	-	-
11	F. Sandaza	39	187	80	1	-	-
7	J. Myrie-Williams	35	180	76	1	-	3
9	Jonathan Daly	41	191	76	11	-	1
22	Kevin Smith	37	180	71	-	-	-

Noticias del Dundee United

Ver últimas noticias

El delantero del Córdoba Arturo Rodríguez, a prueba con el Dundee United

BeSoccer - Martes, 12 Enero 2016

0 482

El delantero del Córdoba Arturo Rodríguez se encuentra en Escocia en un periodo de prueba con el Dundee United, de ahí que se ausentase, con permiso del club, de la última sesión de entrenamientos de la plantilla que dirige José Luis Oltra.

El Dundee United espera firmar un convenio de colaboración con el Shakhtar

BeSoccer - Jueves, 31 Diciembre 2015

0 446

El entrenador del Dundee United, Mixu Paatelainen, confirmó que están negociando con el conjunto ucraniano algún tipo de vinculación deportiva.

El Dundee United recupera a Sinama Pongolle

BeSoccer - Viernes, 27 Noviembre 2015

0 695

El Dundee United ha anunciado este viernes la contratación del antiguo internacional francés Florent Sinama Pongolle, exjugador de Atlético de Madrid, Liverpool y Real Zaragoza, entre otros, hasta final de temporada.

Top de las camisetas de fútbol más extravagantes

Isabel Ruiz - Viernes, 14 Agosto 2015

3 4.210

Cada año las marcas y los equipos intentan sorprendernos con innovadoras equipaciones. Estos son algunos de los peores diseños de la historia del fútbol.

Seis partidos por morder a un rival

Sergio Álvarez - Martes, 21 Julio 2015

3 2.473

Parece que las islas atraen a los futbolistas 'caníbales', y es que el último episodio de un mordisco en un partido tuvo lugar en la Liga Escocesa la pasada campaña. Ahora, Nadir Çiftçi ha sido sancionado con 6 encuentros por el incidente.

Ver más noticias del equipo»

Competiciones que juega

Liga Escocia Grupo 1

Pos	Equipos		Pts
1		Rangers FC	77
2		Celtic	66
3		Dundee United	59
4		Hibernian FC	50
5		Motherwell	48
6		Heart of Midlothian	44
7		St. Johnstone	41
8		Hamilton Academical	36
9		Aberdeen	34
10		Kilmarnock	29
11		St. Mirren	28
12		Falkirk	28

RIVALES EN Copa de la Liga.

RIVALES EN Copa Escocia

RIVALES EN Liga Escocia

USO DE MEMORIA

6,569,560 bytes

BENCHMARKS

Loading Time Base Classes	0.0037
Controller Execution Time ( Home / Category )	0.1914
Total Execution Time	0.1951

CADENA URL

/Dundee-United-Fc/2010

GET DATOS

$_GET['/Dundee-United-Fc/2010']

POST DATOS

No hay datos POST existentes

CONSULTAS (33)

0.0043	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 = 935
0.0026	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 = 10310
0.0026	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 = 20900
0.0025	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 = 20911
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=943 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 943 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	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 (3229,6454,24941,31279,33651) ORDER BY n.cover_points DESC, update_date DESC
0.0038	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 = '943' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 20911 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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 = 20900 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	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 = 10310 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	(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 calendars2010 as c ON c.league_id = l.id WHERE (c.datateam1 = 943 or c.datateam2 = 943) AND l.year = 2010 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0031	(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 calendars2010 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 = 943 or c.datateam2 = 943) AND l.year = 2010 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0035	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2010 as c ON c.league_id = l.id INNER JOIN events2010 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 = 943 or c.datateam2 = 943) AND l.year = 2010)
0.0047	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=943 AND l.year in (2009,2010,2011) ORDER BY l.id DESC, l.year DESC ;
0.0021	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 (42898,20912,20901,10311,1098) 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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 10311 AND teamId = 943
0.0030	SELECT count(id) as num_players from rel_players WHERE league_id = 42898 AND teamId = 943
0.0033	SELECT count(id) as num_players from rel_players WHERE league_id = 20901 AND teamId = 943
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 20912 AND teamId = 943
0.0029	SELECT count(id) as num_players from rel_players WHERE league_id = 1098 AND teamId = 943
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* `tables2010` 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 = 935 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0031	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 events2010 e ON e.player_id = p.id AND e.league_id = 935 WHERE rp.league_id = 935 AND rp.teamId = 943 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.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 events2010 e ON e.player_id = p.id AND e.league_id = 935 WHERE rp.league_id = 935 AND rp.teamId = 943 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034	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 events2010 e ON e.player_id = p.id AND e.league_id = 935 WHERE rp.league_id = 935 AND rp.teamId = 943 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 943 AND rp.league_id = 935 AND l.year= 2010 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0048	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=21916 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0026	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=21916
0.0040	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 events2010 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=21916 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.0026	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 events2010 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=21916 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0023	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 events2010 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=21916 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0027	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 events2010 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=21916 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0026	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 events2010 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=21916 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Resultados de Fútbol

Dundee United

Información sobre Dundee United

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Copa de la Liga de Escocia

Liga Escocia Grupo 3

Copa Escocia

Europa League

Partidos Amistosos

Championship Escocia

Challenge Cup Escocia

Fase Previa Europa League Grupo 3

Liga Escocia - Play Offs Ascenso

Copa de Ferias

Recopa de Europa

Champions League

Fase Previa Conference League Grupo 3

Partidos del Dundee United