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 2003/2004
TEMPORADA 2003/2004
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Arsenal Arsenal 38 73 26 90
2 Chelsea Chelsea 38 67 30 79
3 Manchester United Manchester 38 64 35 75
4 Liverpool Liverpool 38 55 37 60
5 Newcastle Newcastle 38 52 40 56
6 Aston Villa Aston Villa 38 48 44 56
7 Charlton Athletic Charlton 38 51 51 53
8 Bolton Wanderers Bolton 38 48 56 53
9 Fulham Fulham 38 52 46 52
10 Birmingham City Birmingham 38 43 48 50
11 Middlesbrough Middlesbroug 38 44 52 48
12 Southampton Southampton 38 44 45 47
13 Portsmouth Portsmouth 38 47 54 45
14 Tottenham Hotspur Tottenham 38 47 57 45
15 Blackburn Rovers Blackburn 38 51 59 44
16 Manchester City Manchester 38 55 54 41
17 Everton Everton 38 45 57 39
18 Leicester Leicester 38 48 65 33
19 Leeds United Leeds United 38 40 79 33
20 Wolves Wolves 38 38 77 33
TEMPORADA 2002/2003
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Portsmouth Portsmouth 46 97 45 98
2 Leicester Leicester 46 73 40 92
3 Sheffield United Sheffield 46 72 52 80
4 Reading Reading 46 61 46 79
5 Wolves Wolves 46 81 44 76
6 Nottingham Forest Nottingham 46 82 50 74
7 Ipswich Town Ipswich Town 46 80 64 70
8 Norwich City Norwich City 46 59 50 67
9 Millwall Millwall 46 59 69 66
10 Wimbledon FC Wimbledon 46 76 73 65
11 Preston North End Preston 46 69 69 62
12 Gillingham Gillingham 46 56 65 62
13 Watford Watford 46 54 70 60
14 Crystal Palace Crystal 46 59 52 59
15 Rotherham United Rotherham 46 62 62 59
16 Burnley Burnley 46 65 89 55
17 Walsall Walsall 46 57 69 54
18 Derby County Derby County 46 55 74 52
19 Bradford City Bradford 46 51 73 52
20 Coventry City Coventry 46 46 62 50
21 Stoke City Stoke City 46 45 69 50
22 Sheffield Wednesday Sheffield 46 56 73 46
23 Brighton & Hove Albion Brighton 46 49 67 45
24 Grimsby Town Grimsby Town 46 48 85 39
TEMPORADA 2001/2002
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Arsenal Arsenal 38 79 36 87
2 Liverpool Liverpool 38 67 30 80
3 Manchester United Manchester 38 87 45 77
4 Newcastle Newcastle 38 74 52 71
5 Leeds United Leeds United 38 53 37 66
6 Chelsea Chelsea 38 66 38 64
7 West Ham West Ham 38 48 57 53
8 Aston Villa Aston Villa 38 46 47 50
9 Tottenham Hotspur Tottenham 38 49 53 50
10 Blackburn Rovers Blackburn 38 55 51 46
11 Southampton Southampton 38 46 54 45
12 Middlesbrough Middlesbroug 38 35 47 45
13 Fulham Fulham 38 36 44 44
14 Charlton Athletic Charlton 38 38 49 44
15 Everton Everton 38 45 57 43
16 Bolton Wanderers Bolton 38 44 62 40
17 Sunderland Sunderland 38 29 51 40
18 Ipswich Town Ipswich Town 38 41 64 36
19 Derby County Derby County 38 33 63 30
20 Leicester Leicester 38 30 64 28
TEMPORADA 2000/2001
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester United Manchester 38 79 31 80
2 Arsenal Arsenal 38 63 38 70
3 Liverpool Liverpool 38 71 39 69
4 Leeds United Leeds United 38 64 43 68
5 Ipswich Town Ipswich Town 38 57 42 66
6 Chelsea Chelsea 38 68 45 61
7 Sunderland Sunderland 38 46 41 57
8 Aston Villa Aston Villa 38 46 43 54
9 Charlton Athletic Charlton 38 50 57 52
10 Southampton Southampton 38 40 48 52
11 Newcastle Newcastle 38 44 50 51
12 Tottenham Hotspur Tottenham 38 47 54 49
13 Leicester Leicester 38 39 51 48
14 Middlesbrough Middlesbroug 38 44 44 42
15 West Ham West Ham 38 45 50 42
16 Everton Everton 38 45 59 42
17 Derby County Derby County 38 37 59 42
18 Manchester City Manchester 38 41 65 34
19 Coventry City Coventry 38 36 63 34
20 Bradford City Bradford 38 30 70 26
TEMPORADA 1999/2000
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester United Manchester 38 97 45 91
2 Arsenal Arsenal 38 73 43 73
3 Leeds United Leeds United 38 58 43 69
4 Liverpool Liverpool 38 51 30 67
5 Chelsea Chelsea 38 53 34 65
6 Aston Villa Aston Villa 38 46 35 58
7 Sunderland Sunderland 38 57 56 58
8 Leicester Leicester 38 55 55 55
9 West Ham West Ham 38 52 53 55
10 Tottenham Hotspur Tottenham 38 57 49 53
11 Newcastle Newcastle 38 63 54 52
12 Middlesbrough Middlesbroug 38 46 52 52
13 Everton Everton 38 59 49 50
14 Coventry City Coventry 38 47 54 44
15 Southampton Southampton 38 45 62 44
16 Derby County Derby County 38 44 57 38
17 Bradford City Bradford 38 38 68 36
18 Wimbledon FC Wimbledon 38 46 74 33
19 Sheffield Wednesday Sheffield 38 38 70 31
20 Watford Watford 38 35 77 24
TEMPORADA 1998/1999
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester United Manchester 38 80 37 79
2 Arsenal Arsenal 38 59 17 78
3 Chelsea Chelsea 38 57 30 75
4 Leeds United Leeds United 38 62 34 67
5 West Ham West Ham 38 46 53 57
6 Aston Villa Aston Villa 38 51 46 55
7 Liverpool Liverpool 38 68 49 54
8 Derby County Derby County 38 40 45 52
9 Middlesbrough Middlesbroug 38 48 54 51
10 Leicester Leicester 38 40 46 49
11 Tottenham Hotspur Tottenham 38 47 50 47
12 Sheffield Wednesday Sheffield 38 41 42 46
13 Newcastle Newcastle 38 48 54 46
14 Everton Everton 38 42 47 43
15 Coventry City Coventry 38 39 51 42
16 Wimbledon FC Wimbledon 38 40 63 42
17 Southampton Southampton 38 37 64 41
18 Charlton Athletic Charlton 38 41 56 36
19 Blackburn Rovers Blackburn 38 38 52 35
20 Nottingham Forest Nottingham 38 35 69 30
TEMPORADA 1997/1998
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Arsenal Arsenal 38 68 33 78
2 Manchester United Manchester 38 73 26 77
3 Liverpool Liverpool 38 68 42 65
4 Chelsea Chelsea 38 71 43 63
5 Leeds United Leeds United 38 57 46 59
6 Blackburn Rovers Blackburn 38 57 52 58
7 Aston Villa Aston Villa 38 49 48 57
8 West Ham West Ham 38 56 57 56
9 Derby County Derby County 38 52 49 55
10 Leicester Leicester 38 51 41 53
11 Coventry City Coventry 38 46 44 52
12 Southampton Southampton 38 50 55 48
13 Newcastle Newcastle 38 35 44 44
14 Tottenham Hotspur Tottenham 38 44 56 44
15 Wimbledon FC Wimbledon 38 34 46 44
16 Sheffield Wednesday Sheffield 38 52 67 44
17 Everton Everton 38 41 56 40
18 Bolton Wanderers Bolton 38 41 61 40
19 Barnsley Barnsley 38 37 82 35
20 Crystal Palace Crystal 38 37 71 33
TEMPORADA 1996/1997
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester United Manchester 38 76 44 75
2 Newcastle Newcastle 38 73 40 68
3 Arsenal Arsenal 38 62 32 68
4 Liverpool Liverpool 38 62 37 68
5 Aston Villa Aston Villa 38 47 34 61
6 Chelsea Chelsea 38 58 55 59
7 Sheffield Wednesday Sheffield 38 50 51 57
8 Wimbledon FC Wimbledon 38 49 46 56
9 Leicester Leicester 38 46 54 47
10 Tottenham Hotspur Tottenham 38 44 51 46
11 Leeds United Leeds United 38 28 38 46
12 Derby County Derby County 38 45 58 46
13 Blackburn Rovers Blackburn 38 42 43 42
14 West Ham West Ham 38 39 48 42
15 Everton Everton 38 44 57 42
16 Southampton Southampton 38 50 56 41
17 Coventry City Coventry 38 38 54 41
18 Sunderland Sunderland 38 35 53 40
19 Middlesbrough Middlesbroug 38 51 60 39
20 Nottingham Forest Nottingham 38 31 59 34
TEMPORADA 1995/1996
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Sunderland Sunderland 46 59 33 83
2 Derby County Derby County 46 71 51 79
3 Crystal Palace Crystal 46 67 48 75
4 Stoke City Stoke City 46 60 49 73
5 Charlton Athletic Charlton 46 57 45 71
6 Leicester Leicester 46 66 60 71
7 Ipswich Town Ipswich Town 46 79 69 69
8 Huddersfield Town Huddersfield 46 61 58 63
9 Sheffield United Sheffield 46 57 54 62
10 Barnsley Barnsley 46 60 66 60
11 Port Vale Port Vale 46 59 66 60
12 West Bromwich Albion West 46 60 68 60
13 Tranmere Rovers Tranmere 46 64 60 59
14 Southend United Southend 46 52 61 59
15 Birmingham City Birmingham 46 61 64 58
16 Norwich City Norwich City 46 59 55 57
17 Oldham Athletic AFC Oldham 46 54 50 56
18 Reading Reading 46 54 63 56
19 Grimsby Town Grimsby Town 46 55 69 56
20 Wolves Wolves 46 56 62 55
21 Portsmouth Portsmouth 46 61 69 52
22 Millwall Millwall 46 43 63 52
23 Watford Watford 46 62 70 48
24 Luton Town Luton Town 46 40 64 45
TEMPORADA 1994/1995
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Blackburn Rovers Blackburn 42 80 39 89
2 Manchester United Manchester 42 77 28 88
3 Nottingham Forest Nottingham 42 72 43 77
4 Liverpool Liverpool 42 65 37 74
5 Leeds United Leeds United 42 59 38 73
6 Newcastle Newcastle 42 67 47 72
7 Tottenham Hotspur Tottenham 42 66 58 62
8 Queens Park Rangers Queens Park 42 61 59 60
9 Wimbledon FC Wimbledon 42 48 65 56
10 Southampton Southampton 42 61 63 54
11 Chelsea Chelsea 42 50 55 54
12 Arsenal Arsenal 42 52 49 51
13 Sheffield Wednesday Sheffield 42 49 57 51
14 West Ham West Ham 42 44 48 50
15 Everton Everton 42 44 51 50
16 Coventry City Coventry 42 44 62 50
17 Manchester City Manchester 42 53 64 49
18 Aston Villa Aston Villa 42 51 56 48
19 Crystal Palace Crystal 42 34 49 45
20 Norwich City Norwich City 42 37 54 43
21 Leicester Leicester 42 45 80 29
22 Ipswich Town Ipswich Town 42 36 93 27
TEMPORADA 1993/1994
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Crystal Palace Crystal 46 73 46 90
2 Nottingham Forest Nottingham 46 74 49 83
3 Millwall Millwall 46 58 49 74
4 Leicester Leicester 46 72 59 73
5 Tranmere Rovers Tranmere 46 69 53 72
6 Derby County Derby County 46 73 68 71
7 Wolves Wolves 46 60 47 68
8 Notts County Notts County 46 65 69 68
9 Middlesbrough Middlesbroug 46 66 54 67
10 Stoke City Stoke City 46 57 59 67
11 Charlton Athletic Charlton 46 61 58 65
12 Sunderland Sunderland 46 54 57 65
13 Bristol City Bristol City 46 47 50 64
14 Grimsby Town Grimsby Town 46 52 47 59
15 Bolton Wanderers Bolton 46 63 64 59
16 Southend United Southend 46 63 67 59
17 Portsmouth Portsmouth 46 52 58 58
18 Barnsley Barnsley 46 55 67 55
19 Watford Watford 46 66 80 54
20 Luton Town Luton Town 46 56 60 53
21 West Bromwich Albion West 46 60 69 51
22 Birmingham City Birmingham 46 52 69 51
23 Oxford United Oxford 46 54 75 49
24 Peterborough United Peterborough 46 48 76 37
TEMPORADA 1992/1993
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Newcastle Newcastle 46 92 38 96
2 West Ham West Ham 46 81 41 88
3 Portsmouth Portsmouth 46 80 46 88
4 Tranmere Rovers Tranmere 46 72 56 79
5 Swindon Town Swindon Town 46 74 59 76
6 Leicester Leicester 46 71 64 76
7 Millwall Millwall 46 65 53 70
8 Derby County Derby County 46 68 57 66
9 Grimsby Town Grimsby Town 46 58 57 64
10 Peterborough United Peterborough 46 55 63 62
11 Charlton Athletic Charlton 46 49 46 61
12 Wolves Wolves 46 57 56 61
13 Barnsley Barnsley 46 56 60 60
14 Oxford United Oxford 46 53 56 56
15 Bristol City Bristol City 46 49 67 56
16 Watford Watford 46 57 71 55
17 Southend United Southend 46 54 64 52
18 Notts County Notts County 46 55 70 52
19 Luton Town Luton Town 46 48 62 51
20 Birmingham City Birmingham 46 50 72 51
21 Sunderland Sunderland 46 50 64 50
22 Brentford Brentford 46 52 71 49
23 Cambridge United Cambridge 46 48 69 49
24 Bristol Rovers Bristol 46 55 87 41
TEMPORADA 1991/1992
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Ipswich Town Ipswich Town 46 70 50 84
2 Middlesbrough Middlesbroug 46 58 41 80
3 Derby County Derby County 46 69 51 78
4 Leicester Leicester 46 62 55 77
5 Cambridge United Cambridge 46 65 47 74
6 Blackburn Rovers Blackburn 46 70 53 74
7 Charlton Athletic Charlton 46 54 48 71
8 Swindon Town Swindon Town 46 69 55 69
9 Portsmouth Portsmouth 46 65 51 69
10 Watford Watford 46 51 48 65
11 Wolves Wolves 46 61 53 64
12 Southend United Southend 46 63 63 62
13 Bristol Rovers Bristol 46 60 63 62
14 Tranmere Rovers Tranmere 46 56 56 61
15 Millwall Millwall 46 64 71 61
16 Barnsley Barnsley 46 45 57 59
17 Bristol City Bristol City 46 55 71 54
18 Sunderland Sunderland 46 61 65 53
19 Grimsby Town Grimsby Town 46 47 62 53
20 Newcastle Newcastle 46 66 84 52
21 Oxford United Oxford 46 66 73 50
22 Plymouth Argyle Plymouth 46 42 64 48
23 Brighton & Hove Albion Brighton 46 56 77 47
24 Port Vale Port Vale 46 42 59 45
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

  USO DE MEMORIA  
9,223,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6780
Total Execution Time  0.6793
  CADENA URL  
/historico/Leicester-City-Fc/2004
  GET DATOS  
$_GET['/historico/Leicester-City-Fc/2004']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0252  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 = 45
0.0131  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 = 12884
0.0130  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 = 23218
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1538 AND type_rel = 2
0.0162  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.0130  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 (2482,3173,3443,4219,4724) ORDER BY n.cover_points DESC, update_date DESC
0.0149  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.0129  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 = 23218 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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 = 12884 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 45 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0140  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 (2003,2004,2005) 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 (23222,14434,465,45) 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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 45 AND teamId = 1538
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 465 AND teamId = 1538
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 14434 AND teamId = 1538
0.0142  SELECT count(id) as num_players from rel_players WHERE league_id = 23222 AND teamId = 1538
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 FROM `tables2004` 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 = 45 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0138  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 events2004 e ON e.player_id = p.id AND e.league_id = 45 WHERE rp.league_id = 45 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.0136  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 events2004 e ON e.player_id = p.id AND e.league_id = 45 WHERE rp.league_id = 45 AND rp.teamId = 1538 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 events2004 e ON e.player_id = p.id AND e.league_id = 45 WHERE rp.league_id = 45 AND rp.teamId = 1538 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140  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 <= 2004 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130  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 `tables2004` 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 = 45 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2003` 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 = 465 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2002` 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 = 43 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2001` 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 = 330 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2000` 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 = 331 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables1999` 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 = 332 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables1998` 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 = 333 AND t.round = 38 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 `tables1997` 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 = 334 AND t.round = 38 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 `tables1996` 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 = 473 AND t.round = 46 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 `tables1995` 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 = 336 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 `tables1994` 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 = 475 AND t.round = 10 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 `tables1993` 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 = 22823 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables1992` 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 = 22824 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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.0152  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.0158  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.0139  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.0137  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