4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Partidos del West Ham

Ir al LIVESCORE
Championship Championship »
01 May 20  Finalizado West Ham West Ham
3 - 0
 Stockport County Stockport County 0
26 Abr 20  Finalizado Stockport County Stockport County
1 - 0
 West Ham West Ham 0
24 Abr 20  Finalizado West Ham West Ham
2 - 1
 Hull City Hull City 0
17 Abr 20  Finalizado Hull City Hull City
1 - 1
 West Ham West Ham 0
10 Abr 20  Finalizado West Ham West Ham
4 - 0
 Wolves Wolves 0
05 Abr 20  Finalizado Nottingham Forest Nottingham Forest
2 - 1
 West Ham West Ham 0
03 Abr 20  Finalizado Wolves Wolves
1 - 1
 West Ham West Ham 0
02 Abr 20  Finalizado West Ham West Ham
5 - 1
 Nottingham Forest Nottingham Forest 0
27 Mar 20  Finalizado West Ham West Ham
1 - 0
 South Shields South Shields 0
22 Mar 20  Finalizado Tottenham Hotspur Tottenham Hotspur
2 - 0
 West Ham West Ham 0
20 Mar 20  Finalizado South Shields South Shields
3 - 0
 West Ham West Ham 0
13 Mar 20  Finalizado West Ham West Ham
2 - 1
 Tottenham Hotspur Tottenham Hotspur 0
04 Mar 20  Finalizado West Ham West Ham
0 - 1
 Leyton Orient Leyton Orient 0
28 Feb 20  Finalizado Leyton Orient Leyton Orient
1 - 0
 West Ham West Ham 0
14 Feb 20  Finalizado Port Vale Port Vale
1 - 0
 West Ham West Ham 0
11 Feb 20  Finalizado Bury Bury
1 - 0
 West Ham West Ham 0
07 Feb 20  Finalizado West Ham West Ham
3 - 1
 Port Vale Port Vale 0
24 Ene 20  Finalizado West Ham West Ham
1 - 0
 Bury Bury 0
17 Ene 20  Finalizado West Ham West Ham
1 - 0
 Blackpool Blackpool 0
03 Ene 20  Finalizado Blackpool Blackpool
0 - 0
 West Ham West Ham 0
27 Dic 19  Finalizado West Ham West Ham
1 - 1
 Huddersfield Town Huddersfield Town 0
26 Dic 19  Finalizado Bristol City Bristol City
0 - 0
 West Ham West Ham 0
25 Dic 19  Finalizado West Ham West Ham
2 - 0
 Bristol City Bristol City 0
20 Dic 19  Finalizado Huddersfield Town Huddersfield Town
2 - 0
 West Ham West Ham 0
13 Dic 19  Finalizado West Ham West Ham
2 - 0
 Coventry City Coventry City 0
06 Dic 19  Finalizado Coventry City Coventry City
0 - 0
 West Ham West Ham 0
29 Nov 19  Finalizado West Ham West Ham
0 - 1
 Fulham Fulham 0
22 Nov 19  Finalizado Fulham Fulham
1 - 2
 West Ham West Ham 0
15 Nov 19  Finalizado West Ham West Ham
1 - 0
 Leicester Leicester 0
08 Nov 19  Finalizado Leicester Leicester
0 - 0
 West Ham West Ham 0
01 Nov 19  Finalizado West Ham West Ham
1 - 2
 Birmingham City Birmingham City 0
25 Oct 19  Finalizado Birmingham City Birmingham City
0 - 1
 West Ham West Ham 0
18 Oct 19  Finalizado West Ham West Ham
1 - 0
 Grimsby Town Grimsby Town 0
11 Oct 19  Finalizado Grimsby Town Grimsby Town
0 - 1
 West Ham West Ham 0
04 Oct 19  Finalizado West Ham West Ham
1 - 1
 Stoke City Stoke City 0
27 Sep 19  Finalizado Stoke City Stoke City
2 - 1
 West Ham West Ham 0
20 Sep 19  Finalizado West Ham West Ham
2 - 1
 Rotherham United Rotherham United 0
13 Sep 19  Finalizado Rotherham United Rotherham United
0 - 1
 West Ham West Ham 0
08 Sep 19  Finalizado West Ham West Ham
0 - 2
 Barnsley Barnsley 0
06 Sep 19  Finalizado Lincoln City Lincoln City
1 - 4
 West Ham West Ham 0
01 Sep 19  Finalizado Barnsley Barnsley
7 - 0
 West Ham West Ham 0
30 Ago 19  Finalizado West Ham West Ham
1 - 1
 Lincoln City Lincoln City 0

  USO DE MEMORIA  
5,149,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0610
Total Execution Time  0.0623
  CADENA URL  
/partidos/West-Ham-United/1920
  GET DATOS  
$_GET['/partidos/West-Ham-United/1920']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0053  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.0033  (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 calendars1920 as c ON c.league_id = l.id WHERE (c.datateam1 = 2804 or c.datateam2 = 2804) AND l.year = 1920 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0042  (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 calendars1920 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 = 1920 GROUP BY c.id) ORDER BY shedule DESC LIMIT 365
0.0022  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1920 as c ON c.league_id = l.id INNER JOIN events1920 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 = 1920)
0.0043  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 (1919,1920,1921) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (23327) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 23327 AND teamId = 2804
0.0019  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 = 23326 AND l.year= 1920 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1