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 1898/1899
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,514,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0843
Total Execution Time  0.0855
  CADENA URL  
/historico/Leicester-City-Fc/1899
  GET DATOS  
$_GET['/historico/Leicester-City-Fc/1899']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0029  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 = 1899 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=1538 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=1538 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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 = 25394
0.0021  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 = 1899 ORDER BY l.year DESC,cat.coefficient DESC
0.0039  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.0019  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 = 25394 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0032  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 (1898,1899,1900) 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 (25395) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 25395 AND teamId = 1538
0.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 events1899 e ON e.player_id = p.id AND e.league_id = 25394 WHERE rp.league_id = 25394 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.0019  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 events1899 e ON e.player_id = p.id AND e.league_id = 25394 WHERE rp.league_id = 25394 AND rp.teamId = 1538 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 events1899 e ON e.player_id = p.id AND e.league_id = 25394 WHERE rp.league_id = 25394 AND rp.teamId = 1538 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 <= 1899 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,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.0025  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.0026  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.0025  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.0028  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
0.0021  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 = 25394 ORDER BY nameShow LIMIT 100
0.0019  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 25 AND l.year = 1899 ORDER BY l.group_code ASC