21 May 17	Finalizado	Manchester United	2 - 0	Crystal Palace	64
17 May 17	Finalizado	Southampton	0 - 0	Manchester United	494
14 May 17	Finalizado	Tottenham Hotspur	2 - 1	Manchester United	265
07 May 17	Finalizado	Arsenal	2 - 0	Manchester United	253
30 Abr 17	Finalizado	Manchester United	1 - 1	Swansea City	278
27 Abr 17	Finalizado	Manchester City	0 - 0	Manchester United	811
23 Abr 17	Finalizado	Burnley	0 - 2	Manchester United	114
16 Abr 17	Finalizado	Manchester United	2 - 0	Chelsea	663
09 Abr 17	Finalizado	Sunderland	0 - 3	Manchester United	126
04 Abr 17	Finalizado	Manchester United	1 - 1	Everton	337
01 Abr 17	Finalizado	Manchester United	0 - 0	West Bromwich Albion	119
19 Mar 17	Finalizado	Middlesbrough	1 - 3	Manchester United	234
04 Mar 17	Finalizado	Manchester United	1 - 1	AFC Bournemouth	444
11 Feb 17	Finalizado	Manchester United	2 - 0	Watford	116
05 Feb 17	Finalizado	Leicester	0 - 3	Manchester United	270
01 Feb 17	Finalizado	Manchester United	0 - 0	Hull City	262
21 Ene 17	Finalizado	Stoke City	1 - 1	Manchester United	276
15 Ene 17	Finalizado	Manchester United	1 - 1	Liverpool	579
02 Ene 17	Finalizado	West Ham	0 - 2	Manchester United	361
31 Dic 16	Finalizado	Manchester United	2 - 1	Middlesbrough	532
26 Dic 16	Finalizado	Manchester United	3 - 1	Sunderland	93
17 Dic 16	Finalizado	West Bromwich Albion	0 - 2	Manchester United	150
14 Dic 16	Finalizado	Crystal Palace	1 - 2	Manchester United	458
11 Dic 16	Finalizado	Manchester United	1 - 0	Tottenham Hotspur	284
04 Dic 16	Finalizado	Everton	1 - 1	Manchester United	418
27 Nov 16	Finalizado	Manchester United	1 - 1	West Ham	350
19 Nov 16	Finalizado	Manchester United	1 - 1	Arsenal	680
06 Nov 16	Finalizado	Swansea City	1 - 3	Manchester United	216
29 Oct 16	Finalizado	Manchester United	0 - 0	Burnley	464
23 Oct 16	Finalizado	Chelsea	4 - 0	Manchester United	984
17 Oct 16	Finalizado	Liverpool	0 - 0	Manchester United	925
02 Oct 16	Finalizado	Manchester United	1 - 1	Stoke City	507
24 Sep 16	Finalizado	Manchester United	4 - 1	Leicester	679
18 Sep 16	Finalizado	Watford	3 - 1	Manchester United	820
10 Sep 16	Finalizado	Manchester United	1 - 2	Manchester City	2159
27 Ago 16	Finalizado	Hull City	0 - 1	Manchester United	504
19 Ago 16	Finalizado	Manchester United	2 - 0	Southampton	450
14 Ago 16	Finalizado	AFC Bournemouth	1 - 3	Manchester United	488

Europa League »

24 May 17	Finalizado	Ajax	0 - 2	Manchester United	1749
11 May 17	Finalizado	Manchester United	1 - 1	Celta	2822
04 May 17	Finalizado	Celta	0 - 1	Manchester United	3006
20 Abr 17	Finalizado	Manchester United	2 - 1	Anderlecht	677
13 Abr 17	Finalizado	Anderlecht	1 - 1	Manchester United	467
16 Mar 17	Finalizado	Manchester United	1 - 0	FK Rostov	524
09 Mar 17	Finalizado	FK Rostov	1 - 1	Manchester United	534
22 Feb 17	Finalizado	Saint-Étienne	0 - 1	Manchester United	174
16 Feb 17	Finalizado	Manchester United	3 - 0	Saint-Étienne	195
08 Dic 16	Finalizado	Zorya Luhansk	0 - 2	Manchester United	215
24 Nov 16	Finalizado	Manchester United	4 - 0	Feyenoord	201
03 Nov 16	Finalizado	Fenerbahçe	2 - 1	Manchester United	646
20 Oct 16	Finalizado	Manchester United	4 - 1	Fenerbahçe	252
29 Sep 16	Finalizado	Manchester United	1 - 0	Zorya Luhansk	324
15 Sep 16	Finalizado	Feyenoord	1 - 0	Manchester United	563

FA Cup »

13 Mar 17	Finalizado	Chelsea	1 - 0	Manchester United	738
19 Feb 17	Finalizado	Blackburn Rovers	1 - 2	Manchester United	124
29 Ene 17	Finalizado	Manchester United	4 - 0	Wigan Athletic	45
07 Ene 17	Finalizado	Manchester United	4 - 0	Reading	118

EFL Cup »

26 Feb 17	Finalizado	Manchester United	3 - 2	Southampton	574
26 Ene 17	Finalizado	Hull City	2 - 1	Manchester United	468
10 Ene 17	Finalizado	Manchester United	2 - 0	Hull City	397
30 Nov 16	Finalizado	Manchester United	4 - 1	West Ham	169
26 Oct 16	Finalizado	Manchester United	1 - 0	Manchester City	869
21 Sep 16	Finalizado	Northampton	1 - 3	Manchester United	172

Community Shield »

07 Ago 16

Finalizado

Leicester

1 - 2

Manchester United

International Champions Cup »

	~~25 Jul 16~~	Aplazado	Manchester City	-	Manchester United			186
	22 Jul 16	Finalizado	Manchester United	1 - 4	B. Dortmund			371

Partidos Amistosos »

03 Ago 16	Finalizado	Manchester United	0 - 0	Everton	78
30 Jul 16	Finalizado	Galatasaray SK	2 - 5	Manchester United	67
16 Jul 16	Finalizado	Wigan Athletic	0 - 2	Manchester United	45

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del Manchester United Temporada 2016/2017

		Edad	Altura	Peso
Portero
1	D. De Gea	33	192	76	-	-	2
40	Joel Pereira	27	189	82	-	-	-
45	Kieran O'hara	27	193	78	-	-	-
20	S. Romero	37	192	87	-	-	-
Defensa
18	Ashley Young	38	175	65	-	-	2
38	Axel Tuanzebe	26	185	75	-	-	-
12	C. Smalling	34	194	90	1	-	-
17	Daley Blind	34	180	72	1	-	2
35	Demetri Mitchell	27	179	75	-	-	-
3	Eric Bailly	30	187	75	-	-	4
23	Luke Shaw	28	178	75	-	-	1
36	M. Darmian	34	183	70	-	-	3
5	Marcos Rojo	34	186	82	1	-	5
4	Phil Jones	32	185	71	-	-	2
24	T. Fosu-Mensah	26	185	80	-	-	-
Centrocampista
25	A. Valencia	38	181	78	1	-	5
21	Ander Herrera	34	182	70	1	1	7
47	Angel Gomes	23	168	56	-	-	-
22	H. Mkhitaryan	35	177	72	4	-	1
14	J. Lingard	31	174	58	1	-	3
8	J. Mata	35	170	63	6	-	3
46	Joshua Harrop	28	175	70	1	-	-
16	M. Carrick	42	188	74	-	-	2
27	M. Fellaini	36	194	85	1	1	9
42	Matthew Willock	27	172	65	-	-	-
6	Paul Pogba	31	191	84	5	-	7
39	S. Mctominay	27	191	80	-	-	1
Delantero
11	A. Martial	28	181	76	4	-	2
	J. Wilson	28	183	78	-	-	-
19	M. Rashford	26	185	70	5	-	3
10	W. Rooney	38	178	78	5	-	8
9	Z. Ibrahimovic	42	195	95	17	-	7
48	Zachary Dearnley	25	176	66	-	-	-

Noticias del Manchester United

Ver últimas noticias

"Solo dudé de dejar el Madrid cuando vi a Ancelotti llorando"

BeSoccer - Viernes, 19 Abril 2024

5 6.410

Casemiro reveló en 'El Chiringuito' cómo se sintió al abandonar el Real Madrid y poner rumbo al United. Lo decidió tras ganar la última Champions y solo dudó cuando Carlo Ancelotti le hizo llamar a su despacho para hablar con él: "Ya sabía que me iba, entré, se giró y estaba llorando. Me dijo que no quería que me fuese, que me quería mucho".

El calendario manda: ya no habrá 'replays' en la FA Cup

BeSoccer - Viernes, 19 Abril 2024

2 3.030

La Federación Inglesa anunció cambios de cara al próximo año. Atendiendo las peticiones de los clubes más grandes, preocupados por el aumento de partidos europeos en el nuevo calendario de la 2024-25, ya no habrá 'replays' en caso de empate en la competición. Además, la final de la FA Cup se adelantará y tendrá lugar durante la campaña y no a la conclusión de la misma.

Tiempos oscuros se avecinan en el United

BeSoccer - Miércoles, 17 Abril 2024

5 3.200

El Manchester United, que tiene prácticamente imposible clasificarse para Europa vía Premier, tiene en la cabeza la idea de dar salida a más de una figura en el próximo mercado de fichajes. 'Daily Mail' habla incluso de hasta una decena de jugadores.

El United dejará ir a un Martial que no jugará más de 'red devil'

BeSoccer - Martes, 16 Abril 2024

1 879

Fabrizio Romano, periodista especializado en el mercado de fichajes, asegura que está confirmado que Anthony Martial dejará el Manchester United a final de temporada, cuando su contrato se extingue. El francés empleará estos meses en recuperarse del todo de una lesión en la ingle que le tiene en el dique seco desde principios de diciembre, así que contará con margen y pausa para determinar su futuro cercano.

Garnacho, en el centro de la polémica por sus 'likes' a posts contra Ten Hag

BeSoccer - Martes, 16 Abril 2024

1 960

El futbolista hispanoargentino, sustituido al descanso frente al Bournemouth por su pobre rendimiento defensivo, se posicionó contra el técnico neerlandés en varios posts en las redes sociales que criticaban al ex del Ajax. Rápidamente borró los 'likes'.

Ver más noticias del equipo»

Competiciones que juega

Grupo 1

Premier League

Pos	Equipos		Pts
1		Chelsea	93
2		Tottenham Hotspur	86
3		Manchester City	78
4		Liverpool	76
5		Arsenal	75
6		Manchester United	69
7		Everton	61
8		Southampton	46
9		AFC Bournemouth	46
10		West Bromwich Albion	45
11		West Ham	45
12		Leicester	44
13		Stoke City	44
14		Crystal Palace	41
15		Swansea City	41
16		Burnley	40
17		Watford	40
18		Hull City	34
19		Middlesbrough	28
20		Sunderland	24

	Champions League : Chelsea, Tottenham Hotspur, Manchester City, Manchester United
	Previa de Champions : Liverpool
	Europa League : Arsenal, Everton
	Descenso : Hull City, Middlesbrough, Sunderland

RIVALES EN Community Shield

RIVALES EN EFL Cup

RIVALES EN Europa League

RIVALES EN FA Cup

RIVALES EN Premier League

USO DE MEMORIA

7,436,928 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.7373
Total Execution Time	0.7392

CADENA URL

/Manchester-United-Fc/2017

GET DATOS

$_GET['/Manchester-United-Fc/2017']

POST DATOS

No hay datos POST existentes

CONSULTAS (47)

0.0268	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 = 'Manchester-United-Fc' AND l.year = 2017 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.0106	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=1635 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=1635 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=1635 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=1635 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=1635 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=1635 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0108	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=1635 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112	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=1635 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112	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=1635 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0153	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 = 34904
0.0139	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 = 38619
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1635 AND type_rel = 2
0.0140	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1635 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0108	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 (1311577,1311571,1311406,1311187,1311132) ORDER BY n.cover_points DESC, update_date DESC
0.0135	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 = '1635' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0150	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 = '1635' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0108	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 = 38619 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0111	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 = 34904 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0114	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 = 29314 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0121	(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 calendars2017 as c ON c.league_id = l.id WHERE (c.datateam1 = 1635 or c.datateam2 = 1635) AND l.year = 2017 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0151	(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 calendars2017 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 = 1635 or c.datateam2 = 1635) AND l.year = 2017 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0121	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2017 as c ON c.league_id = l.id INNER JOIN events2017 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 = 1635 or c.datateam2 = 1635) AND l.year = 2017)
0.0133	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=1635 AND l.year in (2016,2017,2018) ORDER BY l.id DESC, l.year DESC ;
0.0107	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 (41794,38989,38752,38633,38632,38619,38427,38002,37544,16079) 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.0115	SELECT count(id) as num_players from rel_players WHERE league_id = 38633 AND teamId = 1635
0.0115	SELECT count(id) as num_players from rel_players WHERE league_id = 41794 AND teamId = 1635
0.0113	SELECT count(id) as num_players from rel_players WHERE league_id = 37544 AND teamId = 1635
0.0118	SELECT count(id) as num_players from rel_players WHERE league_id = 38989 AND teamId = 1635
0.0124	SELECT count(id) as num_players from rel_players WHERE league_id = 38752 AND teamId = 1635
0.0105	SELECT count(id) as num_players from rel_players WHERE league_id = 38632 AND teamId = 1635
0.0106	SELECT count(id) as num_players from rel_players WHERE league_id = 38619 AND teamId = 1635
0.0117	SELECT count(id) as num_players from rel_players WHERE league_id = 16079 AND teamId = 1635
0.0112	SELECT count(id) as num_players from rel_players WHERE league_id = 38002 AND teamId = 1635
0.0245	SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 1635
0.0111	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 29314 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0122	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 events2017 e ON e.player_id = p.id AND e.league_id = 29314 WHERE rp.league_id = 29314 AND rp.teamId = 1635 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.0131	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 events2017 e ON e.player_id = p.id AND e.league_id = 29314 WHERE rp.league_id = 29314 AND rp.teamId = 1635 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0120	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 events2017 e ON e.player_id = p.id AND e.league_id = 29314 WHERE rp.league_id = 29314 AND rp.teamId = 1635 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0119	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 = 1635 AND rp.league_id = 29314 AND l.year= 2017 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0116	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=702058 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0108	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=702058
0.0149	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 events2017 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=702058 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.0148	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 events2017 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=702058 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0131	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 events2017 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=702058 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0119	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 events2017 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=702058 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0118	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 events2017 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=702058 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Manchester United

Información sobre Manchester United

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Manchester United

Estadísticas

Plantilla del Manchester United Temporada 2016/2017

Noticias del Manchester United

Manchester United

Selecciona un equipo

Competiciones que juega

RIVALES EN Community Shield

RIVALES EN EFL Cup

RIVALES EN Europa League

RIVALES EN FA Cup

RIVALES EN Premier League