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

Stevenage

Entrenador: Alex Revell

Temporada 2016/2017
TEMPORADA 2016/2017
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Portsmouth Portsmouth 46 79 40 87
2 Plymouth Argyle Plymouth 46 71 46 87
3 Doncaster Rovers Doncaster 46 85 55 85
4 Luton Town Luton Town 46 70 43 77
5 Exeter City Exeter City 46 75 56 71
6 Carlisle United Carlisle 46 69 68 71
7 Blackpool Blackpool 46 69 46 70
8 Colchester United Colchester 46 67 57 69
9 Wycombe Wanderers Wycombe 46 58 53 69
10 Stevenage Stevenage 46 67 63 67
11 Cambridge United Cambridge 46 58 50 66
12 Mansfield Town Mansfield 46 54 50 66
13 Accrington Stanley Accrington 46 59 56 65
14 Grimsby Town Grimsby Town 46 59 63 62
15 Barnet Barnet 46 57 64 57
16 Notts County Notts County 46 54 76 56
17 Crewe Alexandra Crewe 46 58 67 55
18 Morecambe Morecambe 46 53 73 52
19 Crawley Town Crawley Town 46 53 71 51
20 Yeovil Town Yeovil Town 46 49 64 50
21 Cheltenham Town Cheltenham 46 49 69 50
22 Newport County Newport 46 51 73 48
23 Hartlepool United Hartlepool 46 54 75 46
24 Leyton Orient Leyton 46 47 87 36
TEMPORADA 2015/2016
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Northampton Northampton 46 82 46 99
2 Oxford United Oxford 46 84 41 86
3 Bristol Rovers Bristol 46 77 46 85
4 Accrington Stanley Accrington 46 74 48 85
5 Plymouth Argyle Plymouth 46 72 46 81
6 Portsmouth Portsmouth 46 75 44 78
7 AFC Wimbledon Wimbledon 46 64 50 75
8 Leyton Orient Leyton 46 60 61 69
9 Cambridge United Cambridge 46 66 55 68
10 Carlisle United Carlisle 46 67 62 67
11 Luton Town Luton Town 46 63 61 66
12 Mansfield Town Mansfield 46 61 53 64
13 Wycombe Wanderers Wycombe 46 45 44 64
14 Exeter City Exeter City 46 63 65 64
15 Barnet Barnet 46 67 68 62
16 Hartlepool United Hartlepool 46 49 72 51
17 Notts County Notts County 46 54 83 51
18 Stevenage Stevenage 46 52 67 48
19 Yeovil Town Yeovil Town 46 43 59 48
20 Crawley Town Crawley Town 46 45 78 47
21 Morecambe Morecambe 46 69 91 46
22 Newport County Newport 46 43 64 43
23 Dagenham & Redbridge Dagenham 46 46 81 34
24 York City York City 46 51 87 34
TEMPORADA 2014/2015
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Burton Albion Burton 46 69 39 94
2 Shrewsbury Town Shrewsbury 46 67 31 89
3 Bury Bury 46 60 40 85
4 Wycombe Wanderers Wycombe 46 67 45 84
5 Southend United Southend 46 54 38 84
6 Stevenage Stevenage 46 62 54 72
7 Plymouth Argyle Plymouth 46 55 37 71
8 Luton Town Luton Town 46 54 44 68
9 Newport County Newport 46 51 54 65
10 Exeter City Exeter City 46 61 65 64
11 Morecambe Morecambe 46 53 52 63
12 Northampton Northampton 46 67 62 61
13 Oxford United Oxford 46 50 49 61
14 Dagenham & Redbridge Dagenham 46 58 59 59
15 AFC Wimbledon Wimbledon 46 54 60 58
16 Portsmouth Portsmouth 46 52 54 57
17 Accrington Stanley Accrington 46 58 77 56
18 York City York City 46 46 51 52
19 Cambridge United Cambridge 46 61 66 51
20 Carlisle United Carlisle 46 56 74 50
21 Mansfield Town Mansfield 46 38 62 48
22 Hartlepool United Hartlepool 46 39 70 45
23 Cheltenham Town Cheltenham 46 40 67 41
24 Tranmere Rovers Tranmere 46 45 67 39
TEMPORADA 2013/2014
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Wolves Wolves 46 89 31 103
2 Brentford Brentford 46 72 43 94
3 Leyton Orient Leyton 46 85 45 86
4 Rotherham United Rotherham 46 86 58 86
5 Preston North End Preston 46 72 46 85
6 Peterborough United Peterborough 46 72 58 74
7 Sheffield United Sheffield 46 48 46 67
8 Swindon Town Swindon Town 46 63 59 66
9 Port Vale Port Vale 46 59 73 61
10 Milton Keynes Dons Milton 46 63 65 60
11 Bradford City Bradford 46 57 54 59
12 Bristol City Bristol City 46 70 67 58
13 Walsall Walsall 46 49 49 58
14 Crawley Town Crawley Town 46 48 54 57
15 Oldham Athletic AFC Oldham 46 50 59 56
16 Colchester United Colchester 46 53 61 53
17 Gillingham Gillingham 46 60 79 53
18 Coventry City Coventry 46 74 77 51
19 Crewe Alexandra Crewe 46 54 80 51
20 Notts County Notts County 46 64 77 50
21 Tranmere Rovers Tranmere 46 52 79 47
22 Carlisle United Carlisle 46 43 76 45
23 Shrewsbury Town Shrewsbury 46 44 65 42
24 Stevenage Stevenage 46 46 72 42
TEMPORADA 2012/2013
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Doncaster Rovers Doncaster 46 62 44 84
2 AFC Bournemouth Bournemouth 46 76 53 83
3 Brentford Brentford 46 62 47 79
4 Yeovil Town Yeovil Town 46 71 56 77
5 Sheffield United Sheffield 46 56 42 75
6 Swindon Town Swindon Town 46 72 39 74
7 Leyton Orient Leyton 46 55 48 71
8 Milton Keynes Dons Milton 46 62 45 70
9 Walsall Walsall 46 65 58 68
10 Crawley Town Crawley Town 46 59 58 68
11 Tranmere Rovers Tranmere 46 58 48 67
12 Notts County Notts County 46 61 49 65
13 Crewe Alexandra Crewe 46 54 62 64
14 Preston North End Preston 46 54 49 59
15 Coventry City Coventry 46 66 59 55
16 Shrewsbury Town Shrewsbury 46 54 60 55
17 Carlisle United Carlisle 46 56 77 55
18 Stevenage Stevenage 46 47 64 54
19 Oldham Athletic AFC Oldham 46 46 59 51
20 Colchester United Colchester 46 47 68 51
21 Scunthorpe United Scunthorpe 46 49 73 48
22 Bury Bury 46 45 73 41
23 Hartlepool United Hartlepool 46 39 67 41
24 Portsmouth Portsmouth 46 51 69 32
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
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Stevenage Stevenage 44 79 24 99
2 Luton Town Luton Town 44 84 40 88
3 Oxford United Oxford 44 64 31 86
4 Rushden & Diamonds Rushden 44 77 39 79
5 York City York City 44 62 35 78
6 Salisbury City Salisbury 44 58 63 68
7 Kettering Town Kettering 44 51 41 66
8 Crawley Town Crawley Town 44 49 57 66
9 AFC Wimbledon Wimbledon 44 61 47 64
10 Mansfield Town Mansfield 44 69 60 62
11 Cambridge United Cambridge 44 65 53 59
12 Wrexham AFC Wrexham AFC 44 45 39 58
13 Kidderminster Harriers Kidderminste 44 57 52 57
14 Altrincham Altrincham 44 53 51 54
15 Barrow Barrow 44 50 67 52
16 Tamworth Tamworth 44 42 52 49
17 Hayes & Yeading United Hayes 44 58 85 48
18 Histon Histon 44 44 66 46
19 Gateshead Gateshead 44 46 69 46
20 Eastbourne Borough Eastbourne 44 42 71 46
21 Forest Green Rovers Forest Green 44 50 76 45
22 Ebbsfleet United Ebbsfleet 44 50 82 44
23 Grays Athletic Grays 44 35 91 28
TEMPORADA 2008/2009
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Burton Albion Burton 46 81 52 88
2 Cambridge United Cambridge 46 65 39 86
3 Histon Histon 46 78 48 83
4 Torquay United Torquay 46 72 47 83
5 Oxford United Oxford 46 72 51 82
6 Stevenage Stevenage 46 73 54 81
7 Kidderminster Harriers Kidderminste 46 69 48 79
8 Kettering Town Kettering 46 50 37 76
9 Crawley Town Crawley Town 46 77 55 71
10 Wrexham AFC Wrexham AFC 46 64 48 66
11 Mansfield Town Mansfield 46 57 55 66
12 Rushden & Diamonds Rushden 46 61 50 63
13 Eastbourne Borough Eastbourne 46 58 70 60
14 Ebbsfleet United Ebbsfleet 46 52 60 58
15 Altrincham Altrincham 46 49 66 56
16 Salisbury City Salisbury 46 54 64 55
17 York City York City 46 47 51 52
18 Forest Green Rovers Forest Green 46 70 76 52
19 Grays Athletic Grays 46 44 64 52
20 Barrow Barrow 46 51 65 51
21 Woking Woking 46 37 60 44
22 Northwich Victoria Northwich 46 56 75 43
23 Weymouth Weymouth 46 45 86 43
24 Lewes Lewes 46 28 89 24
TEMPORADA 2007/2008
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Aldershot Town Aldershot 46 82 48 101
2 Cambridge United Cambridge 46 68 41 86
3 Torquay United Torquay 46 83 57 86
4 Exeter City Exeter City 46 83 58 83
5 Burton Albion Burton 46 79 56 81
6 Stevenage Stevenage 46 82 55 79
7 Histon Histon 46 76 67 72
8 Forest Green Rovers Forest Green 46 76 59 71
9 Oxford United Oxford 46 56 48 71
10 Grays Athletic Grays 46 58 47 70
11 Ebbsfleet United Ebbsfleet 46 65 61 69
12 Salisbury City Salisbury 46 70 60 68
13 Kidderminster Harriers Kidderminste 46 74 57 67
14 Crawley Town Crawley Town 46 73 67 66
15 York City York City 46 71 74 62
16 Rushden & Diamonds Rushden 46 55 55 59
17 Woking Woking 46 53 61 53
18 FC Halifax Town Halifax Town 46 61 70 52
19 Weymouth Weymouth 46 53 73 46
20 Northwich Victoria Northwich 46 52 78 44
21 Altrincham Altrincham 46 56 82 41
22 Farsley Celtic Farsley 46 48 86 39
23 Stafford Rangers Stafford 46 42 99 25
24 Droylsden Droylsden 46 46 103 24
TEMPORADA 2006/2007
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Dagenham & Redbridge Dagenham 46 93 48 95
2 Oxford United Oxford 46 66 33 81
3 Morecambe Morecambe 46 64 46 81
4 York City York City 46 65 45 80
5 Exeter City Exeter City 46 67 48 78
6 Burton Albion Burton 46 52 47 75
7 Ebbsfleet United Ebbsfleet 46 63 56 74
8 Stevenage Stevenage 46 76 66 70
9 Aldershot Town Aldershot 46 64 62 65
10 Crawley Town Crawley Town 46 52 52 63
11 Kidderminster Harriers Kidderminste 46 43 50 63
12 Weymouth Weymouth 46 57 73 63
13 Rushden & Diamonds Rushden 46 58 54 62
14 Northwich Victoria Northwich 46 51 69 58
15 Forest Green Rovers Forest Green 46 59 64 57
16 Woking Woking 46 56 61 57
17 FC Halifax Town Halifax Town 46 55 62 55
18 Cambridge United Cambridge 46 57 66 55
19 Grays Athletic Grays 46 56 55 52
20 Stafford Rangers Stafford 46 49 71 52
21 Altrincham Altrincham 46 53 67 51
22 Tamworth Tamworth 46 43 61 48
23 Southport Southport 46 57 68 47
24 St. Albans City Albans City 46 57 89 40
TEMPORADA 2005/2006
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Accrington Stanley Accrington 42 76 45 91
2 Hereford United Hereford 42 59 33 80
3 Grays Athletic Grays 42 94 55 76
4 FC Halifax Town Halifax Town 42 55 40 75
5 Morecambe Morecambe 42 68 41 74
6 Stevenage Stevenage 42 63 47 69
7 Exeter City Exeter City 42 65 48 63
8 York City York City 42 63 48 63
9 Burton Albion Burton 42 50 52 60
10 Dagenham & Redbridge Dagenham 42 63 59 58
11 Woking Woking 42 58 47 56
12 Cambridge United Cambridge 42 51 57 55
13 Aldershot Town Aldershot 42 61 74 54
14 Canvey Island Canvey 42 47 58 51
15 Kidderminster Harriers Kidderminste 42 39 55 50
16 Ebbsfleet United Ebbsfleet 42 45 57 49
17 Crawley Town Crawley Town 42 48 55 47
18 Altrincham Altrincham 42 40 72 41
19 Southport Southport 42 36 68 40
20 Forest Green Rovers Forest Green 42 49 62 38
21 Tamworth Tamworth 42 32 63 38
22 Scarborough Scarborough 42 40 66 37
TEMPORADA 2004/2005
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Barnet Barnet 42 90 44 86
2 Hereford United Hereford 42 68 41 74
3 Carlisle United Carlisle 42 74 37 73
4 Aldershot Town Aldershot 42 68 52 73
5 Stevenage Stevenage 42 65 52 72
6 Exeter City Exeter City 42 71 50 71
7 Morecambe Morecambe 42 69 50 71
8 Woking Woking 42 58 45 68
9 FC Halifax Town Halifax Town 42 74 56 66
10 Accrington Stanley Accrington 42 72 58 65
11 Dagenham & Redbridge Dagenham 42 68 60 65
12 Crawley Town Crawley Town 42 50 50 57
13 Scarborough Scarborough 42 60 46 56
14 Tamworth Tamworth 42 53 63 53
15 Northwich Victoria Northwich 42 58 72 52
16 Ebbsfleet United Ebbsfleet 42 58 64 50
17 Burton Albion Burton 42 50 66 50
18 York City York City 42 39 66 43
19 Canvey Island Canvey 42 53 65 42
20 Forest Green Rovers Forest Green 42 41 81 33
21 Farnborough Farnborough 42 35 89 29
22 Leigh Leigh 42 31 98 18
TEMPORADA 2003/2004
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Chester Chester 42 85 34 92
2 Hereford United Hereford 42 103 44 91
3 Shrewsbury Town Shrewsbury 42 67 42 74
4 Barnet Barnet 42 61 47 71
5 Aldershot Town Aldershot 42 80 67 70
6 Exeter City Exeter City 42 71 57 69
7 Morecambe Morecambe 42 66 66 67
8 Stevenage Stevenage 42 58 52 63
9 Woking Woking 42 65 52 61
10 Accrington Stanley Accrington 42 68 61 58
11 Ebbsfleet United Ebbsfleet 42 69 66 57
12 AFC Telford United Telford 42 49 51 55
13 Dagenham & Redbridge Dagenham 42 59 64 54
14 Burton Albion Burton 42 57 59 52
15 Scarborough Scarborough 42 51 54 51
16 Margate Margate 42 56 64 51
17 Tamworth Tamworth 42 49 68 49
18 Forest Green Rovers Forest Green 42 58 80 48
19 FC Halifax Town Halifax Town 42 43 65 44
20 Farnborough Farnborough 42 54 75 39
21 Leigh Leigh 42 46 97 29
22 Northwich Victoria Northwich 42 30 80 23
TEMPORADA 2002/2003
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Yeovil Town Yeovil Town 42 100 37 95
2 Morecambe Morecambe 42 86 42 78
3 Doncaster Rovers Doncaster 42 73 47 78
4 Chester Chester 42 59 31 75
5 Dagenham & Redbridge Dagenham 42 71 59 72
6 Hereford United Hereford 42 64 51 64
7 Scarborough Scarborough 42 63 54 64
8 FC Halifax Town Halifax Town 42 50 51 64
9 Forest Green Rovers Forest Green 42 61 62 59
10 Margate Margate 42 60 66 56
11 Barnet Barnet 42 65 68 53
12 Stevenage Stevenage 42 61 55 52
13 Farnborough Farnborough 42 57 56 51
14 Northwich Victoria Northwich 42 66 72 51
15 AFC Telford United Telford 42 54 69 49
16 Burton Albion Burton 42 52 77 49
17 Ebbsfleet United Ebbsfleet 42 62 73 48
18 Leigh Leigh 42 44 71 48
19 Woking Woking 42 52 81 47
20 Nuneaton Town Nuneaton 42 51 78 46
21 Southport Southport 42 54 69 45
22 Kettering Town Kettering 42 37 73 31
TEMPORADA 2001/2002
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Boston United Boston 42 84 42 84
2 Dagenham & Redbridge Dagenham 42 70 47 84
3 Yeovil Town Yeovil Town 42 66 53 70
4 Doncaster Rovers Doncaster 42 68 46 67
5 Barnet Barnet 42 64 48 67
6 Morecambe Morecambe 42 63 67 62
7 Farnborough Farnborough 42 66 54 61
8 Margate Margate 42 59 53 58
9 AFC Telford United Telford 42 63 58 57
10 Nuneaton Town Nuneaton 42 57 57 57
11 Scarborough Scarborough 42 55 63 56
12 Stevenage Stevenage 42 57 60 55
13 Northwich Victoria Northwich 42 57 70 55
14 Chester Chester 42 54 51 54
15 Southport Southport 42 53 49 53
16 Leigh Leigh 42 56 58 53
17 Hereford United Hereford 42 50 53 52
18 Forest Green Rovers Forest Green 42 54 76 51
19 Woking Woking 42 59 70 48
20 Hayes FC Hayes FC 42 53 80 44
21 Stalybridge Celtic Stalybridge 42 40 69 43
22 Dover Athletic Dover 42 41 65 39
TEMPORADA 2000/2001
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Rushden & Diamonds Rushden 42 78 36 86
2 Yeovil Town Yeovil Town 42 72 50 78
3 Dagenham & Redbridge Dagenham 42 71 54 77
4 Southport Southport 42 58 46 69
5 Leigh Leigh 42 63 57 68
6 AFC Telford United Telford 42 51 51 65
7 Stevenage Stevenage 42 71 61 63
8 Chester Chester 42 49 43 62
9 Doncaster Rovers Doncaster 42 47 43 58
10 Scarborough Scarborough 42 56 54 58
11 Hereford United Hereford 42 59 46 56
12 Boston United Boston 42 74 63 56
13 Nuneaton Town Nuneaton 42 60 59 56
14 Woking Woking 42 52 57 54
15 Dover Athletic Dover 42 54 56 53
16 Forest Green Rovers Forest Green 42 43 54 48
17 Northwich Victoria Northwich 42 49 67 46
18 Hayes FC Hayes FC 42 44 71 46
19 Morecambe Morecambe 42 64 66 45
20 Kettering Town Kettering 42 46 62 43
21 Kingstonian Kingstonian 42 47 73 34
22 Hednesford Town Hednesford 42 46 85 29

  USO DE MEMORIA  
8,924,832 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6122
Total Execution Time  0.6134
  CADENA URL  
/historico/Stevenage/2017
  GET DATOS  
$_GET['/historico/Stevenage/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0128  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 = 'Stevenage' 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.0106  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=2859 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=2859 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=2859 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=2859 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=2859 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=2859 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0113  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 = 30629
0.0117  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 = '2859' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0114  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 = '2859' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = 30629 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0112  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=2859 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 (38990,38989,38752,38701,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.0111  SELECT count(id) as num_players from rel_players WHERE league_id = 38701 AND teamId = 2859
0.0114  SELECT count(id) as num_players from rel_players WHERE league_id = 38989 AND teamId = 2859
0.0117  SELECT count(id) as num_players from rel_players WHERE league_id = 38752 AND teamId = 2859
0.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 38990 AND teamId = 2859
0.0386  SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 2859
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 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 = 30629 AND t.round = 46 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = 30629 WHERE rp.league_id = 30629 AND rp.teamId = 2859 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.0134  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 = 30629 WHERE rp.league_id = 30629 AND rp.teamId = 2859 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0123  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 = 30629 WHERE rp.league_id = 30629 AND rp.teamId = 2859 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0120  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 = 2859 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 = 30629 AND t.round = 46 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 `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 = 15150 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 `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 = 3889 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 `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 = 2438 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 `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 = 1917 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 = 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.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 `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.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 `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 = 1048 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0117  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 = 1049 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0116  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 = 529 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0117  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 = 530 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124  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 = 531 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 532 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 533 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 `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 = 578 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 `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 = 579 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 `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 = 580 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 30629 ORDER BY nameShow LIMIT 100