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 1970/1971
TEMPORADA 1970/1971
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Leicester Leicester 42 57 30 82
2 Sheffield United Sheffield 42 73 39 77
3 Cardiff City Cardiff City 42 64 41 73
4 Carlisle United Carlisle 42 65 43 73
5 Hull City Hull City 42 54 41 70
6 Luton Town Luton Town 42 62 43 67
7 Millwall Millwall 42 59 42 66
8 Middlesbrough Middlesbroug 42 60 43 65
9 Birmingham City Birmingham 42 58 48 63
10 Queens Park Rangers Queens Park 42 58 53 59
11 Norwich City Norwich City 42 54 52 59
12 Swindon Town Swindon Town 42 61 51 57
13 Sunderland Sunderland 42 52 54 57
14 Oxford United Oxford 42 41 48 56
15 Sheffield Wednesday Sheffield 42 51 69 48
16 Portsmouth Portsmouth 42 46 61 44
17 Watford Watford 42 38 60 43
18 Leyton Orient Leyton 42 29 51 43
19 Bristol City Bristol City 42 46 64 41
20 Charlton Athletic Charlton 42 41 65 38
21 Blackburn Rovers Blackburn 42 37 69 33
22 Bolton Wanderers Bolton 42 35 74 31
TEMPORADA 1969/1970
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Huddersfield Town Huddersfield 42 68 37 84
2 Blackpool Blackpool 42 56 45 73
3 Sheffield United Sheffield 42 73 38 71
4 Leicester Leicester 42 64 50 70
5 Middlesbrough Middlesbroug 42 55 45 70
6 Cardiff City Cardiff City 42 61 41 67
7 Swindon Town Swindon Town 42 57 47 67
8 Blackburn Rovers Blackburn 42 54 50 67
9 Queens Park Rangers Queens Park 42 66 57 62
10 Norwich City Norwich City 42 49 46 59
11 Millwall Millwall 42 56 56 59
12 Hull City Hull City 42 72 70 56
13 Carlisle United Carlisle 42 58 56 55
14 Bristol City Bristol City 42 54 50 52
15 Oxford United Oxford 42 35 42 51
16 Bolton Wanderers Bolton 42 54 61 48
17 Portsmouth Portsmouth 42 66 80 48
18 Birmingham City Birmingham 42 51 78 44
19 Watford Watford 42 44 57 40
20 Charlton Athletic Charlton 42 35 76 38
21 Aston Villa Aston Villa 42 36 62 37
22 Preston North End Preston 42 43 63 36
TEMPORADA 1968/1969
PREMIER LEAGUE
Equipo PJ GF GC Puntos
TEMPORADA 1967/1968
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester City Manchester 42 86 43 58
2 Manchester United Manchester 42 89 55 56
3 Liverpool Liverpool 42 71 40 55
4 Leeds United Leeds United 42 71 41 53
5 Everton Everton 42 67 40 52
6 Chelsea Chelsea 42 62 68 48
7 Tottenham Hotspur Tottenham 42 70 59 47
8 West Bromwich Albion West 42 75 62 46
9 Arsenal Arsenal 42 60 56 44
10 Newcastle Newcastle 42 54 67 41
11 Nottingham Forest Nottingham 42 52 64 39
12 West Ham West Ham 42 73 69 38
13 Leicester Leicester 42 64 69 38
14 Burnley Burnley 42 64 71 38
15 Sunderland Sunderland 42 51 61 37
16 Southampton Southampton 42 66 83 37
17 Wolves Wolves 42 66 75 36
18 Stoke City Stoke City 42 50 73 35
19 Sheffield Wednesday Sheffield 42 51 63 34
20 Coventry City Coventry 42 51 71 33
21 Sheffield United Sheffield 42 49 70 32
22 Fulham Fulham 42 56 98 27
TEMPORADA 1966/1967
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester United Manchester 42 84 45 60
2 Nottingham Forest Nottingham 42 64 41 56
3 Tottenham Hotspur Tottenham 42 71 48 56
4 Leeds United Leeds United 42 62 42 55
5 Liverpool Liverpool 42 64 47 51
6 Everton Everton 42 65 46 48
7 Arsenal Arsenal 42 58 47 46
8 Leicester Leicester 42 78 71 44
9 Chelsea Chelsea 42 67 62 44
10 Sheffield United Sheffield 42 52 58 42
11 Sheffield Wednesday Sheffield 42 56 47 41
12 Stoke City Stoke City 42 62 58 41
13 West Bromwich Albion West 42 77 73 39
14 Burnley Burnley 42 66 76 39
15 Manchester City Manchester 42 43 52 39
16 West Ham West Ham 42 80 84 36
17 Sunderland Sunderland 42 58 72 36
18 Fulham Fulham 42 71 83 34
19 Southampton Southampton 42 74 92 34
20 Newcastle Newcastle 42 39 81 33
21 Aston Villa Aston Villa 42 54 85 29
22 Blackpool Blackpool 42 41 76 21
TEMPORADA 1965/1966
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Liverpool Liverpool 42 79 34 61
2 Leeds United Leeds United 42 79 38 55
3 Burnley Burnley 42 79 45 55
4 Manchester United Manchester 42 84 59 51
5 Chelsea Chelsea 42 65 53 51
6 West Bromwich Albion West 42 91 69 50
7 Leicester Leicester 42 80 65 49
8 Tottenham Hotspur Tottenham 42 75 66 44
9 Sheffield United Sheffield 42 56 59 43
10 Stoke City Stoke City 42 65 64 42
11 Everton Everton 42 56 62 41
12 West Ham West Ham 42 70 83 39
13 Blackpool Blackpool 42 55 65 37
14 Arsenal Arsenal 42 62 75 37
15 Newcastle Newcastle 42 50 63 37
16 Aston Villa Aston Villa 42 69 80 36
17 Sheffield Wednesday Sheffield 42 56 66 36
18 Nottingham Forest Nottingham 42 56 72 36
19 Sunderland Sunderland 42 51 72 36
20 Fulham Fulham 42 65 85 35
21 Northampton Northampton 42 55 92 33
22 Blackburn Rovers Blackburn 42 57 88 20
TEMPORADA 1964/1965
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester United Manchester 42 89 39 61
2 Leeds United Leeds United 42 83 52 61
3 Chelsea Chelsea 42 89 54 56
4 Everton Everton 42 69 60 49
5 Nottingham Forest Nottingham 42 71 67 47
6 Tottenham Hotspur Tottenham 42 87 71 45
7 Liverpool Liverpool 42 67 73 44
8 Sheffield Wednesday Sheffield 42 57 55 43
9 West Ham West Ham 42 82 71 42
10 Blackburn Rovers Blackburn 42 83 79 42
11 Stoke City Stoke City 42 67 66 42
12 Burnley Burnley 42 70 70 42
13 Arsenal Arsenal 42 69 75 41
14 West Bromwich Albion West 42 70 65 39
15 Sunderland Sunderland 42 64 74 37
16 Aston Villa Aston Villa 42 57 82 37
17 Blackpool Blackpool 42 67 78 35
18 Leicester Leicester 42 69 85 35
19 Sheffield United Sheffield 42 50 64 35
20 Fulham Fulham 42 60 78 34
21 Wolves Wolves 42 59 89 30
22 Birmingham City Birmingham 42 64 96 27
TEMPORADA 1963/1964
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Liverpool Liverpool 42 92 45 57
2 Manchester United Manchester 42 90 62 53
3 Everton Everton 42 84 64 52
4 Tottenham Hotspur Tottenham 42 97 81 51
5 Chelsea Chelsea 42 72 56 50
6 Sheffield Wednesday Sheffield 42 84 67 49
7 Blackburn Rovers Blackburn 42 89 65 46
8 Arsenal Arsenal 42 90 82 45
9 Burnley Burnley 42 71 64 44
10 West Bromwich Albion West 42 70 61 43
11 Leicester Leicester 42 61 58 43
12 Sheffield United Sheffield 42 61 64 43
13 Nottingham Forest Nottingham 42 64 68 41
14 West Ham West Ham 42 69 74 40
15 Fulham Fulham 42 58 65 39
16 Wolves Wolves 42 70 80 39
17 Stoke City Stoke City 42 77 78 38
18 Blackpool Blackpool 42 52 73 35
19 Aston Villa Aston Villa 42 62 71 34
20 Birmingham City Birmingham 42 54 92 29
21 Bolton Wanderers Bolton 42 48 80 28
22 Ipswich Town Ipswich Town 42 56 121 25
TEMPORADA 1962/1963
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Everton Everton 42 84 42 61
2 Tottenham Hotspur Tottenham 42 111 62 55
3 Burnley Burnley 42 78 57 54
4 Leicester Leicester 42 79 53 52
5 Wolves Wolves 42 93 65 50
6 Sheffield Wednesday Sheffield 42 77 63 48
7 Arsenal Arsenal 42 86 77 46
8 Liverpool Liverpool 42 71 59 44
9 Nottingham Forest Nottingham 42 67 69 44
10 Sheffield United Sheffield 42 58 60 44
11 Blackburn Rovers Blackburn 42 79 71 42
12 West Ham West Ham 42 73 69 40
13 Blackpool Blackpool 42 58 64 40
14 West Bromwich Albion West 42 71 79 39
15 Aston Villa Aston Villa 42 62 68 38
16 Fulham Fulham 42 50 71 38
17 Ipswich Town Ipswich Town 42 59 78 35
18 Bolton Wanderers Bolton 42 55 75 35
19 Manchester United Manchester 42 67 81 34
20 Birmingham City Birmingham 42 63 90 33
21 Manchester City Manchester 42 58 102 31
22 Leyton Orient Leyton 42 37 81 21
TEMPORADA 1961/1962
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Ipswich Town Ipswich Town 42 93 67 56
2 Burnley Burnley 42 101 67 53
3 Tottenham Hotspur Tottenham 42 88 69 52
4 Everton Everton 42 88 54 51
5 Sheffield United Sheffield 42 61 69 47
6 Sheffield Wednesday Sheffield 42 72 58 46
7 Aston Villa Aston Villa 42 65 56 44
8 West Ham West Ham 42 76 82 44
9 West Bromwich Albion West 42 83 67 43
10 Arsenal Arsenal 42 71 72 43
11 Bolton Wanderers Bolton 42 62 66 42
12 Manchester City Manchester 42 78 81 41
13 Blackpool Blackpool 42 70 75 41
14 Leicester Leicester 42 72 71 40
15 Manchester United Manchester 42 72 75 39
16 Blackburn Rovers Blackburn 42 50 58 39
17 Birmingham City Birmingham 42 65 81 38
18 Wolves Wolves 42 73 86 36
19 Nottingham Forest Nottingham 42 63 79 36
20 Fulham Fulham 42 66 74 33
21 Cardiff City Cardiff City 42 50 81 32
22 Chelsea Chelsea 42 63 94 28
TEMPORADA 1960/1961
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Tottenham Hotspur Tottenham 42 115 55 66
2 Sheffield Wednesday Sheffield 42 78 47 58
3 Wolves Wolves 42 103 75 57
4 Burnley Burnley 42 102 77 51
5 Everton Everton 42 87 69 50
6 Leicester Leicester 42 87 70 45
7 Manchester United Manchester 42 88 76 45
8 Blackburn Rovers Blackburn 42 77 76 43
9 Aston Villa Aston Villa 42 78 77 43
10 West Bromwich Albion West 42 67 71 41
11 Arsenal Arsenal 42 77 85 41
12 Chelsea Chelsea 42 98 100 37
13 Manchester City Manchester 42 79 90 37
14 Nottingham Forest Nottingham 42 62 78 37
15 Cardiff City Cardiff City 42 60 85 37
16 West Ham West Ham 42 77 88 36
17 Fulham Fulham 42 72 95 36
18 Bolton Wanderers Bolton 42 58 73 35
19 Birmingham City Birmingham 42 62 84 34
20 Blackpool Blackpool 42 68 73 33
21 Newcastle Newcastle 42 86 109 32
22 Preston North End Preston 42 43 71 30
TEMPORADA 1959/1960
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Burnley Burnley 42 85 61 55
2 Wolves Wolves 42 106 67 54
3 Tottenham Hotspur Tottenham 42 86 50 53
4 West Bromwich Albion West 42 83 57 49
5 Sheffield Wednesday Sheffield 42 80 59 49
6 Bolton Wanderers Bolton 42 59 51 48
7 Manchester United Manchester 42 102 80 45
8 Newcastle Newcastle 42 82 78 44
9 Preston North End Preston 42 79 76 44
10 Fulham Fulham 42 73 80 44
11 Blackpool Blackpool 42 59 71 40
12 Leicester Leicester 42 66 75 39
13 Arsenal Arsenal 42 68 80 39
14 West Ham West Ham 42 75 91 38
15 Everton Everton 42 73 78 37
16 Manchester City Manchester 42 78 84 37
17 Blackburn Rovers Blackburn 42 60 70 37
18 Chelsea Chelsea 42 76 91 37
19 Birmingham City Birmingham 42 63 80 36
20 Nottingham Forest Nottingham 42 50 74 35
21 Leeds United Leeds United 42 65 92 34
22 Luton Town Luton Town 42 50 73 30
TEMPORADA 1958/1959
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Wolves Wolves 42 110 49 61
2 Manchester United Manchester 42 103 66 55
3 Arsenal Arsenal 42 88 68 50
4 Bolton Wanderers Bolton 42 79 66 50
5 West Bromwich Albion West 42 88 68 49
6 West Ham West Ham 42 85 70 48
7 Burnley Burnley 42 81 70 48
8 Blackpool Blackpool 42 66 49 47
9 Birmingham City Birmingham 42 84 68 46
10 Blackburn Rovers Blackburn 42 76 70 44
11 Newcastle Newcastle 42 80 80 41
12 Preston North End Preston 42 70 77 41
13 Nottingham Forest Nottingham 42 71 74 40
14 Chelsea Chelsea 42 77 98 40
15 Leeds United Leeds United 42 57 74 39
16 Everton Everton 42 71 87 38
17 Luton Town Luton Town 42 68 71 37
18 Tottenham Hotspur Tottenham 42 85 95 36
19 Leicester Leicester 42 67 98 32
20 Manchester City Manchester 42 64 95 31
21 Aston Villa Aston Villa 42 58 87 30
22 Portsmouth Portsmouth 42 64 112 21
TEMPORADA 1957/1958
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Wolves Wolves 42 103 47 64
2 Preston North End Preston 42 100 51 59
3 West Bromwich Albion West 42 92 68 51
4 Tottenham Hotspur Tottenham 42 93 77 51
5 Manchester City Manchester 42 104 100 49
6 Burnley Burnley 42 80 74 47
7 Blackpool Blackpool 42 80 67 44
8 Luton Town Luton Town 42 69 63 44
9 Manchester United Manchester 42 85 75 43
10 Nottingham Forest Nottingham 42 69 63 42
11 Chelsea Chelsea 42 83 79 42
12 Arsenal Arsenal 42 73 85 39
13 Birmingham City Birmingham 42 76 89 39
14 Aston Villa Aston Villa 42 73 86 39
15 Everton Everton 42 65 75 37
16 Leeds United Leeds United 42 51 63 37
17 Bolton Wanderers Bolton 42 63 87 37
18 Leicester Leicester 42 91 112 33
19 Newcastle Newcastle 42 73 81 32
20 Portsmouth Portsmouth 42 73 88 32
21 Sunderland Sunderland 42 54 97 32
22 Sheffield Wednesday Sheffield 42 69 92 31
TEMPORADA 1956/1957
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Leicester Leicester 42 109 67 86
2 Nottingham Forest Nottingham 42 94 55 76
3 Liverpool Liverpool 42 82 54 74
4 Blackburn Rovers Blackburn 42 83 75 73
5 Stoke City Stoke City 42 83 58 68
6 Middlesbrough Middlesbroug 42 84 60 67
7 Sheffield United Sheffield 42 87 76 65
8 West Ham West Ham 42 59 63 65
9 Swansea City Swansea City 42 90 90 64
10 Bristol Rovers Bristol 42 81 67 63
11 Fulham Fulham 42 84 76 61
12 Huddersfield Town Huddersfield 42 68 74 60
13 Bristol City Bristol City 42 74 79 57
14 Grimsby Town Grimsby Town 42 61 62 56
15 Doncaster Rovers Doncaster 42 77 77 55
16 Leyton Orient Leyton 42 66 84 55
17 Rotherham United Rotherham 42 74 75 50
18 Lincoln City Lincoln City 42 54 80 48
19 Barnsley Barnsley 42 59 89 46
20 Notts County Notts County 42 58 86 39
21 Bury Bury 42 60 96 33
22 Port Vale Port Vale 42 57 101 30
TEMPORADA 1955/1956
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Sheffield Wednesday Sheffield 42 101 62 76
2 Leeds United Leeds United 42 80 60 75
3 Liverpool Liverpool 42 85 63 69
4 Blackburn Rovers Blackburn 42 84 65 69
5 Leicester Leicester 42 94 78 69
6 Bristol Rovers Bristol 42 84 70 69
7 Fulham Fulham 42 89 79 66
8 Nottingham Forest Nottingham 42 68 63 66
9 Swansea City Swansea City 42 83 81 66
10 Bristol City Bristol City 42 80 64 64
11 Lincoln City Lincoln City 42 79 65 64
12 Stoke City Stoke City 42 71 62 64
13 Port Vale Port Vale 42 60 58 61
14 Middlesbrough Middlesbroug 42 76 78 56
15 Bury Bury 42 86 90 56
16 West Ham West Ham 42 74 69 53
17 Doncaster Rovers Doncaster 42 69 96 47
18 Rotherham United Rotherham 42 56 75 45
19 Barnsley Barnsley 42 47 84 45
20 Notts County Notts County 42 55 82 42
21 Plymouth Argyle Plymouth 42 54 87 38
22 Hull City Hull City 42 53 97 36
TEMPORADA 1954/1955
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Chelsea Chelsea 42 81 57 52
2 Wolves Wolves 42 89 70 48
3 Portsmouth Portsmouth 42 74 62 48
4 Sunderland Sunderland 42 64 54 48
5 Manchester United Manchester 42 84 74 47
6 Aston Villa Aston Villa 42 72 73 47
7 Manchester City Manchester 42 76 69 46
8 Newcastle Newcastle 42 89 77 43
9 Arsenal Arsenal 42 69 63 43
10 Burnley Burnley 42 51 48 43
11 Everton Everton 42 62 68 42
12 Huddersfield Town Huddersfield 42 63 68 41
13 Sheffield United Sheffield 42 70 86 41
14 Preston North End Preston 42 83 64 40
15 Charlton Athletic Charlton 42 76 75 40
16 Tottenham Hotspur Tottenham 42 72 73 40
17 West Bromwich Albion West 42 76 96 40
18 Bolton Wanderers Bolton 42 62 69 39
19 Blackpool Blackpool 42 60 64 38
20 Cardiff City Cardiff City 42 62 76 37
21 Leicester Leicester 42 74 86 35
22 Sheffield Wednesday Sheffield 42 63 100 26
TEMPORADA 1953/1954
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Leicester Leicester 42 97 60 79
2 Blackburn Rovers Blackburn 42 86 50 78
3 Everton Everton 42 92 58 76
4 Nottingham Forest Nottingham 42 86 59 72
5 Rotherham United Rotherham 42 80 67 70
6 Luton Town Luton Town 42 64 59 66
7 Birmingham City Birmingham 42 78 58 65
8 Fulham Fulham 42 98 85 61
9 Leeds United Leeds United 42 89 81 58
10 Bristol Rovers Bristol 42 64 58 58
11 Doncaster Rovers Doncaster 42 59 63 57
12 West Ham West Ham 42 67 69 54
13 Hull City Hull City 42 64 66 54
14 Stoke City Stoke City 42 71 60 53
15 Notts County Notts County 42 54 74 52
16 Lincoln City Lincoln City 42 65 83 51
17 Derby County Derby County 42 64 82 47
18 Bury Bury 42 54 72 47
19 Swansea City Swansea City 42 58 82 47
20 Plymouth Argyle Plymouth 42 65 82 43
21 Brentford Brentford 42 40 78 41
22 Oldham Athletic AFC Oldham 42 40 89 33
TEMPORADA 1952/1953
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Sheffield United Sheffield 42 97 55 85
2 Huddersfield Town Huddersfield 42 84 33 82
3 Luton Town Luton Town 42 84 49 74
4 Plymouth Argyle Plymouth 42 65 60 69
5 Birmingham City Birmingham 42 71 66 67
6 Leicester Leicester 42 89 74 66
7 Nottingham Forest Nottingham 42 77 67 62
8 Blackburn Rovers Blackburn 42 68 65 62
9 Fulham Fulham 42 81 71 61
10 Leeds United Leeds United 42 71 63 57
11 Rotherham United Rotherham 42 75 74 57
12 Swansea City Swansea City 42 78 81 57
13 West Ham West Ham 42 58 60 52
14 Doncaster Rovers Doncaster 42 58 64 52
15 Everton Everton 42 71 75 50
16 Lincoln City Lincoln City 42 64 71 50
17 Hull City Hull City 42 57 69 50
18 Brentford Brentford 42 59 76 50
19 Notts County Notts County 42 60 88 50
20 Bury Bury 42 53 81 48
21 Southampton Southampton 42 68 85 43
22 Barnsley Barnsley 42 47 108 23
TEMPORADA 1951/1952
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Sheffield Wednesday Sheffield 42 100 66 74
2 Birmingham City Birmingham 42 67 56 72
3 Cardiff City Cardiff City 42 72 54 71
4 Nottingham Forest Nottingham 42 77 62 67
5 Leicester Leicester 42 78 64 66
6 Leeds United Leeds United 42 59 57 65
7 Everton Everton 42 64 58 61
8 Luton Town Luton Town 42 77 78 60
9 Sheffield United Sheffield 42 90 76 59
10 Rotherham United Rotherham 42 73 71 59
11 Brentford Brentford 42 54 55 57
12 Blackburn Rovers Blackburn 42 54 63 57
13 West Ham West Ham 42 67 77 56
14 Southampton Southampton 42 61 73 56
15 Notts County Notts County 42 71 68 55
16 Bury Bury 42 67 69 52
17 Doncaster Rovers Doncaster 42 55 60 51
18 Hull City Hull City 42 60 70 50
19 Swansea City Swansea City 42 72 76 48
20 Coventry City Coventry 42 59 82 48
21 Barnsley Barnsley 42 59 72 47
22 Queens Park Rangers Queens Park 42 52 81 45

  USO DE MEMORIA  
8,535,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6354
Total Execution Time  0.6366
  CADENA URL  
/historico/Leicester-City-Fc/1971
  GET DATOS  
$_GET['/historico/Leicester-City-Fc/1971']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0192  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 = 1971 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.0127  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.0257  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 = 23314
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1538 AND type_rel = 2
0.0244  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.0138  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.0152  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 = 1971 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 = 23314 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0158  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 (1970,1971,1972) 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 (23314,23205,22773,14754,5682) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 5682 AND teamId = 1538
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 23314 AND teamId = 1538
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 14754 AND teamId = 1538
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 23205 AND teamId = 1538
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 22773 AND teamId = 1538
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 events1971 e ON e.player_id = p.id AND e.league_id = 23314 WHERE rp.league_id = 23314 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.0127  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 events1971 e ON e.player_id = p.id AND e.league_id = 23314 WHERE rp.league_id = 23314 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 events1971 e ON e.player_id = p.id AND e.league_id = 23314 WHERE rp.league_id = 23314 AND rp.teamId = 1538 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0141  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 <= 1971 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 `tables1971` 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 = 23314 AND t.round = 42 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 `tables1970` 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 = 23313 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 `tables1969` 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 = 5679 AND t.round = 42 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 `tables1968` 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 = 5678 AND t.round = 42 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 `tables1967` 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 = 5677 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 `tables1966` 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 = 5676 AND t.round = 42 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 `tables1965` 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 = 5675 AND t.round = 42 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 `tables1964` 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 = 5674 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 `tables1963` 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 = 5673 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 `tables1962` 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 = 5672 AND t.round = 42 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 `tables1957` 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 = 23300 AND t.round = 42 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 `tables1956` 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 = 23299 AND t.round = 42 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 `tables1954` 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 = 23297 AND t.round = 42 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 `tables1953` 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 = 23296 AND t.round = 42 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 `tables1952` 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 = 23295 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC