4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Leicester Leicester 44 86 39 94
2 Ipswich Town Ipswich Town 44 87 54 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 66 58 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
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester City Manchester 38 99 26 93
2 Liverpool Liverpool 38 94 26 92
3 Chelsea Chelsea 38 76 33 74
4 Tottenham Hotspur Tottenham 38 69 40 71
5 Arsenal Arsenal 38 61 48 69
6 Manchester United Manchester 38 57 57 58
7 West Ham West Ham 38 60 51 56
8 Leicester Leicester 38 62 59 52
9 Brighton & Hove Albion Brighton 38 42 44 51
10 Wolves Wolves 38 38 43 51
11 Newcastle Newcastle 38 44 62 49
12 Crystal Palace Crystal 38 50 46 48
13 Brentford Brentford 38 48 56 46
14 Aston Villa Aston Villa 38 52 54 45
15 Southampton Southampton 38 43 67 40
16 Everton Everton 38 43 66 39
17 Leeds United Leeds United 38 42 79 38
18 Burnley Burnley 38 34 53 35
19 Watford Watford 38 34 77 23
20 Norwich City Norwich City 38 23 84 22
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
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Liverpool Liverpool 38 85 33 99
2 Manchester City Manchester 38 102 35 81
3 Manchester United Manchester 38 66 36 66
4 Chelsea Chelsea 38 69 54 66
5 Leicester Leicester 38 67 41 62
6 Tottenham Hotspur Tottenham 38 61 47 59
7 Wolves Wolves 38 51 40 59
8 Arsenal Arsenal 38 56 48 56
9 Sheffield United Sheffield 38 39 39 54
10 Burnley Burnley 38 43 50 54
11 Southampton Southampton 38 51 60 52
12 Everton Everton 38 44 56 49
13 Newcastle Newcastle 38 38 58 44
14 Crystal Palace Crystal 38 31 50 43
15 Brighton & Hove Albion Brighton 38 39 54 41
16 West Ham West Ham 38 49 62 39
17 Aston Villa Aston Villa 38 41 67 35
18 AFC Bournemouth Bournemouth 38 40 65 34
19 Watford Watford 38 36 64 34
20 Norwich City Norwich City 38 26 75 21
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
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Wolves Wolves 46 82 39 99
2 Cardiff City Cardiff City 46 69 39 90
3 Fulham Fulham 46 79 46 88
4 Aston Villa Aston Villa 46 72 42 83
5 Middlesbrough Middlesbroug 46 67 45 76
6 Derby County Derby County 46 70 48 75
7 Preston North End Preston 46 57 46 73
8 Millwall Millwall 46 56 45 72
9 Brentford Brentford 46 62 52 69
10 Sheffield United Sheffield 46 62 55 69
11 Bristol City Bristol City 46 67 58 67
12 Ipswich Town Ipswich Town 46 57 60 60
13 Leeds United Leeds United 46 59 64 60
14 Norwich City Norwich City 46 49 60 60
15 Sheffield Wednesday Sheffield 46 59 60 57
16 Queens Park Rangers Queens Park 46 58 70 56
17 Nottingham Forest Nottingham 46 51 65 53
18 Hull City Hull City 46 70 70 49
19 Birmingham City Birmingham 46 38 68 46
20 Reading Reading 46 48 70 44
21 Bolton Wanderers Bolton 46 39 74 43
22 Barnsley Barnsley 46 48 72 41
23 Burton Albion Burton 46 38 81 41
24 Sunderland Sunderland 46 52 80 37
TEMPORADA 2016/2017
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Newcastle Newcastle 46 85 40 94
2 Brighton & Hove Albion Brighton 46 74 40 93
3 Reading Reading 46 68 64 85
4 Sheffield Wednesday Sheffield 46 60 45 81
5 Huddersfield Town Huddersfield 46 56 58 81
6 Fulham Fulham 46 85 57 80
7 Leeds United Leeds United 46 61 47 75
8 Norwich City Norwich City 46 85 69 70
9 Derby County Derby County 46 54 50 67
10 Brentford Brentford 46 75 65 64
11 Preston North End Preston 46 64 63 62
12 Cardiff City Cardiff City 46 60 61 62
13 Aston Villa Aston Villa 46 47 48 62
14 Barnsley Barnsley 46 64 67 58
15 Wolves Wolves 46 54 58 58
16 Ipswich Town Ipswich Town 46 48 58 55
17 Bristol City Bristol City 46 60 66 54
18 Queens Park Rangers Queens Park 46 52 66 53
19 Birmingham City Birmingham 46 45 64 53
20 Burton Albion Burton 46 49 63 52
21 Nottingham Forest Nottingham 46 62 72 51
22 Blackburn Rovers Blackburn 46 53 65 51
23 Wigan Athletic Wigan 46 40 57 42
24 Rotherham United Rotherham 46 40 98 23
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
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 AFC Bournemouth Bournemouth 46 98 45 90
2 Watford Watford 46 91 50 89
3 Norwich City Norwich City 46 88 48 86
4 Middlesbrough Middlesbroug 46 68 37 85
5 Brentford Brentford 46 78 59 78
6 Ipswich Town Ipswich Town 46 72 54 78
7 Wolves Wolves 46 70 56 78
8 Derby County Derby County 46 85 56 77
9 Blackburn Rovers Blackburn 46 66 59 67
10 Birmingham City Birmingham 46 54 64 63
11 Cardiff City Cardiff City 46 57 61 62
12 Charlton Athletic Charlton 46 54 60 60
13 Sheffield Wednesday Sheffield 46 43 49 60
14 Nottingham Forest Nottingham 46 71 69 59
15 Leeds United Leeds United 46 50 61 56
16 Huddersfield Town Huddersfield 46 58 75 55
17 Fulham Fulham 46 62 83 52
18 Bolton Wanderers Bolton 46 54 67 51
19 Reading Reading 46 48 69 50
20 Brighton & Hove Albion Brighton 46 44 54 47
21 Rotherham United Rotherham 46 46 67 46
22 Millwall Millwall 46 42 76 41
23 Wigan Athletic Wigan 46 39 64 39
24 Blackpool Blackpool 46 36 91 26
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
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Queens Park Rangers Queens Park 46 71 32 88
2 Norwich City Norwich City 46 83 58 84
3 Swansea City Swansea City 46 69 42 80
4 Cardiff City Cardiff City 46 76 54 80
5 Reading Reading 46 77 51 77
6 Nottingham Forest Nottingham 46 69 50 75
7 Leeds United Leeds United 46 81 70 72
8 Burnley Burnley 46 65 61 68
9 Millwall Millwall 46 62 48 67
10 Leicester Leicester 46 76 71 67
11 Hull City Hull City 46 52 51 65
12 Middlesbrough Middlesbroug 46 68 68 62
13 Ipswich Town Ipswich Town 46 62 68 62
14 Watford Watford 46 77 71 61
15 Bristol City Bristol City 46 62 65 60
16 Portsmouth Portsmouth 46 53 60 58
17 Barnsley Barnsley 46 55 66 56
18 Coventry City Coventry 46 54 58 55
19 Derby County Derby County 46 58 71 49
20 Crystal Palace Crystal 46 44 69 48
21 Doncaster Rovers Doncaster 46 55 81 48
22 Preston North End Preston 46 54 79 42
23 Sheffield United Sheffield 46 44 79 42
24 Scunthorpe United Scunthorpe 46 43 87 42
TEMPORADA 2009/2010
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Colchester United Colchester 1 7 1 3
2 Gillingham Gillingham 1 5 0 3
3 Brentford Brentford 1 3 1 3
4 Yeovil Town Yeovil Town 1 2 0 3
5 Charlton Athletic Charlton 1 3 2 3
6 Leeds United Leeds United 1 2 1 3
7 Leyton Orient Leyton 1 2 1 3
8 Walsall Walsall 1 1 0 3
9 Huddersfield Town Huddersfield 1 2 2 1
10 Southend United Southend 1 2 2 1
11 Millwall Millwall 1 1 1 1
12 Southampton Southampton 1 1 1 1
13 Hartlepool United Hartlepool 1 0 0 1
14 Milton Keynes Dons Milton 1 0 0 1
15 Oldham Athletic AFC Oldham 1 0 0 1
16 Stockport County Stockport 1 0 0 1
17 Wycombe Wanderers Wycombe 1 2 3 0
18 Bristol Rovers Bristol 1 1 2 0
19 Exeter City Exeter City 1 1 2 0
20 Brighton & Hove Albion Brighton 1 0 1 0
21 Carlisle United Carlisle 1 1 3 0
22 Tranmere Rovers Tranmere 1 0 2 0
23 Swindon Town Swindon Town 1 0 5 0
24 Norwich City Norwich City 1 1 7 0
TEMPORADA 2008/2009
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Wolves Wolves 46 80 52 90
2 Birmingham City Birmingham 46 54 37 83
3 Sheffield United Sheffield 46 64 39 80
4 Reading Reading 46 72 40 77
5 Burnley Burnley 46 72 60 76
6 Preston North End Preston 46 66 54 74
7 Cardiff City Cardiff City 46 65 53 74
8 Swansea City Swansea City 46 63 50 68
9 Ipswich Town Ipswich Town 46 62 53 66
10 Bristol City Bristol City 46 54 54 61
11 Queens Park Rangers Queens Park 46 42 44 61
12 Sheffield Wednesday Sheffield 46 51 58 61
13 Watford Watford 46 68 72 58
14 Doncaster Rovers Doncaster 46 42 53 58
15 Crystal Palace Crystal 46 52 55 57
16 Blackpool Blackpool 46 47 58 56
17 Coventry City Coventry 46 47 58 54
18 Derby County Derby County 46 55 67 54
19 Nottingham Forest Nottingham 46 50 65 53
20 Barnsley Barnsley 46 45 58 52
21 Plymouth Argyle Plymouth 46 44 57 51
22 Norwich City Norwich City 46 57 70 46
23 Southampton Southampton 46 46 69 45
24 Charlton Athletic Charlton 46 52 74 39
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
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Chelsea Chelsea 38 72 15 95
2 Arsenal Arsenal 38 87 36 83
3 Manchester United Manchester 38 58 26 77
4 Everton Everton 38 45 46 61
5 Liverpool Liverpool 38 52 41 58
6 Bolton Wanderers Bolton 38 49 44 58
7 Middlesbrough Middlesbroug 38 53 46 55
8 Manchester City Manchester 38 47 39 52
9 Tottenham Hotspur Tottenham 38 47 41 52
10 Aston Villa Aston Villa 38 45 52 47
11 Charlton Athletic Charlton 38 42 58 46
12 Birmingham City Birmingham 38 40 46 45
13 Fulham Fulham 38 52 60 44
14 Newcastle Newcastle 38 47 57 44
15 Blackburn Rovers Blackburn 38 32 43 42
16 Portsmouth Portsmouth 38 43 59 39
17 West Bromwich Albion West 38 36 61 34
18 Crystal Palace Crystal 38 41 62 33
19 Norwich City Norwich City 38 42 77 33
20 Southampton Southampton 38 45 66 32

  USO DE MEMORIA  
9,306,488 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.6674
Total Execution Time  0.6688
  CADENA URL  
/historico/Norwich-City-Fc
  GET DATOS  
$_GET['/historico/Norwich-City-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0176  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 = 'Norwich-City-Fc' AND l.year = 2024 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.0145  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=1824 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=1824 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  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=1824 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  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=1824 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=1824 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1824 AND type_rel = 2
0.0156  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1824 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148  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 (2195,2300,2354,4357,5489) ORDER BY n.cover_points DESC, update_date DESC
0.0157  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 = '1824' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0174  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 = '1824' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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.0155  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=1824 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 72033 AND teamId = 1824
0.0158  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 1824
0.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 72258 AND teamId = 1824
0.0242  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1824
0.0164  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 = 1824 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.0172  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 = 1824 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0159  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 = 1824 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0161  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 = 1824 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0294  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.0155  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 `tables2022` 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 = 62729 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 = 49845 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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.0154  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 `tables2016` 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 = 15131 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0170  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 `tables2015` 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 = 3812 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0170  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.0172  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.0166  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 `tables2012` 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 = 1315 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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