4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Farsley Celtic
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
NON LEAGUE PREMIER GRUPO 4
Equipo PJ GF GC Puntos
1 Farsley Celtic Farsley 40 82 40 90
2 South Shields South 40 86 41 87
3 Warrington Town Warrington 40 69 33 84
4 Nantwich Town Nantwich 40 70 59 69
5 Buxton Buxton 40 60 45 66
6 Gainsborough Trinity Gainsborough 40 53 41 65
7 Basford United Basford 40 82 67 61
8 Scarborough Athletic Scarborough 40 70 56 61
9 Witton Albion Witton 40 45 41 58
10 Hyde Hyde 40 58 53 53
11 Whitby Town Whitby Town 40 48 59 49
12 Lancaster City Lancaster 40 42 61 49
13 Hednesford Town Hednesford 40 51 63 48
14 Stafford Rangers Stafford 40 62 70 47
15 Matlock Town Matlock Town 40 58 79 44
16 Bamber Bridge Bamber 40 62 67 42
17 Stalybridge Celtic Stalybridge 40 46 62 42
18 Grantham Town Grantham 40 39 72 42
19 Mickleover Sports FC Mickleover 40 37 61 41
20 Marine Marine 40 39 54 40
21 Workington Workington 40 38 73 29
22 North Ferriby United North 0 0 0 0
TEMPORADA 2017/2018
NON LEAGUE PREMIER GRUPO 2
Equipo PJ GF GC Puntos
1 Altrincham Altrincham 46 101 42 95
2 Ashton United Ashton 46 85 59 82
3 Warrington Town Warrington 46 72 49 82
4 Grantham Town Grantham 46 90 55 81
5 Farsley Celtic Farsley 46 87 69 80
6 Shaw Lane Aquaforce Shaw Lane A. 46 79 62 79
7 Witton Albion Witton 46 83 63 70
8 Rushall Olympic Rushall 45 72 78 65
9 Barwell Barwell 46 65 67 64
10 Buxton Buxton 46 71 66 64
11 Workington Workington 46 72 69 62
12 Stourbridge Stourbridge 46 67 56 62
13 Stafford Rangers Stafford 46 54 58 61
14 Mickleover Sports FC Mickleover 46 68 60 61
15 Matlock Town Matlock Town 46 69 75 60
16 Nantwich Town Nantwich 46 62 72 57
17 Hednesford Town Hednesford 45 59 78 56
18 Lancaster City Lancaster 46 66 72 55
19 Marine Marine 46 67 78 53
20 Coalville Town Coalville 46 70 92 52
21 Whitby Town Whitby Town 46 60 82 50
22 Stalybridge Celtic Stalybridge 46 57 90 48
23 Halesowen Town Halesowen 46 48 76 45
24 Sutton Coldfield Town Sutton 46 52 108 35
TEMPORADA 2016/2017
NON LEAGUE DIVISION 1 GRUPO 5
Equipo PJ GF GC Puntos
1 Lancaster City Lancaster 42 73 41 85
2 Farsley Celtic Farsley 42 100 50 84
3 Colne FC Colne FC 42 74 50 73
4 Scarborough Athletic Scarborough 42 70 47 73
5 Ossett Town Ossett Town 42 68 48 73
6 Trafford Trafford 42 79 45 70
7 Clitheroe Clitheroe 42 74 54 70
8 Glossop Glossop 42 72 70 69
9 Brighouse Town Brighouse 42 66 48 68
10 Hyde Hyde 42 78 58 62
11 Ramsbottom United Ramsbottom 42 64 81 57
12 Bamber Bridge Bamber 42 59 58 55
13 Kendal Town Kendal Town 42 61 62 54
14 Droylsden Droylsden 42 71 77 54
15 Colwyn Bay Colwyn Bay 42 61 57 50
16 Prescot Cables Prescot 42 71 81 50
17 Mossley Mossley 42 67 87 46
18 Ossett Albion Ossett 42 47 78 45
19 Tadcaster Albion Tadcaster 42 57 70 44
20 Radcliffe Borough Radcliffe 42 59 82 44
21 Goole Goole 42 39 83 36
22 Burscough Burscough 42 26 109 24
TEMPORADA 2015/2016
NON LEAGUE DIVISION 1 GRUPO 5
Equipo PJ GF GC Puntos
1 Warrington Town Warrington 42 121 36 106
2 Northwich Victoria Northwich 42 102 41 92
3 Spennymoor Town Spennymoor 42 113 35 91
4 Glossop Glossop 42 78 41 81
5 Burscough Burscough 42 81 50 80
6 Lancaster City Lancaster 42 74 57 69
7 Clitheroe Clitheroe 42 90 86 69
8 Trafford Trafford 42 78 51 65
9 Farsley Celtic Farsley 42 82 50 63
10 Ossett Albion Ossett 42 56 63 63
11 Witton Albion Witton 42 85 72 61
12 Bamber Bridge Bamber 42 73 55 60
13 Mossley Mossley 42 80 76 60
14 Brighouse Town Brighouse 42 75 72 59
15 Kendal Town Kendal Town 42 62 80 52
16 Prescot Cables Prescot 42 66 99 46
17 Ossett Town Ossett Town 42 51 94 43
18 Radcliffe Borough Radcliffe 42 54 75 40
19 Droylsden Droylsden 42 68 139 39
20 Scarborough Athletic Scarborough 42 40 64 38
21 Harrogate Railway Harrogate 42 52 115 26
22 New Mills New Mills 42 26 156 3
TEMPORADA 2014/2015
NON LEAGUE DIVISION 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Salford City Salford City 42 92 42 95
2 Darlington FC Darlington 42 99 37 91
3 Bamber Bridge Bamber 42 88 58 83
4 Northwich Victoria Northwich 42 75 39 82
5 Spennymoor Town Spennymoor 42 76 45 77
6 Scarborough Athletic Scarborough 42 80 61 75
7 Mossley Mossley 42 79 63 75
8 Harrogate Railway Harrogate 42 85 75 67
9 Warrington Town Warrington 42 65 55 65
10 Droylsden Droylsden 42 98 84 63
11 Lancaster City Lancaster 42 65 53 62
12 Farsley Celtic Farsley 42 73 64 61
13 Clitheroe Clitheroe 42 73 81 52
14 Brighouse Town Brighouse 42 64 81 51
15 Burscough Burscough 42 62 73 48
16 Kendal Town Kendal Town 42 81 92 46
17 Ossett Albion Ossett 42 49 72 46
18 Ossett Town Ossett Town 42 48 83 42
19 Radcliffe Borough Radcliffe 42 49 91 35
20 Prescot Cables Prescot 42 47 86 33
21 New Mills New Mills 42 56 107 25
22 Padiham Padiham 42 50 112 24
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 2008/2009
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 Tamworth Tamworth 42 70 41 85
2 Gateshead Gateshead 42 81 48 80
3 Alfreton Town Alfreton 42 81 48 77
4 AFC Telford United Telford 42 65 34 76
5 Southport Southport 42 63 36 76
6 Stalybridge Celtic Stalybridge 42 71 50 70
7 Droylsden Droylsden 42 64 44 68
8 Fleetwood Town Fleetwood 42 70 66 62
9 Harrogate Town Harrogate 42 66 57 61
10 Hinckley United Hinckley 42 56 59 57
11 Vauxhall Motors Vauxhall 42 51 67 53
12 Workington Workington 42 54 55 51
13 Gainsborough Trinity Gainsborough 42 57 63 50
14 Redditch United Redditch 42 49 61 50
15 Blyth Spartans Blyth 42 50 58 49
16 Solihull Moors Solihull 42 49 73 49
17 Kings Lynn Town Kings Lynn. 42 50 60 48
18 Stafford Rangers Stafford 42 41 56 48
19 Farsley Celtic Farsley 42 58 65 47
20 Hyde Hyde 42 57 80 42
21 Burscough Burscough 42 43 80 36
22 Hucknall Town Hucknall 42 39 84 28
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 NORTH
Equipo PJ GF GC Puntos
1 Droylsden Droylsden 42 85 55 78
2 Kettering Town Kettering 42 75 58 73
3 Workington Workington 42 61 46 70
4 Hinckley United Hinckley 42 68 54 69
5 Farsley Celtic Farsley 42 58 51 68
6 Harrogate Town Harrogate 42 58 41 67
7 Blyth Spartans Blyth 42 57 49 66
8 Hyde Hyde 42 79 62 65
9 Worcester City Worcester 42 67 54 62
10 Nuneaton Town Nuneaton 42 54 45 60
11 Moor Green Moor Green 42 53 51 59
12 Gainsborough Trinity Gainsborough 42 51 57 56
13 Hucknall Town Hucknall 42 69 69 54
14 Alfreton Town Alfreton 42 44 50 54
15 Vauxhall Motors Vauxhall 42 62 64 51
16 Barrow Barrow 42 47 48 50
17 Leigh Leigh 42 47 61 49
18 Stalybridge Celtic Stalybridge 42 64 81 49
19 Redditch United Redditch 42 61 68 48
20 Scarborough Scarborough 42 50 45 45
21 Worksop Town Worksop Town 42 44 62 45
22 Lancaster City Lancaster 42 27 110 1
TEMPORADA 2005/2006
NON LEAGUE PREMIER GRUPO 3
Equipo PJ GF GC Puntos
1 Blyth Spartans Blyth 43 84 32 92
2 Frickley Athletic Frickley 42 73 36 86
3 Marine Marine 42 61 25 81
4 Farsley Celtic Farsley 42 84 34 79
5 North Ferriby United North 42 77 54 73
6 Whitby Town Whitby Town 41 59 57 64
7 Witton Albion Witton 42 67 53 60
8 Burscough Burscough 41 62 63 60
9 AFC Telford United Telford 42 54 52 59
10 Ossett Town Ossett Town 42 57 61 58
11 Matlock Town Matlock Town 41 57 54 56
12 Leek Town Leek Town 42 50 53 56
13 Prescot Cables Prescot 42 49 60 53
14 Guiseley Guiseley 41 45 58 51
15 Ashton United Ashton 42 62 63 49
16 Ilkeston Town FC Ilkeston 42 48 51 49
17 Gateshead Gateshead 41 50 75 45
18 Radcliffe Borough Radcliffe 42 54 62 44
19 Lincoln United FC Lincoln 41 42 61 43
20 Wakefield Wakefield 42 38 69 42
21 Bradford Park Avenue Bradford 42 63 86 39
22 Runcorn Linnets Runcorn 43 36 113 29
TEMPORADA 2004/2005
NON LEAGUE PREMIER GRUPO 3
Equipo PJ GF GC Puntos
1 Workington Workington 43 75 31 88
2 Hyde Hyde 42 80 43 86
3 Farsley Celtic Farsley 42 81 41 83
4 Whitby Town Whitby Town 41 63 47 79
5 Burscough Burscough 42 93 74 70
6 Guiseley Guiseley 43 74 65 64
7 Prescot Cables Prescot 41 61 53 64
8 Witton Albion Witton 41 54 42 61
9 Radcliffe Borough Radcliffe 43 61 64 60
10 Leek Town Leek Town 41 62 50 59
11 Matlock Town Matlock Town 43 60 69 55
12 Wakefield Wakefield 42 60 67 52
13 Blyth Spartans Blyth 41 51 55 49
14 Lincoln United FC Lincoln 41 53 64 47
15 Marine Marine 42 53 60 46
16 Ossett Town Ossett Town 42 53 62 46
17 Spennymoor Town Spennymoor 42 44 65 46
18 Gateshead Gateshead 42 61 84 45
19 Frickley Athletic Frickley 42 44 57 44
20 Bishop Auckland Bishop 42 51 74 40
21 Bamber Bridge Bamber 42 48 92 34
22 Bridlington Town Bridlington 42 43 66 33

  USO DE MEMORIA  
8,851,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.7285
Total Execution Time  0.7297
  CADENA URL  
/historico/Farsley
  GET DATOS  
$_GET['/historico/Farsley']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0152  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 = 'Farsley' 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=2847 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=2847 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=2847 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=2847 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=2847 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2847 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=172 AND type_rel = 3
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 172 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0129  SELECT /*53 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 (1118647,957265,792822,730963,607236) ORDER BY n.cover_points DESC, update_date DESC
0.0135  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 = '2847' ORDER BY l.year DESC,cat.coefficient DESC
0.0135  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 = '2847' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0134  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 = '2847' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 72550 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  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=2847 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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,72550,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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 72550 AND teamId = 2847
0.0136  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 2847
0.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 2847
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2847
0.0256  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 = 72550 AND t.round = 46 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '2847' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2847' and rp.type = 4
0.0126  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 = '2847' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0140  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 = 72550 WHERE rp.league_id = 72550 AND rp.teamId = 2847 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.0137  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72550 WHERE rp.league_id = 72550 AND rp.teamId = 2847 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72550 WHERE rp.league_id = 72550 AND rp.teamId = 2847 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 2847 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.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 `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.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 `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.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 `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 = 44472 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 `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 = 39018 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 33756 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 15617 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 4399 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 `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.0136  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 `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 = 12903 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 `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.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 `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 = 12901 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 24370 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 72550 ORDER BY nameShow LIMIT 100