24 May 15	Finalizado	Newcastle	2 - 0	West Ham	87
16 May 15	Finalizado	West Ham	1 - 2	Everton	77
09 May 15	Finalizado	Aston Villa	1 - 0	West Ham	40
02 May 15	Finalizado	West Ham	1 - 0	Burnley	27
25 Abr 15	Finalizado	Queens Park Rangers	0 - 0	West Ham	34
19 Abr 15	Finalizado	Manchester City	2 - 0	West Ham	288
11 Abr 15	Finalizado	West Ham	1 - 1	Stoke City	41
04 Abr 15	Finalizado	Leicester	2 - 1	West Ham	81
21 Mar 15	Finalizado	West Ham	1 - 0	Sunderland	70
14 Mar 15	Finalizado	Arsenal	3 - 0	West Ham	302
04 Mar 15	Finalizado	West Ham	0 - 1	Chelsea	327
28 Feb 15	Finalizado	West Ham	1 - 3	Crystal Palace	327
22 Feb 15	Finalizado	Tottenham Hotspur	2 - 2	West Ham	466
11 Feb 15	Finalizado	Southampton	0 - 0	West Ham	217
08 Feb 15	Finalizado	West Ham	1 - 1	Manchester United	302
31 Ene 15	Finalizado	Liverpool	2 - 0	West Ham	190
18 Ene 15	Finalizado	West Ham	3 - 0	Hull City	118
10 Ene 15	Finalizado	Swansea City	1 - 1	West Ham	74
01 Ene 15	Finalizado	West Ham	1 - 1	West Bromwich Albion	70
28 Dic 14	Finalizado	West Ham	1 - 2	Arsenal	191
26 Dic 14	Finalizado	Chelsea	2 - 0	West Ham	579
20 Dic 14	Finalizado	West Ham	2 - 0	Leicester	30
13 Dic 14	Finalizado	Sunderland	1 - 1	West Ham	37
07 Dic 14	Finalizado	West Ham	3 - 1	Swansea City	73
02 Dic 14	Finalizado	West Bromwich Albion	1 - 2	West Ham	45
29 Nov 14	Finalizado	West Ham	1 - 0	Newcastle	51
22 Nov 14	Finalizado	Everton	2 - 1	West Ham	121
08 Nov 14	Finalizado	West Ham	0 - 0	Aston Villa	30
01 Nov 14	Finalizado	Stoke City	2 - 2	West Ham	39
25 Oct 14	Finalizado	West Ham	2 - 1	Manchester City	274
18 Oct 14	Finalizado	Burnley	1 - 3	West Ham	25
05 Oct 14	Finalizado	West Ham	2 - 0	Queens Park Rangers	29
27 Sep 14	Finalizado	Manchester United	2 - 1	West Ham	153
20 Sep 14	Finalizado	West Ham	3 - 1	Liverpool	138
15 Sep 14	Finalizado	Hull City	2 - 2	West Ham	55
30 Ago 14	Finalizado	West Ham	1 - 3	Southampton	19
23 Ago 14	Finalizado	Crystal Palace	1 - 3	West Ham	29
16 Ago 14	Finalizado	West Ham	0 - 1	Tottenham Hotspur	78

FA Cup »

14 Feb 15	Finalizado	West Bromwich Albion	4 - 0	West Ham	39
25 Ene 15	Finalizado	Bristol City	0 - 1	West Ham	27
13 Ene 15	Finalizado	West Ham	2 - 2	Everton	220
06 Ene 15	Finalizado	Everton	1 - 1	West Ham	199

EFL Cup »

26 Ago 14

Finalizado

West Ham

1 - 1

Sheffield United

Partidos Amistosos »

09 Ago 14	Finalizado	West Ham	3 - 2	Sampdoria	2
03 Ago 14	Finalizado	West Ham	0 - 2	Málaga	14
02 Ago 14	Finalizado	Schalke 04	0 - 0	West Ham	6
26 Jul 14	Finalizado	Sydney FC	3 - 1	West Ham	3
23 Jul 14	Finalizado	Wellington Phoenix	2 - 1	West Ham	3
12 Jul 14	Finalizado	Stevenage	2 - 2	West Ham	2

Estadísticas

GOLEADORES

AMARILLAS

W. Reid10

ROJAS

Adrián1

J. Collins1

Plantilla del West Ham Temporada 2014/2015

		Edad	Altura	Peso
Portero
13	Adrián	37	190	78	-	1	3
22	J. Jääskeläinen	49	191	81	-	-	-
	R. Spiegel	31	197	88	-	-	-
Defensa
3	A. Cresswell	34	170	66	2	-	5
18	Carl Jenkinson	32	185	77	-	-	2
	D. Henry	31	188	82	-	-	-
	Dan Potts	30	173	76	-	-	-
40	E. Onariase	27	188	82	-	-	-
20	Guy Demel	42	188	88	-	-	-
19	J. Collins	40	193	89	-	1	7
17	J. O'brien	38	180	69	-	-	2
5	J. Tomkins	35	192	74	1	-	6
32	Reece Burke	27	189	81	-	-	-
35	Reece Oxford	25	190	71	-	-	-
Centrocampista
30	Alex Song	36	184	76	-	-	4
8	C. Kouyaté	34	189	74	4	-	5
36	E. Lee	29	180	72	-	-	-
39	J. Cullen	28	175	70	-	-	-
4	K. Nolan	41	180	88	1	-	2
21	M. Amalfitano	39	176	68	3	-	3
7	M. Jarvis	37	170	72	-	-	-
16	M. Noble	36	180	76	2	-	4
	Nenê	42	181	74	-	-	-
11	Stewart Downing	39	180	64	6	-	3
2	W. Reid	35	190	87	1	-	10
Delantero
9	A. Carroll	35	193	76	5	-	2
24	Carlton Cole	40	191	78	2	-	2
15	D. Sakho	34	184	79	10	-	2
31	E. Valencia	34	177	74	4	-	2

Noticias del West Ham

Ver últimas noticias

El técnico del West Ham imita a Mourinho ante el Lusitanos de Andorra

Sergio Álvarez - Viernes, 03 Julio 2015

3 1.783

El croata Slaven Bilic pasó de dirigir el encuentro de Previa de Europa League del equipo londinense ante el cuadro andorrano, algo que no gustó al técnico visitante.

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»

Pos	Equipos	Pts
1		Chelsea	87
2		Manchester City	79
3		Arsenal	75
4		Manchester United	70
5		Tottenham Hotspur	64
6		Liverpool	62
7		Southampton	60
8		Swansea City	56
9		Stoke City	54
10		Crystal Palace	48
11		Everton	47
12		West Ham	47
13		West Bromwich Albion	44
14		Leicester	41
15		Newcastle	39
16		Sunderland	38
17		Aston Villa	38
18		Hull City	35
19		Burnley	33
20		Queens Park Rangers	30

Pos

Equipos

Pts

	Champions League : Chelsea, Manchester City, Arsenal
	Previa de Champions : Manchester United
	Europa League : Tottenham Hotspur, Liverpool, Southampton, West Ham
	Descenso : Hull City, Burnley, Queens Park Rangers

Champions League : Chelsea, Manchester City, Arsenal

Previa de Champions : Manchester United

Europa League : Tottenham Hotspur, Liverpool, Southampton, West Ham

Descenso : Hull City, Burnley, Queens Park Rangers

USO DE MEMORIA

6,428,600 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.1784
Total Execution Time	0.1805

CADENA URL

/West-Ham-United/2015

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0043	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 = 2015 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.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=2804 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=2804 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=2804 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=2804 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=2804 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0044	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 = 2015 ORDER BY l.year DESC,cat.coefficient DESC
0.0041	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.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 = 4028 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0038	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 = 4393 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	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 = 3773 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 calendars2015 as c ON c.league_id = l.id WHERE (c.datateam1 = 2804 or c.datateam2 = 2804) AND l.year = 2015 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0035	(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 calendars2015 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 = 2015 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0029	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2015 as c ON c.league_id = l.id INNER JOIN events2015 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 = 2015)
0.0040	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 (2014,2015,2016) 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 (16427,16245,16076,15425,15131) 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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 15131 AND teamId = 2804
0.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 16427 AND teamId = 2804
0.0039	SELECT count(id) as num_players from rel_players WHERE league_id = 15425 AND teamId = 2804
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 16076 AND teamId = 2804
0.0051	SELECT count(id) as num_players from rel_players WHERE league_id = 16245 AND teamId = 2804
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2015` 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 = 3773 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0050	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 events2015 e ON e.player_id = p.id AND e.league_id = 3773 WHERE rp.league_id = 3773 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.0037	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 events2015 e ON e.player_id = p.id AND e.league_id = 3773 WHERE rp.league_id = 3773 AND rp.teamId = 2804 AND (e.action = 4 or e.action = 5) 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 events2015 e ON e.player_id = p.id AND e.league_id = 3773 WHERE rp.league_id = 3773 AND rp.teamId = 2804 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 3773 AND l.year= 2015 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0024	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=69565 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0020	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=69565
0.0030	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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=69565 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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=69565 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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=69565 and (e.action = 3 or e.action = 4) 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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=69565 AND (e.action = 22) 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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=69565 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 = 3773 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 2014/2015

Noticias del West Ham

West Ham

Selecciona un equipo

Competiciones que juega

RIVALES EN EFL Cup

RIVALES EN FA Cup

RIVALES EN Premier League