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 2023/2024
TEMPORADA 2023/2024
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Leicester Leicester 44 86 39 94
2 Ipswich Town Ipswich Town 44 88 55 92
3 Leeds United Leeds United 45 80 41 90
4 Southampton Southampton 45 85 62 84
5 Norwich City Norwich City 45 79 63 73
6 West Bromwich Albion West 45 67 47 72
7 Hull City Hull City 45 67 59 69
8 Middlesbrough Middlesbroug 45 68 61 66
9 Coventry City Coventry 44 68 55 64
10 Preston North End Preston 44 56 61 63
11 Bristol City Bristol City 45 53 47 62
12 Cardiff City Cardiff City 45 51 65 62
13 Swansea City Swansea City 45 59 64 57
14 Watford Watford 45 60 58 56
15 Sunderland Sunderland 45 52 52 56
16 Millwall Millwall 45 44 55 56
17 Queens Park Rangers Queens Park 45 45 57 53
18 Stoke City Stoke City 45 45 60 53
19 Blackburn Rovers Blackburn 45 58 74 50
20 Sheffield Wednesday Sheffield 45 42 68 50
21 Plymouth Argyle Plymouth 45 58 70 48
22 Birmingham City Birmingham 45 49 65 47
23 Huddersfield Town Huddersfield 45 48 75 45
24 Rotherham United Rotherham 45 32 87 24
TEMPORADA 2022/2023
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Burnley Burnley 46 87 35 101
2 Sheffield United Sheffield 46 73 39 91
3 Luton Town Luton Town 46 57 39 80
4 Middlesbrough Middlesbroug 46 84 56 75
5 Coventry City Coventry 46 58 46 70
6 Sunderland Sunderland 46 68 55 69
7 Blackburn Rovers Blackburn 46 52 54 69
8 Millwall Millwall 46 57 50 68
9 West Bromwich Albion West 46 59 53 66
10 Swansea City Swansea City 46 68 64 66
11 Watford Watford 46 56 53 63
12 Preston North End Preston 46 45 59 63
13 Norwich City Norwich City 46 57 54 62
14 Bristol City Bristol City 46 55 56 59
15 Hull City Hull City 46 51 61 58
16 Stoke City Stoke City 46 55 54 53
17 Birmingham City Birmingham 46 47 58 53
18 Huddersfield Town Huddersfield 46 47 62 53
19 Rotherham United Rotherham 46 49 60 50
20 Queens Park Rangers Queens Park 46 44 71 50
21 Cardiff City Cardiff City 46 41 58 49
22 Reading Reading 46 46 68 44
23 Blackpool Blackpool 46 48 72 44
24 Wigan Athletic Wigan 46 38 65 42
TEMPORADA 2021/2022
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Fulham Fulham 46 106 43 90
2 AFC Bournemouth Bournemouth 46 74 39 88
3 Huddersfield Town Huddersfield 46 64 47 82
4 Nottingham Forest Nottingham 46 73 40 80
5 Sheffield United Sheffield 46 63 45 75
6 Luton Town Luton Town 46 63 55 75
7 Middlesbrough Middlesbroug 46 59 50 70
8 Blackburn Rovers Blackburn 46 59 50 69
9 Millwall Millwall 46 53 45 69
10 West Bromwich Albion West 46 52 45 67
11 Queens Park Rangers Queens Park 46 60 59 66
12 Coventry City Coventry 46 60 59 64
13 Preston North End Preston 46 52 56 64
14 Stoke City Stoke City 46 57 52 62
15 Swansea City Swansea City 46 58 68 61
16 Blackpool Blackpool 46 54 58 60
17 Bristol City Bristol City 46 62 77 55
18 Cardiff City Cardiff City 46 50 68 53
19 Hull City Hull City 46 41 54 51
20 Birmingham City Birmingham 46 50 75 47
21 Reading Reading 46 54 87 41
22 Peterborough United Peterborough 46 43 87 37
23 Derby County Derby County 46 45 53 34
24 Barnsley Barnsley 46 33 73 30
TEMPORADA 2020/2021
CHAMPIONSHIP GRUPO 1
Equipo PJ GF GC Puntos
1 Norwich City Norwich City 46 75 36 97
2 Watford Watford 46 63 30 91
3 Brentford Brentford 46 79 42 87
4 Swansea City Swansea City 46 56 39 80
5 Barnsley Barnsley 46 58 50 78
6 AFC Bournemouth Bournemouth 46 73 46 77
7 Reading Reading 46 62 54 70
8 Cardiff City Cardiff City 46 66 49 68
9 Queens Park Rangers Queens Park 46 57 55 68
10 Middlesbrough Middlesbroug 46 55 53 64
11 Millwall Millwall 46 47 52 62
12 Luton Town Luton Town 46 41 52 62
13 Preston North End Preston 46 49 56 61
14 Stoke City Stoke City 46 50 52 60
15 Blackburn Rovers Blackburn 46 65 54 57
16 Coventry City Coventry 46 49 61 55
17 Nottingham Forest Nottingham 46 37 45 52
18 Birmingham City Birmingham 46 37 61 52
19 Bristol City Bristol City 46 46 68 51
20 Huddersfield Town Huddersfield 46 50 71 49
21 Derby County Derby County 46 36 58 44
22 Wycombe Wanderers Wycombe 46 39 69 43
23 Rotherham United Rotherham 46 44 60 42
24 Sheffield Wednesday Sheffield 46 40 61 41
TEMPORADA 2019/2020
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Leeds United Leeds United 46 77 35 93
2 West Bromwich Albion West 46 77 45 83
3 Brentford Brentford 46 80 38 81
4 Fulham Fulham 46 64 48 81
5 Cardiff City Cardiff City 46 68 58 73
6 Swansea City Swansea City 46 62 53 70
7 Nottingham Forest Nottingham 46 58 50 70
8 Millwall Millwall 46 57 51 68
9 Preston North End Preston 46 59 54 66
10 Derby County Derby County 46 62 64 64
11 Blackburn Rovers Blackburn 46 66 63 63
12 Bristol City Bristol City 46 60 65 63
13 Queens Park Rangers Queens Park 46 67 76 58
14 Reading Reading 46 59 58 56
15 Stoke City Stoke City 46 62 68 56
16 Sheffield Wednesday Sheffield 46 58 66 56
17 Middlesbrough Middlesbroug 46 48 61 53
18 Huddersfield Town Huddersfield 46 52 70 51
19 Luton Town Luton Town 46 54 82 51
20 Birmingham City Birmingham 46 54 75 50
21 Barnsley Barnsley 46 49 69 49
22 Charlton Athletic Charlton 46 50 65 48
23 Wigan Athletic Wigan 46 57 56 47
24 Hull City Hull City 46 57 87 45
TEMPORADA 2018/2019
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Norwich City Norwich City 46 93 57 94
2 Sheffield United Sheffield 46 78 41 89
3 Leeds United Leeds United 46 73 50 83
4 West Bromwich Albion West 46 87 62 80
5 Aston Villa Aston Villa 46 82 61 76
6 Derby County Derby County 46 69 54 74
7 Middlesbrough Middlesbroug 46 49 41 73
8 Bristol City Bristol City 46 59 53 70
9 Nottingham Forest Nottingham 46 61 54 66
10 Swansea City Swansea City 46 65 62 65
11 Brentford Brentford 46 73 59 64
12 Sheffield Wednesday Sheffield 46 60 62 64
13 Hull City Hull City 46 66 68 62
14 Preston North End Preston 46 67 67 61
15 Blackburn Rovers Blackburn 46 64 69 60
16 Stoke City Stoke City 46 45 52 55
17 Birmingham City Birmingham 46 64 58 52
18 Wigan Athletic Wigan 46 51 64 52
19 Queens Park Rangers Queens Park 46 53 71 51
20 Reading Reading 46 49 66 47
21 Millwall Millwall 46 48 64 44
22 Rotherham United Rotherham 46 52 83 40
23 Bolton Wanderers Bolton 46 29 78 32
24 Ipswich Town Ipswich Town 46 36 77 31
TEMPORADA 2017/2018
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester City Manchester 38 106 27 100
2 Manchester United Manchester 38 68 28 81
3 Tottenham Hotspur Tottenham 38 74 36 77
4 Liverpool Liverpool 38 84 38 75
5 Chelsea Chelsea 38 62 38 70
6 Arsenal Arsenal 38 74 51 63
7 Burnley Burnley 38 36 39 54
8 Everton Everton 38 44 58 49
9 Leicester Leicester 38 56 60 47
10 Newcastle Newcastle 38 39 47 44
11 Crystal Palace Crystal 38 45 55 44
12 AFC Bournemouth Bournemouth 38 45 61 44
13 West Ham West Ham 38 48 68 42
14 Watford Watford 38 44 64 41
15 Brighton & Hove Albion Brighton 38 34 54 40
16 Huddersfield Town Huddersfield 38 28 58 37
17 Southampton Southampton 38 37 56 36
18 Swansea City Swansea City 38 28 56 33
19 Stoke City Stoke City 38 35 68 33
20 West Bromwich Albion West 38 31 56 31
TEMPORADA 2016/2017
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Chelsea Chelsea 38 85 33 93
2 Tottenham Hotspur Tottenham 38 86 26 86
3 Manchester City Manchester 38 80 39 78
4 Liverpool Liverpool 38 78 42 76
5 Arsenal Arsenal 38 77 44 75
6 Manchester United Manchester 38 54 29 69
7 Everton Everton 38 62 44 61
8 Southampton Southampton 38 41 48 46
9 AFC Bournemouth Bournemouth 38 55 67 46
10 West Bromwich Albion West 38 43 51 45
11 West Ham West Ham 38 47 64 45
12 Leicester Leicester 38 48 63 44
13 Stoke City Stoke City 38 41 56 44
14 Crystal Palace Crystal 38 50 63 41
15 Swansea City Swansea City 38 45 70 41
16 Burnley Burnley 38 39 55 40
17 Watford Watford 38 40 68 40
18 Hull City Hull City 38 37 80 34
19 Middlesbrough Middlesbroug 38 27 53 28
20 Sunderland Sunderland 38 29 69 24
TEMPORADA 2015/2016
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Leicester Leicester 38 68 36 81
2 Arsenal Arsenal 38 65 36 71
3 Tottenham Hotspur Tottenham 38 69 35 70
4 Manchester City Manchester 38 71 41 66
5 Manchester United Manchester 38 49 35 66
6 Southampton Southampton 38 59 41 63
7 West Ham West Ham 38 65 51 62
8 Liverpool Liverpool 38 63 50 60
9 Stoke City Stoke City 38 41 55 51
10 Chelsea Chelsea 38 59 53 50
11 Everton Everton 38 59 55 47
12 Swansea City Swansea City 38 42 52 47
13 Watford Watford 38 40 50 45
14 West Bromwich Albion West 38 34 48 43
15 Crystal Palace Crystal 38 39 51 42
16 AFC Bournemouth Bournemouth 38 45 67 42
17 Sunderland Sunderland 38 48 62 39
18 Newcastle Newcastle 38 44 65 37
19 Norwich City Norwich City 38 39 67 34
20 Aston Villa Aston Villa 38 27 76 17
TEMPORADA 2014/2015
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Chelsea Chelsea 38 73 32 87
2 Manchester City Manchester 38 83 38 79
3 Arsenal Arsenal 38 71 36 75
4 Manchester United Manchester 38 62 37 70
5 Tottenham Hotspur Tottenham 38 58 53 64
6 Liverpool Liverpool 38 52 48 62
7 Southampton Southampton 38 54 33 60
8 Swansea City Swansea City 38 46 49 56
9 Stoke City Stoke City 38 48 45 54
10 Crystal Palace Crystal 38 47 51 48
11 Everton Everton 38 48 50 47
12 West Ham West Ham 38 44 47 47
13 West Bromwich Albion West 38 38 51 44
14 Leicester Leicester 38 46 55 41
15 Newcastle Newcastle 38 40 63 39
16 Sunderland Sunderland 38 31 53 38
17 Aston Villa Aston Villa 38 31 57 38
18 Hull City Hull City 38 33 51 35
19 Burnley Burnley 38 28 53 33
20 Queens Park Rangers Queens Park 38 42 73 30
TEMPORADA 2013/2014
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester City Manchester 38 102 37 86
2 Liverpool Liverpool 38 101 50 84
3 Chelsea Chelsea 38 71 27 82
4 Arsenal Arsenal 38 68 41 79
5 Everton Everton 38 61 39 72
6 Tottenham Hotspur Tottenham 38 55 51 69
7 Manchester United Manchester 38 64 43 64
8 Southampton Southampton 38 54 46 56
9 Stoke City Stoke City 38 45 52 50
10 Newcastle Newcastle 38 43 59 49
11 Crystal Palace Crystal 38 33 48 45
12 Swansea City Swansea City 38 54 54 42
13 West Ham West Ham 38 40 51 40
14 Sunderland Sunderland 38 41 60 38
15 Aston Villa Aston Villa 38 39 61 38
16 Hull City Hull City 38 38 53 37
17 West Bromwich Albion West 38 43 59 36
18 Norwich City Norwich City 38 28 62 33
19 Fulham Fulham 38 40 85 32
20 Cardiff City Cardiff City 38 32 74 30
TEMPORADA 2012/2013
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester United Manchester 38 86 43 89
2 Manchester City Manchester 38 66 34 78
3 Chelsea Chelsea 38 75 39 75
4 Arsenal Arsenal 38 72 37 73
5 Tottenham Hotspur Tottenham 38 66 46 72
6 Everton Everton 38 55 40 63
7 Liverpool Liverpool 38 71 43 61
8 West Bromwich Albion West 38 53 57 49
9 Swansea City Swansea City 38 47 51 46
10 West Ham West Ham 38 45 53 46
11 Norwich City Norwich City 38 41 58 44
12 Fulham Fulham 38 50 60 43
13 Stoke City Stoke City 38 34 45 42
14 Southampton Southampton 38 49 60 41
15 Aston Villa Aston Villa 38 47 69 41
16 Newcastle Newcastle 38 45 68 41
17 Sunderland Sunderland 38 41 54 39
18 Wigan Athletic Wigan 38 47 73 36
19 Reading Reading 38 43 73 28
20 Queens Park Rangers Queens Park 38 30 60 25
TEMPORADA 2011/2012
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester City Manchester 38 93 29 89
2 Manchester United Manchester 38 89 33 89
3 Arsenal Arsenal 38 74 49 70
4 Tottenham Hotspur Tottenham 38 66 41 69
5 Newcastle Newcastle 38 56 51 65
6 Chelsea Chelsea 38 65 46 64
7 Everton Everton 38 50 40 56
8 Liverpool Liverpool 38 47 40 52
9 Fulham Fulham 38 48 51 52
10 West Bromwich Albion West 38 45 52 47
11 Swansea City Swansea City 38 44 51 47
12 Norwich City Norwich City 38 52 66 47
13 Sunderland Sunderland 38 45 46 45
14 Stoke City Stoke City 38 36 53 45
15 Wigan Athletic Wigan 38 42 62 43
16 Aston Villa Aston Villa 38 37 53 38
17 Queens Park Rangers Queens Park 38 43 66 37
18 Bolton Wanderers Bolton 38 46 77 36
19 Blackburn Rovers Blackburn 38 48 78 31
20 Wolves Wolves 38 40 82 25
TEMPORADA 2010/2011
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester United Manchester 38 78 37 80
2 Chelsea Chelsea 38 69 33 71
3 Manchester City Manchester 38 60 33 71
4 Arsenal Arsenal 38 72 43 68
5 Tottenham Hotspur Tottenham 38 55 46 62
6 Liverpool Liverpool 38 59 44 58
7 Everton Everton 38 51 45 54
8 Fulham Fulham 38 49 43 49
9 Aston Villa Aston Villa 38 48 59 48
10 Sunderland Sunderland 38 45 56 47
11 West Bromwich Albion West 38 56 71 47
12 Newcastle Newcastle 38 56 57 46
13 Stoke City Stoke City 38 46 48 46
14 Bolton Wanderers Bolton 38 52 56 46
15 Blackburn Rovers Blackburn 38 46 59 43
16 Wigan Athletic Wigan 38 40 61 42
17 Wolves Wolves 38 46 66 40
18 Birmingham City Birmingham 38 37 58 39
19 Blackpool Blackpool 38 55 78 39
20 West Ham West Ham 38 43 70 33
TEMPORADA 2009/2010
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Chelsea Chelsea 38 103 32 86
2 Manchester United Manchester 38 86 28 85
3 Arsenal Arsenal 38 83 41 75
4 Tottenham Hotspur Tottenham 38 67 41 70
5 Manchester City Manchester 38 73 45 67
6 Aston Villa Aston Villa 38 52 39 64
7 Liverpool Liverpool 38 61 35 63
8 Everton Everton 38 60 49 61
9 Birmingham City Birmingham 38 38 47 50
10 Blackburn Rovers Blackburn 38 41 55 50
11 Stoke City Stoke City 38 34 48 47
12 Fulham Fulham 38 39 46 46
13 Sunderland Sunderland 38 48 56 44
14 Bolton Wanderers Bolton 38 42 67 39
15 Wolves Wolves 38 32 56 38
16 Wigan Athletic Wigan 38 37 79 36
17 West Ham West Ham 38 47 66 35
18 Burnley Burnley 38 42 82 30
19 Hull City Hull City 38 34 75 30
20 Portsmouth Portsmouth 38 34 66 19
TEMPORADA 2008/2009
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester United Manchester 38 68 24 90
2 Liverpool Liverpool 38 77 27 86
3 Chelsea Chelsea 38 68 24 83
4 Arsenal Arsenal 38 68 37 72
5 Everton Everton 38 55 37 63
6 Aston Villa Aston Villa 38 54 48 62
7 Fulham Fulham 38 39 34 53
8 Tottenham Hotspur Tottenham 38 45 45 51
9 West Ham West Ham 38 42 45 51
10 Manchester City Manchester 38 58 50 50
11 Wigan Athletic Wigan 38 34 45 45
12 Stoke City Stoke City 38 38 55 45
13 Bolton Wanderers Bolton 38 41 53 41
14 Portsmouth Portsmouth 38 38 57 41
15 Blackburn Rovers Blackburn 38 40 60 41
16 Sunderland Sunderland 38 34 54 36
17 Hull City Hull City 38 39 64 35
18 Newcastle Newcastle 38 40 59 34
19 Middlesbrough Middlesbroug 38 28 57 32
20 West Bromwich Albion West 38 36 67 32
TEMPORADA 2007/2008
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 West Bromwich Albion West 46 88 55 81
2 Stoke City Stoke City 46 69 55 79
3 Hull City Hull City 46 65 47 75
4 Bristol City Bristol City 46 54 53 74
5 Crystal Palace Crystal 46 58 42 71
6 Watford Watford 46 62 56 70
7 Wolves Wolves 46 53 48 70
8 Ipswich Town Ipswich Town 46 65 56 69
9 Sheffield United Sheffield 46 56 51 66
10 Plymouth Argyle Plymouth 46 60 50 64
11 Charlton Athletic Charlton 46 63 58 64
12 Cardiff City Cardiff City 46 59 55 64
13 Burnley Burnley 46 60 67 62
14 Queens Park Rangers Queens Park 46 60 66 58
15 Preston North End Preston 46 50 56 56
16 Sheffield Wednesday Sheffield 46 54 55 55
17 Norwich City Norwich City 46 49 59 55
18 Barnsley Barnsley 46 52 65 55
19 Blackpool Blackpool 46 59 64 54
20 Southampton Southampton 46 56 72 54
21 Coventry City Coventry 46 52 64 53
22 Leicester Leicester 46 42 45 52
23 Scunthorpe United Scunthorpe 46 46 69 46
24 Colchester United Colchester 46 62 86 38
TEMPORADA 2006/2007
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Sunderland Sunderland 46 76 47 88
2 Birmingham City Birmingham 46 67 42 86
3 Derby County Derby County 46 62 46 84
4 West Bromwich Albion West 46 81 55 76
5 Wolves Wolves 46 59 56 76
6 Southampton Southampton 46 77 53 75
7 Preston North End Preston 46 64 53 74
8 Stoke City Stoke City 46 62 41 73
9 Sheffield Wednesday Sheffield 46 70 66 71
10 Colchester United Colchester 46 70 56 69
11 Plymouth Argyle Plymouth 46 63 62 67
12 Crystal Palace Crystal 46 59 51 65
13 Cardiff City Cardiff City 46 57 53 64
14 Ipswich Town Ipswich Town 46 64 59 62
15 Burnley Burnley 46 52 49 57
16 Norwich City Norwich City 46 56 71 57
17 Coventry City Coventry 46 47 62 56
18 Queens Park Rangers Queens Park 46 54 68 53
19 Leicester Leicester 46 49 64 53
20 Barnsley Barnsley 46 53 85 50
21 Hull City Hull City 46 51 67 49
22 Leeds United Leeds United 46 46 72 46
23 Southend United Southend 46 47 80 42
24 Luton Town Luton Town 46 53 81 40
TEMPORADA 2005/2006
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Reading Reading 46 99 32 106
2 Sheffield United Sheffield 46 76 46 90
3 Watford Watford 46 77 53 81
4 Preston North End Preston 46 59 30 80
5 Leeds United Leeds United 46 57 38 78
6 Crystal Palace Crystal 46 67 48 75
7 Wolves Wolves 46 50 42 67
8 Coventry City Coventry 46 62 65 63
9 Norwich City Norwich City 46 56 65 62
10 Luton Town Luton Town 46 66 67 61
11 Cardiff City Cardiff City 46 58 59 60
12 Southampton Southampton 46 49 50 58
13 Stoke City Stoke City 46 54 63 58
14 Plymouth Argyle Plymouth 46 39 46 56
15 Ipswich Town Ipswich Town 46 53 66 56
16 Leicester Leicester 46 51 59 54
17 Burnley Burnley 46 46 54 54
18 Hull City Hull City 46 49 55 52
19 Sheffield Wednesday Sheffield 46 39 52 52
20 Derby County Derby County 46 53 67 50
21 Queens Park Rangers Queens Park 46 50 65 50
22 Crewe Alexandra Crewe 46 57 86 42
23 Millwall Millwall 46 35 62 40
24 Brighton & Hove Albion Brighton 46 39 71 38
TEMPORADA 2004/2005
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Sunderland Sunderland 46 76 41 94
2 Wigan Athletic Wigan 46 79 35 87
3 Ipswich Town Ipswich Town 46 85 56 85
4 Derby County Derby County 46 71 60 76
5 Preston North End Preston 46 67 58 75
6 West Ham West Ham 46 66 56 73
7 Reading Reading 46 51 44 70
8 Sheffield United Sheffield 46 57 56 67
9 Wolves Wolves 46 72 59 66
10 Millwall Millwall 46 51 45 66
11 Queens Park Rangers Queens Park 46 54 58 62
12 Stoke City Stoke City 46 36 38 61
13 Burnley Burnley 46 38 39 60
14 Leeds United Leeds United 46 49 52 60
15 Leicester Leicester 46 49 46 57
16 Cardiff City Cardiff City 46 48 51 54
17 Plymouth Argyle Plymouth 46 52 64 53
18 Watford Watford 46 52 59 52
19 Coventry City Coventry 46 61 73 52
20 Brighton & Hove Albion Brighton 46 40 65 51
21 Crewe Alexandra Crewe 46 66 86 50
22 Gillingham Gillingham 46 45 66 50
23 Nottingham Forest Nottingham 46 42 66 44
24 Rotherham United Rotherham 46 35 69 29

  USO DE MEMORIA  
9,303,336 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1950
Total Execution Time  0.1964
  CADENA URL  
/historico/Stoke-City
  GET DATOS  
$_GET['/historico/Stoke-City']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0039  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72258
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2429 AND type_rel = 2
0.0034  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.0020  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.0036  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.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 = 72033 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0037  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 (2023,2024,2025) 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 (72728,72258,72033,71432) 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.0035  SELECT count(id) as num_players from rel_players WHERE league_id = 72033 AND teamId = 2429
0.0070  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 2429
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 72258 AND teamId = 2429
0.0115  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2429
0.0043  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 72033 AND t.round = 45 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024  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.0023  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.0019  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '2429' and rp.type = 4
0.0054  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 events2024 e ON e.player_id = p.id AND e.league_id = 72033 WHERE rp.league_id = 72033 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.0048  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 events2024 e ON e.player_id = p.id AND e.league_id = 72033 WHERE rp.league_id = 72033 AND rp.teamId = 2429 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2024 e ON e.player_id = p.id AND e.league_id = 72033 WHERE rp.league_id = 72033 AND rp.teamId = 2429 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0041  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 <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0043  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 `tables2024` 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 = 72033 AND t.round = 45 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 `tables2023` 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 = 67799 AND t.round = 46 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 `tables2021` 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 = 58333 AND t.round = 46 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 49880 AND t.round = 46 ORDER BY team.conference ASC,t.position 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 `tables2019` 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 = 43565 AND t.round = 46 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 `tables2018` 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 = 38633 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2017` 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 = 29314 AND t.round = 38 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 `tables2014` 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 = 2435 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` 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 = 1900 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2011` 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 = 1068 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` 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 = 810 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` 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 = 150 AND t.round = 38 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 `tables2007` 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 = 155 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` 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 = 154 AND t.round = 46 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 `tables2005` 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 = 153 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC