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

Leicester

Entrenador: Enzo Maresca

Temporada 1899/1900
TEMPORADA 1899/1900
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Sheffield Wednesday Sheffield 34 84 22 79
2 Bolton Wanderers Bolton 34 79 25 74
3 Birmingham City Birmingham 34 78 38 66
4 Manchester United Manchester 34 63 27 64
5 Leicester Leicester 34 53 36 60
6 Grimsby Town Grimsby Town 34 67 46 57
7 Chesterfield Chesterfield 34 65 60 54
8 Arsenal Arsenal 34 61 43 52
9 Lincoln City Lincoln City 34 46 43 50
10 New Brighton Tower Brighton 34 66 58 48
11 Port Vale Port Vale 34 39 49 48
12 Walsall Walsall 34 50 55 44
13 Gainsborough Trinity Gainsborough 34 47 75 34
14 Burton Swifts Burton 34 43 84 33
15 Middlesbrough Middlesbroug 34 39 69 32
16 Barnsley Barnsley 34 46 79 31
17 Luton Town Luton Town 34 40 75 23
18 Loughborough Loughborough 34 18 100 9
TEMPORADA 1898/1899
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Manchester City Manchester 34 92 35 75
2 Glossop Glossop 34 76 38 66
3 Leicester Leicester 34 64 42 63
4 Manchester United Manchester 34 67 43 62
5 New Brighton Tower Brighton 34 71 52 61
6 Arsenal Arsenal 34 72 41 59
7 Birmingham City Birmingham 34 85 50 58
8 Walsall Walsall 34 79 36 57
9 Port Vale Port Vale 34 56 34 56
10 Grimsby Town Grimsby Town 34 71 60 50
11 Barnsley Barnsley 34 52 56 43
12 Lincoln City Lincoln City 34 51 56 43
13 Burton Swifts Burton 34 51 70 38
14 Gainsborough Trinity Gainsborough 34 56 72 35
15 Luton Town Luton Town 34 51 95 33
16 Blackpool Blackpool 34 49 90 28
17 Loughborough Loughborough 34 38 92 24
18 Darwen FC Darwen FC 34 22 141 11
TEMPORADA 1897/1898
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Burnley Burnley 30 80 24 68
2 Newcastle Newcastle 30 64 32 66
3 Manchester City Manchester 30 66 36 54
4 Manchester United Manchester 30 64 35 54
5 Arsenal Arsenal 30 69 49 53
6 Birmingham City Birmingham 30 58 50 52
7 Leicester Leicester 30 46 35 46
8 Luton Town Luton Town 30 68 50 43
9 Gainsborough Trinity Gainsborough 30 50 54 42
10 Walsall Walsall 30 58 58 41
11 Blackpool Blackpool 30 49 61 35
12 Grimsby Town Grimsby Town 30 52 62 34
13 Burton Swifts Burton 30 38 69 29
14 Lincoln City Lincoln City 30 43 82 23
15 Darwen FC Darwen FC 30 31 76 20
16 Loughborough Loughborough 30 24 87 20
TEMPORADA 1896/1897
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Notts County Notts County 30 92 43 61
2 Manchester United Manchester 30 56 34 56
3 Grimsby Town Grimsby Town 30 66 45 55
4 Birmingham City Birmingham 30 69 47 53
5 Newcastle Newcastle 30 56 52 52
6 Manchester City Manchester 30 58 50 44
7 Blackpool Blackpool 30 59 56 44
8 Leicester Leicester 30 59 56 43
9 Gainsborough Trinity Gainsborough 30 50 47 43
10 Arsenal Arsenal 30 68 70 43
11 Darwen FC Darwen FC 30 67 61 42
12 Loughborough Loughborough 30 50 64 37
13 Burton Swifts Burton 30 46 59 35
14 Walsall Walsall 30 53 71 35
15 Burton Wanderers Burton 30 31 67 29
16 Lincoln City Lincoln City 30 27 85 17
TEMPORADA 1895/1896
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Liverpool Liverpool 30 106 32 68
2 Manchester City Manchester 30 63 38 67
3 Grimsby Town Grimsby Town 30 82 38 62
4 Burton Wanderers Burton 30 69 40 61
5 Newcastle Newcastle 30 73 50 50
6 Manchester United Manchester 30 66 57 48
7 Arsenal Arsenal 30 59 42 46
8 Leicester Leicester 30 57 44 46
9 Darwen FC Darwen FC 30 72 67 42
10 Notts County Notts County 30 57 54 38
11 Burton Swifts Burton 30 39 69 34
12 Loughborough Loughborough 30 40 67 32
13 Lincoln City Lincoln City 30 53 75 31
14 Port Vale Port Vale 30 43 78 25
15 Rotherham Town Rotherham 30 34 97 24
16 Crewe Alexandra Crewe 30 30 95 18
TEMPORADA 1894/1895
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Bury Bury 30 78 33 71
2 Notts County Notts County 30 75 45 56
3 Grimsby Town Grimsby Town 30 79 52 55
4 Manchester United Manchester 30 78 44 53
5 Leicester Leicester 30 72 53 53
6 Darwen FC Darwen FC 30 74 43 52
7 Burton Wanderers Burton 30 67 39 49
8 Arsenal Arsenal 30 75 58 48
9 Manchester City Manchester 30 82 72 45
10 Newcastle Newcastle 30 72 84 39
11 Burton Swifts Burton 30 52 74 36
12 Rotherham Town Rotherham 30 55 62 35
13 Lincoln City Lincoln City 30 52 92 30
14 Walsall Walsall 30 47 92 30
15 Port Vale Port Vale 30 39 77 25
16 Crewe Alexandra Crewe 30 26 103 13

  USO DE MEMORIA  
5,664,784 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4320
Total Execution Time  0.4332
  CADENA URL  
/historico/Leicester-City-Fc/1900
  GET DATOS  
$_GET['/historico/Leicester-City-Fc/1900']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0133  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 = 'Leicester-City-Fc' AND l.year = 1900 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.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=1538 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=1538 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255  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 = 25395
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1538 AND type_rel = 2
0.0180  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1538 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (1313208,1312774,2482,3173,3443) ORDER BY n.cover_points DESC, update_date DESC
0.0127  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 = '1538' AND l.year = 1900 ORDER BY l.year DESC,cat.coefficient DESC
0.0146  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 = '1538' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = 25395 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  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=1538 AND l.year in (1899,1900,1901) 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 (25396) 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.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 25396 AND teamId = 1538
0.0145  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1900` 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 = 25395 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0133  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 events1900 e ON e.player_id = p.id AND e.league_id = 25395 WHERE rp.league_id = 25395 AND rp.teamId = 1538 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.0128  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 events1900 e ON e.player_id = p.id AND e.league_id = 25395 WHERE rp.league_id = 25395 AND rp.teamId = 1538 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 events1900 e ON e.player_id = p.id AND e.league_id = 25395 WHERE rp.league_id = 25395 AND rp.teamId = 1538 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137  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 = 1538 AND l.year <= 1900 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,team.teamId FROM `tables1900` 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 = 25395 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 `tables1899` 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 = 25394 AND t.round = 34 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 `tables1898` 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 = 25393 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 `tables1897` 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 = 25391 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables1896` 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 = 25390 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables1895` 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 = 25387 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC