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

Chesterfield

Entrenador: Paul Cook

Temporada 2023/2024
TEMPORADA 2023/2024
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Chesterfield Chesterfield 46 106 65 98
2 Barnet Barnet 46 91 60 86
3 Bromley Bromley 46 73 49 81
4 Altrincham Altrincham 46 84 59 77
5 Solihull Moors Solihull 46 71 62 76
6 Gateshead Gateshead 46 88 64 75
7 FC Halifax Town Halifax Town 46 58 50 71
8 Aldershot Town Aldershot 46 74 83 69
9 Southend United Southend 46 70 45 65
10 Oldham Athletic AFC Oldham 46 63 60 63
11 Rochdale Rochdale 46 69 64 62
12 Hartlepool United Hartlepool 46 70 82 60
13 Eastleigh Eastleigh 46 73 87 59
14 Maidenhead United Maidenhead 46 60 67 58
15 Dagenham & Redbridge Dagenham 46 69 63 56
16 Wealdstone Wealdstone 46 60 72 56
17 Woking Woking 46 49 55 55
18 Fylde Fylde 46 74 82 55
19 Ebbsfleet United Ebbsfleet 46 59 74 54
20 York City York City 46 55 69 53
21 Boreham Wood Boreham Wood 46 59 73 52
22 Kidderminster Harriers Kidderminste 46 40 59 46
23 Dorking Wanderers Dorking 46 54 85 45
24 Oxford City Oxford City 46 54 94 33
TEMPORADA 2022/2023
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Wrexham AFC Wrexham AFC 46 116 43 111
2 Notts County Notts County 46 117 42 107
3 Chesterfield Chesterfield 46 81 52 84
4 Woking Woking 46 71 48 82
5 Barnet Barnet 46 75 67 74
6 Boreham Wood Boreham Wood 46 52 40 72
7 Bromley Bromley 46 68 53 71
8 Southend United Southend 46 57 45 69
9 Eastleigh Eastleigh 46 56 57 67
10 Dagenham & Redbridge Dagenham 46 61 72 63
11 FC Halifax Town Halifax Town 46 49 48 61
12 Oldham Athletic AFC Oldham 46 63 64 61
13 Wealdstone Wealdstone 46 57 72 60
14 Gateshead Gateshead 46 67 62 59
15 Solihull Moors Solihull 46 62 66 58
16 Dorking Wanderers Dorking 46 67 91 57
17 Altrincham Altrincham 46 68 82 56
18 Aldershot Town Aldershot 46 64 76 53
19 York City York City 46 55 63 51
20 Maidenhead United Maidenhead 46 47 66 50
21 Torquay United Torquay 46 58 80 48
22 Yeovil Town Yeovil Town 46 35 60 40
23 Scunthorpe United Scunthorpe 46 49 87 34
24 Maidstone United Maidstone 46 45 104 25
TEMPORADA 2021/2022
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Stockport County Stockport 44 87 38 94
2 Wrexham AFC Wrexham AFC 44 91 46 88
3 Solihull Moors Solihull 44 83 45 87
4 FC Halifax Town Halifax Town 44 62 35 84
5 Notts County Notts County 44 81 52 82
6 Grimsby Town Grimsby Town 44 68 46 77
7 Chesterfield Chesterfield 44 69 51 74
8 Dagenham & Redbridge Dagenham 44 80 53 73
9 Boreham Wood Boreham Wood 44 49 40 67
10 Bromley Bromley 44 61 53 67
11 Torquay United Torquay 44 66 54 66
12 Yeovil Town Yeovil Town 44 43 46 59
13 Southend United Southend 44 45 61 58
14 Altrincham Altrincham 44 62 69 55
15 Woking Woking 44 59 61 53
16 Wealdstone Wealdstone 44 51 65 53
17 Maidenhead United Maidenhead 44 48 67 51
18 Barnet Barnet 44 59 89 50
19 Eastleigh Eastleigh 44 52 74 46
20 Aldershot Town Aldershot 44 46 73 43
21 Kings Lynn Town Kings Lynn. 44 47 79 34
22 Weymouth Weymouth 44 40 88 28
23 Dover Athletic Dover 44 37 101 1
TEMPORADA 2020/2021
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Sutton United Sutton 42 72 36 84
2 Torquay United Torquay 42 68 39 80
3 Stockport County Stockport 42 69 32 77
4 Hartlepool United Hartlepool 42 66 43 76
5 Notts County Notts County 42 62 41 70
6 Chesterfield Chesterfield 42 60 43 69
7 Bromley Bromley 42 63 53 69
8 Wrexham AFC Wrexham AFC 42 64 43 68
9 Eastleigh Eastleigh 42 49 40 66
10 FC Halifax Town Halifax Town 42 63 54 65
11 Solihull Moors Solihull 42 58 48 64
12 Dagenham & Redbridge Dagenham 42 53 48 60
13 Maidenhead United Maidenhead 42 62 60 56
14 Boreham Wood Boreham Wood 42 52 48 55
15 Aldershot Town Aldershot 42 59 66 52
16 Yeovil Town Yeovil Town 42 58 68 52
17 Altrincham Altrincham 42 46 60 47
18 Weymouth Weymouth 42 45 71 39
19 Wealdstone Wealdstone 42 49 99 37
20 Woking Woking 42 42 69 33
21 Kings Lynn Town Kings Lynn. 42 50 98 31
22 Barnet Barnet 42 37 88 31
23 Dover Athletic Dover 0 0 0 0
TEMPORADA 2019/2020
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Barrow Barrow 37 68 39 70
2 Harrogate Town Harrogate 37 61 44 66
3 Notts County Notts County 38 61 38 63
4 Yeovil Town Yeovil Town 37 61 44 60
5 Boreham Wood Boreham Wood 37 55 40 60
6 FC Halifax Town Halifax Town 37 50 49 58
7 Barnet Barnet 35 52 42 54
8 Stockport County Stockport 39 51 54 58
9 Solihull Moors Solihull 38 48 37 55
10 Woking Woking 38 50 55 55
11 Dover Athletic Dover 38 49 49 54
12 Hartlepool United Hartlepool 39 56 50 55
13 Bromley Bromley 38 57 52 52
14 Torquay United Torquay 36 56 61 48
15 Sutton United Sutton 38 47 42 50
16 Eastleigh Eastleigh 37 43 55 46
17 Dagenham & Redbridge Dagenham 37 40 44 44
18 Aldershot Town Aldershot 39 43 55 46
19 Wrexham AFC Wrexham AFC 37 46 49 43
20 Chesterfield Chesterfield 38 55 65 44
21 Maidenhead United Maidenhead 38 44 58 41
22 Ebbsfleet United Ebbsfleet 39 47 68 42
23 Fylde Fylde 37 44 60 39
24 Chorley Chorley 38 31 65 26
TEMPORADA 2018/2019
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Leyton Orient Leyton 46 73 35 89
2 Solihull Moors Solihull 46 73 43 86
3 Salford City Salford City 46 77 45 85
4 Wrexham AFC Wrexham AFC 46 58 39 84
5 Fylde Fylde 46 72 41 81
6 Harrogate Town Harrogate 46 78 57 74
7 Eastleigh Eastleigh 46 62 63 74
8 Ebbsfleet United Ebbsfleet 46 64 50 67
9 Gateshead Gateshead 46 52 48 66
10 Sutton United Sutton 46 55 60 65
11 Barrow Barrow 46 52 51 64
12 Bromley Bromley 46 68 69 60
13 Barnet Barnet 46 45 50 60
14 Dover Athletic Dover 46 58 64 60
15 Chesterfield Chesterfield 46 55 53 59
16 FC Halifax Town Halifax Town 46 44 43 59
17 Hartlepool United Hartlepool 46 56 62 59
18 Dagenham & Redbridge Dagenham 46 50 56 56
19 Maidenhead United Maidenhead 46 45 70 54
20 Boreham Wood Boreham Wood 46 53 65 52
21 Aldershot Town Aldershot 46 38 67 44
22 Braintree Town Braintree 46 48 78 41
23 Havant & Waterlooville Havant 46 62 84 40
24 Maidstone United Maidstone 46 37 82 34
TEMPORADA 2017/2018
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Accrington Stanley Accrington 46 76 46 93
2 Luton Town Luton Town 46 94 46 88
3 Wycombe Wanderers Wycombe 46 79 60 84
4 Exeter City Exeter City 46 64 54 80
5 Notts County Notts County 46 71 48 77
6 Coventry City Coventry 46 64 47 75
7 Lincoln City Lincoln City 46 64 48 75
8 Mansfield Town Mansfield 46 67 52 72
9 Swindon Town Swindon Town 46 67 65 68
10 Carlisle United Carlisle 46 62 54 67
11 Newport County Newport 46 56 58 64
12 Cambridge United Cambridge 46 56 60 64
13 Colchester United Colchester 46 53 52 62
14 Crawley Town Crawley Town 46 58 66 59
15 Crewe Alexandra Crewe 46 62 75 56
16 Stevenage Stevenage 46 60 65 55
17 Cheltenham Town Cheltenham 46 67 73 51
18 Grimsby Town Grimsby Town 46 42 66 51
19 Yeovil Town Yeovil Town 46 59 75 48
20 Port Vale Port Vale 46 49 67 47
21 Forest Green Rovers Forest Green 46 54 77 47
22 Morecambe Morecambe 46 41 56 46
23 Barnet Barnet 46 46 65 46
24 Chesterfield Chesterfield 46 47 83 38
TEMPORADA 2016/2017
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Sheffield United Sheffield 46 92 47 100
2 Bolton Wanderers Bolton 46 68 36 86
3 Scunthorpe United Scunthorpe 46 80 54 82
4 Fleetwood Town Fleetwood 46 64 43 82
5 Bradford City Bradford 46 62 43 79
6 Millwall Millwall 46 66 57 73
7 Southend United Southend 46 70 53 72
8 Oxford United Oxford 46 65 52 69
9 Rochdale Rochdale 46 71 62 69
10 Bristol Rovers Bristol 46 68 70 66
11 Peterborough United Peterborough 46 61 62 62
12 Milton Keynes Dons Milton 46 60 58 61
13 Charlton Athletic Charlton 46 60 53 60
14 Walsall Walsall 46 51 58 58
15 AFC Wimbledon Wimbledon 46 52 55 57
16 Northampton Northampton 46 60 73 53
17 Oldham Athletic AFC Oldham 46 31 44 53
18 Shrewsbury Town Shrewsbury 46 46 63 51
19 Bury Bury 46 61 73 50
20 Gillingham Gillingham 46 59 79 50
21 Port Vale Port Vale 46 45 69 49
22 Swindon Town Swindon Town 46 44 66 44
23 Coventry City Coventry 46 37 68 39
24 Chesterfield Chesterfield 46 43 78 37
TEMPORADA 2015/2016
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Wigan Athletic Wigan 46 82 45 87
2 Burton Albion Burton 46 57 37 85
3 Walsall Walsall 46 71 49 84
4 Millwall Millwall 46 73 49 81
5 Bradford City Bradford 46 55 40 80
6 Barnsley Barnsley 46 70 54 74
7 Scunthorpe United Scunthorpe 46 60 47 74
8 Coventry City Coventry 46 67 49 69
9 Gillingham Gillingham 46 71 56 69
10 Rochdale Rochdale 46 68 61 69
11 Sheffield United Sheffield 46 64 59 66
12 Port Vale Port Vale 46 56 58 65
13 Peterborough United Peterborough 46 82 73 63
14 Bury Bury 46 56 73 60
15 Southend United Southend 46 58 64 59
16 Swindon Town Swindon Town 46 64 71 59
17 Oldham Athletic AFC Oldham 46 44 58 54
18 Chesterfield Chesterfield 46 58 70 53
19 Fleetwood Town Fleetwood 46 52 56 51
20 Shrewsbury Town Shrewsbury 46 58 79 50
21 Doncaster Rovers Doncaster 46 48 64 46
22 Blackpool Blackpool 46 40 63 46
23 Colchester United Colchester 46 57 99 40
24 Crewe Alexandra Crewe 46 46 83 34
TEMPORADA 2014/2015
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Bristol City Bristol City 46 96 38 99
2 Milton Keynes Dons Milton 46 101 44 91
3 Preston North End Preston 46 79 40 89
4 Swindon Town Swindon Town 46 76 57 79
5 Sheffield United Sheffield 46 66 53 71
6 Chesterfield Chesterfield 46 68 55 69
7 Bradford City Bradford 46 55 55 65
8 Rochdale Rochdale 46 72 66 63
9 Peterborough United Peterborough 46 53 56 63
10 Fleetwood Town Fleetwood 46 49 52 63
11 Barnsley Barnsley 46 62 61 62
12 Gillingham Gillingham 46 65 66 62
13 Doncaster Rovers Doncaster 46 58 62 61
14 Walsall Walsall 46 50 54 59
15 Oldham Athletic AFC Oldham 46 54 67 57
16 Scunthorpe United Scunthorpe 46 62 75 56
17 Coventry City Coventry 46 49 60 55
18 Port Vale Port Vale 46 55 65 54
19 Colchester United Colchester 46 58 77 52
20 Crewe Alexandra Crewe 46 43 75 52
21 Notts County Notts County 46 45 63 50
22 Crawley Town Crawley Town 46 53 79 50
23 Leyton Orient Leyton 46 59 69 49
24 Yeovil Town Yeovil Town 46 36 75 40
TEMPORADA 2013/2014
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Chesterfield Chesterfield 46 71 40 84
2 Scunthorpe United Scunthorpe 46 68 44 81
3 Rochdale Rochdale 46 69 48 81
4 Fleetwood Town Fleetwood 46 66 52 76
5 Southend United Southend 46 56 39 72
6 Burton Albion Burton 46 47 42 72
7 York City York City 46 52 41 71
8 Oxford United Oxford 46 53 50 62
9 Dagenham & Redbridge Dagenham 46 53 59 60
10 Plymouth Argyle Plymouth 46 51 58 60
11 Mansfield Town Mansfield 46 49 58 60
12 Bury Bury 46 59 51 59
13 Portsmouth Portsmouth 46 56 66 59
14 Newport County Newport 46 56 59 58
15 Accrington Stanley Accrington 46 54 56 57
16 AFC Wimbledon Wimbledon 46 49 57 56
17 Exeter City Exeter City 46 54 57 55
18 Cheltenham Town Cheltenham 46 53 63 55
19 Morecambe Morecambe 46 52 64 54
20 Hartlepool United Hartlepool 46 50 56 53
21 Northampton Northampton 46 42 57 53
22 Wycombe Wanderers Wycombe 46 46 54 50
23 Bristol Rovers Bristol 46 43 54 50
24 Torquay United Torquay 46 42 66 45
TEMPORADA 2012/2013
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Gillingham Gillingham 46 66 39 83
2 Rotherham United Rotherham 46 74 59 79
3 Port Vale Port Vale 46 87 52 78
4 Burton Albion Burton 46 71 66 76
5 Cheltenham Town Cheltenham 46 58 51 75
6 Northampton Northampton 46 64 55 73
7 Bradford City Bradford 46 63 52 69
8 Chesterfield Chesterfield 46 60 45 67
9 Oxford United Oxford 46 60 61 65
10 Exeter City Exeter City 46 63 62 64
11 Southend United Southend 46 61 55 61
12 Rochdale Rochdale 46 68 70 61
13 Fleetwood Town Fleetwood 46 55 57 60
14 Bristol Rovers Bristol 46 60 69 60
15 Wycombe Wanderers Wycombe 46 50 60 60
16 Morecambe Morecambe 46 55 61 58
17 York City York City 46 50 60 55
18 Accrington Stanley Accrington 46 51 68 54
19 Torquay United Torquay 46 55 62 53
20 AFC Wimbledon Wimbledon 46 54 76 53
21 Plymouth Argyle Plymouth 46 46 55 52
22 Dagenham & Redbridge Dagenham 46 55 62 51
23 Barnet Barnet 46 48 59 51
24 Aldershot Town Aldershot 46 42 60 48
TEMPORADA 2011/2012
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Charlton Athletic Charlton 46 82 36 101
2 Sheffield Wednesday Sheffield 46 81 48 93
3 Sheffield United Sheffield 46 92 51 90
4 Huddersfield Town Huddersfield 46 79 47 81
5 Milton Keynes Dons Milton 46 84 47 80
6 Stevenage Stevenage 46 69 44 73
7 Notts County Notts County 46 75 63 73
8 Carlisle United Carlisle 46 65 66 69
9 Brentford Brentford 46 63 52 67
10 Colchester United Colchester 46 61 66 59
11 AFC Bournemouth Bournemouth 46 48 52 58
12 Tranmere Rovers Tranmere 46 49 53 56
13 Hartlepool United Hartlepool 46 50 55 56
14 Bury Bury 46 60 79 56
15 Preston North End Preston 46 54 68 54
16 Oldham Athletic AFC Oldham 46 50 66 54
17 Yeovil Town Yeovil Town 46 59 80 54
18 Scunthorpe United Scunthorpe 46 55 59 52
19 Walsall Walsall 46 51 57 50
20 Leyton Orient Leyton 46 48 75 50
21 Wycombe Wanderers Wycombe 46 65 88 43
22 Chesterfield Chesterfield 46 56 81 42
23 Exeter City Exeter City 46 46 75 42
24 Rochdale Rochdale 46 47 81 38
TEMPORADA 2010/2011
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Chesterfield Chesterfield 46 85 51 86
2 Bury Bury 46 82 50 81
3 Wycombe Wanderers Wycombe 46 69 50 80
4 Shrewsbury Town Shrewsbury 46 72 49 79
5 Accrington Stanley Accrington 46 73 55 73
6 Torquay United Torquay 46 74 53 69
7 Stevenage Stevenage 46 62 45 69
8 Gillingham Gillingham 46 67 57 68
9 Rotherham United Rotherham 46 75 60 66
10 Crewe Alexandra Crewe 46 87 65 65
11 Port Vale Port Vale 46 54 49 65
12 Oxford United Oxford 46 58 60 63
13 Southend United Southend 46 62 56 61
14 Aldershot Town Aldershot 46 54 54 61
15 Macclesfield Town Macclesfield 46 59 73 55
16 Hereford United Hereford 46 50 66 53
17 Northampton Northampton 46 63 71 52
18 Cheltenham Town Cheltenham 46 56 77 52
19 Bradford City Bradford 46 43 68 52
20 Burton Albion Burton 46 56 70 51
21 Morecambe Morecambe 46 54 73 51
22 Barnet Barnet 46 58 77 48
23 Lincoln City Lincoln City 46 45 81 47
24 Stockport County Stockport 46 48 96 41
TEMPORADA 2009/2010
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Notts County Notts County 46 96 31 93
2 AFC Bournemouth Bournemouth 46 61 44 83
3 Rochdale Rochdale 46 82 48 82
4 Morecambe Morecambe 46 73 64 73
5 Rotherham United Rotherham 46 55 52 73
6 Aldershot Town Aldershot 46 69 56 72
7 Dagenham & Redbridge Dagenham 46 69 58 72
8 Chesterfield Chesterfield 46 61 62 70
9 Bury Bury 46 54 59 69
10 Port Vale Port Vale 46 61 50 68
11 Northampton Northampton 46 62 53 67
12 Shrewsbury Town Shrewsbury 46 55 54 63
13 Burton Albion Burton 46 71 71 62
14 Bradford City Bradford 46 59 62 62
15 Accrington Stanley Accrington 46 62 74 61
16 Hereford United Hereford 46 54 65 59
17 Torquay United Torquay 46 64 55 57
18 Crewe Alexandra Crewe 46 68 73 55
19 Macclesfield Town Macclesfield 46 49 58 54
20 Lincoln City Lincoln City 46 42 65 50
21 Barnet Barnet 46 47 63 48
22 Cheltenham Town Cheltenham 46 54 71 48
23 Grimsby Town Grimsby Town 46 45 71 44
24 Darlington FC Darlington 46 33 87 30
TEMPORADA 2008/2009
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Brentford Brentford 46 65 36 85
2 Exeter City Exeter City 46 65 50 79
3 Wycombe Wanderers Wycombe 46 54 33 78
4 Bury Bury 46 63 43 78
5 Rotherham United Rotherham 46 60 46 75
6 Gillingham Gillingham 46 58 55 75
7 Darlington FC Darlington 46 61 44 72
8 Rochdale Rochdale 46 70 59 70
9 Shrewsbury Town Shrewsbury 46 61 44 69
10 Dagenham & Redbridge Dagenham 46 77 53 68
11 Bradford City Bradford 46 66 55 67
12 AFC Bournemouth Bournemouth 46 59 51 63
13 Chesterfield Chesterfield 46 62 57 63
14 Morecambe Morecambe 46 53 56 63
15 Lincoln City Lincoln City 46 53 52 59
16 Luton Town Luton Town 46 58 65 56
17 Aldershot Town Aldershot 46 59 80 54
18 Accrington Stanley Accrington 46 42 59 50
19 Barnet Barnet 46 56 74 48
20 Port Vale Port Vale 46 44 66 48
21 Notts County Notts County 46 49 69 47
22 Macclesfield Town Macclesfield 46 45 77 47
23 Grimsby Town Grimsby Town 46 51 69 41
24 Chester Chester 46 43 81 37
TEMPORADA 2007/2008
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Milton Keynes Dons Milton 46 82 37 97
2 Peterborough United Peterborough 46 84 43 92
3 Hereford United Hereford 46 72 41 88
4 Stockport County Stockport 46 72 54 82
5 Rochdale Rochdale 46 77 54 80
6 Darlington FC Darlington 46 67 40 78
7 Wycombe Wanderers Wycombe 46 56 42 78
8 Rotherham United Rotherham 46 62 58 74
9 Chesterfield Chesterfield 46 76 56 69
10 Bradford City Bradford 46 63 61 62
11 Morecambe Morecambe 46 59 63 60
12 Barnet Barnet 46 56 63 60
13 Bury Bury 46 58 61 59
14 Brentford Brentford 46 52 70 59
15 Lincoln City Lincoln City 46 61 77 58
16 Grimsby Town Grimsby Town 46 55 66 55
17 Accrington Stanley Accrington 46 49 83 51
18 Shrewsbury Town Shrewsbury 46 56 65 50
19 Macclesfield Town Macclesfield 46 47 64 50
20 Dagenham & Redbridge Dagenham 46 49 70 49
21 Notts County Notts County 46 37 53 48
22 Chester Chester 46 51 68 47
23 Mansfield Town Mansfield 46 48 68 42
24 Wrexham AFC Wrexham AFC 46 38 70 40
TEMPORADA 2006/2007
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Scunthorpe United Scunthorpe 46 73 35 91
2 Bristol City Bristol City 46 63 39 85
3 Blackpool Blackpool 46 76 49 83
4 Nottingham Forest Nottingham 46 65 41 82
5 Yeovil Town Yeovil Town 46 55 39 79
6 Oldham Athletic AFC Oldham 46 69 47 75
7 Swansea City Swansea City 46 69 53 72
8 Carlisle United Carlisle 46 54 55 68
9 Tranmere Rovers Tranmere 46 58 53 67
10 Millwall Millwall 46 59 62 66
11 Doncaster Rovers Doncaster 46 52 47 63
12 Port Vale Port Vale 46 64 65 60
13 Crewe Alexandra Crewe 46 66 72 60
14 Northampton Northampton 46 48 51 59
15 Huddersfield Town Huddersfield 46 60 69 59
16 Gillingham Gillingham 46 56 77 59
17 Cheltenham Town Cheltenham 46 49 61 54
18 Brighton & Hove Albion Brighton 46 49 58 53
19 AFC Bournemouth Bournemouth 46 50 64 52
20 Leyton Orient Leyton 46 61 77 51
21 Rotherham United Rotherham 46 58 75 48
22 Chesterfield Chesterfield 46 45 53 47
23 Bradford City Bradford 46 47 65 47
24 Brentford Brentford 46 40 79 37
TEMPORADA 2005/2006
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Southend United Southend 46 72 43 82
2 Colchester United Colchester 46 58 40 79
3 Brentford Brentford 46 72 52 76
4 Huddersfield Town Huddersfield 46 72 59 73
5 Barnsley Barnsley 46 62 44 72
6 Swansea City Swansea City 46 78 55 71
7 Nottingham Forest Nottingham 46 67 52 69
8 Doncaster Rovers Doncaster 46 55 51 69
9 Bristol City Bristol City 46 66 62 65
10 Oldham Athletic AFC Oldham 46 58 60 65
11 Bradford City Bradford 46 51 49 61
12 Scunthorpe United Scunthorpe 46 68 73 60
13 Port Vale Port Vale 46 49 54 60
14 Gillingham Gillingham 46 50 64 60
15 Yeovil Town Yeovil Town 46 54 62 56
16 Chesterfield Chesterfield 46 63 73 56
17 AFC Bournemouth Bournemouth 46 49 53 55
18 Tranmere Rovers Tranmere 46 50 52 54
19 Blackpool Blackpool 46 56 64 53
20 Rotherham United Rotherham 46 52 62 52
21 Hartlepool United Hartlepool 46 44 59 50
22 Milton Keynes Dons Milton 46 45 66 50
23 Swindon Town Swindon Town 46 46 65 48
24 Walsall Walsall 46 47 70 47
TEMPORADA 2004/2005
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Luton Town Luton Town 46 87 48 98
2 Hull City Hull City 46 80 53 86
3 Tranmere Rovers Tranmere 46 73 55 79
4 Brentford Brentford 46 57 60 75
5 Sheffield Wednesday Sheffield 46 77 59 72
6 Hartlepool United Hartlepool 46 76 66 71
7 Bristol City Bristol City 46 74 57 70
8 AFC Bournemouth Bournemouth 46 77 64 70
9 Huddersfield Town Huddersfield 46 74 65 70
10 Doncaster Rovers Doncaster 46 65 60 66
11 Bradford City Bradford 46 64 62 65
12 Swindon Town Swindon Town 46 66 68 63
13 Barnsley Barnsley 46 69 64 61
14 Walsall Walsall 46 65 69 60
15 Colchester United Colchester 46 60 50 59
16 Blackpool Blackpool 46 54 59 57
17 Chesterfield Chesterfield 46 55 62 57
18 Port Vale Port Vale 46 49 59 56
19 Wrexham AFC Wrexham AFC 46 62 80 53
20 Oldham Athletic AFC Oldham 46 60 73 52
21 Milton Keynes Dons Milton 46 54 68 51
22 Torquay United Torquay 46 55 79 51
23 Peterborough United Peterborough 46 49 73 39
24 Stockport County Stockport 46 49 98 26

  USO DE MEMORIA  
9,534,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2000
Total Execution Time  0.2012
  CADENA URL  
/historico/Chesterfield
  GET DATOS  
$_GET['/historico/Chesterfield']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (49)  
0.0038  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 = 'Chesterfield' 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.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9201 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9201 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9201 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9201 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9201 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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 = 72111
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9201 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9201 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (69636,82339,85798,89209,121401) ORDER BY n.cover_points DESC, update_date DESC
0.0033  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 = '9201' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient 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 = '9201' 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 = 72111 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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 = 72677 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  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=9201 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,72677,72111,71574,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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72111 AND teamId = 9201
0.0036  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 9201
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71574 AND teamId = 9201
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 9201
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9201
0.0045  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 = 72111 AND t.round = 46 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '9201' 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 = '9201' and rp.type = 4
0.0020  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 = '9201' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0063  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 = 72111 WHERE rp.league_id = 72111 AND rp.teamId = 9201 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.0036  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 = 72111 WHERE rp.league_id = 72111 AND rp.teamId = 9201 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 72111 WHERE rp.league_id = 72111 AND rp.teamId = 9201 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036  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 = 9201 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0041  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 = 72111 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.0041  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 = 68217 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 `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 = 63246 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 `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 = 58730 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.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 50119 AND t.round = 39 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 = 44236 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 38701 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 `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 = 30628 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 `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 = 15149 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 `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 = 3887 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 `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 = 2439 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 `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 = 1918 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 `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 = 1317 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 `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 = 1073 AND t.round = 46 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 `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 = 443 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 `tables2008` 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 = 491 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 `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 = 477 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 478 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 479 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72111 ORDER BY nameShow LIMIT 100