14 May 58	Finalizado	Milan	4 - 0	Manchester United	0
08 May 58	Finalizado	Manchester United	2 - 1	Milan	0
05 Feb 58	Finalizado	Crvena Zvezda	3 - 3	Manchester United	2
14 Ene 58	Finalizado	Manchester United	2 - 1	Crvena Zvezda	0
04 Dic 57	Finalizado	FK Dukla Praha	1 - 0	Manchester United	0
20 Nov 57	Finalizado	Manchester United	3 - 0	FK Dukla Praha	0
02 Oct 57	Finalizado	Manchester United	3 - 2	Shamrock Rovers	0
25 Sep 57	Finalizado	Shamrock Rovers	0 - 6	Manchester United	0

Premier League »

26 Abr 58	Finalizado	Chelsea	2 - 1	Manchester United
23 Abr 58	Finalizado	Manchester United	1 - 1	Newcastle
21 Abr 58	Finalizado	Manchester United	0 - 4	Wolves
19 Abr 58	Finalizado	Manchester United	0 - 2	Birmingham City
16 Abr 58	Finalizado	Portsmouth	3 - 3	Manchester United
12 Abr 58	Finalizado	Tottenham Hotspur	1 - 0	Manchester United
07 Abr 58	Finalizado	Sunderland	1 - 2	Manchester United
05 Abr 58	Finalizado	Manchester United	0 - 0	Preston North End
04 Abr 58	Finalizado	Manchester United	2 - 2	Sunderland
31 Mar 58	Finalizado	Aston Villa	3 - 2	Manchester United
29 Mar 58	Finalizado	Sheffield Wednesday	1 - 0	Manchester United
15 Mar 58	Finalizado	Burnley	3 - 0	Manchester United
08 Mar 58	Finalizado	Manchester United	0 - 4	West Bromwich Albion
22 Feb 58	Finalizado	Manchester United	1 - 1	Nottingham Forest
01 Feb 58	Finalizado	Arsenal	4 - 5	Manchester United
18 Ene 58	Finalizado	Manchester United	7 - 2	Bolton Wanderers
11 Ene 58	Finalizado	Leeds United	1 - 1	Manchester United
28 Dic 57	Finalizado	Manchester City	2 - 2	Manchester United
26 Dic 57	Finalizado	Luton Town	2 - 2	Manchester United
25 Dic 57	Finalizado	Manchester United	3 - 0	Luton Town
21 Dic 57	Finalizado	Manchester United	4 - 0	Leicester
14 Dic 57	Finalizado	Manchester United	0 - 1	Chelsea
07 Dic 57	Finalizado	Birmingham City	3 - 3	Manchester United
30 Nov 57	Finalizado	Manchester United	3 - 4	Tottenham Hotspur
23 Nov 57	Finalizado	Newcastle	1 - 2	Manchester United
16 Nov 57	Finalizado	Manchester United	2 - 1	Sheffield Wednesday
09 Nov 57	Finalizado	Preston North End	1 - 1	Manchester United
02 Nov 57	Finalizado	Manchester United	1 - 0	Burnley
26 Oct 57	Finalizado	West Bromwich Albion	4 - 3	Manchester United
19 Oct 57	Finalizado	Manchester United	0 - 3	Portsmouth
12 Oct 57	Finalizado	Nottingham Forest	1 - 2	Manchester United
05 Oct 57	Finalizado	Manchester United	4 - 1	Aston Villa
28 Sep 57	Finalizado	Wolves	3 - 1	Manchester United
21 Sep 57	Finalizado	Manchester United	4 - 2	Arsenal
18 Sep 57	Finalizado	Manchester United	1 - 2	Blackpool
14 Sep 57	Finalizado	Bolton Wanderers	4 - 0	Manchester United
09 Sep 57	Finalizado	Blackpool	1 - 4	Manchester United
07 Sep 57	Finalizado	Manchester United	5 - 0	Leeds United
04 Sep 57	Finalizado	Everton	3 - 3	Manchester United
31 Ago 57	Finalizado	Manchester United	4 - 1	Manchester City
28 Ago 57	Finalizado	Manchester United	3 - 0	Everton
24 Ago 57	Finalizado	Leicester	0 - 3	Manchester United

FA Cup »

03 May 58	Finalizado	Bolton Wanderers	2 - 0	Manchester United
26 Mar 58	Finalizado	Fulham	3 - 5	Manchester United
22 Mar 58	Finalizado	Manchester United	2 - 2	Fulham
05 Mar 58	Finalizado	Manchester United	1 - 0	West Bromwich Albion
01 Mar 58	Finalizado	West Bromwich Albion	2 - 2	Manchester United

Community Shield »

22 Oct 57

Finalizado

Manchester United

4 - 0

Aston Villa

Estadísticas

GOLEADORES

Plantilla del Manchester United Temporada 1957/1958

		Edad	Altura	Peso
Portero
	David Gaskell	83	178	-	1	-	-
	H. Gregg	91	-	-	-	-	-
	Ray Wood	92	-	-	-	-	-
Defensa
	Bill Foulkes	92	-	-	-	-	-
	Bobby Harrop	87	178	-	-	-	-
	Eddie Colman	87	-	-	-	-	-
	Ian Greaves	91	-	-	-	-	-
	Peter Jones	86	-	-	-	-	-
	R. Byrne	95	-	-	-	-	-
	Ron Cope	89	-	-	-	-	-
	S. Brennan	86	-	-	-	-	-
	Tommy Heron	88	174	-	-	-	-
Centrocampista
	Albert Scanlon	88	178	-	3	-	-
	David Pegg	88	-	-	3	-	-
	Duncan Edwards	87	-	-	6	-	-
	Freddie Goodwin	90	186	-	-	-	-
	Jackie Blanchflower	91	180	74	-	-	-
	John Doherty	89	-	-	6	-	-
	Johnny Berry	97	-	-	4	-	-
	Liam Whelan	89	-	-	12	-	-
	Mark Jones	90	-	-	-	-	-
	Stan Crowther	88	-	-	4	-	-
	Wilf Mcguinness	86	-	-	-	-	-
Delantero
	Alex Dawson	84	-	-	5	-	-
	Bobby Charlton	86	-	-	8	-	-
	C. Webster	91	-	-	6	-	-
	Dennis Viollet	90	-	-	16	-	-
	Ernie Taylor	98	163	-	10	-	-
	Kenny Morgans	85	-	-	-	-	-
	Mark Pearson	84	168	-	-	-	-
	Tommy Taylor	92	-	-	16	-	-

Noticias del Manchester United

Ver últimas noticias

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

BeSoccer - Sábado, 27 Abril 2024

0 8.100

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.

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

BeSoccer - Sábado, 27 Abril 2024

0 825

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

7 2.673

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.695

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.499

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'.

Ver más noticias del equipo»

Competiciones que juega

Grupo 1

Premier League

Pos	Equipos		Pts
1		Wolves	64
2		Preston North End	59
3		West Bromwich Albion	51
4		Tottenham Hotspur	51
5		Manchester City	49
6		Burnley	47
7		Blackpool	44
8		Luton Town	44
9		Manchester United	43
10		Nottingham Forest	42
11		Chelsea	42
12		Arsenal	39
13		Birmingham City	39
14		Aston Villa	39
15		Everton	37
16		Leeds United	37
17		Bolton Wanderers	37
18		Leicester	33
19		Newcastle	32
20		Portsmouth	32
21		Sunderland	32
22		Sheffield Wednesday	31

	Copa de Europa : Wolves, Manchester United
	Copa de Ferias : Chelsea, Birmingham City
	Descenso : Sunderland, Sheffield Wednesday

RIVALES EN Champions League

RIVALES EN Community Shield

RIVALES EN FA Cup

RIVALES EN Premier League

USO DE MEMORIA

6,595,576 bytes

BENCHMARKS

Loading Time Base Classes	0.0030
Controller Execution Time ( Home / Category )	0.8207
Total Execution Time	0.8237

CADENA URL

/Manchester-United-Fc/1958

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (46)

0.0125	SELECT type FROM routes WHERE alias = 'manchester-united-fc'
0.0156	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 = 1958 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.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=1635 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=1635 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=1635 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=1635 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=1635 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132	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 = 5668
0.0132	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 = 10903
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 = 14924
0.0131	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 = 22785
0.0126	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1635 AND type_rel = 2
0.0148	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.0128	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 (1312838,1312783,1312776,1312646,1312471) ORDER BY n.cover_points DESC, update_date DESC
0.0145	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 = 1958 ORDER BY l.year DESC,cat.coefficient DESC
0.0148	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.0127	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 = 10903 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0125	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 = 22785 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149	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 = 14924 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0139	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 = 5668 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0173	(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 calendars1958 as c ON c.league_id = l.id WHERE (c.datateam1 = 1635 or c.datateam2 = 1635) AND l.year = 1958 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0198	(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 calendars1958 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 = 1958 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0151	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1958 as c ON c.league_id = l.id INNER JOIN events1958 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 = 1958)
0.0143	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 (1957,1958,1959) 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 (22786,14925,10905,5669) 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.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 5669 AND teamId = 1635
0.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 10905 AND teamId = 1635
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 14925 AND teamId = 1635
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 22786 AND teamId = 1635
0.0132	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables1958` 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 = 5668 AND t.round = 42 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0221	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.0128	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1635' and rp.type = 4
0.0139	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.0125	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1635' and rp.type = 4
0.0140	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 events1958 e ON e.player_id = p.id AND e.league_id = 5668 WHERE rp.league_id = 5668 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.0166	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 events1958 e ON e.player_id = p.id AND e.league_id = 5668 WHERE rp.league_id = 5668 AND rp.teamId = 1635 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0141	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 events1958 e ON e.player_id = p.id AND e.league_id = 5668 WHERE rp.league_id = 5668 AND rp.teamId = 1635 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140	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 = 5668 AND l.year= 1958 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0135	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=100531 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0128	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=100531
0.0151	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 events1958 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=100531 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.0142	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 events1958 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=100531 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0174	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 events1958 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=100531 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0151	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 events1958 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=100531 AND (e.action = 22) 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 events1958 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=100531 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0139	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 = 5668 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 1957/1958

Noticias del Manchester United

Manchester United

Selecciona un equipo

Competiciones que juega

RIVALES EN Champions League

RIVALES EN Community Shield

RIVALES EN FA Cup

RIVALES EN Premier League