12 May 19	Finalizado	Watford	1 - 4	West Ham	30
04 May 19	Finalizado	West Ham	3 - 0	Southampton	38
27 Abr 19	Finalizado	Tottenham Hotspur	0 - 1	West Ham	157
20 Abr 19	Finalizado	West Ham	2 - 2	Leicester	72
13 Abr 19	Finalizado	Manchester United	2 - 1	West Ham	158
08 Abr 19	Finalizado	Chelsea	2 - 0	West Ham	223
30 Mar 19	Finalizado	West Ham	0 - 2	Everton	85
16 Mar 19	Finalizado	West Ham	4 - 3	Huddersfield Town	255
09 Mar 19	Finalizado	Cardiff City	2 - 0	West Ham	119
02 Mar 19	Finalizado	West Ham	2 - 0	Newcastle	69
27 Feb 19	Finalizado	Manchester City	1 - 0	West Ham	175
22 Feb 19	Finalizado	West Ham	3 - 1	Fulham	76
09 Feb 19	Finalizado	Crystal Palace	1 - 1	West Ham	64
04 Feb 19	Finalizado	West Ham	1 - 1	Liverpool	324
29 Ene 19	Finalizado	Wolves	3 - 0	West Ham	128
19 Ene 19	Finalizado	AFC Bournemouth	2 - 0	West Ham	30
12 Ene 19	Finalizado	West Ham	1 - 0	Arsenal	290
02 Ene 19	Finalizado	West Ham	2 - 2	Brighton & Hove Albion	124
30 Dic 18	Finalizado	Burnley	2 - 0	West Ham	249
27 Dic 18	Finalizado	Southampton	1 - 2	West Ham	285
22 Dic 18	Finalizado	West Ham	0 - 2	Watford	51
15 Dic 18	Finalizado	Fulham	0 - 2	West Ham	71
08 Dic 18	Finalizado	West Ham	3 - 2	Crystal Palace	81
04 Dic 18	Finalizado	West Ham	3 - 1	Cardiff City	83
01 Dic 18	Finalizado	Newcastle	0 - 3	West Ham	68
24 Nov 18	Finalizado	West Ham	0 - 4	Manchester City	66
10 Nov 18	Finalizado	Huddersfield Town	1 - 1	West Ham	41
03 Nov 18	Finalizado	West Ham	4 - 2	Burnley	62
27 Oct 18	Finalizado	Leicester	1 - 1	West Ham	152
20 Oct 18	Finalizado	West Ham	0 - 1	Tottenham Hotspur	72
05 Oct 18	Finalizado	Brighton & Hove Albion	1 - 0	West Ham	240
29 Sep 18	Finalizado	West Ham	3 - 1	Manchester United	555
23 Sep 18	Finalizado	West Ham	0 - 0	Chelsea	561
16 Sep 18	Finalizado	Everton	1 - 3	West Ham	281
01 Sep 18	Finalizado	West Ham	0 - 1	Wolves	185
25 Ago 18	Finalizado	Arsenal	3 - 1	West Ham	428
18 Ago 18	Finalizado	West Ham	1 - 2	AFC Bournemouth	122
12 Ago 18	Finalizado	Liverpool	4 - 0	West Ham	435

FA Cup »

	26 Ene 19	Finalizado	AFC Wimbledon	4 - 2	West Ham			66
	05 Ene 19	Finalizado	West Ham	2 - 0	Birmingham City			39

EFL Cup »

31 Oct 18	Finalizado	West Ham	1 - 3	Tottenham Hotspur	70
26 Sep 18	Finalizado	West Ham	8 - 0	Macclesfield Town	23
28 Ago 18	Finalizado	AFC Wimbledon	1 - 3	West Ham	103

Partidos Amistosos »

03 Ago 18	Finalizado	West Ham	1 - 0	Angers SCO	12
31 Jul 18	Finalizado	Mainz 05	1 - 1	West Ham	62
28 Jul 18	Finalizado	Ipswich Town	1 - 2	West Ham	3
25 Jul 18	Finalizado	Aston Villa	1 - 3	West Ham	17
21 Jul 18	Finalizado	Preston North End	2 - 2	West Ham	7
14 Jul 18	Finalizado	Wycombe Wanderers	0 - 1	West Ham	6
08 Jul 18	Finalizado	Winterthur	3 - 2	West Ham	9

Trofeo Premier League Asia »

	20 Jul 19	Finalizado	Newcastle	1 - 0	West Ham			16
	17 Jul 19	Finalizado	Manchester City	4 - 1	West Ham			68

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del West Ham Temporada 2018/2019

		Edad	Altura	Peso
Portero
13	Adrián	37	190	78	-	-	-
1	L. Fabianski	39	190	83	-	-	-
Defensa
3	A. Cresswell	34	170	66	-	-	1
26	A. Masuaku	30	179	70	-	-	2
21	A. Ogbonna	35	191	86	1	-	2
53	Ben Johnson	24	184	67	-	-	-
4	F. Balbuena	32	189	82	1	-	2
23	Issa Diop	27	194	84	1	-	4
5	P. Zabaleta	39	174	74	-	-	4
24	R. Fredericks	31	181	72	1	-	5
Centrocampista
15	C. Sánchez	38	182	82	-	-	-
54	Conor Coventry	24	177	70	-	-	-
41	Declan Rice	25	188	80	2	-	4
19	J. Wilshere	32	170	65	-	-	2
10	M. Lanzini	31	167	66	1	-	2
16	M. Noble	36	180	76	5	1	6
14	Pedro Obiang	32	186	75	-	-	-
18	S. Nasri	36	178	75	-	-	-
	W. Reid	35	190	87	-	-	-
Delantero
9	A. Carroll	35	193	76	-	-	2
20	A. Yarmolenko	34	189	81	2	-	2
17	Chicharito	35	175	72	7	-	2
8	Felipe Anderson	31	175	69	9	-	3
45	G. Diangana	26	180	73	-	-	-
27	Lucas Pérez	35	180	78	3	-	-
30	M. Antonio	34	180	81	6	-	3
7	M. Arnautović	35	190	83	10	-	3
37	Nathan Holland	25	176	70	-	-	-
11	R. Snodgrass	36	182	77	2	-	10
32	Xande Silva	27	177	68	-	-	-

Noticias del West Ham

Ver últimas noticias

Adiós al tipo que jugaba feo y ganaba

David Caravaca - Martes, 07 Mayo 2024

0 11.459

El West Ham United anunció la marcha de David Moyes de mutuo acuerdo para el final de la temporada, con lo que se pone fin a toda una era a orillas del Támesis. El técnico escocés se caracteriza por aplicar un estilo de juego defensivo y de estilo directo que ha servido, desde 2017, para que los 'hammers' abandonen las inmediaciones del descenso y peleen por clasificarse para competiciones europeas. De hecho, es esta ambición la que le ha costado el puesto.

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

BeSoccer - Martes, 07 Mayo 2024

4 45.148

La Premier League sigue su transcurso de partidos y con la trigésimo séptima 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.

Lopetegui, más cerca: el West Ham anuncia la marcha de Moyes

BeSoccer - Lunes, 06 Mayo 2024

1 483

El West Ham United ha confirmado que su entrenador, David Moyes, abandonará el banquillo 'hammer' al término de la campaña 2023-24. El escocés finaliza su contrato con los londinenses el próximo verano y tanto club como técnico han acordado que lo mejor es separar sus caminos y no llevar a cabo la renovación. La entidad también ha explicado que el proceso de selección del nuevo preparador ha comenzado, pero que no harán más comentarios pese a que todas las miradas se posan en Julen Lopetegui.

Lopetegui dice "sí" al West Ham

BeSoccer - Lunes, 06 Mayo 2024

1 707

Julen Lopetegui será, salvo giro radical de los acontecimientos, el nuevo entrenador del West Ham para la próxima temporada. El técnico español ha hecho caso omiso a otras proposiciones fuera de Inglaterra.

Ni Liverpool ni West Ham: Amorim se queda en el Sporting

BeSoccer - Lunes, 06 Mayo 2024

1 472

Rúben Amorim, antes de ganar la Liga Portuguesa con el Sporting CP, confirmó que seguirá en el conjunto lisboeta la próxima temporada, descartando de esta manera un desembarco en la Premier League.

Ver más noticias del equipo»

Competiciones que juega

Grupo 1

Premier League

Pos	Equipos		Pts
1		Manchester City	98
2		Liverpool	97
3		Chelsea	72
4		Tottenham Hotspur	71
5		Arsenal	70
6		Manchester United	66
7		Wolves	57
8		Everton	54
9		Leicester	52
10		West Ham	52
11		Watford	50
12		Crystal Palace	49
13		Newcastle	45
14		AFC Bournemouth	45
15		Burnley	40
16		Southampton	39
17		Brighton & Hove Albion	36
18		Cardiff City	34
19		Fulham	26
20		Huddersfield Town	16

	Champions League : Manchester City, Liverpool, Chelsea, Tottenham Hotspur
	Europa League : Arsenal, Manchester United, Wolves
	Descenso : Cardiff City, Fulham, Huddersfield Town

RIVALES EN EFL Cup

RIVALES EN FA Cup

RIVALES EN Premier League

USO DE MEMORIA

6,558,760 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.8058
Total Execution Time	0.8078

CADENA URL

/West-Ham-United/2019

GET DATOS

$_GET['/West-Ham-United/2019']

POST DATOS

No hay datos POST existentes

CONSULTAS (47)

0.0125	SELECT type FROM routes WHERE alias = 'west-ham-united'
0.0147	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 = 'West-Ham-United' AND l.year = 2019 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.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=2804 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=2804 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=2804 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=2804 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=2804 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=2804 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 = 43543
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 = 44547
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 = 43924
0.0133	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 = 49725
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2804 AND type_rel = 2
0.0176	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2804 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0130	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 (1314301,1254444,1314206,1314163,1314143) ORDER BY n.cover_points DESC, update_date DESC
0.0161	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 = '2804' ORDER BY l.year DESC,cat.coefficient DESC
0.0148	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 = '2804' AND l.year = 2019 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 = '2804' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131	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 = 43924 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0158	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 = 44547 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 43543 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130	(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 calendars2019 as c ON c.league_id = l.id WHERE (c.datateam1 = 2804 or c.datateam2 = 2804) AND l.year = 2019 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0138	(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 calendars2019 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 = 2804 or c.datateam2 = 2804) AND l.year = 2019 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0132	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2019 as c ON c.league_id = l.id INNER JOIN events2019 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 = 2804 or c.datateam2 = 2804) AND l.year = 2019)
0.0144	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=2804 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0135	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 (50579,50152,49845,49725,49506) 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.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 49845 AND teamId = 2804
0.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 50579 AND teamId = 2804
0.0141	SELECT count(id) as num_players from rel_players WHERE league_id = 50152 AND teamId = 2804
0.0215	SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 2804
0.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 49725 AND teamId = 2804
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* `tables2019` 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 = 43543 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0131	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 = '2804' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2804' and rp.type = 4
0.0128	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 = '2804' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0150	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 events2019 e ON e.player_id = p.id AND e.league_id = 43543 WHERE rp.league_id = 43543 AND rp.teamId = 2804 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.0151	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 events2019 e ON e.player_id = p.id AND e.league_id = 43543 WHERE rp.league_id = 43543 AND rp.teamId = 2804 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2019 e ON e.player_id = p.id AND e.league_id = 43543 WHERE rp.league_id = 43543 AND rp.teamId = 2804 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138	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 = 2804 AND rp.league_id = 43543 AND l.year= 2019 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0133	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=6185356 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0126	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6185356
0.0135	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 events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6185356 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.0132	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 events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6185356 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0129	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 events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6185356 and (e.action = 3 or e.action = 4) 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 events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6185356 AND (e.action = 22) 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 events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6185356 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0128	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 = 43543 ORDER BY nameShow LIMIT 100

West Ham

Información sobre West Ham

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del West Ham

Estadísticas

Plantilla del West Ham Temporada 2018/2019

Noticias del West Ham

West Ham

Selecciona un equipo

Competiciones que juega

RIVALES EN EFL Cup

RIVALES EN FA Cup

RIVALES EN Premier League