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 1990/1991
TEMPORADA 1990/1991
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Oldham Athletic AFC Oldham 46 83 53 88
2 West Ham West Ham 46 60 34 87
3 Sheffield Wednesday Sheffield 46 80 51 82
4 Notts County Notts County 46 76 55 80
5 Millwall Millwall 46 70 51 73
6 Brighton & Hove Albion Brighton 46 63 69 70
7 Middlesbrough Middlesbroug 46 66 47 69
8 Barnsley Barnsley 46 63 48 69
9 Bristol City Bristol City 46 68 71 67
10 Oxford United Oxford 46 69 66 61
11 Newcastle Newcastle 46 49 56 59
12 Wolves Wolves 46 63 63 58
13 Bristol Rovers Bristol 46 56 59 58
14 Ipswich Town Ipswich Town 46 60 68 57
15 Port Vale Port Vale 46 56 64 57
16 Charlton Athletic Charlton 46 57 61 56
17 Portsmouth Portsmouth 46 58 70 53
18 Plymouth Argyle Plymouth 46 54 68 53
19 Blackburn Rovers Blackburn 46 51 66 52
20 Watford Watford 46 45 59 51
21 Swindon Town Swindon Town 46 65 73 50
22 Leicester Leicester 46 60 83 50
23 West Bromwich Albion West 46 52 61 48
24 Hull City Hull City 46 57 85 45
TEMPORADA 1989/1990
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Leeds United Leeds United 46 79 52 85
2 Sheffield United Sheffield 46 78 58 85
3 Newcastle Newcastle 46 80 55 80
4 Swindon Town Swindon Town 46 79 59 74
5 Blackburn Rovers Blackburn 46 74 59 74
6 Sunderland Sunderland 46 70 64 74
7 West Ham West Ham 46 80 57 72
8 Oldham Athletic AFC Oldham 46 70 57 71
9 Ipswich Town Ipswich Town 46 67 66 69
10 Wolves Wolves 46 67 60 67
11 Port Vale Port Vale 46 62 57 61
12 Portsmouth Portsmouth 46 62 65 61
13 Leicester Leicester 46 67 79 59
14 Hull City Hull City 46 58 65 58
15 Watford Watford 46 58 60 57
16 Plymouth Argyle Plymouth 46 58 63 55
17 Oxford United Oxford 46 57 66 54
18 Brighton & Hove Albion Brighton 46 56 72 54
19 Barnsley Barnsley 46 49 71 54
20 West Bromwich Albion West 46 67 71 51
21 Middlesbrough Middlesbroug 46 52 63 50
22 AFC Bournemouth Bournemouth 46 57 76 48
23 Bradford City Bradford 46 44 68 41
24 Stoke City Stoke City 46 35 63 37
TEMPORADA 1988/1989
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Chelsea Chelsea 46 96 50 99
2 Manchester City Manchester 46 77 53 82
3 Crystal Palace Crystal 46 71 49 81
4 Watford Watford 46 74 48 78
5 Blackburn Rovers Blackburn 46 74 59 77
6 Swindon Town Swindon Town 46 68 53 76
7 Barnsley Barnsley 46 66 58 74
8 Ipswich Town Ipswich Town 46 71 61 73
9 West Bromwich Albion West 46 65 41 72
10 Leeds United Leeds United 46 59 50 67
11 Sunderland Sunderland 46 60 60 63
12 AFC Bournemouth Bournemouth 46 53 62 62
13 Stoke City Stoke City 46 57 72 59
14 Bradford City Bradford 46 52 59 56
15 Leicester Leicester 46 56 63 55
16 Oldham Athletic AFC Oldham 46 75 72 54
17 Oxford United Oxford 46 62 70 54
18 Plymouth Argyle Plymouth 46 55 66 54
19 Brighton & Hove Albion Brighton 46 57 66 51
20 Portsmouth Portsmouth 46 53 62 51
21 Hull City Hull City 46 52 68 47
22 Shrewsbury Town Shrewsbury 46 40 67 42
23 Birmingham City Birmingham 46 31 76 35
24 Walsall Walsall 46 41 80 31
TEMPORADA 1987/1988
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Millwall Millwall 42 70 48 79
2 Bradford City Bradford 42 72 50 77
3 Middlesbrough Middlesbroug 42 59 34 75
4 Aston Villa Aston Villa 42 67 41 74
5 Blackburn Rovers Blackburn 42 63 50 73
6 Crystal Palace Crystal 42 84 58 72
7 Leeds United Leeds United 42 60 51 65
8 Manchester City Manchester 42 76 56 62
9 Oldham Athletic AFC Oldham 42 70 63 62
10 Stoke City Stoke City 43 49 56 61
11 Ipswich Town Ipswich Town 42 57 50 60
12 Swindon Town Swindon Town 42 73 58 58
13 Barnsley Barnsley 42 59 57 56
14 Hull City Hull City 42 54 59 56
15 Plymouth Argyle Plymouth 42 63 65 53
16 Leicester Leicester 42 57 60 53
17 Birmingham City Birmingham 42 41 65 47
18 AFC Bournemouth Bournemouth 42 54 66 46
19 West Bromwich Albion West 42 46 63 46
20 Shrewsbury Town Shrewsbury 42 39 52 45
21 Sheffield United Sheffield 43 43 74 43
22 Reading Reading 42 43 69 40
23 Huddersfield Town Huddersfield 42 41 95 28
TEMPORADA 1986/1987
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Everton Everton 42 76 31 86
2 Liverpool Liverpool 42 72 42 77
3 Tottenham Hotspur Tottenham 42 68 43 71
4 Arsenal Arsenal 42 58 35 70
5 Norwich City Norwich City 42 53 51 68
6 Wimbledon FC Wimbledon 42 57 50 66
7 Luton Town Luton Town 42 47 45 66
8 Nottingham Forest Nottingham 42 64 51 65
9 Watford Watford 42 67 54 63
10 Coventry City Coventry 42 50 45 63
11 Manchester United Manchester 42 52 45 56
12 Southampton Southampton 42 69 68 52
13 Sheffield Wednesday Sheffield 42 58 59 52
14 Chelsea Chelsea 42 53 64 52
15 West Ham West Ham 42 52 67 52
16 Queens Park Rangers Queens Park 42 48 64 50
17 Newcastle Newcastle 42 47 65 47
18 Oxford United Oxford 42 44 69 46
19 Charlton Athletic Charlton 42 45 55 44
20 Leicester Leicester 42 54 76 42
21 Manchester City Manchester 42 36 57 39
22 Aston Villa Aston Villa 42 45 79 36
TEMPORADA 1985/1986
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Liverpool Liverpool 42 89 37 88
2 Everton Everton 42 87 41 86
3 West Ham West Ham 42 74 40 84
4 Manchester United Manchester 42 70 36 76
5 Sheffield Wednesday Sheffield 42 63 54 73
6 Chelsea Chelsea 42 57 56 71
7 Arsenal Arsenal 42 49 47 69
8 Nottingham Forest Nottingham 42 69 53 68
9 Luton Town Luton Town 42 61 44 66
10 Tottenham Hotspur Tottenham 42 74 52 65
11 Newcastle Newcastle 42 67 72 63
12 Watford Watford 42 69 62 59
13 Queens Park Rangers Queens Park 42 53 64 52
14 Southampton Southampton 42 51 62 46
15 Manchester City Manchester 42 43 57 45
16 Aston Villa Aston Villa 42 51 67 44
17 Coventry City Coventry 42 48 71 43
18 Oxford United Oxford 42 62 80 42
19 Leicester Leicester 42 54 76 42
20 Ipswich Town Ipswich Town 42 32 55 41
21 Birmingham City Birmingham 42 30 73 29
22 West Bromwich Albion West 42 35 89 24
TEMPORADA 1984/1985
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Everton Everton 42 88 43 90
2 Liverpool Liverpool 42 68 35 77
3 Tottenham Hotspur Tottenham 42 78 51 77
4 Manchester United Manchester 42 77 47 76
5 Southampton Southampton 42 56 47 68
6 Chelsea Chelsea 42 63 48 66
7 Arsenal Arsenal 42 61 49 66
8 Sheffield Wednesday Sheffield 42 58 45 65
9 Nottingham Forest Nottingham 42 56 48 64
10 Aston Villa Aston Villa 42 60 60 56
11 Watford Watford 42 81 71 55
12 West Bromwich Albion West 42 58 62 55
13 Luton Town Luton Town 42 57 61 54
14 Newcastle Newcastle 42 55 70 52
15 Leicester Leicester 42 65 73 51
16 West Ham West Ham 42 51 68 51
17 Ipswich Town Ipswich Town 42 46 57 50
18 Coventry City Coventry 42 47 64 50
19 Queens Park Rangers Queens Park 42 53 72 50
20 Norwich City Norwich City 42 46 64 49
21 Sunderland Sunderland 42 40 62 40
22 Stoke City Stoke City 42 24 91 17
TEMPORADA 1983/1984
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Liverpool Liverpool 42 73 32 80
2 Southampton Southampton 42 66 38 77
3 Nottingham Forest Nottingham 42 76 45 74
4 Manchester United Manchester 42 71 41 74
5 Queens Park Rangers Queens Park 42 67 37 73
6 Arsenal Arsenal 42 74 60 63
7 Everton Everton 42 44 42 62
8 Tottenham Hotspur Tottenham 42 64 65 61
9 West Ham West Ham 42 60 55 60
10 Aston Villa Aston Villa 42 59 61 60
11 Watford Watford 42 68 77 57
12 Ipswich Town Ipswich Town 42 55 57 53
13 Sunderland Sunderland 42 42 53 52
14 Norwich City Norwich City 42 48 49 51
15 Leicester Leicester 42 65 68 51
16 Luton Town Luton Town 42 53 66 51
17 West Bromwich Albion West 42 48 62 51
18 Stoke City Stoke City 42 44 63 50
19 Coventry City Coventry 42 57 77 50
20 Birmingham City Birmingham 42 39 50 48
21 Notts County Notts County 42 50 72 41
22 Wolves Wolves 42 27 80 29
TEMPORADA 1982/1983
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Queens Park Rangers Queens Park 42 77 36 85
2 Wolves Wolves 42 68 44 75
3 Leicester Leicester 42 72 44 70
4 Fulham Fulham 42 64 47 69
5 Newcastle Newcastle 42 75 53 67
6 Sheffield Wednesday Sheffield 42 60 47 63
7 Oldham Athletic AFC Oldham 42 64 47 61
8 Leeds United Leeds United 42 51 46 60
9 Shrewsbury Town Shrewsbury 42 48 48 59
10 Barnsley Barnsley 42 57 55 57
11 Blackburn Rovers Blackburn 42 58 58 57
12 Cambridge United Cambridge 42 42 60 51
13 Derby County Derby County 42 49 58 49
14 Carlisle United Carlisle 42 68 70 48
15 Crystal Palace Crystal 42 43 52 48
16 Middlesbrough Middlesbroug 42 46 67 48
17 Charlton Athletic Charlton 42 63 86 48
18 Chelsea Chelsea 42 51 61 47
19 Grimsby Town Grimsby Town 42 45 70 47
20 Rotherham United Rotherham 42 45 68 45
21 Burnley Burnley 42 56 66 44
22 Bolton Wanderers Bolton 42 42 61 44
TEMPORADA 1981/1982
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Luton Town Luton Town 42 86 46 88
2 Watford Watford 42 76 42 80
3 Norwich City Norwich City 42 64 50 71
4 Sheffield Wednesday Sheffield 42 55 51 70
5 Queens Park Rangers Queens Park 42 65 43 69
6 Barnsley Barnsley 42 59 41 67
7 Rotherham United Rotherham 42 66 54 67
8 Leicester Leicester 42 56 48 66
9 Newcastle Newcastle 42 52 50 62
10 Blackburn Rovers Blackburn 42 47 43 59
11 Oldham Athletic AFC Oldham 42 50 51 59
12 Chelsea Chelsea 42 60 60 57
13 Charlton Athletic Charlton 42 50 65 51
14 Cambridge United Cambridge 42 48 53 48
15 Crystal Palace Crystal 42 34 45 48
16 Derby County Derby County 42 53 68 48
17 Grimsby Town Grimsby Town 42 53 65 46
18 Shrewsbury Town Shrewsbury 42 37 57 46
19 Bolton Wanderers Bolton 42 39 61 46
20 Cardiff City Cardiff City 42 45 61 44
21 Wrexham AFC Wrexham AFC 42 40 56 44
22 Leyton Orient Leyton 42 36 61 39
TEMPORADA 1980/1981
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Aston Villa Aston Villa 42 72 40 60
2 Ipswich Town Ipswich Town 42 77 43 56
3 Arsenal Arsenal 42 61 45 53
4 West Bromwich Albion West 42 60 42 52
5 Liverpool Liverpool 42 62 42 51
6 Southampton Southampton 42 76 56 50
7 Nottingham Forest Nottingham 42 62 44 50
8 Manchester United Manchester 42 51 36 48
9 Leeds United Leeds United 42 39 47 44
10 Tottenham Hotspur Tottenham 42 70 68 43
11 Stoke City Stoke City 42 51 60 42
12 Manchester City Manchester 42 56 59 39
13 Birmingham City Birmingham 42 50 61 38
14 Middlesbrough Middlesbroug 42 53 61 37
15 Everton Everton 42 55 58 36
16 Coventry City Coventry 42 48 68 36
17 Sunderland Sunderland 42 52 53 35
18 Wolves Wolves 42 43 55 35
19 Brighton & Hove Albion Brighton 42 54 67 35
20 Norwich City Norwich City 42 49 73 33
21 Leicester Leicester 42 40 67 32
22 Crystal Palace Crystal 42 47 83 19
TEMPORADA 1979/1980
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Chelsea Chelsea 42 69 52 78
2 Leicester Leicester 42 58 38 76
3 Birmingham City Birmingham 42 58 38 74
4 Sunderland Sunderland 42 68 45 72
5 Queens Park Rangers Queens Park 42 75 53 67
6 West Ham West Ham 42 54 43 67
7 Luton Town Luton Town 42 66 45 65
8 Swansea City Swansea City 42 48 53 60
9 Shrewsbury Town Shrewsbury 42 60 53 59
10 Newcastle Newcastle 42 54 49 59
11 Oldham Athletic AFC Oldham 42 49 53 59
12 Cambridge United Cambridge 42 61 53 58
13 Cardiff City Cardiff City 42 41 48 56
14 Preston North End Preston 42 56 52 55
15 Wrexham AFC Wrexham AFC 42 40 50 54
16 Leyton Orient Leyton 42 48 54 53
17 Notts County Notts County 42 51 51 49
18 Watford Watford 42 39 46 49
19 Bristol Rovers Bristol 42 50 64 46
20 Fulham Fulham 42 42 74 40
21 Burnley Burnley 42 39 73 33
22 Charlton Athletic Charlton 42 39 78 28
TEMPORADA 1978/1979
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Brighton & Hove Albion Brighton 42 72 39 79
2 Sunderland Sunderland 42 70 44 77
3 Stoke City Stoke City 42 58 31 76
4 Crystal Palace Crystal 42 51 24 76
5 West Ham West Ham 42 70 39 68
6 Newcastle Newcastle 42 51 55 59
7 Notts County Notts County 42 48 60 58
8 Cardiff City Cardiff City 42 56 70 58
9 Leyton Orient Leyton 42 51 51 55
10 Fulham Fulham 42 50 47 54
11 Preston North End Preston 42 59 57 54
12 Burnley Burnley 42 51 62 54
13 Cambridge United Cambridge 42 44 52 52
14 Oldham Athletic AFC Oldham 42 52 61 52
15 Bristol Rovers Bristol 42 48 60 52
16 Wrexham AFC Wrexham AFC 42 45 42 50
17 Luton Town Luton Town 42 60 57 49
18 Leicester Leicester 42 43 52 47
19 Charlton Athletic Charlton 42 60 69 46
20 Sheffield United Sheffield 42 52 69 45
21 Millwall Millwall 42 42 61 43
22 Blackburn Rovers Blackburn 42 41 72 40
TEMPORADA 1977/1978
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Nottingham Forest Nottingham 42 69 24 64
2 Liverpool Liverpool 42 65 34 57
3 Everton Everton 42 76 45 55
4 Manchester City Manchester 42 74 51 52
5 Arsenal Arsenal 42 60 37 52
6 West Bromwich Albion West 42 62 53 50
7 Coventry City Coventry 42 75 62 48
8 Aston Villa Aston Villa 42 57 42 46
9 Leeds United Leeds United 42 63 53 46
10 Manchester United Manchester 42 67 63 42
11 Birmingham City Birmingham 42 55 60 41
12 Derby County Derby County 42 54 59 41
13 Norwich City Norwich City 42 52 66 40
14 Middlesbrough Middlesbroug 42 42 54 39
15 Wolves Wolves 42 51 64 36
16 Chelsea Chelsea 42 46 69 36
17 Bristol City Bristol City 42 49 53 35
18 Ipswich Town Ipswich Town 42 47 61 35
19 Queens Park Rangers Queens Park 42 47 64 33
20 West Ham West Ham 42 52 69 32
21 Newcastle Newcastle 42 42 78 22
22 Leicester Leicester 42 26 70 22
TEMPORADA 1976/1977
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Liverpool Liverpool 42 62 33 57
2 Manchester City Manchester 42 60 34 56
3 Ipswich Town Ipswich Town 42 66 39 52
4 Aston Villa Aston Villa 42 76 50 51
5 Newcastle Newcastle 42 64 49 49
6 Manchester United Manchester 42 71 62 47
7 West Bromwich Albion West 42 62 56 45
8 Arsenal Arsenal 42 64 59 43
9 Everton Everton 42 62 64 42
10 Leeds United Leeds United 42 48 51 42
11 Leicester Leicester 42 47 60 42
12 Middlesbrough Middlesbroug 42 40 45 41
13 Birmingham City Birmingham 42 63 61 38
14 Queens Park Rangers Queens Park 42 47 52 38
15 Derby County Derby County 42 50 55 37
16 Norwich City Norwich City 42 47 64 37
17 West Ham West Ham 42 46 65 36
18 Bristol City Bristol City 42 38 48 35
19 Coventry City Coventry 42 48 59 35
20 Sunderland Sunderland 42 46 54 34
21 Stoke City Stoke City 42 28 51 34
22 Tottenham Hotspur Tottenham 42 48 72 33
TEMPORADA 1975/1976
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Liverpool Liverpool 42 66 31 60
2 Queens Park Rangers Queens Park 42 67 33 59
3 Manchester United Manchester 42 68 42 56
4 Derby County Derby County 42 75 58 53
5 Leeds United Leeds United 42 65 46 51
6 Ipswich Town Ipswich Town 42 54 48 46
7 Leicester Leicester 42 48 51 45
8 Manchester City Manchester 42 64 46 43
9 Tottenham Hotspur Tottenham 42 63 63 43
10 Norwich City Norwich City 42 58 58 42
11 Everton Everton 42 60 66 42
12 Stoke City Stoke City 42 48 50 41
13 Middlesbrough Middlesbroug 42 46 45 40
14 Coventry City Coventry 42 47 57 40
15 Newcastle Newcastle 42 71 62 39
16 Aston Villa Aston Villa 42 51 59 39
17 Arsenal Arsenal 42 47 53 36
18 West Ham West Ham 42 48 71 36
19 Birmingham City Birmingham 42 57 75 33
20 Wolves Wolves 42 51 68 30
21 Burnley Burnley 42 43 66 28
22 Sheffield United Sheffield 42 33 82 22
TEMPORADA 1974/1975
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Derby County Derby County 42 67 49 53
2 Liverpool Liverpool 42 60 39 51
3 Ipswich Town Ipswich Town 42 66 44 51
4 Everton Everton 42 56 42 50
5 Stoke City Stoke City 42 64 48 49
6 Sheffield United Sheffield 42 58 51 49
7 Middlesbrough Middlesbroug 42 54 40 48
8 Manchester City Manchester 42 54 54 46
9 Leeds United Leeds United 42 57 49 45
10 Burnley Burnley 42 68 67 45
11 Queens Park Rangers Queens Park 42 54 54 42
12 Wolves Wolves 42 57 54 39
13 West Ham West Ham 42 58 59 39
14 Coventry City Coventry 42 51 62 39
15 Newcastle Newcastle 42 59 72 39
16 Arsenal Arsenal 42 47 49 37
17 Birmingham City Birmingham 42 53 61 37
18 Leicester Leicester 42 46 60 36
19 Tottenham Hotspur Tottenham 42 52 63 34
20 Luton Town Luton Town 42 47 65 33
21 Chelsea Chelsea 42 42 72 33
22 Carlisle United Carlisle 42 43 59 29
TEMPORADA 1973/1974
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Leeds United Leeds United 42 66 31 62
2 Liverpool Liverpool 42 52 31 57
3 Derby County Derby County 42 52 42 48
4 Ipswich Town Ipswich Town 42 67 58 47
5 Stoke City Stoke City 42 54 42 46
6 Burnley Burnley 42 56 53 46
7 Everton Everton 42 50 48 44
8 Queens Park Rangers Queens Park 42 56 52 43
9 Leicester Leicester 42 51 41 42
10 Arsenal Arsenal 42 49 51 42
11 Tottenham Hotspur Tottenham 42 45 50 42
12 Wolves Wolves 42 49 49 41
13 Sheffield United Sheffield 42 44 49 40
14 Manchester City Manchester 42 39 46 40
15 Newcastle Newcastle 42 49 48 38
16 Coventry City Coventry 42 43 54 38
17 Chelsea Chelsea 42 56 60 37
18 West Ham West Ham 42 55 60 37
19 Birmingham City Birmingham 42 52 64 37
20 Southampton Southampton 42 47 68 36
21 Manchester United Manchester 42 38 48 32
22 Norwich City Norwich City 42 37 62 29
TEMPORADA 1972/1973
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Liverpool Liverpool 42 72 42 60
2 Arsenal Arsenal 42 57 43 57
3 Leeds United Leeds United 42 71 45 53
4 Ipswich Town Ipswich Town 42 55 45 48
5 Wolves Wolves 42 66 54 47
6 West Ham West Ham 42 67 53 46
7 Derby County Derby County 42 56 54 46
8 Tottenham Hotspur Tottenham 42 58 48 45
9 Newcastle Newcastle 42 60 51 45
10 Birmingham City Birmingham 42 53 54 42
11 Manchester City Manchester 42 57 60 41
12 Chelsea Chelsea 42 49 51 40
13 Southampton Southampton 42 47 52 40
14 Sheffield United Sheffield 42 51 59 40
15 Stoke City Stoke City 42 61 56 38
16 Leicester Leicester 42 40 46 37
17 Everton Everton 42 41 49 37
18 Manchester United Manchester 42 44 60 37
19 Coventry City Coventry 42 40 55 35
20 Norwich City Norwich City 42 36 63 32
21 Crystal Palace Crystal 42 41 58 30
22 West Bromwich Albion West 42 38 62 28
TEMPORADA 1971/1972
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Derby County Derby County 42 69 33 58
2 Leeds United Leeds United 42 73 31 57
3 Liverpool Liverpool 42 64 30 57
4 Manchester City Manchester 42 77 45 57
5 Arsenal Arsenal 42 58 40 52
6 Tottenham Hotspur Tottenham 42 63 42 51
7 Chelsea Chelsea 42 58 49 48
8 Manchester United Manchester 42 69 61 48
9 Wolves Wolves 42 65 57 47
10 Sheffield United Sheffield 42 61 60 46
11 Newcastle Newcastle 42 49 52 41
12 Leicester Leicester 42 41 46 39
13 Ipswich Town Ipswich Town 42 39 53 38
14 West Ham West Ham 42 47 51 36
15 Everton Everton 42 37 48 36
16 West Bromwich Albion West 42 42 54 35
17 Stoke City Stoke City 42 39 56 35
18 Coventry City Coventry 42 44 67 33
19 Southampton Southampton 42 52 80 31
20 Crystal Palace Crystal 42 39 65 29
21 Nottingham Forest Nottingham 42 47 81 25
22 Huddersfield Town Huddersfield 42 27 59 25

  USO DE MEMORIA  
9,227,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2390
Total Execution Time  0.2409
  CADENA URL  
/historico/Leicester-City-Fc/1991
  GET DATOS  
$_GET['/historico/Leicester-City-Fc/1991']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (49)  
0.0060  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 = 1991 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.0020  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.0023  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 = 14681
0.0023  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 = 23236
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1538 AND type_rel = 2
0.0052  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.0023  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 (1312774,2482,3173,3443,4219) ORDER BY n.cover_points DESC, update_date DESC
0.0033  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 = 1991 ORDER BY l.year DESC,cat.coefficient DESC
0.0038  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 = 22825 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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 = 23236 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 14681 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0031  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 (1990,1991,1992) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (23238,22826,14682) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 22826 AND teamId = 1538
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 14682 AND teamId = 1538
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 23238 AND teamId = 1538
0.0045  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1991` 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 = 22825 AND t.round = 10 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0025  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '1538' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1538' and rp.type = 4
0.0021  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '1538' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1538' and rp.type = 4
0.0020  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 events1991 e ON e.player_id = p.id AND e.league_id = 22825 WHERE rp.league_id = 22825 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 events1991 e ON e.player_id = p.id AND e.league_id = 22825 WHERE rp.league_id = 22825 AND rp.teamId = 1538 AND (e.action = 4 or e.action = 5) 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 events1991 e ON e.player_id = p.id AND e.league_id = 22825 WHERE rp.league_id = 22825 AND rp.teamId = 1538 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0044  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 <= 1991 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0038  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 `tables1991` 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 = 22825 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 `tables1990` 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 = 22826 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 `tables1989` 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 = 22827 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables1988` 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 = 23278 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 `tables1987` 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 = 5697 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0067  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 `tables1986` 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 = 5696 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 `tables1985` 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 = 5695 AND t.round = 42 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 `tables1984` 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 = 5694 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables1983` 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 = 23216 AND t.round = 42 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 `tables1982` 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 = 23203 AND t.round = 42 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 `tables1981` 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 = 5691 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables1980` 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 = 23323 AND t.round = 42 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 `tables1979` 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 = 23322 AND t.round = 42 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 `tables1978` 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 = 5688 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 `tables1977` 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 = 5687 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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 `tables1976` 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 = 5686 AND t.round = 42 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 `tables1975` 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 = 5685 AND t.round = 42 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 `tables1974` 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 = 5684 AND t.round = 42 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 `tables1973` 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 = 5683 AND t.round = 42 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 `tables1972` 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 = 5682 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC