05 May 96	Finalizado	Middlesbrough	0 - 3	Manchester United	0
28 Abr 96	Finalizado	Manchester United	5 - 0	Nottingham Forest	1
17 Abr 96	Finalizado	Manchester United	1 - 0	Leeds United	0
13 Abr 96	Finalizado	Southampton	3 - 1	Manchester United	0
08 Abr 96	Finalizado	Manchester United	1 - 0	Coventry City	1
06 Abr 96	Finalizado	Manchester City	2 - 3	Manchester United	0
24 Mar 96	Finalizado	Manchester United	1 - 0	Tottenham Hotspur	0
20 Mar 96	Finalizado	Manchester United	1 - 0	Arsenal	0
16 Mar 96	Finalizado	Queens Park Rangers	1 - 1	Manchester United	0
04 Mar 96	Finalizado	Newcastle	0 - 1	Manchester United	0
25 Feb 96	Finalizado	Bolton Wanderers	0 - 6	Manchester United	0
21 Feb 96	Finalizado	Manchester United	2 - 0	Everton	0
10 Feb 96	Finalizado	Manchester United	1 - 0	Blackburn Rovers	0
03 Feb 96	Finalizado	Wimbledon FC	2 - 4	Manchester United	0
22 Ene 96	Finalizado	West Ham	0 - 1	Manchester United	0
13 Ene 96	Finalizado	Manchester United	0 - 0	Aston Villa	0
01 Ene 96	Finalizado	Tottenham Hotspur	4 - 1	Manchester United	0
30 Dic 95	Finalizado	Manchester United	2 - 1	Queens Park Rangers	0
27 Dic 95	Finalizado	Manchester United	2 - 0	Newcastle	0
24 Dic 95	Finalizado	Leeds United	3 - 1	Manchester United	0
17 Dic 95	Finalizado	Liverpool	2 - 0	Manchester United	0
09 Dic 95	Finalizado	Manchester United	2 - 2	Sheffield Wednesday	0
02 Dic 95	Finalizado	Manchester United	1 - 1	Chelsea	0
27 Nov 95	Finalizado	Nottingham Forest	1 - 1	Manchester United	0
22 Nov 95	Finalizado	Coventry City	0 - 4	Manchester United	0
18 Nov 95	Finalizado	Manchester United	4 - 1	Southampton	0
04 Nov 95	Finalizado	Arsenal	1 - 0	Manchester United	0
28 Oct 95	Finalizado	Manchester United	2 - 0	Middlesbrough	0
21 Oct 95	Finalizado	Chelsea	1 - 4	Manchester United	0
14 Oct 95	Finalizado	Manchester United	1 - 0	Manchester City	0
01 Oct 95	Finalizado	Manchester United	2 - 2	Liverpool	0
23 Sep 95	Finalizado	Sheffield Wednesday	0 - 0	Manchester United	0
16 Sep 95	Finalizado	Manchester United	3 - 0	Bolton Wanderers	0
09 Sep 95	Finalizado	Everton	2 - 3	Manchester United	0
28 Ago 95	Finalizado	Blackburn Rovers	1 - 2	Manchester United	0
26 Ago 95	Finalizado	Manchester United	3 - 1	Wimbledon FC	0
23 Ago 95	Finalizado	Manchester United	2 - 1	West Ham	0
19 Ago 95	Finalizado	Aston Villa	3 - 1	Manchester United	0

Europa League »

	26 Sep 95	Finalizado	Manchester United	2 - 2	Rotor Volgograd			3
	12 Sep 95	Finalizado	Rotor Volgograd	0 - 0	Manchester United			0

FA Cup »

11 May 96	Finalizado	Manchester United	1 - 0	Liverpool
31 Mar 96	Finalizado	Manchester United	2 - 1	Chelsea
11 Mar 96	Finalizado	Manchester United	2 - 0	Southampton
18 Feb 96	Finalizado	Manchester United	2 - 1	Manchester City
27 Ene 96	Finalizado	Reading	0 - 3	Manchester United
16 Ene 96	Finalizado	Sunderland	1 - 2	Manchester United
06 Ene 96	Finalizado	Manchester United	2 - 2	Sunderland

EFL Cup »

	03 Oct 95	Finalizado	York City	1 - 3	Manchester United			0
	20 Sep 95	Finalizado	Manchester United	0 - 3	York City			0

Estadísticas

GOLEADORES

AMARILLAS

N. Butt10

ROJAS

N. Butt1

Plantilla del Manchester United Temporada 1995/1996

		Edad	Altura	Peso
Portero
25	Kevin Pilkington	50	185	81	-	-	-
1	Peter Schmeichel	60	193	-	-	-	1
	Tony Coton	62	-	-	-	-	-
Defensa
26	Chris Casper	48	183	77	-	-	-
12	David May	53	184	85	1	-	1
3	Denis Irwin	58	173	68	1	-	4
6	G. Pallister	58	193	93	-	-	5
20	Gary Neville	49	180	77	-	-	7
30	J. O'kane	49	178	79	-	-	-
21	P. Mcgibbon	50	-	-	-	-	-
	Paul Parker	60	170	75	-	-	-
4	Steve Bruce	63	183	83	2	-	2
	William Prunier	56	183	80	-	-	-
Centrocampista
24	D. Beckham	48	183	85	7	-	5
5	L. Sharpe	52	183	81	4	-	4
19	N. Butt	49	178	72	2	1	10
23	P. Neville	47	180	75	-	-	1
22	P. Scholes	49	168	69	10	-	1
11	R. Giggs	50	180	68	11	-	-
16	R. Keane	52	180	77	6	2	8
18	Simon Davies	50	183	73	-	-	-
27	Terry Cooke	47	170	61	-	-	-
Delantero
17	Andy Cole	52	178	76	11	-	4
29	Ben Thornley	49	172	73	-	-	-
9	Brian Mcclair	60	178	82	3	-	1
7	E. Cantona	57	188	89	14	-	1

Noticias del Manchester United

Ver últimas noticias

El Lopetegui más cotizado: Milan, United, West Ham...

BeSoccer - Sábado, 27 Abril 2024

0 372

Julen Lopetegui es uno de los nombres más repetidos en las quinielas de los banquillos para la próxima temporada. 'Relevo' insiste en que mantiene conversaciones muy activas por el Milan, pero no es el único club de élite con el que se le ha relacionado en las últimas semanas.

Ten Hag reclama fichajes para poder pelear por la Premier

BeSoccer - Sábado, 27 Abril 2024

3 2.296

El técnico del Manchester United Erik ten Hag compareció en la rueda de prensa previa al partido que enfrenta a los 'red devils' contra el Burnley y reclamó fichajes si el club quiere ganar la Premier League: "Tenemos que reforzarnos en posiciones clave y en profundidad de plantilla". Por otro lado, aseguró que con los jugadores actuales, aun estando todos disponibles, no les da para poder hacerse con el campeonato inglés.

El United llegó a 250 canteranos debutantes en toda la historia

Sergio Álvarez - Viernes, 26 Abril 2024

4 1.605

El club, que abrazó la cantera con especial fuerza después de la catástrofe de Múnich, celebró con el estreno de Ethan Wheatley el debut número 250 de un canterano en el primer equipo 'red devil'.

Bruno siempre encuentra la solución

BeSoccer - Miércoles, 24 Abril 2024

0 1.477

El Manchester United volvió a coquetear con la derrota y se salvó 'in extremis' con una victoria por 4-2 ante el Sheffield United. Una vez más, Bruno Fernandes fue el encargado de echarse al equipo a la espalda y, con su doblete, ser el timón para la victoria 'red devil'.

Error de Onana, gol en contra para el United: el Sheffield puso el 0-1

BeSoccer - Miércoles, 24 Abril 2024

0 3.573

André Onana volvió a dejar uno de sus habituales errores bajo palos y el Sheffield United se puso por delante en el marcador en el minuto 35. El portero camerunés le entregó la pelota directamente a Jayden Bogle y este no perdonó en el mano a mano.

Ver más noticias del equipo»

Pos	Equipos	Pts
1		Manchester United	82
2		Newcastle	78
3		Liverpool	71
4		Aston Villa	63
5		Arsenal	63
6		Everton	61
7		Blackburn Rovers	61
8		Tottenham Hotspur	61
9		Nottingham Forest	58
10		West Ham	51
11		Chelsea	50
12		Middlesbrough	43
13		Leeds United	43
14		Wimbledon FC	41
15		Sheffield Wednesday	40
16		Coventry City	38
17		Southampton	38
18		Manchester City	38
19		Queens Park Rangers	33
20		Bolton Wanderers	29

Pos

Equipos

Pts

	Champions League : Manchester United
	UEFA : Newcastle, Aston Villa, Arsenal
	Recopa : Liverpool
	Descenso : Manchester City, Queens Park Rangers, Bolton Wanderers

Champions League : Manchester United

UEFA : Newcastle, Aston Villa, Arsenal

Recopa : Liverpool

Descenso : Manchester City, Queens Park Rangers, Bolton Wanderers

USO DE MEMORIA

6,784,488 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.2631
Total Execution Time	0.2652

CADENA URL

/Manchester-United-Fc/1996

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0056	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 = 1996 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=1635 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=1635 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=1635 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=1635 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=1635 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023	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 = 335
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 = 10964
0.0028	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 = 14537
0.0024	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 = 23240
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1635 AND type_rel = 2
0.0044	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.0021	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 (1312783,1312776,1312646,1312471,1312452) ORDER BY n.cover_points DESC, update_date DESC
0.0050	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 = 1996 ORDER BY l.year DESC,cat.coefficient DESC
0.0068	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.0024	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 = 23240 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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 = 10964 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026	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 = 14537 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 = 335 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0166	(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 calendars1996 as c ON c.league_id = l.id WHERE (c.datateam1 = 1635 or c.datateam2 = 1635) AND l.year = 1996 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0191	(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 calendars1996 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 = 1996 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0172	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1996 as c ON c.league_id = l.id INNER JOIN events1996 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 = 1996)
0.0057	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 (1995,1996,1997) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (23242,22745,14538,10964,9717,336) 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.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 336 AND teamId = 1635
0.0029	SELECT count(id) as num_players from rel_players WHERE league_id = 9717 AND teamId = 1635
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 10964 AND teamId = 1635
0.0032	SELECT count(id) as num_players from rel_players WHERE league_id = 14538 AND teamId = 1635
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 23242 AND teamId = 1635
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 22745 AND teamId = 1635
0.0032	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables1996` 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 = 335 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0045	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 events1996 e ON e.player_id = p.id AND e.league_id = 335 WHERE rp.league_id = 335 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.0042	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 events1996 e ON e.player_id = p.id AND e.league_id = 335 WHERE rp.league_id = 335 AND rp.teamId = 1635 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036	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 events1996 e ON e.player_id = p.id AND e.league_id = 335 WHERE rp.league_id = 335 AND rp.teamId = 1635 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029	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 = 335 AND l.year= 1996 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0027	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=7697 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0018	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=7697
0.0032	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 events1996 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=7697 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 events1996 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=7697 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 events1996 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=7697 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0022	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 events1996 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=7697 AND (e.action = 22) 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 events1996 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=7697 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0020	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 = 335 ORDER BY nameShow LIMIT 100


	¿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 1995/1996

Noticias del Manchester United

Manchester United

Selecciona un equipo

Competiciones que juega

RIVALES EN EFL Cup

RIVALES EN Europa League

RIVALES EN FA Cup

RIVALES EN Premier League