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

Stoke City

Entrenador: Steven Schumacher

Temporada 1971/1972
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
TEMPORADA 1970/1971
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Arsenal Arsenal 42 71 29 65
2 Leeds United Leeds United 42 72 30 64
3 Tottenham Hotspur Tottenham 42 54 33 52
4 Wolves Wolves 42 64 54 52
5 Liverpool Liverpool 42 42 24 51
6 Chelsea Chelsea 42 52 42 51
7 Southampton Southampton 42 56 44 46
8 Manchester United Manchester 42 65 66 43
9 Derby County Derby County 42 56 54 42
10 Coventry City Coventry 42 37 38 42
11 Manchester City Manchester 42 47 42 41
12 Newcastle Newcastle 42 44 46 41
13 Stoke City Stoke City 42 44 48 37
14 Everton Everton 42 54 60 37
15 Huddersfield Town Huddersfield 42 40 49 36
16 Nottingham Forest Nottingham 42 42 61 36
17 West Bromwich Albion West 42 58 75 35
18 Crystal Palace Crystal 42 39 57 35
19 Ipswich Town Ipswich Town 42 42 48 34
20 West Ham West Ham 42 47 60 34
21 Burnley Burnley 42 29 63 27
22 Blackpool Blackpool 42 34 66 23
TEMPORADA 1969/1970
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Everton Everton 42 72 34 66
2 Leeds United Leeds United 42 84 49 57
3 Chelsea Chelsea 42 70 50 55
4 Derby County Derby County 42 64 37 53
5 Liverpool Liverpool 42 65 42 51
6 Coventry City Coventry 42 58 48 49
7 Newcastle Newcastle 42 57 35 47
8 Manchester United Manchester 42 66 61 45
9 Stoke City Stoke City 42 56 52 45
10 Manchester City Manchester 42 55 48 43
11 Tottenham Hotspur Tottenham 42 54 55 43
12 Arsenal Arsenal 42 51 49 42
13 Wolves Wolves 42 55 57 40
14 Burnley Burnley 42 56 61 39
15 Nottingham Forest Nottingham 42 50 71 38
16 West Bromwich Albion West 42 58 66 37
17 West Ham West Ham 42 51 60 36
18 Ipswich Town Ipswich Town 42 40 63 31
19 Southampton Southampton 42 46 67 29
20 Crystal Palace Crystal 42 34 68 27
21 Sunderland Sunderland 42 30 68 26
22 Sheffield Wednesday Sheffield 42 40 71 25
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
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Chelsea Chelsea 42 81 42 76
2 Stoke City Stoke City 42 73 50 73
3 Sunderland Sunderland 42 84 55 72
4 Middlesbrough Middlesbroug 42 86 85 69
5 Leeds United Leeds United 42 79 53 67
6 Newcastle Newcastle 42 79 59 65
7 Huddersfield Town Huddersfield 42 63 50 65
8 Bury Bury 42 51 47 65
9 Cardiff City Cardiff City 42 83 73 61
10 Scunthorpe United Scunthorpe 42 57 59 60
11 Southampton Southampton 42 72 67 59
12 Norwich City Norwich City 42 80 79 59
13 Plymouth Argyle Plymouth 42 76 73 57
14 Rotherham United Rotherham 42 67 74 57
15 Swansea City Swansea City 42 51 72 54
16 Preston North End Preston 42 59 74 50
17 Portsmouth Portsmouth 42 63 79 50
18 Derby County Derby County 42 61 72 48
19 Grimsby Town Grimsby Town 42 55 66 46
20 Charlton Athletic Charlton 42 62 94 44
21 Walsall Walsall 42 53 89 42
22 Luton Town Luton Town 42 61 84 40
TEMPORADA 1961/1962
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Liverpool Liverpool 42 99 43 89
2 Leyton Orient Leyton 42 69 40 76
3 Sunderland Sunderland 42 85 50 75
4 Scunthorpe United Scunthorpe 42 86 71 70
5 Plymouth Argyle Plymouth 42 75 75 65
6 Southampton Southampton 42 77 62 63
7 Huddersfield Town Huddersfield 42 67 59 60
8 Stoke City Stoke City 42 55 57 59
9 Rotherham United Rotherham 42 70 76 57
10 Luton Town Luton Town 42 69 71 56
11 Bury Bury 42 52 76 56
12 Middlesbrough Middlesbroug 42 76 72 55
13 Preston North End Preston 42 55 57 55
14 Newcastle Newcastle 42 64 58 54
15 Charlton Athletic Charlton 42 69 75 54
16 Walsall Walsall 42 70 75 53
17 Derby County Derby County 42 68 75 53
18 Norwich City Norwich City 42 61 70 53
19 Leeds United Leeds United 42 50 61 48
20 Swansea City Swansea City 42 61 83 48
21 Bristol Rovers Bristol 42 53 81 46
22 Brighton & Hove Albion Brighton 42 42 86 41
TEMPORADA 1960/1961
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Ipswich Town Ipswich Town 42 100 55 85
2 Sheffield United Sheffield 42 81 51 84
3 Liverpool Liverpool 42 87 58 73
4 Norwich City Norwich City 42 70 53 69
5 Middlesbrough Middlesbroug 42 83 74 66
6 Swansea City Swansea City 42 77 73 65
7 Sunderland Sunderland 42 75 60 64
8 Southampton Southampton 42 84 81 62
9 Charlton Athletic Charlton 42 97 90 59
10 Plymouth Argyle Plymouth 42 81 82 59
11 Scunthorpe United Scunthorpe 42 69 64 57
12 Derby County Derby County 42 80 80 55
13 Luton Town Luton Town 42 70 79 54
14 Leeds United Leeds United 42 75 83 52
15 Bristol Rovers Bristol 42 73 92 52
16 Brighton & Hove Albion Brighton 42 61 75 51
17 Leyton Orient Leyton 42 55 78 50
18 Rotherham United Rotherham 42 65 64 49
19 Stoke City Stoke City 42 51 59 48
20 Huddersfield Town Huddersfield 42 62 71 48
21 Portsmouth Portsmouth 42 64 91 44
22 Lincoln City Lincoln City 42 48 95 32
TEMPORADA 1959/1960
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Aston Villa Aston Villa 42 89 43 84
2 Cardiff City Cardiff City 42 90 62 81
3 Liverpool Liverpool 42 90 66 70
4 Sheffield United Sheffield 42 68 51 69
5 Middlesbrough Middlesbroug 42 90 64 67
6 Huddersfield Town Huddersfield 42 73 52 66
7 Bristol Rovers Bristol 42 72 78 65
8 Charlton Athletic Charlton 42 90 87 64
9 Rotherham United Rotherham 42 61 60 64
10 Ipswich Town Ipswich Town 42 78 68 63
11 Leyton Orient Leyton 42 76 61 59
12 Swansea City Swansea City 42 82 84 55
13 Lincoln City Lincoln City 42 75 78 55
14 Brighton & Hove Albion Brighton 42 67 76 51
15 Scunthorpe United Scunthorpe 42 57 71 49
16 Derby County Derby County 42 61 77 49
17 Stoke City Stoke City 42 66 83 49
18 Sunderland Sunderland 42 52 65 48
19 Plymouth Argyle Plymouth 42 61 89 48
20 Portsmouth Portsmouth 42 59 77 42
21 Hull City Hull City 42 48 76 40
22 Bristol City Bristol City 42 60 97 38
TEMPORADA 1958/1959
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Sheffield Wednesday Sheffield 42 106 48 90
2 Fulham Fulham 42 96 61 87
3 Liverpool Liverpool 42 87 62 77
4 Sheffield United Sheffield 42 82 48 76
5 Stoke City Stoke City 42 72 58 70
6 Derby County Derby County 42 74 71 68
7 Bristol Rovers Bristol 42 80 64 66
8 Charlton Athletic Charlton 42 92 90 61
9 Cardiff City Cardiff City 42 65 65 61
10 Bristol City Bristol City 42 74 70 58
11 Swansea City Swansea City 42 79 81 57
12 Ipswich Town Ipswich Town 42 62 77 57
13 Huddersfield Town Huddersfield 42 62 55 56
14 Sunderland Sunderland 42 64 75 56
15 Brighton & Hove Albion Brighton 42 74 90 56
16 Middlesbrough Middlesbroug 42 87 71 55
17 Leyton Orient Leyton 42 71 78 50
18 Scunthorpe United Scunthorpe 42 55 84 45
19 Lincoln City Lincoln City 42 63 93 40
20 Rotherham United Rotherham 42 42 82 39
21 Grimsby Town Grimsby Town 42 62 90 37
22 Barnsley Barnsley 42 55 91 37
TEMPORADA 1957/1958
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 West Ham West Ham 42 101 54 80
2 Charlton Athletic Charlton 42 107 69 79
3 Blackburn Rovers Blackburn 42 93 57 78
4 Liverpool Liverpool 42 79 54 76
5 Sheffield United Sheffield 42 75 50 73
6 Fulham Fulham 42 97 59 72
7 Middlesbrough Middlesbroug 42 83 74 64
8 Stoke City Stoke City 42 75 73 60
9 Ipswich Town Ipswich Town 42 68 69 60
10 Bristol Rovers Bristol 42 85 80 59
11 Leyton Orient Leyton 42 77 79 59
12 Huddersfield Town Huddersfield 42 63 66 58
13 Grimsby Town Grimsby Town 42 86 83 57
14 Barnsley Barnsley 42 70 74 54
15 Cardiff City Cardiff City 42 63 77 51
16 Derby County Derby County 42 60 81 50
17 Bristol City Bristol City 42 63 88 48
18 Rotherham United Rotherham 42 65 101 47
19 Swansea City Swansea City 42 72 99 42
20 Lincoln City Lincoln City 42 55 82 42
21 Notts County Notts County 42 44 80 42
22 Doncaster Rovers Doncaster 42 56 88 35
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
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Rotherham United Rotherham 42 94 64 79
2 Luton Town Luton Town 42 88 53 77
3 Birmingham City Birmingham 42 92 47 76
4 Leeds United Leeds United 42 70 53 76
5 Stoke City Stoke City 42 69 46 73
6 Blackburn Rovers Blackburn 42 114 79 72
7 Notts County Notts County 42 74 71 69
8 Bristol Rovers Bristol 42 75 70 64
9 West Ham West Ham 42 74 70 64
10 Swansea City Swansea City 42 86 83 60
11 Middlesbrough Middlesbroug 42 73 82 60
12 Liverpool Liverpool 42 92 96 58
13 Bury Bury 42 77 72 56
14 Nottingham Forest Nottingham 42 58 62 55
15 Fulham Fulham 42 76 79 53
16 Lincoln City Lincoln City 42 68 79 49
17 Doncaster Rovers Doncaster 42 58 95 49
18 Port Vale Port Vale 42 48 71 47
19 Hull City Hull City 42 44 69 46
20 Plymouth Argyle Plymouth 42 57 82 43
21 Ipswich Town Ipswich Town 42 57 92 39
22 Derby County Derby County 42 53 82 30
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
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Arsenal Arsenal 42 97 64 54
2 Preston North End Preston 42 85 60 54
3 Wolves Wolves 42 86 63 51
4 West Bromwich Albion West 42 66 60 50
5 Charlton Athletic Charlton 42 77 63 49
6 Burnley Burnley 42 67 52 48
7 Blackpool Blackpool 42 71 70 47
8 Manchester United Manchester 42 69 72 46
9 Sunderland Sunderland 42 68 82 43
10 Tottenham Hotspur Tottenham 42 78 69 41
11 Aston Villa Aston Villa 42 63 61 41
12 Cardiff City Cardiff City 42 54 46 40
13 Middlesbrough Middlesbroug 42 70 77 39
14 Bolton Wanderers Bolton 42 61 69 39
15 Portsmouth Portsmouth 42 74 83 38
16 Newcastle Newcastle 42 59 70 37
17 Liverpool Liverpool 42 61 82 36
18 Sheffield Wednesday Sheffield 42 62 72 35
19 Chelsea Chelsea 42 56 66 35
20 Manchester City Manchester 42 72 87 35
21 Stoke City Stoke City 42 53 66 34
22 Derby County Derby County 42 59 74 32

  USO DE MEMORIA  
8,713,072 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.2114
Total Execution Time  0.2132
  CADENA URL  
/historico/Stoke-City/1972
  GET DATOS  
$_GET['/historico/Stoke-City/1972']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (52)  
0.0051  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 = 'Stoke-City' AND l.year = 1972 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=2429 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=2429 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=2429 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=2429 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 5682
0.0026  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 = 14751
0.0024  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 = 23207
0.0023  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2429 AND type_rel = 2
0.0036  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2429 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (401,910,1269,1483,1778) ORDER BY n.cover_points DESC, update_date DESC
0.0044  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 = '2429' AND l.year = 1972 ORDER BY l.year DESC,cat.coefficient DESC
0.0080  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 = '2429' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 23207 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 = 14751 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 5682 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0046  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=2429 AND l.year in (1971,1972,1973) 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 (23207,14753,10939,5683) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 5683 AND teamId = 2429
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 10939 AND teamId = 2429
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 14753 AND teamId = 2429
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 23207 AND teamId = 2429
0.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '2429' 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 = '2429' and rp.type = 4
0.0024  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 = '2429' 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 = '2429' and rp.type = 4
0.0038  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 events1972 e ON e.player_id = p.id AND e.league_id = 5682 WHERE rp.league_id = 5682 AND rp.teamId = 2429 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.0028  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 events1972 e ON e.player_id = p.id AND e.league_id = 5682 WHERE rp.league_id = 5682 AND rp.teamId = 2429 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 events1972 e ON e.player_id = p.id AND e.league_id = 5682 WHERE rp.league_id = 5682 AND rp.teamId = 2429 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 = 2429 AND l.year <= 1972 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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
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 `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 = 5681 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 `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 = 5680 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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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 = 23306 AND t.round = 42 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 `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 = 23305 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 `tables1961` 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 = 23304 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 `tables1960` 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 = 23303 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 `tables1959` 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 = 23302 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 `tables1958` 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 = 23301 AND t.round = 42 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 `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.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 `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.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 `tables1955` 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 = 23298 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 `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.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 `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 = 5663 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 5682 ORDER BY nameShow LIMIT 100