4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Curzon Ashton
TEMPORADA 2023/2024
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 Tamworth Tamworth 46 74 29 96
2 Scunthorpe United Scunthorpe 46 84 38 88
3 Brackley Town Brackley 46 65 37 85
4 Chorley Chorley 46 81 50 83
5 Alfreton Town Alfreton 46 76 50 80
6 Boston United Boston 46 68 46 75
7 Curzon Ashton Curzon 46 62 49 75
8 South Shields South 46 79 53 74
9 Spennymoor Town Spennymoor 46 74 62 74
10 Chester Chester 46 58 37 69
11 Hereford Hereford 46 62 66 69
12 Warrington Town Warrington 46 64 60 64
13 Scarborough Athletic Scarborough 46 53 55 64
14 Buxton Buxton 46 70 63 62
15 Peterborough Sports Peterborough 46 55 65 58
16 Darlington FC Darlington 46 52 72 56
17 Southport Southport 46 54 75 56
18 Kings Lynn Town Kings Lynn. 46 54 66 55
19 Rushall Olympic Rushall 46 61 73 54
20 Farsley Celtic Farsley 46 40 59 53
21 Blyth Spartans Blyth 46 66 82 50
22 Banbury United Banbury 46 38 86 38
23 Gloucester City Gloucester 46 49 89 36
24 Bishops Stortford Bishops 46 35 112 21
TEMPORADA 2022/2023
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 Fylde Fylde 46 80 44 95
2 Kings Lynn Town Kings Lynn. 46 84 43 93
3 Chester Chester 46 72 41 84
4 Brackley Town Brackley 46 57 47 69
5 Alfreton Town Alfreton 46 54 44 69
6 Kidderminster Harriers Kidderminste 46 49 42 69
7 Gloucester City Gloucester 46 75 68 68
8 Scarborough Athletic Scarborough 46 74 69 68
9 Spennymoor Town Spennymoor 46 68 67 68
10 Darlington FC Darlington 46 72 64 67
11 Buxton Buxton 46 55 54 67
12 Chorley Chorley 46 62 50 66
13 Curzon Ashton Curzon 46 58 55 65
14 Peterborough Sports Peterborough 46 50 55 57
15 Boston United Boston 46 68 66 56
16 Hereford Hereford 46 47 56 55
17 Banbury United Banbury 46 55 62 54
18 Southport Southport 46 50 62 50
19 Blyth Spartans Blyth 46 49 62 50
20 Farsley Celtic Farsley 46 51 75 50
21 Kettering Town Kettering 46 41 63 49
22 Leamington Leamington 46 41 60 48
23 Bradford Park Avenue Bradford 46 43 65 46
24 AFC Telford United Telford 46 35 76 32
TEMPORADA 2021/2022
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 Gateshead Gateshead 42 99 47 94
2 Brackley Town Brackley 42 53 23 87
3 Fylde Fylde 42 68 37 80
4 Kidderminster Harriers Kidderminste 42 72 35 74
5 York City York City 42 58 50 66
6 Chorley Chorley 42 62 49 65
7 Boston United Boston 42 63 57 63
8 Kettering Town Kettering 42 54 48 61
9 Alfreton Town Alfreton 42 58 59 61
10 Spennymoor Town Spennymoor 42 55 51 60
11 Southport Southport 42 60 55 57
12 Hereford Hereford 42 51 52 55
13 Darlington FC Darlington 42 57 58 53
14 Curzon Ashton Curzon 42 51 63 52
15 Leamington Leamington 42 39 47 48
16 Chester Chester 42 70 71 47
17 Gloucester City Gloucester 42 47 60 46
18 Bradford Park Avenue Bradford 42 46 70 44
19 Blyth Spartans Blyth 42 41 76 43
20 AFC Telford United Telford 42 48 65 37
21 Farsley Celtic Farsley 42 37 78 37
22 Guiseley Guiseley 42 31 69 35
TEMPORADA 2020/2021
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 Gloucester City Gloucester 18 36 22 35
2 Fylde Fylde 15 26 16 30
3 Chester Chester 17 32 24 28
4 Brackley Town Brackley 16 22 19 27
5 Kidderminster Harriers Kidderminste 15 24 17 25
6 Boston United Boston 13 20 10 23
7 Chorley Chorley 18 21 25 23
8 York City York City 13 22 17 22
9 Leamington Leamington 15 22 20 22
10 Gateshead Gateshead 14 17 15 21
11 Farsley Celtic Farsley 17 21 26 21
12 Hereford Hereford 13 20 16 20
13 Spennymoor Town Spennymoor 13 18 14 20
14 AFC Telford United Telford 17 17 23 19
15 Bradford Park Avenue Bradford 16 26 30 18
16 Curzon Ashton Curzon 17 18 26 17
17 Southport Southport 14 16 19 16
18 Kettering Town Kettering 14 21 23 15
19 Darlington FC Darlington 11 17 11 13
20 Guiseley Guiseley 15 17 22 12
21 Alfreton Town Alfreton 15 15 27 12
22 Blyth Spartans Blyth 14 10 36 6
TEMPORADA 2019/2020
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 Kings Lynn Town Kings Lynn. 32 63 39 64
2 York City York City 34 52 28 66
3 Boston United Boston 32 46 32 58
4 Brackley Town Brackley 34 61 25 60
5 Altrincham Altrincham 33 62 40 57
6 Chester Chester 32 58 38 54
7 Gateshead Gateshead 31 47 31 52
8 Spennymoor Town Spennymoor 34 63 45 55
9 Guiseley Guiseley 33 52 41 50
10 Darlington FC Darlington 33 43 50 48
11 Farsley Celtic Farsley 34 50 45 48
12 Southport Southport 32 40 41 43
13 Alfreton Town Alfreton 32 48 55 40
14 AFC Telford United Telford 34 51 56 42
15 Kidderminster Harriers Kidderminste 33 39 43 38
16 Hereford Hereford 35 39 56 39
17 Gloucester City Gloucester 30 39 57 33
18 Leamington Leamington 32 39 51 35
19 Kettering Town Kettering 31 36 46 32
20 Curzon Ashton Curzon 33 34 42 34
21 Blyth Spartans Blyth 33 32 78 23
22 Bradford Park Avenue Bradford 33 25 80 20
TEMPORADA 2018/2019
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 Stockport County Stockport 42 77 36 82
2 Chorley Chorley 42 83 41 81
3 Brackley Town Brackley 42 72 40 77
4 Spennymoor Town Spennymoor 42 78 48 76
5 Altrincham Altrincham 42 85 56 71
6 Blyth Spartans Blyth 42 74 62 69
7 Bradford Park Avenue Bradford 42 71 61 65
8 AFC Telford United Telford 42 64 55 65
9 Chester Chester 42 60 62 62
10 Kidderminster Harriers Kidderminste 42 68 62 60
11 Boston United Boston 42 62 60 58
12 York City York City 42 58 63 58
13 Leamington Leamington 42 57 60 54
14 Southport Southport 42 58 55 53
15 Alfreton Town Alfreton 42 53 67 51
16 Darlington FC Darlington 42 56 62 50
17 Hereford Hereford 42 47 58 49
18 Curzon Ashton Curzon 42 44 71 49
19 Guiseley Guiseley 42 46 60 44
20 Ashton United Ashton 42 43 86 35
21 United of Manchester United 42 49 82 34
22 Nuneaton Town Nuneaton 42 38 96 19
TEMPORADA 2017/2018
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 Salford City Salford City 42 80 45 91
2 Harrogate Town Harrogate 42 100 49 85
3 Brackley Town Brackley 42 70 39 77
4 Kidderminster Harriers Kidderminste 42 76 50 72
5 Stockport County Stockport 42 75 57 69
6 Chorley Chorley 42 52 39 68
7 Bradford Park Avenue Bradford 42 66 56 63
8 Spennymoor Town Spennymoor 42 71 67 63
9 York City York City 42 67 60 61
10 Boston United Boston 42 67 66 60
11 Blyth Spartans Blyth 42 76 69 59
12 Darlington FC Darlington 42 58 58 55
13 Nuneaton Town Nuneaton 42 50 57 55
14 AFC Telford United Telford 42 55 69 53
15 Southport Southport 42 60 72 50
16 United of Manchester United 42 58 72 50
17 Alfreton Town Alfreton 42 67 71 49
18 Curzon Ashton Curzon 42 52 66 49
19 Leamington Leamington 42 51 65 49
20 Gainsborough Trinity Gainsborough 42 47 73 46
21 Tamworth Tamworth 42 55 77 42
22 North Ferriby United North 42 25 101 21
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
NON LEAGUE PREMIER GRUPO 2
Equipo PJ GF GC Puntos
1 United of Manchester United 46 78 37 92
2 Workington Workington 46 63 39 90
3 Ashton United Ashton 46 75 54 84
4 Curzon Ashton Curzon 46 79 47 81
5 Ilkeston Town FC Ilkeston 46 79 56 81
6 Blyth Spartans Blyth 46 84 54 79
7 Skelmersdale United Skelmersdale 46 58 48 73
8 Barwell Barwell 46 69 63 73
9 Rushall Olympic Rushall 46 76 64 72
10 Buxton Buxton 46 70 57 71
11 Halesowen Town Halesowen 46 56 48 59
12 Grantham Town Grantham 46 64 72 59
13 Whitby Town Whitby Town 46 56 63 58
14 Matlock Town Matlock Town 46 57 60 56
15 Nantwich Town Nantwich 46 61 76 55
16 Stourbridge Stourbridge 46 59 72 53
17 Ramsbottom United Ramsbottom 46 66 80 53
18 Kings Lynn Town Kings Lynn. 46 60 81 52
19 Stamford Stamford 46 57 75 51
20 Frickley Athletic Frickley 46 60 73 50
21 Marine Marine 46 58 69 49
22 Witton Albion Witton 46 58 86 49
23 Trafford Trafford 46 58 93 33
24 Belper Town FC Belper Town 46 62 96 32
TEMPORADA 2013/2014
NON LEAGUE DIVISION 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Curzon Ashton Curzon 42 92 36 99
2 Darlington FC Darlington 42 101 37 90
3 Warrington Town Warrington 42 86 47 87
4 Bamber Bridge Bamber 42 81 45 83
5 Ramsbottom United Ramsbottom 42 112 57 83
6 Lancaster City Lancaster 42 75 52 80
7 Farsley Celtic Farsley 42 76 51 75
8 Ossett Town Ossett Town 42 66 63 65
9 Northwich Victoria Northwich 42 73 52 63
10 Kendal Town Kendal Town 42 83 84 56
11 Cammell Laird Cammell 42 65 64 54
12 Salford City Salford City 42 68 80 52
13 Harrogate Railway Harrogate 42 52 66 48
14 Burscough Burscough 42 58 82 48
15 Mossley Mossley 42 73 90 47
16 New Mills New Mills 42 68 95 45
17 Clitheroe Clitheroe 42 55 81 43
18 Radcliffe Borough Radcliffe 42 57 93 43
19 Padiham Padiham 42 61 92 42
20 Prescot Cables Prescot 42 63 86 40
21 Ossett Albion Ossett 42 40 80 29
22 Wakefield Wakefield 42 55 127 28
TEMPORADA 2012/2013
NON LEAGUE DIVISION 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Skelmersdale United Skelmersdale 42 110 41 102
2 Cammell Laird Cammell 42 86 58 86
3 New Mills New Mills 42 107 69 85
4 Trafford Trafford 42 93 44 80
5 Mossley Mossley 42 83 48 80
6 Ramsbottom United Ramsbottom 42 97 49 79
7 Curzon Ashton Curzon 42 98 67 73
8 Clitheroe Clitheroe 42 66 63 73
9 Bamber Bridge Bamber 42 86 58 70
10 Warrington Town Warrington 42 76 54 69
11 Burscough Burscough 42 81 64 59
12 Ossett Town Ossett Town 42 67 65 55
13 Lancaster City Lancaster 42 70 73 53
14 Farsley Celtic Farsley 42 72 80 49
15 Radcliffe Borough Radcliffe 42 68 69 48
16 Salford City Salford City 42 65 79 46
17 Prescot Cables Prescot 42 51 67 46
18 Harrogate Railway Harrogate 42 47 89 41
19 Wakefield Wakefield 42 38 119 27
20 Ossett Albion Ossett 42 49 96 25
21 Goole Goole 42 44 89 23
22 Garforth Town Garforth 42 44 157 16
TEMPORADA 2011/2012
NON LEAGUE DIVISION 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Fylde Fylde 42 90 29 99
2 Curzon Ashton Curzon 42 91 44 92
3 Witton Albion Witton 42 101 44 90
4 Farsley Celtic Farsley 42 86 48 81
5 Garforth Town Garforth 42 95 63 79
6 Lancaster City Lancaster 42 80 48 77
7 Skelmersdale United Skelmersdale 42 94 60 75
8 Woodley Sports Woodley 42 71 51 71
9 Durham City Durham City 42 81 80 62
10 Bamber Bridge Bamber 42 69 68 60
11 Warrington Town Warrington 42 69 71 60
12 Trafford Trafford 42 70 66 56
13 Salford City Salford City 42 69 73 52
14 Mossley Mossley 42 66 75 45
15 Radcliffe Borough Radcliffe 42 54 75 45
16 Prescot Cables Prescot 42 53 71 42
17 Ossett Town Ossett Town 42 41 84 42
18 Ossett Albion Ossett 42 59 95 39
19 Clitheroe Clitheroe 42 51 76 38
20 Wakefield Wakefield 42 38 77 33
21 Harrogate Railway Harrogate 42 54 115 31
22 Cammell Laird Cammell 42 34 103 28
TEMPORADA 2010/2011
NON LEAGUE DIVISION 1 GRUPO 5
Equipo PJ GF GC Puntos
1 Chester Chester 44 107 36 97
2 Skelmersdale United Skelmersdale 44 117 48 97
3 Chorley Chorley 44 87 43 86
4 Curzon Ashton Curzon 44 85 49 85
5 Fylde Fylde 44 91 59 81
6 Clitheroe Clitheroe 44 82 70 70
7 Bamber Bridge Bamber 44 70 60 70
8 Lancaster City Lancaster 44 80 61 68
9 Warrington Town Warrington 44 70 52 67
10 Witton Albion Witton 44 75 64 62
11 Woodley Sports Woodley 44 71 75 62
12 Salford City Salford City 44 68 73 62
13 Garforth Town Garforth 44 67 71 52
14 Trafford Trafford 44 73 92 52
15 Mossley Mossley 44 75 77 51
16 Wakefield Wakefield 44 55 74 50
17 Durham City Durham City 44 75 92 48
18 Radcliffe Borough Radcliffe 44 60 89 48
19 Cammell Laird Cammell 44 66 94 47
20 Harrogate Railway Harrogate 44 82 103 46
21 Prescot Cables Prescot 44 52 79 42
22 Ossett Albion Ossett 44 60 134 26
23 Leigh Genesis Leigh 44 39 112 23
TEMPORADA 2009/2010
NON LEAGUE DIVISION 1 GRUPO 3
Equipo PJ GF GC Puntos
1 FC Halifax Town Halifax Town 42 108 38 100
2 Lancaster City Lancaster 42 95 45 96
3 Curzon Ashton Curzon 42 93 50 81
4 Colwyn Bay Colwyn Bay 42 77 57 75
5 Skelmersdale United Skelmersdale 42 80 56 74
6 Leigh Genesis Leigh 42 81 51 71
7 Mossley Mossley 42 73 67 65
8 Clitheroe Clitheroe 42 72 66 62
9 Warrington Town Warrington 42 65 69 60
10 Radcliffe Borough Radcliffe 42 65 78 57
11 Salford City Salford City 42 63 74 56
12 Trafford Trafford 42 79 73 53
13 Fylde Fylde 42 67 79 53
14 Bamber Bridge Bamber 42 58 67 52
15 Harrogate Railway Harrogate 42 58 79 52
16 Prescot Cables Prescot 42 51 68 50
17 Chorley Chorley 42 56 76 49
18 Wakefield Wakefield 42 49 58 48
19 Woodley Sports Woodley 42 53 67 45
20 Garforth Town Garforth 42 64 94 40
21 Ossett Albion Ossett 42 52 91 28
22 Rossendale United Rossendale 42 38 94 25
TEMPORADA 2008/2009
NON LEAGUE DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Durham City Durham City 40 98 41 87
2 Skelmersdale United Skelmersdale 40 96 51 86
3 Colwyn Bay Colwyn Bay 40 72 49 76
4 Newcastle Blue Star Newcastle 40 93 54 73
5 Curzon Ashton Curzon 41 68 45 71
6 Ossett Albion Ossett 40 76 61 66
7 Lancaster City Lancaster 39 68 63 64
8 FC Halifax Town Halifax Town 41 72 54 63
9 Wakefield Wakefield 40 65 62 56
10 Mossley Mossley 40 63 70 54
11 Bamber Bridge Bamber 40 69 78 53
12 Clitheroe Clitheroe 40 64 76 52
13 Woodley Sports Woodley 40 57 74 51
14 Chorley Chorley 40 56 66 47
15 Trafford Trafford 40 72 83 46
16 Garforth Town Garforth 40 77 99 44
17 Radcliffe Borough Radcliffe 40 51 66 42
18 Harrogate Railway Harrogate 40 58 82 42
19 Warrington Town Warrington 40 50 73 41
20 Salford City Salford City 40 59 107 36
21 Rossendale United Rossendale 39 52 82 33
TEMPORADA 2007/2008
NON LEAGUE DIVISION 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Bradford Park Avenue Bradford 42 91 43 82
2 United of Manchester United 42 91 49 81
3 Skelmersdale United Skelmersdale 42 94 46 78
4 Curzon Ashton Curzon 42 78 48 78
5 Bamber Bridge Bamber 42 70 54 74
6 Ossett Albion Ossett 42 77 65 70
7 Wakefield Wakefield 41 57 46 64
8 Newcastle Blue Star Newcastle 41 68 57 60
9 Rossendale United Rossendale 42 66 74 59
10 Garforth Town Garforth 42 60 63 56
11 Lancaster City Lancaster 42 54 70 54
12 Harrogate Railway Harrogate 42 51 58 51
13 Clitheroe Clitheroe 42 63 77 50
14 Chorley Chorley 42 56 80 42
15 Mossley Mossley 42 60 100 42
16 Radcliffe Borough Radcliffe 42 53 75 38
17 Woodley Sports Woodley 42 38 65 34
18 Bridlington Town Bridlington 42 42 99 32

  USO DE MEMORIA  
8,649,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5292
Total Execution Time  0.5305
  CADENA URL  
/historico/Curzon-Ashton
  GET DATOS  
$_GET['/historico/Curzon-Ashton']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0228  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 = 'Curzon-Ashton' 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.0127  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10679 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10679 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10679 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10679 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10679 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10679 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133  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 = 72728
0.0135  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 = '10679' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0204  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 = 72728 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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 = 10679 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0132  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 72550 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.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 68218 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.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 63261 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 58732 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 50296 AND t.round = 35 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 44237 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 38704 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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.0148  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.0147  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 = 4013 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 3492 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 24866 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 24880 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 `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 = 24904 AND t.round = 46 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 `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 = 24916 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 25006 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 25021 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC