4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1921/1922
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Nottingham Forest Nottingham 42 51 30 78
2 Barnsley Barnsley 42 67 52 74
3 Stoke City Stoke City 42 60 44 70
4 West Ham West Ham 42 52 39 68
5 Hull City Hull City 42 51 41 67
6 Fulham Fulham 42 57 38 63
7 South Shields South 42 43 38 63
8 Leeds United Leeds United 42 48 38 61
9 Leicester Leicester 42 39 34 59
10 Sheffield Wednesday Sheffield 42 47 50 59
11 Bury Bury 42 54 55 55
12 Derby County Derby County 42 60 64 54
13 Leyton Orient Leyton 42 43 50 54
14 Rotherham United Rotherham 42 32 43 53
15 Crystal Palace Crystal 42 45 51 52
16 Notts County Notts County 42 47 51 51
17 Wolves Wolves 42 44 49 50
18 Blackpool Blackpool 42 44 57 50
19 Port Vale Port Vale 42 43 57 50
20 Coventry City Coventry 42 51 60 46
21 Bradford Park Avenue Bradford 42 46 62 45
22 Bristol City Bristol City 42 37 58 45
TEMPORADA 1920/1921
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Birmingham City Birmingham 42 79 38 82
2 Cardiff City Cardiff City 42 59 32 82
3 Bristol City Bristol City 42 49 29 70
4 Blackpool Blackpool 42 54 42 70
5 West Ham West Ham 42 51 30 67
6 Notts County Notts County 42 55 40 65
7 South Shields South 42 61 46 61
8 Leyton Orient Leyton 42 43 42 61
9 Fulham Fulham 42 43 47 58
10 Sheffield Wednesday Sheffield 42 48 48 56
11 Bury Bury 42 45 49 55
12 Wolves Wolves 42 49 66 54
13 Leeds United Leeds United 42 40 45 52
14 Leicester Leicester 42 39 46 52
15 Hull City Hull City 42 43 53 50
16 Nottingham Forest Nottingham 42 48 55 48
17 Rotherham United Rotherham 42 37 53 48
18 Port Vale Port Vale 42 43 49 47
19 Stoke City Stoke City 42 46 56 47
20 Coventry City Coventry 42 39 70 47
21 Barnsley Barnsley 42 48 50 46
22 Stockport County Stockport 42 42 75 39
TEMPORADA 1919/1920
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Tottenham Hotspur Tottenham 42 102 32 102
2 Huddersfield Town Huddersfield 42 97 38 92
3 Birmingham City Birmingham 42 85 34 80
4 Blackpool Blackpool 42 65 47 73
5 Bury Bury 42 60 44 68
6 Fulham Fulham 42 61 50 66
7 West Ham West Ham 42 47 40 66
8 Hull City Hull City 42 78 72 60
9 Stoke City Stoke City 42 60 54 60
10 South Shields South 42 58 48 57
11 Bristol City Bristol City 42 46 43 56
12 Barnsley Barnsley 42 61 55 55
13 Leicester Leicester 42 41 61 55
14 Leyton Orient Leyton 42 51 59 54
15 Stockport County Stockport 42 52 61 51
16 Rotherham United Rotherham 42 51 83 47
17 Port Vale Port Vale 34 42 52 42
18 Nottingham Forest Nottingham 42 43 73 42
19 Wolves Wolves 42 55 80 40
20 Coventry City Coventry 42 35 73 38
21 Lincoln City Lincoln City 42 44 101 36
22 Grimsby Town Grimsby Town 42 34 75 35
23 Leeds City Leeds City 8 17 10 14

  USO DE MEMORIA  
5,458,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4021
Total Execution Time  0.4033
  CADENA URL  
/historico/West-Ham-United/1922
  GET DATOS  
$_GET['/historico/West-Ham-United/1922']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0148  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 = 1922 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.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.0254  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 = 23328
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2804 AND type_rel = 2
0.0157  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 (540,704,1158,1370,1442) ORDER BY n.cover_points DESC, update_date DESC
0.0132  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 = 1922 ORDER BY l.year DESC,cat.coefficient DESC
0.0142  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.0126  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 = 23328 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0139  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 (1921,1922,1923) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (23329,15308) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 23329 AND teamId = 2804
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 15308 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 `tables1922` 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 = 23328 AND t.round = 42 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 events1922 e ON e.player_id = p.id AND e.league_id = 23328 WHERE rp.league_id = 23328 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.0126  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 events1922 e ON e.player_id = p.id AND e.league_id = 23328 WHERE rp.league_id = 23328 AND rp.teamId = 2804 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 events1922 e ON e.player_id = p.id AND e.league_id = 23328 WHERE rp.league_id = 23328 AND rp.teamId = 2804 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 2804 AND l.year <= 1922 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1922` 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 = 23328 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1921` 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 = 23327 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables1920` 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 = 23326 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC