24 Feb 04	Finalizado	West Ham	0 - 3	Fulham
14 Feb 04	Finalizado	Fulham	0 - 0	West Ham
25 Ene 04	Finalizado	Wolves	1 - 3	West Ham
03 Ene 04	Finalizado	Wigan Athletic	1 - 2	West Ham

EFL Cup »

29 Oct 03	Finalizado	Tottenham Hotspur	1 - 0	West Ham
23 Sep 03	Finalizado	Cardiff City	2 - 3	West Ham
13 Ago 03	Finalizado	West Ham	3 - 1	Rushden & Diamonds

Championship »

09 May 04	Finalizado	Wigan Athletic	1 - 1	West Ham
01 May 04	Finalizado	West Ham	4 - 0	Watford
24 Abr 04	Finalizado	Stoke City	0 - 2	West Ham
17 Abr 04	Finalizado	West Ham	2 - 0	Coventry City
12 Abr 04	Finalizado	Crystal Palace	1 - 0	West Ham
10 Abr 04	Finalizado	West Ham	0 - 0	Derby County
03 Abr 04	Finalizado	Reading	2 - 0	West Ham
27 Mar 04	Finalizado	West Ham	2 - 1	Gillingham
21 Mar 04	Finalizado	Millwall	4 - 1	West Ham
17 Mar 04	Finalizado	West Ham	4 - 2	Crewe Alexandra
13 Mar 04	Finalizado	Sunderland	2 - 0	West Ham
09 Mar 04	Finalizado	West Ham	5 - 0	Wimbledon FC
06 Mar 04	Finalizado	West Ham	0 - 0	Walsall
02 Mar 04	Finalizado	Burnley	1 - 1	West Ham
28 Feb 04	Finalizado	West Ham	1 - 0	Cardiff City
21 Feb 04	Finalizado	Norwich City	1 - 1	West Ham
07 Feb 04	Finalizado	Bradford City	1 - 2	West Ham
31 Ene 04	Finalizado	West Ham	2 - 1	Rotherham United
17 Ene 04	Finalizado	Sheffield United	3 - 3	West Ham
10 Ene 04	Finalizado	West Ham	1 - 2	Preston North End
28 Dic 03	Finalizado	Nottingham Forest	0 - 2	West Ham
26 Dic 03	Finalizado	West Ham	1 - 2	Ipswich Town
20 Dic 03	Finalizado	Walsall	1 - 1	West Ham
13 Dic 03	Finalizado	West Ham	3 - 2	Sunderland
09 Dic 03	Finalizado	West Ham	0 - 1	Stoke City
06 Dic 03	Finalizado	West Bromwich Albion	1 - 1	West Ham
29 Nov 03	Finalizado	West Ham	4 - 0	Wigan Athletic
25 Nov 03	Finalizado	Wimbledon FC	1 - 1	West Ham
22 Nov 03	Finalizado	Watford	0 - 0	West Ham
08 Nov 03	Finalizado	West Ham	3 - 4	West Bromwich Albion
01 Nov 03	Finalizado	Coventry City	1 - 1	West Ham
25 Oct 03	Finalizado	Cardiff City	0 - 0	West Ham
22 Oct 03	Finalizado	West Ham	1 - 1	Nottingham Forest
18 Oct 03	Finalizado	West Ham	2 - 2	Burnley
15 Oct 03	Finalizado	West Ham	1 - 1	Norwich City
04 Oct 03	Finalizado	Derby County	0 - 1	West Ham
01 Oct 03	Finalizado	West Ham	3 - 0	Crystal Palace
28 Sep 03	Finalizado	West Ham	1 - 1	Millwall
20 Sep 03	Finalizado	Gillingham	2 - 0	West Ham
16 Sep 03	Finalizado	Crewe Alexandra	0 - 3	West Ham
13 Sep 03	Finalizado	West Ham	1 - 0	Reading
30 Ago 03	Finalizado	Ipswich Town	1 - 2	West Ham
26 Ago 03	Finalizado	West Ham	1 - 0	Bradford City
23 Ago 03	Finalizado	Rotherham United	1 - 0	West Ham
16 Ago 03	Finalizado	West Ham	0 - 0	Sheffield United
09 Ago 03	Finalizado	Preston North End	1 - 2	West Ham

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del West Ham Temporada 2003/2004

		Edad	Altura	Peso
Portero
	D. Forde	44	191	90	-	-	-
1	D. James	53	190	94	-	-	-
30	P. Srnícek	56	188	93	-	-	-
	R. Shaaban	48	193	93	-	-	-
32	Stephen Bywater	42	188	80	-	1	-
Defensa
15	A. Ferdinand	39	186	78	-	-	1
	A. Melville	55	185	79	-	-	1
7	Christian Dailly	50	183	77	3	-	4
19	Ian Pearce	49	190	89	1	-	2
24	J. Harley	44	177	73	1	-	3
	M. Kilgallon	40	188	81	-	-	-
20	Robbie Stockdale	44	180	71	1	-	1
3	Rufus Brevett	54	173	70	-	-	1
2	T. Repka	50	183	78	-	-	14
	Wayne Quinn	47	178	71	-	-	3
Centrocampista
14	C. Cohen	37	178	68	-	-	2
	D. Noble	42	183	78	-	-	-
4	Don Hutchison	52	188	76	3	-	3
17	Hayden Mullins	45	180	66	-	-	7
16	Kevin Horlock	51	183	76	1	-	7
6	M. Carrick	42	188	74	1	-	1
12	M. Etherington	42	178	64	5	1	4
20	N. Reo-Coker	39	175	78	6	-	9
	Niclas Alexandersson	52	188	73	-	-	-
	R. Garcia	42	180	76	-	-	-
5	Rob Lee	58	178	71	-	-	-
	S. Byrne	43	178	65	-	-	-
11	Steve Lomas	50	183	77	-	-	-
Delantero
	Adam Nowland	42	-	-	3	-	7
25	B. Zamora	43	185	73	5	-	2
	Brian Deane	56	190	89	6	-	2
8	David Connolly	46	175	68	10	1	8
9	J. Defoe	41	169	65	11	3	7
	Joel Mcanuff	42	180	72	6	-	4
10	M. Harewood	44	189	85	25	-	1
	Neil Mellor	41	183	83	2	-	-
	Sébastien Carole	41	-	-	-	-	-
	Youseff Sofiane	39	-	-	-	-	-

Noticias del West Ham

Ver últimas noticias

El Liverpool no pasó del empate ante el West Ham (2-2) en la jornada 35 de la Premier League. Michail Antonio le arrebató 2 puntos vitales al conjunto de Jürgen Klopp en la pelea por el título. Se le complica la gloria a los 'reds', pendientes de lo que hagan Arsenal y Manchester City.

Ni falta ni amarilla para este pisotón de Paquetá en la cara del árbitro

BeSoccer - Sábado, 27 Abril 2024

6 6.447

El Liverpool protestó en pleno por un duro pisotón de Lucas Paquetá sobre Alexis Mac Allister. La acción, sucedida a pocos minutos del inicio del duelo ante el West Ham United, no recibió sanción alguna ni fue revisada por el VAR.

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

BeSoccer - Sábado, 27 Abril 2024

0 888

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.

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

Ver más noticias del equipo»

Pos	Equipos	Pts
1		Norwich City	94
2		West Bromwich Albion	86
3		Sunderland	79
4		West Ham	74
5		Ipswich Town	73
6		Crystal Palace	73
7		Wigan Athletic	71
8		Sheffield United	71
9		Reading	70
10		Millwall	69
11		Stoke City	66
12		Coventry City	65
13		Cardiff City	65
14		Nottingham Forest	60
15		Preston North End	59
16		Watford	57
17		Rotherham United	54
18		Crewe Alexandra	53
19		Burnley	53
20		Derby County	52
21		Gillingham	51
22		Walsall	51
23		Bradford City	36
24		Wimbledon FC	29

Pos

Equipos

Pts

USO DE MEMORIA

6,506,880 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.6576
Total Execution Time	0.6594

CADENA URL

/West-Ham-United/2004

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0217	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 = 2004 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.0130	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.0127	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.0127	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.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 = 12884
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 = 23218
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2804 AND type_rel = 2
0.0159	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.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 (1312801,1312792,1312783,704,1158) ORDER BY n.cover_points DESC, update_date DESC
0.0146	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 = 2004 ORDER BY l.year DESC,cat.coefficient DESC
0.0161	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.0135	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 = 464 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150	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 = 23218 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0154	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 = 12884 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151	(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 calendars2004 as c ON c.league_id = l.id WHERE (c.datateam1 = 2804 or c.datateam2 = 2804) AND l.year = 2004 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0151	(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 calendars2004 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 = 2004 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0139	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2004 as c ON c.league_id = l.id INNER JOIN events2004 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 = 2004)
0.0147	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 (2003,2004,2005) ORDER BY l.id DESC, l.year DESC ;
0.0128	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 (23222,14434,464,44) 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.0162	SELECT count(id) as num_players from rel_players WHERE league_id = 44 AND teamId = 2804
0.0156	SELECT count(id) as num_players from rel_players WHERE league_id = 464 AND teamId = 2804
0.0163	SELECT count(id) as num_players from rel_players WHERE league_id = 14434 AND teamId = 2804
0.0132	SELECT count(id) as num_players from rel_players WHERE league_id = 23222 AND teamId = 2804
0.0133	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2004` 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 = 464 AND t.round = 46 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 events2004 e ON e.player_id = p.id AND e.league_id = 464 WHERE rp.league_id = 464 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.0142	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 events2004 e ON e.player_id = p.id AND e.league_id = 464 WHERE rp.league_id = 464 AND rp.teamId = 2804 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0142	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 events2004 e ON e.player_id = p.id AND e.league_id = 464 WHERE rp.league_id = 464 AND rp.teamId = 2804 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131	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 = 464 AND l.year= 2004 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0130	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=12391 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0125	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=12391
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 events2004 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=12391 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.0134	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 events2004 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=12391 and (e.action = 4 or e.action = 5) 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 events2004 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=12391 and (e.action = 3 or e.action = 4) 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 events2004 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=12391 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0137	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 events2004 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=12391 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

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 2003/2004

Noticias del West Ham

West Ham

Selecciona un equipo

Competiciones que juega

RIVALES EN Championship

RIVALES EN EFL Cup

RIVALES EN FA Cup