Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Manchester United

Entrenador: Erik ten Hag

Temporada 1951/1952

Información sobre Manchester United

Enviar Datos

Información

Nombre del equipo Manchester United
Nombre completo Manchester United Football Club
Nombre corto MUD
País Inglaterra
Ciudad Mánchester
Entrenador Erik ten Hag
URL del equipo en RF //m.resultados-futbol.com/Manchester-United-Fc

Otros Datos

Año de Fundación 1878
Patrocinador TeamViewer
Marca de Ropa Adidas
Socios 152000

Internet

Sitio Web www.manutd.com/
Twitter principal @manutd

Información sobre el estadio

Nombre del estadio Old Trafford
Capacidad 76212
Dirección Sir Matt Busby Way
Teléfono 087 04 42 19 94
Fax 087 04 42 19 94
Año de construcción 1909
Tamaño 105x68

Histórico de participación

Premier League

100 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1981, 1980, 1979, 1978, 1977, 1976, 1974, 1973, 1972, 1971, 1970, 1969, 1968, 1967, 1966, 1965, 1964, 1963, 1962, 1961, 1960, 1959, 1958, 1957, 1956, 1955, 1954, 1953, 1952, 1951, 1950, 1949, 1948, 1947, 1940, 1939, 1937, 1931, 1930, 1929, 1928, 1927, 1926, 1922, 1921, 1920, 1915, 1914, 1913, 1912, 1911, 1910, 1909, 1908, 1907, 1894, 1893)

FA Cup

72 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1979, 1977, 1976, 1972, 1970, 1969, 1966, 1965, 1963, 1962, 1960, 1958, 1957, 1953, 1951, 1950, 1949, 1948, 1938, 1928, 1926, 1913, 1912, 1911, 1909, 1908, 1906, 1904, 1903, 1897, 1896)

Champions League Grupo 1

53 veces

(2024, 2022, 2022, 2021, 2019, 2019, 2018, 2018, 2016, 2014, 2014, 2013, 2013, 2012, 2011, 2011, 2010, 2010, 2009, 2009, 2008, 2008, 2007, 2007, 2006, 2005, 2005, 2004, 2004, 2003, 2003, 2003, 2002, 2002, 2002, 2001, 2001, 2001, 2000, 2000, 2000, 1999, 1999, 1998, 1998, 1997, 1997, 1995, 1969, 1968, 1966, 1958, 1957)

Community Shield

30 veces

(2017, 2014, 2012, 2011, 2010, 2009, 2008, 2005, 2004, 2002, 2001, 2000, 1999, 1998, 1997, 1995, 1994, 1991, 1986, 1984, 1978, 1968, 1966, 1964, 1958, 1957, 1953, 1949, 1912, 1908)

Championship

22 veces

(1975, 1938, 1936, 1935, 1934, 1933, 1932, 1925, 1924, 1923, 1906, 1905, 1904, 1903, 1902, 1901, 1900, 1899, 1898, 1897, 1896, 1895)

Partidos Amistosos

15 veces

(2025, 2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011)

Europa League Grupo 5

15 veces

(2023, 2023, 2021, 2020, 2020, 2017, 2017, 2016, 2012, 1996, 1993, 1985, 1983, 1981, 1977)

International Champions Cup

7 veces

(2020, 2019, 2018, 2017, 2016, 2015, 2015)

Fase Previa Champions League Grupo 4

6 veces

(2016, 2006, 2005, 2003, 1999, 1994)

Partidos del Manchester United

Ir al LIVESCORE

Premier League »

26 Abr 52	Finalizado	Manchester United	6 - 1	Arsenal	0
21 Abr 52	Finalizado	Manchester United	3 - 0	Chelsea	0
19 Abr 52	Finalizado	Blackpool	2 - 2	Manchester United	0
14 Abr 52	Finalizado	Manchester United	6 - 1	Burnley	0
12 Abr 52	Finalizado	Manchester United	4 - 0	Liverpool	0
11 Abr 52	Finalizado	Burnley	1 - 1	Manchester United	0
05 Abr 52	Finalizado	Portsmouth	1 - 0	Manchester United	0
22 Mar 52	Finalizado	Huddersfield Town	3 - 2	Manchester United	1
15 Mar 52	Finalizado	Manchester United	2 - 0	Wolves	0
08 Mar 52	Finalizado	Sunderland	1 - 2	Manchester United	0
01 Mar 52	Finalizado	Manchester United	1 - 1	Aston Villa	0
16 Feb 52	Finalizado	Derby County	0 - 3	Manchester United	0
09 Feb 52	Finalizado	Preston North End	1 - 2	Manchester United	0
26 Ene 52	Finalizado	Manchester United	2 - 0	Tottenham Hotspur	0
19 Ene 52	Finalizado	Manchester United	1 - 1	Manchester City	0
05 Ene 52	Finalizado	Stoke City	0 - 0	Manchester United	0
29 Dic 51	Finalizado	Manchester United	1 - 0	Bolton Wanderers	0
26 Dic 51	Finalizado	Fulham	3 - 3	Manchester United	0
25 Dic 51	Finalizado	Manchester United	3 - 2	Fulham	0
22 Dic 51	Finalizado	Newcastle	2 - 2	Manchester United	0
15 Dic 51	Finalizado	Manchester United	5 - 1	West Bromwich Albion	0
08 Dic 51	Finalizado	Arsenal	1 - 3	Manchester United	0
01 Dic 51	Finalizado	Manchester United	3 - 1	Blackpool	0
24 Nov 51	Finalizado	Liverpool	0 - 0	Manchester United	0
17 Nov 51	Finalizado	Manchester United	1 - 3	Portsmouth	0
10 Nov 51	Finalizado	Chelsea	4 - 2	Manchester United	0
03 Nov 51	Finalizado	Manchester United	1 - 1	Huddersfield Town	0
27 Oct 51	Finalizado	Wolves	0 - 2	Manchester United	0
20 Oct 51	Finalizado	Manchester United	0 - 1	Sunderland	0
13 Oct 51	Finalizado	Aston Villa	2 - 5	Manchester United	0
06 Oct 51	Finalizado	Manchester United	2 - 1	Derby County	0
29 Sep 51	Finalizado	Manchester United	1 - 2	Preston North End	0
22 Sep 51	Finalizado	Tottenham Hotspur	2 - 0	Manchester United	0
15 Sep 51	Finalizado	Manchester City	1 - 2	Manchester United	0
12 Sep 51	Finalizado	Charlton Athletic	2 - 2	Manchester United	0
08 Sep 51	Finalizado	Manchester United	4 - 0	Stoke City	0
05 Sep 51	Finalizado	Manchester United	3 - 2	Charlton Athletic	0
01 Sep 51	Finalizado	Bolton Wanderers	1 - 0	Manchester United	0
29 Ago 51	Finalizado	Middlesbrough	1 - 4	Manchester United	0
25 Ago 51	Finalizado	Manchester United	2 - 1	Newcastle	0
22 Ago 51	Finalizado	Manchester United	4 - 2	Middlesbrough	0
18 Ago 51	Finalizado	West Bromwich Albion	3 - 3	Manchester United	0

Estadísticas

GOLEADORES

Plantilla del Manchester United Temporada 1951/1952

		Edad	Altura	Peso
Portero
	Jack Crompton	102	-	-	-	-	-
Defensa
	A. Chilton	105	-	-	-	-	-
	John Aston	102	-	-	4	-	-
	Johnny Carey	105	-	-	3	-	-
	R. Byrne	95	-	-	7	-	-
Centrocampista
	Billy Mcglen	103	-	-	-	-	-
	Billy Redman	96	-	-	-	-	-
	Brian Birch	92	168	-	1	-	-
	Don Gibson	94	-	-	-	-	-
	Frank Clempson	93	-	-	2	-	-
	H. Cockburn	102	-	-	2	-	-
	Jackie Blanchflower	91	180	74	-	-	-
	Jeff Whitefoot	90	170	-	-	-	-
	Johnny Berry	97	-	-	6	-	-
	Johnny Walton	96	-	-	-	-	-
	Laurie Cassidy	101	-	-	-	-	-
	Mark Jones	90	-	-	-	-	-
	Reg Allen	105	-	-	-	-	-
	Tommy Mcnulty	94	-	-	-	-	-
Delantero
	Ernie Bond	94	168	-	4	-	-
	Harry Mcshane	104	173	-	1	-	-
	Jack Rowley	103	-	-	30	-	-
	Johnny Downie	98	-	-	11	-	-
	Stan Pearson	105	-	-	22	-	-

Noticias del Manchester United

Ver últimas noticias

"Fuimos a por De Jong, se habría complementado bien con Casemiro"

BeSoccer - Viernes, 03 Mayo 2024

3 1.464

Erik ten Hag admitió a 'Sky Sports' que el Manchester United estuvo muy interesado en hacerse con los servicios de Frenkie de Jong. Lamentó el entrenador 'red devil' que no se pudiera completar su fichaje porque habría sido clave "para desarrollar el juego" que tenía en mente.

Horarios y partidos de la jornada 36 de Premier League 2023-24

BeSoccer - Miércoles, 01 Mayo 2024

4 44.876

La Premier League sigue su transcurso de partidos y con la trigésimo sexta jornada de encuentros se esperan una cantidad importante de duelos emocionantes, cosa a la que ya nos acostumbra este torneo. Encuentra aquí los días y horarios de Premier League.

Sneijder, crítico con Ten Hag: "Su error fue luchar contra Cristiano"

BeSoccer - Martes, 30 Abril 2024

6 2.226

El exfutbolista neerlandés Wesley Sneijder se ha hecho viral por unas declaraciones en las que criticaba al técnico del Manchester United, Erik ten Hag: "Su error fue luchar contra Cristiano Ronaldo. Ahí empezó a perder todo el respeto". Ya son conocidos los problemas con futbolistas de su vestuario del exentrenador del Ajax tras su enfrentamiento con la estrella lusa.

El United quiere a Greenwood en Old Trafford

BeSoccer - Lunes, 29 Abril 2024

2 2.226

Tal y como apuntó 'The Times', el Manchester United estaría pensándose la vuelta de Mason Greenwood este verano. El delantero inglés, que está cedido en el Getafe, tiene contrato con los 'red devils' hasta 2025, aunque su escándalo sobre una supuesta violación le alejó de Old Trafford. Ahora, el conjunto inglés podría haber cambiado de opinión debido a la temporada del futbolista y al poco margen de maniobra económica de la entidad.

Otra vez el Onana héroe-villano, otra vez el United mediocre

BeSoccer - Sábado, 27 Abril 2024

0 8.184

André Onana fue el culpable de que el Burnley llegase a la recta final a cero, pero también fue el responsable del penalti que le dio un punto a los visitantes. El Manchester United no pasó del 1-1 en Old Trafford frente a un rival que lucha por no descender y se complica la 6ª posición.

Ver más noticias del equipo»

Competiciones que juega

Grupo 1

Premier League

Pos	Equipos		Pts
1		Manchester United	57
2		Tottenham Hotspur	53
3		Arsenal	53
4		Portsmouth	48
5		Bolton Wanderers	48
6		Aston Villa	47
7		Preston North End	46
8		Newcastle	45
9		Blackpool	45
10		Charlton Athletic	44
11		Liverpool	43
12		Sunderland	42
13		West Bromwich Albion	41
14		Burnley	40
15		Manchester City	39
16		Wolves	38
17		Derby County	37
18		Middlesbrough	36
19		Chelsea	36
20		Stoke City	31
21		Huddersfield Town	28
22		Fulham	27

	Descenso : Huddersfield Town, Fulham

RIVALES EN Premier League

USO DE MEMORIA

5,934,688 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.7016
Total Execution Time	0.7036

CADENA URL

/Manchester-United-Fc/1952

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (32)

0.0144	SELECT type FROM routes WHERE alias = 'manchester-united-fc'
0.0174	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 = 1952 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.0146	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.0145	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.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1635 AND type_rel = 2
0.0188	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.0147	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 (1313720,1254444,1313250,1313176,1312838) ORDER BY n.cover_points DESC, update_date DESC
0.0154	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 = 1952 ORDER BY l.year DESC,cat.coefficient DESC
0.0168	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.0175	(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 calendars1952 as c ON c.league_id = l.id WHERE (c.datateam1 = 1635 or c.datateam2 = 1635) AND l.year = 1952 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0342	(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 calendars1952 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 = 1952 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0290	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1952 as c ON c.league_id = l.id INNER JOIN events1952 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 = 1952)
0.0337	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 (1951,1952,1953) ORDER BY l.id DESC, l.year DESC ;
0.0147	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 (22789,14941,5663) 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.0165	SELECT count(id) as num_players from rel_players WHERE league_id = 5663 AND teamId = 1635
0.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 14941 AND teamId = 1635
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 22789 AND teamId = 1635
0.0232	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 = '1635' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1635' and rp.type = 4
0.0157	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 = '1635' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0145	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1635' and rp.type = 4
0.0159	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 events1952 e ON e.player_id = p.id AND e.league_id = 5662 WHERE rp.league_id = 5662 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.0157	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 events1952 e ON e.player_id = p.id AND e.league_id = 5662 WHERE rp.league_id = 5662 AND rp.teamId = 1635 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0161	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 events1952 e ON e.player_id = p.id AND e.league_id = 5662 WHERE rp.league_id = 5662 AND rp.teamId = 1635 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158	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 = 5662 AND l.year= 1952 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0148	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=100388 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0145	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=100388
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 events1952 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=100388 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.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 events1952 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=100388 and (e.action = 4 or e.action = 5) 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 events1952 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=100388 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
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 events1952 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=100388 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
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 events1952 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=100388 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

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 1951/1952

Noticias del Manchester United

Manchester United

Selecciona un equipo

Competiciones que juega

RIVALES EN Premier League