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

Stockport County

Entrenador: Dave Challinor

Temporada 2016/2017
TEMPORADA 2016/2017
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 Fylde Fylde 42 109 60 88
2 Kidderminster Harriers Kidderminste 42 76 41 82
3 FC Halifax Town Halifax Town 42 81 43 80
4 Salford City Salford City 42 79 44 77
5 Darlington FC Darlington 42 89 67 76
6 Chorley Chorley 42 60 41 74
7 Brackley Town Brackley 42 66 43 73
8 Stockport County Stockport 42 59 41 73
9 Tamworth Tamworth 42 73 67 69
10 Gloucester City Gloucester 42 69 61 64
11 Harrogate Town Harrogate 42 71 63 59
12 Nuneaton Town Nuneaton 42 67 69 55
13 United of Manchester United 42 69 68 54
14 Curzon Ashton Curzon 42 63 72 52
15 Boston United Boston 42 54 72 47
16 Bradford Park Avenue Bradford 42 46 74 43
17 AFC Telford United Telford 42 38 57 42
18 Alfreton Town Alfreton 42 62 95 42
19 Gainsborough Trinity Gainsborough 42 51 84 36
20 Worcester City Worcester 42 44 63 35
21 Stalybridge Celtic Stalybridge 42 40 89 29
22 Altrincham Altrincham 42 39 91 21
TEMPORADA 2015/2016
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 Solihull Moors Solihull 42 84 48 85
2 North Ferriby United North 42 82 49 76
3 Fylde Fylde 42 76 53 75
4 Nuneaton Town Nuneaton 42 71 46 73
5 Harrogate Town Harrogate 42 73 46 72
6 Boston United Boston 42 73 60 71
7 Tamworth Tamworth 42 55 45 63
8 Chorley Chorley 42 64 55 63
9 Stockport County Stockport 42 50 49 59
10 Alfreton Town Alfreton 42 58 54 58
11 Curzon Ashton Curzon 42 55 52 57
12 Stalybridge Celtic Stalybridge 42 62 75 53
13 United of Manchester United 42 60 75 53
14 Bradford Park Avenue Bradford 42 51 59 50
15 Gloucester City Gloucester 42 39 49 50
16 Gainsborough Trinity Gainsborough 42 46 62 50
17 Worcester City Worcester 42 55 61 48
18 AFC Telford United Telford 42 47 60 47
19 Brackley Town Brackley 42 45 54 46
20 Lowestoft Town Lowestoft 42 48 69 46
21 Hednesford Town Hednesford 42 50 77 38
22 Corby Town Corby Town 42 47 93 32
TEMPORADA 2014/2015
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 Barrow Barrow 42 81 43 87
2 Fylde Fylde 42 93 43 85
3 Boston United Boston 42 75 51 72
4 Chorley Chorley 42 76 55 71
5 Guiseley Guiseley 42 68 49 70
6 Oxford City Oxford City 42 81 67 69
7 Tamworth Tamworth 42 66 57 69
8 Hednesford Town Hednesford 42 63 50 61
9 Worcester City Worcester 42 54 54 60
10 North Ferriby United North 42 65 63 58
11 Stockport County Stockport 42 56 59 57
12 Solihull Moors Solihull 42 68 63 55
13 Bradford Park Avenue Bradford 42 52 66 53
14 Gloucester City Gloucester 42 63 75 52
15 Harrogate Town Harrogate 42 50 62 52
16 Lowestoft Town Lowestoft 42 54 66 51
17 Gainsborough Trinity Gainsborough 42 59 67 50
18 Brackley Town Brackley 42 39 62 47
19 Stalybridge Celtic Stalybridge 42 54 70 45
20 Colwyn Bay Colwyn Bay 42 59 82 45
21 Leamington Leamington 42 59 74 40
22 Hyde Hyde 42 49 106 21
TEMPORADA 2013/2014
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 AFC Telford United Telford 42 82 53 85
2 North Ferriby United North 42 80 51 82
3 Altrincham Altrincham 42 95 51 81
4 Hednesford Town Hednesford 42 87 65 78
5 Guiseley Guiseley 42 78 56 78
6 Boston United Boston 42 85 60 72
7 Brackley Town Brackley 42 66 45 67
8 Solihull Moors Solihull 42 63 52 65
9 Harrogate Town Harrogate 42 75 59 63
10 Bradford Park Avenue Bradford 42 66 70 57
11 Barrow Barrow 42 50 56 56
12 Colwyn Bay Colwyn Bay 42 63 67 55
13 Leamington Leamington 42 54 53 52
14 Stockport County Stockport 42 58 57 50
15 Worcester City Worcester 42 40 53 50
16 Gainsborough Trinity Gainsborough 42 67 86 45
17 Gloucester City Gloucester 42 64 77 44
18 Vauxhall Motors Vauxhall 42 43 74 44
19 Stalybridge Celtic Stalybridge 42 57 88 39
20 Oxford City Oxford City 42 50 70 37
21 Histon Histon 42 42 76 32
22 Workington Workington 42 39 85 28
TEMPORADA 2012/2013
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Mansfield Town Mansfield 46 92 52 95
2 Kidderminster Harriers Kidderminste 46 82 40 93
3 Newport County Newport 46 85 60 85
4 Grimsby Town Grimsby Town 46 70 38 83
5 Wrexham AFC Wrexham AFC 46 74 45 80
6 Hereford United Hereford 46 73 63 70
7 Luton Town Luton Town 46 70 62 67
8 Dartford Dartford 46 67 63 66
9 Braintree Town Braintree 46 63 72 66
10 Forest Green Rovers Forest Green 46 63 49 65
11 Macclesfield Town Macclesfield 46 65 70 63
12 Woking Woking 46 73 81 62
13 Alfreton Town Alfreton 46 69 74 60
14 Cambridge United Cambridge 46 68 69 59
15 Nuneaton Town Nuneaton 46 55 63 57
16 Lincoln City Lincoln City 46 66 73 56
17 Gateshead Gateshead 46 58 61 55
18 Hyde Hyde 46 63 75 55
19 Tamworth Tamworth 46 55 69 55
20 Southport Southport 46 72 86 54
21 Stockport County Stockport 46 57 76 50
22 Barrow Barrow 46 45 83 46
23 Ebbsfleet United Ebbsfleet 46 55 89 39
24 AFC Telford United Telford 46 52 79 35
TEMPORADA 2011/2012
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Fleetwood Town Fleetwood 46 102 48 103
2 Wrexham AFC Wrexham AFC 46 85 33 98
3 Mansfield Town Mansfield 46 87 48 89
4 York City York City 46 81 45 83
5 Luton Town Luton Town 46 78 42 81
6 Kidderminster Harriers Kidderminste 46 82 63 76
7 Southport Southport 46 72 69 76
8 Gateshead Gateshead 46 69 62 74
9 Cambridge United Cambridge 46 57 41 71
10 Forest Green Rovers Forest Green 46 66 45 70
11 Grimsby Town Grimsby Town 46 79 60 70
12 Braintree Town Braintree 46 76 80 62
13 Barrow Barrow 46 62 76 60
14 Ebbsfleet United Ebbsfleet 46 69 84 54
15 Alfreton Town Alfreton 46 62 86 54
16 Stockport County Stockport 46 58 74 51
17 Lincoln City Lincoln City 46 56 66 49
18 Tamworth Tamworth 46 47 70 48
19 Newport County Newport 46 53 65 47
20 AFC Telford United Telford 46 45 65 46
21 Darlington FC Darlington 46 47 73 46
22 Hayes & Yeading United Hayes 46 58 90 41
23 Kettering Town Kettering 46 40 100 33
24 Bath City Bath City 46 43 89 31
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 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
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Leicester Leicester 46 84 39 96
2 Peterborough United Peterborough 46 78 54 89
3 Milton Keynes Dons Milton 46 83 47 87
4 Leeds United Leeds United 46 77 49 84
5 Millwall Millwall 46 63 53 82
6 Scunthorpe United Scunthorpe 46 82 63 76
7 Tranmere Rovers Tranmere 46 62 49 74
8 Southend United Southend 46 58 61 71
9 Huddersfield Town Huddersfield 46 62 65 68
10 Oldham Athletic AFC Oldham 46 66 65 65
11 Bristol Rovers Bristol 46 79 61 63
12 Colchester United Colchester 46 58 58 63
13 Walsall Walsall 46 61 66 61
14 Stockport County Stockport 46 59 57 60
15 Leyton Orient Leyton 46 45 57 56
16 Swindon Town Swindon Town 46 68 71 53
17 Brighton & Hove Albion Brighton 46 55 70 52
18 Yeovil Town Yeovil Town 46 41 66 51
19 Hartlepool United Hartlepool 46 66 79 50
20 Carlisle United Carlisle 46 56 69 50
21 Northampton Northampton 46 61 65 49
22 Crewe Alexandra Crewe 46 59 82 46
23 Cheltenham Town Cheltenham 46 51 91 39
24 Hereford United Hereford 46 42 79 34
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 TWO
Equipo PJ GF GC Puntos
1 Walsall Walsall 46 66 34 89
2 Hartlepool United Hartlepool 46 65 40 88
3 Swindon Town Swindon Town 46 58 38 85
4 Milton Keynes Dons Milton 46 76 58 84
5 Lincoln City Lincoln City 46 70 59 74
6 Bristol Rovers Bristol 46 49 42 72
7 Shrewsbury Town Shrewsbury 46 68 46 71
8 Stockport County Stockport 46 65 54 71
9 Rochdale Rochdale 46 70 50 66
10 Peterborough United Peterborough 46 70 61 65
11 Darlington FC Darlington 46 52 56 65
12 Wycombe Wanderers Wycombe 46 52 47 62
13 Notts County Notts County 46 55 53 62
14 Barnet Barnet 46 55 70 59
15 Grimsby Town Grimsby Town 46 57 73 59
16 Hereford United Hereford 46 45 53 55
17 Mansfield Town Mansfield 46 58 63 54
18 Chester Chester 46 40 48 53
19 Wrexham AFC Wrexham AFC 46 43 65 51
20 Accrington Stanley Accrington 46 70 81 50
21 Bury Bury 46 46 61 50
22 Macclesfield Town Macclesfield 46 55 77 48
23 Boston United Boston 46 51 80 46
24 Torquay United Torquay 46 36 63 35
TEMPORADA 2005/2006
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Carlisle United Carlisle 46 84 42 86
2 Northampton Northampton 46 63 37 83
3 Leyton Orient Leyton 46 67 51 81
4 Grimsby Town Grimsby Town 46 64 44 78
5 Cheltenham Town Cheltenham 46 65 53 72
6 Wycombe Wanderers Wycombe 46 72 56 71
7 Lincoln City Lincoln City 46 65 53 66
8 Darlington FC Darlington 46 58 52 63
9 Peterborough United Peterborough 46 57 49 62
10 Shrewsbury Town Shrewsbury 46 55 55 61
11 Boston United Boston 46 50 60 61
12 Bristol Rovers Bristol 46 59 67 60
13 Wrexham AFC Wrexham AFC 46 61 54 59
14 Rochdale Rochdale 46 66 69 56
15 Chester Chester 46 53 59 54
16 Mansfield Town Mansfield 46 59 66 54
17 Macclesfield Town Macclesfield 46 60 71 54
18 Barnet Barnet 46 44 57 54
19 Bury Bury 46 45 57 53
20 Torquay United Torquay 46 53 66 52
21 Notts County Notts County 46 48 63 52
22 Stockport County Stockport 46 57 78 52
23 Oxford United Oxford 46 43 57 49
24 Rushden & Diamonds Rushden 46 44 76 45
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
TEMPORADA 2003/2004
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Plymouth Argyle Plymouth 46 85 41 90
2 Queens Park Rangers Queens Park 46 80 45 83
3 Bristol City Bristol City 46 58 37 82
4 Brighton & Hove Albion Brighton 46 64 43 77
5 Swindon Town Swindon Town 46 76 58 73
6 Hartlepool United Hartlepool 46 76 61 73
7 Port Vale Port Vale 46 73 63 73
8 Tranmere Rovers Tranmere 46 59 56 67
9 AFC Bournemouth Bournemouth 46 56 51 66
10 Luton Town Luton Town 46 69 66 66
11 Colchester United Colchester 46 52 56 64
12 Barnsley Barnsley 46 54 58 62
13 Wrexham AFC Wrexham AFC 46 50 60 60
14 Blackpool Blackpool 46 58 65 59
15 Oldham Athletic AFC Oldham 46 66 60 57
16 Sheffield Wednesday Sheffield 46 48 64 53
17 Brentford Brentford 46 52 69 53
18 Peterborough United Peterborough 46 58 58 52
19 Stockport County Stockport 46 62 70 52
20 Chesterfield Chesterfield 46 49 71 51
21 Grimsby Town Grimsby Town 46 55 81 50
22 Rushden & Diamonds Rushden 46 60 74 48
23 Notts County Notts County 46 50 78 42
24 Wycombe Wanderers Wycombe 46 50 75 37
TEMPORADA 2002/2003
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Wigan Athletic Wigan 46 68 25 100
2 Crewe Alexandra Crewe 46 76 40 86
3 Bristol City Bristol City 46 79 48 83
4 Queens Park Rangers Queens Park 46 69 45 83
5 Oldham Athletic AFC Oldham 46 68 38 82
6 Cardiff City Cardiff City 46 68 43 81
7 Tranmere Rovers Tranmere 46 66 57 80
8 Plymouth Argyle Plymouth 46 63 52 65
9 Luton Town Luton Town 46 67 62 65
10 Swindon Town Swindon Town 46 59 63 60
11 Peterborough United Peterborough 46 51 54 58
12 Colchester United Colchester 46 52 56 58
13 Blackpool Blackpool 46 56 64 58
14 Stockport County Stockport 46 65 70 55
15 Notts County Notts County 46 62 70 55
16 Brentford Brentford 46 47 56 54
17 Port Vale Port Vale 46 54 70 53
18 Wycombe Wanderers Wycombe 46 59 66 52
19 Barnsley Barnsley 46 51 64 52
20 Chesterfield Chesterfield 46 43 73 50
21 Cheltenham Town Cheltenham 46 53 68 48
22 Huddersfield Town Huddersfield 46 39 61 45
23 Mansfield Town Mansfield 46 66 97 44
24 Northampton Northampton 46 40 79 39
TEMPORADA 2001/2002
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Manchester City Manchester 46 108 52 99
2 West Bromwich Albion West 46 61 29 89
3 Wolves Wolves 46 76 43 86
4 Millwall Millwall 46 69 48 77
5 Birmingham City Birmingham 46 70 49 76
6 Norwich City Norwich City 46 60 51 75
7 Burnley Burnley 46 70 62 75
8 Preston North End Preston 46 71 59 72
9 Wimbledon FC Wimbledon 46 63 57 67
10 Crystal Palace Crystal 46 70 62 66
11 Coventry City Coventry 46 59 53 66
12 Gillingham Gillingham 46 64 67 64
13 Sheffield United Sheffield 46 53 54 60
14 Watford Watford 46 62 56 59
15 Bradford City Bradford 46 69 76 55
16 Nottingham Forest Nottingham 46 50 51 54
17 Portsmouth Portsmouth 46 60 72 53
18 Walsall Walsall 46 51 71 51
19 Grimsby Town Grimsby Town 46 50 72 50
20 Sheffield Wednesday Sheffield 46 49 71 50
21 Rotherham United Rotherham 46 52 66 49
22 Crewe Alexandra Crewe 46 47 76 49
23 Barnsley Barnsley 46 59 86 48
24 Stockport County Stockport 46 42 102 26
TEMPORADA 2000/2001
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Fulham Fulham 46 90 32 101
2 Blackburn Rovers Blackburn 46 76 39 91
3 Bolton Wanderers Bolton 46 76 45 87
4 Preston North End Preston 46 64 52 78
5 Birmingham City Birmingham 46 59 48 78
6 West Bromwich Albion West 46 60 52 74
7 Burnley Burnley 46 50 54 72
8 Wimbledon FC Wimbledon 46 71 50 69
9 Watford Watford 46 76 67 69
10 Sheffield United Sheffield 46 52 49 68
11 Nottingham Forest Nottingham 46 55 53 68
12 Wolves Wolves 46 45 48 55
13 Gillingham Gillingham 46 61 66 55
14 Crewe Alexandra Crewe 46 47 62 55
15 Norwich City Norwich City 46 46 58 54
16 Barnsley Barnsley 46 49 62 54
17 Sheffield Wednesday Sheffield 46 52 71 53
18 Grimsby Town Grimsby Town 46 43 62 52
19 Stockport County Stockport 46 58 65 51
20 Portsmouth Portsmouth 46 47 59 49
21 Crystal Palace Crystal 46 57 70 49
22 Huddersfield Town Huddersfield 46 48 57 48
23 Queens Park Rangers Queens Park 46 45 75 40
24 Tranmere Rovers Tranmere 46 46 77 38
TEMPORADA 1999/2000
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Charlton Athletic Charlton 46 79 45 91
2 Manchester City Manchester 46 78 40 89
3 Ipswich Town Ipswich Town 46 71 42 87
4 Barnsley Barnsley 46 88 67 82
5 Birmingham City Birmingham 46 65 44 77
6 Bolton Wanderers Bolton 46 69 50 76
7 Wolves Wolves 46 64 48 74
8 Huddersfield Town Huddersfield 46 62 49 74
9 Fulham Fulham 46 49 41 67
10 Queens Park Rangers Queens Park 46 62 53 66
11 Blackburn Rovers Blackburn 46 55 51 62
12 Norwich City Norwich City 46 45 50 57
13 Tranmere Rovers Tranmere 46 57 68 57
14 Nottingham Forest Nottingham 46 53 55 56
15 Crystal Palace Crystal 46 57 67 54
16 Sheffield United Sheffield 46 59 71 54
17 Stockport County Stockport 46 55 67 54
18 Portsmouth Portsmouth 46 55 66 51
19 Crewe Alexandra Crewe 46 46 67 51
20 Grimsby Town Grimsby Town 46 41 67 51
21 West Bromwich Albion West 46 43 60 49
22 Walsall Walsall 46 52 77 46
23 Port Vale Port Vale 46 48 69 36
24 Swindon Town Swindon Town 46 38 77 36
TEMPORADA 1998/1999
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Sunderland Sunderland 46 91 28 105
2 Bradford City Bradford 46 82 47 87
3 Ipswich Town Ipswich Town 46 69 32 86
4 Birmingham City Birmingham 46 66 37 81
5 Watford Watford 46 65 56 77
6 Bolton Wanderers Bolton 46 78 59 76
7 Wolves Wolves 46 64 43 73
8 Sheffield United Sheffield 46 71 66 67
9 Norwich City Norwich City 46 62 61 62
10 Huddersfield Town Huddersfield 46 62 71 61
11 Grimsby Town Grimsby Town 46 40 52 61
12 Barnsley Barnsley 46 59 56 59
13 West Bromwich Albion West 46 69 76 59
14 Crystal Palace Crystal 46 58 71 58
15 Tranmere Rovers Tranmere 46 63 61 56
16 Stockport County Stockport 46 49 60 53
17 Swindon Town Swindon Town 46 59 81 50
18 Crewe Alexandra Crewe 46 54 78 48
19 Queens Park Rangers Queens Park 46 52 61 47
20 Portsmouth Portsmouth 46 57 73 47
21 Bury Bury 46 35 60 47
22 Port Vale Port Vale 46 45 75 47
23 Oxford United Oxford 46 48 71 44
24 Bristol City Bristol City 46 57 80 42
TEMPORADA 1997/1998
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Nottingham Forest Nottingham 12 18 7 26
2 West Bromwich Albion West 11 15 10 21
3 Sheffield United Sheffield 9 16 6 19
4 Charlton Athletic Charlton 10 22 14 17
5 Birmingham City Birmingham 10 14 8 17
6 Port Vale Port Vale 12 17 15 17
7 Bradford City Bradford 11 12 14 17
8 Swindon Town Swindon Town 10 13 9 16
9 Sunderland Sunderland 10 16 14 16
10 Middlesbrough Middlesbroug 8 14 9 15
11 Wolves Wolves 11 14 13 15
12 Queens Park Rangers Queens Park 10 13 18 14
13 Oxford United Oxford 11 16 17 13
14 Stockport County Stockport 12 18 20 13
15 Stoke City Stoke City 8 8 8 12
16 Tranmere Rovers Tranmere 9 15 13 11
17 Norwich City Norwich City 9 8 16 11
18 Bury Bury 9 10 14 10
19 Ipswich Town Ipswich Town 9 8 10 9
20 Portsmouth Portsmouth 10 13 16 9
21 Crewe Alexandra Crewe 10 14 18 9
22 Reading Reading 10 11 17 9
23 Manchester City Manchester 8 9 11 7
24 Huddersfield Town Huddersfield 11 5 22 3

  USO DE MEMORIA  
9,320,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6630
Total Execution Time  0.6642
  CADENA URL  
/historico/Stockport-County/2017
  GET DATOS  
$_GET['/historico/Stockport-County/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (48)  
0.0126  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 = 'Stockport-County' AND l.year = 2017 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.0105  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=9760 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=9760 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=9760 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=9760 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=9760 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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 = 33979
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9760 AND type_rel = 2
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9760 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0109  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 (33815,44119,912259,938749,1069162) ORDER BY n.cover_points DESC, update_date DESC
0.0116  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 = '9760' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0117  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 = '9760' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0106  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 = 33911 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 33979 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0113  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 = 37590 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0116  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=9760 AND l.year in (2016,2017,2018) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (48708,48640,38989,38704,38427) 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.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 38704 AND teamId = 9760
0.0113  SELECT count(id) as num_players from rel_players WHERE league_id = 38989 AND teamId = 9760
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 48708 AND teamId = 9760
0.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 48640 AND teamId = 9760
0.0189  SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 9760
0.0111  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 33911 AND t.round = 42 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0122  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 events2017 e ON e.player_id = p.id AND e.league_id = 33911 WHERE rp.league_id = 33911 AND rp.teamId = 9760 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.0107  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 events2017 e ON e.player_id = p.id AND e.league_id = 33911 WHERE rp.league_id = 33911 AND rp.teamId = 9760 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0107  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 events2017 e ON e.player_id = p.id AND e.league_id = 33911 WHERE rp.league_id = 33911 AND rp.teamId = 9760 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0117  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 = 9760 AND l.year <= 2017 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0111  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 = 33911 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 15423 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 3894 AND t.round = 47 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 2513 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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 = 2010 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 1560 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114  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.0111  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2600 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 442 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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.0112  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 = 492 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 493 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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.0113  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 `tables2004` 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 = 480 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 `tables2003` 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 = 481 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 `tables2002` 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 = 466 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 `tables2001` 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 = 467 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 `tables2000` 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 = 468 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 `tables1999` 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 = 56341 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables1998` 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 = 471 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  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 = 33911 ORDER BY nameShow LIMIT 100