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

Crystal Palace

Entrenador: Oliver Glasner

Temporada 1987/1988
TEMPORADA 1987/1988
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Millwall Millwall 42 70 48 79
2 Bradford City Bradford 42 72 50 77
3 Middlesbrough Middlesbroug 42 59 34 75
4 Aston Villa Aston Villa 42 67 41 74
5 Blackburn Rovers Blackburn 42 63 50 73
6 Crystal Palace Crystal 42 84 58 72
7 Leeds United Leeds United 42 60 51 65
8 Manchester City Manchester 42 76 56 62
9 Oldham Athletic AFC Oldham 42 70 63 62
10 Stoke City Stoke City 43 49 56 61
11 Ipswich Town Ipswich Town 42 57 50 60
12 Swindon Town Swindon Town 42 73 58 58
13 Barnsley Barnsley 42 59 57 56
14 Hull City Hull City 42 54 59 56
15 Plymouth Argyle Plymouth 42 63 65 53
16 Leicester Leicester 42 57 60 53
17 Birmingham City Birmingham 42 41 65 47
18 AFC Bournemouth Bournemouth 42 54 66 46
19 West Bromwich Albion West 42 46 63 46
20 Shrewsbury Town Shrewsbury 42 39 52 45
21 Sheffield United Sheffield 43 43 74 43
22 Reading Reading 42 43 69 40
23 Huddersfield Town Huddersfield 42 41 95 28
TEMPORADA 1986/1987
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Derby County Derby County 42 64 38 84
2 Portsmouth Portsmouth 42 53 28 78
3 Oldham Athletic AFC Oldham 42 65 44 75
4 Leeds United Leeds United 42 58 44 68
5 Ipswich Town Ipswich Town 42 59 43 64
6 Crystal Palace Crystal 42 51 53 62
7 Plymouth Argyle Plymouth 42 62 57 61
8 Stoke City Stoke City 42 63 53 58
9 Sheffield United Sheffield 42 50 49 58
10 Bradford City Bradford 42 62 62 55
11 Barnsley Barnsley 42 49 52 55
12 Blackburn Rovers Blackburn 42 45 55 55
13 Reading Reading 42 52 59 53
14 Hull City Hull City 42 41 55 53
15 West Bromwich Albion West 42 51 49 51
16 Millwall Millwall 42 39 45 51
17 Huddersfield Town Huddersfield 42 54 61 51
18 Shrewsbury Town Shrewsbury 42 41 53 51
19 Birmingham City Birmingham 42 47 59 50
20 Sunderland Sunderland 42 49 59 48
21 Grimsby Town Grimsby Town 42 39 59 44
22 Brighton & Hove Albion Brighton 42 37 54 39
TEMPORADA 1985/1986
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Norwich City Norwich City 42 84 37 84
2 Charlton Athletic Charlton 42 78 45 77
3 Wimbledon FC Wimbledon 42 58 37 76
4 Portsmouth Portsmouth 42 69 41 73
5 Crystal Palace Crystal 42 57 52 66
6 Hull City Hull City 42 65 55 64
7 Sheffield United Sheffield 42 64 63 62
8 Oldham Athletic AFC Oldham 42 62 61 60
9 Millwall Millwall 42 64 65 59
10 Stoke City Stoke City 42 48 50 57
11 Brighton & Hove Albion Brighton 42 64 64 56
12 Barnsley Barnsley 42 47 50 56
13 Bradford City Bradford 42 51 63 54
14 Leeds United Leeds United 42 56 72 53
15 Grimsby Town Grimsby Town 42 58 62 52
16 Huddersfield Town Huddersfield 42 51 67 52
17 Shrewsbury Town Shrewsbury 42 52 64 51
18 Sunderland Sunderland 42 47 61 50
19 Blackburn Rovers Blackburn 42 53 62 49
20 Carlisle United Carlisle 42 47 71 46
21 Middlesbrough Middlesbroug 42 44 53 45
22 Fulham Fulham 42 45 69 36
TEMPORADA 1984/1985
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Oxford United Oxford 42 84 36 84
2 Birmingham City Birmingham 42 59 33 82
3 Manchester City Manchester 42 66 40 74
4 Portsmouth Portsmouth 42 69 50 74
5 Blackburn Rovers Blackburn 42 66 41 73
6 Brighton & Hove Albion Brighton 42 54 34 72
7 Leeds United Leeds United 42 66 43 69
8 Shrewsbury Town Shrewsbury 42 66 53 65
9 Fulham Fulham 42 68 64 65
10 Grimsby Town Grimsby Town 42 72 64 62
11 Barnsley Barnsley 42 42 42 58
12 Wimbledon FC Wimbledon 42 71 75 58
13 Huddersfield Town Huddersfield 42 52 64 55
14 Oldham Athletic AFC Oldham 42 49 67 53
15 Crystal Palace Crystal 42 46 65 48
16 Carlisle United Carlisle 42 50 67 47
17 Charlton Athletic Charlton 42 51 63 45
18 Sheffield United Sheffield 42 54 66 44
19 Middlesbrough Middlesbroug 42 41 57 40
20 Notts County Notts County 42 45 73 37
21 Cardiff City Cardiff City 42 47 79 35
22 Wolves Wolves 42 37 79 33
TEMPORADA 1983/1984
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Chelsea Chelsea 42 90 40 88
2 Sheffield Wednesday Sheffield 42 72 34 88
3 Newcastle Newcastle 42 85 53 80
4 Manchester City Manchester 42 66 48 70
5 Grimsby Town Grimsby Town 42 60 47 70
6 Blackburn Rovers Blackburn 42 57 48 64
7 Carlisle United Carlisle 42 48 41 64
8 Shrewsbury Town Shrewsbury 42 49 53 61
9 Brighton & Hove Albion Brighton 42 69 60 60
10 Leeds United Leeds United 42 55 56 60
11 Fulham Fulham 42 60 53 57
12 Huddersfield Town Huddersfield 42 56 49 57
13 Charlton Athletic Charlton 42 53 64 57
14 Cardiff City Cardiff City 42 55 66 54
15 Barnsley Barnsley 42 57 53 52
16 Portsmouth Portsmouth 42 73 64 49
17 Middlesbrough Middlesbroug 42 41 47 49
18 Crystal Palace Crystal 42 42 52 47
19 Oldham Athletic AFC Oldham 42 47 73 47
20 Derby County Derby County 42 36 72 42
21 Swansea City Swansea City 42 36 85 29
22 Cambridge United Cambridge 42 28 77 24
TEMPORADA 1982/1983
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Queens Park Rangers Queens Park 42 77 36 85
2 Wolves Wolves 42 68 44 75
3 Leicester Leicester 42 72 44 70
4 Fulham Fulham 42 64 47 69
5 Newcastle Newcastle 42 75 53 67
6 Sheffield Wednesday Sheffield 42 60 47 63
7 Oldham Athletic AFC Oldham 42 64 47 61
8 Leeds United Leeds United 42 51 46 60
9 Shrewsbury Town Shrewsbury 42 48 48 59
10 Barnsley Barnsley 42 57 55 57
11 Blackburn Rovers Blackburn 42 58 58 57
12 Cambridge United Cambridge 42 42 60 51
13 Derby County Derby County 42 49 58 49
14 Carlisle United Carlisle 42 68 70 48
15 Crystal Palace Crystal 42 43 52 48
16 Middlesbrough Middlesbroug 42 46 67 48
17 Charlton Athletic Charlton 42 63 86 48
18 Chelsea Chelsea 42 51 61 47
19 Grimsby Town Grimsby Town 42 45 70 47
20 Rotherham United Rotherham 42 45 68 45
21 Burnley Burnley 42 56 66 44
22 Bolton Wanderers Bolton 42 42 61 44
TEMPORADA 1981/1982
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Luton Town Luton Town 42 86 46 88
2 Watford Watford 42 76 42 80
3 Norwich City Norwich City 42 64 50 71
4 Sheffield Wednesday Sheffield 42 55 51 70
5 Queens Park Rangers Queens Park 42 65 43 69
6 Barnsley Barnsley 42 59 41 67
7 Rotherham United Rotherham 42 66 54 67
8 Leicester Leicester 42 56 48 66
9 Newcastle Newcastle 42 52 50 62
10 Blackburn Rovers Blackburn 42 47 43 59
11 Oldham Athletic AFC Oldham 42 50 51 59
12 Chelsea Chelsea 42 60 60 57
13 Charlton Athletic Charlton 42 50 65 51
14 Cambridge United Cambridge 42 48 53 48
15 Crystal Palace Crystal 42 34 45 48
16 Derby County Derby County 42 53 68 48
17 Grimsby Town Grimsby Town 42 53 65 46
18 Shrewsbury Town Shrewsbury 42 37 57 46
19 Bolton Wanderers Bolton 42 39 61 46
20 Cardiff City Cardiff City 42 45 61 44
21 Wrexham AFC Wrexham AFC 42 40 56 44
22 Leyton Orient Leyton 42 36 61 39
TEMPORADA 1980/1981
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Aston Villa Aston Villa 42 72 40 60
2 Ipswich Town Ipswich Town 42 77 43 56
3 Arsenal Arsenal 42 61 45 53
4 West Bromwich Albion West 42 60 42 52
5 Liverpool Liverpool 42 62 42 51
6 Southampton Southampton 42 76 56 50
7 Nottingham Forest Nottingham 42 62 44 50
8 Manchester United Manchester 42 51 36 48
9 Leeds United Leeds United 42 39 47 44
10 Tottenham Hotspur Tottenham 42 70 68 43
11 Stoke City Stoke City 42 51 60 42
12 Manchester City Manchester 42 56 59 39
13 Birmingham City Birmingham 42 50 61 38
14 Middlesbrough Middlesbroug 42 53 61 37
15 Everton Everton 42 55 58 36
16 Coventry City Coventry 42 48 68 36
17 Sunderland Sunderland 42 52 53 35
18 Wolves Wolves 42 43 55 35
19 Brighton & Hove Albion Brighton 42 54 67 35
20 Norwich City Norwich City 42 49 73 33
21 Leicester Leicester 42 40 67 32
22 Crystal Palace Crystal 42 47 83 19
TEMPORADA 1979/1980
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Liverpool Liverpool 42 81 30 60
2 Manchester United Manchester 42 65 35 58
3 Ipswich Town Ipswich Town 42 68 39 53
4 Arsenal Arsenal 42 52 36 52
5 Nottingham Forest Nottingham 42 63 43 48
6 Wolves Wolves 42 58 47 47
7 Aston Villa Aston Villa 42 51 50 46
8 Southampton Southampton 42 65 53 45
9 Middlesbrough Middlesbroug 42 50 44 44
10 West Bromwich Albion West 42 54 50 41
11 Leeds United Leeds United 42 46 50 40
12 Norwich City Norwich City 42 58 66 40
13 Crystal Palace Crystal 42 41 50 40
14 Tottenham Hotspur Tottenham 42 52 62 40
15 Coventry City Coventry 42 56 66 39
16 Brighton & Hove Albion Brighton 42 47 57 37
17 Manchester City Manchester 42 43 66 37
18 Stoke City Stoke City 42 44 58 36
19 Everton Everton 42 43 51 35
20 Bristol City Bristol City 42 37 66 31
21 Derby County Derby County 42 47 67 30
22 Bolton Wanderers Bolton 42 38 73 25
TEMPORADA 1978/1979
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Brighton & Hove Albion Brighton 42 72 39 79
2 Sunderland Sunderland 42 70 44 77
3 Stoke City Stoke City 42 58 31 76
4 Crystal Palace Crystal 42 51 24 76
5 West Ham West Ham 42 70 39 68
6 Newcastle Newcastle 42 51 55 59
7 Notts County Notts County 42 48 60 58
8 Cardiff City Cardiff City 42 56 70 58
9 Leyton Orient Leyton 42 51 51 55
10 Fulham Fulham 42 50 47 54
11 Preston North End Preston 42 59 57 54
12 Burnley Burnley 42 51 62 54
13 Cambridge United Cambridge 42 44 52 52
14 Oldham Athletic AFC Oldham 42 52 61 52
15 Bristol Rovers Bristol 42 48 60 52
16 Wrexham AFC Wrexham AFC 42 45 42 50
17 Luton Town Luton Town 42 60 57 49
18 Leicester Leicester 42 43 52 47
19 Charlton Athletic Charlton 42 60 69 46
20 Sheffield United Sheffield 42 52 69 45
21 Millwall Millwall 42 42 61 43
22 Blackburn Rovers Blackburn 42 41 72 40
TEMPORADA 1977/1978
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Bolton Wanderers Bolton 42 63 33 82
2 Southampton Southampton 42 70 39 79
3 Brighton & Hove Albion Brighton 42 63 38 78
4 Tottenham Hotspur Tottenham 42 83 49 76
5 Blackburn Rovers Blackburn 42 56 60 61
6 Sunderland Sunderland 42 67 59 58
7 Stoke City Stoke City 42 53 49 58
8 Sheffield United Sheffield 42 62 73 56
9 Fulham Fulham 42 49 49 55
10 Oldham Athletic AFC Oldham 42 54 58 55
11 Burnley Burnley 42 56 64 55
12 Crystal Palace Crystal 42 50 47 54
13 Luton Town Luton Town 42 54 52 52
14 Charlton Athletic Charlton 42 55 68 51
15 Bristol Rovers Bristol 42 61 77 51
16 Cardiff City Cardiff City 42 51 71 51
17 Millwall Millwall 42 49 57 50
18 Blackpool Blackpool 42 59 60 49
19 Notts County Notts County 42 54 62 49
20 Leyton Orient Leyton 42 43 49 48
21 Mansfield Town Mansfield 42 49 69 41
22 Hull City Hull City 42 34 52 36
TEMPORADA 1973/1974
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Middlesbrough Middlesbroug 42 77 30 92
2 Luton Town Luton Town 42 64 51 69
3 Carlisle United Carlisle 42 61 48 69
4 Sunderland Sunderland 42 58 44 66
5 Blackpool Blackpool 42 57 40 64
6 Leyton Orient Leyton 42 55 42 63
7 Nottingham Forest Nottingham 42 57 43 60
8 West Bromwich Albion West 42 48 45 58
9 Fulham Fulham 42 39 43 58
10 Notts County Notts County 42 55 60 58
11 Bolton Wanderers Bolton 42 44 40 57
12 Millwall Millwall 42 51 51 56
13 Hull City Hull City 42 46 47 56
14 Aston Villa Aston Villa 42 48 45 54
15 Portsmouth Portsmouth 42 45 62 54
16 Bristol City Bristol City 42 47 54 52
17 Sheffield Wednesday Sheffield 42 51 63 47
18 Oxford United Oxford 42 35 46 46
19 Cardiff City Cardiff City 42 49 62 46
20 Crystal Palace Crystal 42 43 56 45
21 Preston North End Preston 42 40 62 41
22 Swindon Town Swindon Town 42 36 72 32
TEMPORADA 1972/1973
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Liverpool Liverpool 42 72 42 60
2 Arsenal Arsenal 42 57 43 57
3 Leeds United Leeds United 42 71 45 53
4 Ipswich Town Ipswich Town 42 55 45 48
5 Wolves Wolves 42 66 54 47
6 West Ham West Ham 42 67 53 46
7 Derby County Derby County 42 56 54 46
8 Tottenham Hotspur Tottenham 42 58 48 45
9 Newcastle Newcastle 42 60 51 45
10 Birmingham City Birmingham 42 53 54 42
11 Manchester City Manchester 42 57 60 41
12 Chelsea Chelsea 42 49 51 40
13 Southampton Southampton 42 47 52 40
14 Sheffield United Sheffield 42 51 59 40
15 Stoke City Stoke City 42 61 56 38
16 Leicester Leicester 42 40 46 37
17 Everton Everton 42 41 49 37
18 Manchester United Manchester 42 44 60 37
19 Coventry City Coventry 42 40 55 35
20 Norwich City Norwich City 42 36 63 32
21 Crystal Palace Crystal 42 41 58 30
22 West Bromwich Albion West 42 38 62 28
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
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Derby County Derby County 42 65 32 89
2 Crystal Palace Crystal 42 70 47 78
3 Charlton Athletic Charlton 42 61 52 68
4 Middlesbrough Middlesbroug 42 58 49 68
5 Cardiff City Cardiff City 42 67 54 67
6 Huddersfield Town Huddersfield 42 53 46 63
7 Birmingham City Birmingham 42 73 59 62
8 Millwall Millwall 42 57 49 60
9 Sheffield United Sheffield 42 61 50 59
10 Carlisle United Carlisle 42 46 49 58
11 Blackpool Blackpool 42 51 41 57
12 Hull City Hull City 42 59 52 55
13 Norwich City Norwich City 42 53 56 55
14 Preston North End Preston 42 38 44 51
15 Portsmouth Portsmouth 42 58 58 50
16 Blackburn Rovers Blackburn 42 52 63 50
17 Aston Villa Aston Villa 42 37 48 50
18 Bolton Wanderers Bolton 42 55 67 50
19 Bristol City Bristol City 42 46 53 49
20 Oxford United Oxford 42 34 55 45
21 Bury Bury 42 51 80 41
22 Fulham Fulham 42 40 81 32
TEMPORADA 1967/1968
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Queens Park Rangers Queens Park 42 67 36 83
2 Blackpool Blackpool 42 71 43 82
3 Ipswich Town Ipswich Town 42 79 44 81
4 Birmingham City Birmingham 42 83 51 71
5 Portsmouth Portsmouth 42 68 55 67
6 Middlesbrough Middlesbroug 42 60 54 63
7 Millwall Millwall 42 62 50 59
8 Blackburn Rovers Blackburn 42 56 49 59
9 Norwich City Norwich City 42 60 65 59
10 Carlisle United Carlisle 42 58 52 55
11 Crystal Palace Crystal 42 56 56 53
12 Bolton Wanderers Bolton 42 60 63 52
13 Aston Villa Aston Villa 42 54 64 52
14 Cardiff City Cardiff City 42 60 66 51
15 Huddersfield Town Huddersfield 42 46 61 51
16 Charlton Athletic Charlton 42 63 68 49
17 Derby County Derby County 42 71 78 49
18 Bristol City Bristol City 42 48 62 49
19 Hull City Hull City 42 58 73 49
20 Preston North End Preston 42 43 65 47
21 Rotherham United Rotherham 42 42 76 41
22 Plymouth Argyle Plymouth 42 38 72 36
TEMPORADA 1966/1967
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Wolves Wolves 42 88 48 83
2 Coventry City Coventry 42 74 43 82
3 Carlisle United Carlisle 42 71 54 75
4 Blackburn Rovers Blackburn 42 56 46 70
5 Huddersfield Town Huddersfield 42 58 46 69
6 Ipswich Town Ipswich Town 42 70 54 67
7 Crystal Palace Crystal 42 61 55 67
8 Millwall Millwall 42 49 58 63
9 Bolton Wanderers Bolton 42 64 58 56
10 Birmingham City Birmingham 42 70 66 56
11 Hull City Hull City 42 77 72 55
12 Preston North End Preston 42 65 67 55
13 Norwich City Norwich City 42 49 55 53
14 Portsmouth Portsmouth 42 59 70 52
15 Plymouth Argyle Plymouth 42 59 58 51
16 Bristol City Bristol City 42 56 62 50
17 Rotherham United Rotherham 42 61 70 49
18 Derby County Derby County 42 68 72 48
19 Charlton Athletic Charlton 42 49 53 48
20 Cardiff City Cardiff City 42 61 87 45
21 Northampton Northampton 42 47 84 42
22 Bury Bury 42 49 83 39
TEMPORADA 1965/1966
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Manchester City Manchester 42 76 44 81
2 Southampton Southampton 42 85 56 76
3 Coventry City Coventry 42 73 53 73
4 Wolves Wolves 42 87 61 70
5 Huddersfield Town Huddersfield 42 62 36 70
6 Bristol City Bristol City 42 63 48 68
7 Rotherham United Rotherham 42 75 74 62
8 Derby County Derby County 42 71 68 59
9 Bolton Wanderers Bolton 42 62 59 57
10 Birmingham City Birmingham 42 70 75 57
11 Carlisle United Carlisle 42 60 63 56
12 Portsmouth Portsmouth 42 74 78 56
13 Crystal Palace Crystal 42 47 52 55
14 Ipswich Town Ipswich Town 42 58 66 54
15 Norwich City Norwich City 42 52 52 51
16 Charlton Athletic Charlton 42 61 70 50
17 Plymouth Argyle Plymouth 42 54 63 49
18 Bury Bury 42 62 76 49
19 Preston North End Preston 42 62 70 48
20 Cardiff City Cardiff City 42 71 91 46
21 Middlesbrough Middlesbroug 42 58 86 43
22 Leyton Orient Leyton 42 38 80 28

  USO DE MEMORIA  
9,058,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7717
Total Execution Time  0.7730
  CADENA URL  
/historico/Crystal-Palace-Fc/1988
  GET DATOS  
$_GET['/historico/Crystal-Palace-Fc/1988']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0143  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 = 'Crystal-Palace-Fc' AND l.year = 1988 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=860 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=860 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=860 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=860 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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 = 23278
0.0130  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 14684
0.0131  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 23231
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=860 AND type_rel = 2
0.0149  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 860 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0132  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 (1312842,2190,3300,4711,5521) ORDER BY n.cover_points DESC, update_date DESC
0.0167  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 = '860' ORDER BY l.year DESC,cat.coefficient DESC
0.0169  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 = '860' AND l.year = 1988 ORDER BY l.year DESC,cat.coefficient DESC
0.0167  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 = '860' 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 = 23278 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136  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 = 23231 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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 = 14684 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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=860 AND l.year in (1987,1988,1989) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (23278,23232,14685) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 23278 AND teamId = 860
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 14685 AND teamId = 860
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 23232 AND teamId = 860
0.0136  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1988` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 23278 AND t.round = 44 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0133  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 events1988 e ON e.player_id = p.id AND e.league_id = 23278 WHERE rp.league_id = 23278 AND rp.teamId = 860 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.0133  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 events1988 e ON e.player_id = p.id AND e.league_id = 23278 WHERE rp.league_id = 23278 AND rp.teamId = 860 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137  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 events1988 e ON e.player_id = p.id AND e.league_id = 23278 WHERE rp.league_id = 23278 AND rp.teamId = 860 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0185  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 = 860 AND l.year <= 1988 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 `tables1988` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 23278 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 `tables1987` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 23274 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 `tables1986` 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 = 23273 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 `tables1985` 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 = 23270 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1984` 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 = 23265 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1983` 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 = 23216 AND t.round = 42 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 `tables1982` 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 = 23203 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 `tables1981` 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 = 5691 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 `tables1980` 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 = 5690 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 `tables1979` 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 = 23322 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1978` 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 = 23321 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 `tables1974` 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 = 23317 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1973` 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 = 5683 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 `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.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 = 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.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 `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.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 `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 = 23312 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 `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 = 23311 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 `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 = 23310 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 `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 = 23309 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC