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

West Ham

Entrenador: David Moyes

Temporada 2018/2019

Información sobre West Ham

Enviar Datos

Información

Nombre del equipo West Ham
Nombre completo West Ham United FC
Nombre corto WHU
País Inglaterra
Ciudad Londres
Entrenador David Moyes
URL del equipo en RF testing.resultados-futbol.com/West-Ham-United

Otros Datos

Año de Fundación 1895
Patrocinador Betway
Marca de Ropa Umbro
Socios 27000

Internet

Sitio Web www.whufc.com
Twitter principal @WestHam

Información sobre el estadio

Nombre del estadio London Stadium
Capacidad 80000
Dirección Queen Elizabeth Olympic Park, London E20 2ST, Reino Unido
Año de construcción 2012
Tamaño 105x68

Histórico de participación

Premier League

66 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2011, 2010, 2009, 2008, 2007, 2006, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1992, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1978, 1977, 1976, 1975, 1974, 1973, 1972, 1971, 1970, 1969, 1968, 1967, 1966, 1965, 1964, 1963, 1962, 1961, 1960, 1959, 1932, 1931, 1930, 1929, 1928, 1927, 1926, 1925, 1924)

FA Cup

61 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, 1980, 1977, 1975, 1972, 1969, 1964, 1963, 1956, 1939, 1933, 1930, 1929, 1928, 1923, 1914, 1911, 1910, 1909, 1907)

Championship

33 veces

(2012, 2005, 2004, 1993, 1991, 1990, 1981, 1980, 1979, 1958, 1957, 1956, 1955, 1954, 1953, 1952, 1951, 1950, 1949, 1948, 1947, 1940, 1939, 1938, 1937, 1936, 1935, 1934, 1933, 1923, 1922, 1921, 1920)

Partidos Amistosos

14 veces

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

Europa League Grupo 1

6 veces

(2024, 2024, 2022, 2022, 2007, 2000)

Fase Previa Europa League Grupo 3

5 veces

(2017, 2017, 2016, 2016, 2016)

Championship - Play Offs Ascenso

1 vez

(2012)

Fase Previa Conference League Grupo 4

1 vez

(2023)

Partidos del West Ham

Ir al LIVESCORE

Premier League »

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

Lopetegui, decepcionado con el Milan, se acerca más al West Ham

BeSoccer - Viernes, 03 Mayo 2024

2 1.371

El diario 'AS' informa de que Julen Lopetegui está decepcionado por el trato del Milan, que se ha dejado llevar por la furiosa respuesta de sus 'tifosi' a su potencial contratación como nuevo entrenador. El periódico sostiene que el estratega llevaba trabajando seis meses en la confección del proyecto de San Siro y que, ahora, se siente faltado al respecto. En paralelo, Fabrizio Romano indica que el West Ham United está en conversaciones directas con él.

Fase Previa Europa League: El West Ham gana, el Brondby golea y el Estrella Roja pierde

BeSoccer - Jueves, 02 Julio 2015

0 463

El West Ham inglés no falló su partido de ida de la primera ronda de clasificación de la Liga Europa y ganó con comodidad 3-0 al Lusitanos en una jornada en la que el Brondby danés goleó 9-0 al Juvenes y el Estrella Roja perdió 0-2 con el Kayrat Almaty kazajo.

¿Volverá Arbeloa a la Premier?

Isabel Ruiz - Miércoles, 01 Julio 2015

0 1.295

El club inglés realizaría una oferta económica importante al lateral blanco si el Madrid le dejara salir gratis.

El Barça facilitará la salida de Song al West Ham

Sergio Álvarez - Viernes, 26 Junio 2015

0 204

Pese a que había otros equipos británicos interesados en su fichaje, el camerunés prefiere continuar en el West Ham y el Barça no pondrá pegas para su traspaso definitivo.

El Lusitans andorrano, primer rival del West Ham

BeSoccer - Lunes, 22 Junio 2015

0 218

(Amplia con el sorteo de la segunda ronda previa)

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,615,824 bytes

BENCHMARKS

Loading Time Base Classes	0.0024
Controller Execution Time ( Home / Category )	0.2131
Total Execution Time	0.2156

CADENA URL

/West-Ham-United/2019

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (37)

0.0018	SELECT type FROM routes WHERE alias = 'west-ham-united'
0.0039	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.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 = 44547
0.0026	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.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 = 49725
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2804 AND type_rel = 2
0.0062	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.0027	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 (1313787,540,704,1158,1370) ORDER BY n.cover_points DESC, update_date DESC
0.0046	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.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 = 43924 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0047	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.0020	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.0024	(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.0044	(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.0030	(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.0058	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.0021	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.0034	SELECT count(id) as num_players from rel_players WHERE league_id = 49845 AND teamId = 2804
0.0042	SELECT count(id) as num_players from rel_players WHERE league_id = 50579 AND teamId = 2804
0.0060	SELECT count(id) as num_players from rel_players WHERE league_id = 50152 AND teamId = 2804
0.0105	SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 2804
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 49725 AND teamId = 2804
0.0027	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.0023	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.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2804' and rp.type = 4
0.0021	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.0040	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.0033	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.0030	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.0026	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.0028	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.0019	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6185356
0.0035	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.0029	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.0026	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.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 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.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 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


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

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