4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Hastings United Hastings 28 53 21 62
2 Ashford United Ashford 30 75 41 59
3 Whitehawk Whitehawk 28 61 33 56
4 Cray Valley PM Cray Valley 27 50 27 54
5 Herne Bay Herne Bay 28 53 40 51
6 Chichester City Chichester 25 46 34 45
7 Whyteleafe Whyteleafe 27 45 37 45
8 VCD Athletic Athletic 30 48 53 42
9 Sevenoaks Town Sevenoaks 29 43 37 41
10 Hythe Town Hythe Town 29 34 37 40
11 Phoenix Sports Phoenix 26 43 40 38
12 Haywards Heath Town Haywards 26 32 32 36
13 Guernsey Guernsey 28 39 47 36
14 Whitstable Town Whitstable 28 38 41 35
15 Burgess Hill Town Burgess Hill 27 47 60 31
16 Sittingbourne Sittingbourn 28 31 39 28
17 Faversham Town Faversham 29 29 46 28
18 Ramsgate Ramsgate 30 35 68 20
19 Three Bridges Three 28 33 66 17
20 East Grinstead Town East 25 23 59 9
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Cray Wanderers Cray 36 79 35 82
2 Horsham Horsham 36 73 38 74
3 Hastings United Hastings 36 78 45 70
4 Ashford United Ashford 36 74 36 68
5 Haywards Heath Town Haywards 36 65 52 63
6 VCD Athletic Athletic 36 74 66 62
7 Hythe Town Hythe Town 36 66 59 52
8 Whyteleafe Whyteleafe 36 59 51 49
9 Phoenix Sports Phoenix 36 65 65 49
10 Sevenoaks Town Sevenoaks 36 49 54 47
11 Ramsgate Ramsgate 36 54 53 45
12 Whitstable Town Whitstable 36 36 55 43
13 East Grinstead Town East 36 65 72 41
14 Three Bridges Three 36 51 69 41
15 Herne Bay Herne Bay 36 65 85 38
16 Sittingbourne Sittingbourn 36 49 72 37
17 Faversham Town Faversham 36 55 85 37
18 Guernsey Guernsey 36 50 77 30
19 Greenwich Borough Greenwich 36 40 78 30
20 Thamesmead Town FC Thamesmead 0 0 0 0
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 South Shields South 42 112 37 103
2 Scarborough Athletic Scarborough 42 101 42 95
3 Hyde Hyde 42 90 35 92
4 Bamber Bridge Bamber 42 81 54 74
5 Prescot Cables Prescot 42 78 55 72
6 Trafford Trafford 42 61 50 66
7 Tadcaster Albion Tadcaster 42 67 46 62
8 Colne FC Colne FC 42 68 61 62
9 Colwyn Bay Colwyn Bay 42 77 58 61
10 Atherton Collieries Atherton 42 50 55 58
11 Glossop Glossop 42 66 72 53
12 Clitheroe Clitheroe 42 69 79 51
13 Droylsden Droylsden 42 67 77 50
14 Ramsbottom United Ramsbottom 42 61 70 48
15 Ossett Albion Ossett 42 56 76 47
16 Ossett Town Ossett Town 42 55 77 47
17 Brighouse Town Brighouse 42 59 93 46
18 Kendal Town Kendal Town 42 61 89 45
19 Mossley Mossley 42 57 81 44
20 Radcliffe Borough Radcliffe 42 51 89 44
21 Skelmersdale United Skelmersdale 42 53 84 37
22 Goole Goole 42 49 109 31
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Royston Town Royston Town 42 121 45 105
2 Farnborough Farnborough 42 96 51 90
3 Barton Rovers Barton 42 91 66 77
4 Marlow FC Marlow FC 42 65 43 77
5 Egham Town Egham Town 42 79 51 74
6 Kempston Rovers Kempston 42 82 61 73
7 AFC Dunstable Dunstable 42 85 53 71
8 Bedford Town Bedford Town 42 76 58 67
9 Potters Bar Town Potters Town 42 71 61 62
10 Ashford Town Ashford Town 42 73 71 59
11 Kidlington Kidlington 42 70 79 59
12 Hanwell Town Hanwell Town 42 64 67 58
13 Aylesbury United Aylesbury 42 58 68 55
14 Fleet Town Fleet Town 42 72 81 50
15 Beaconsfield Beaconsfield 42 81 85 48
16 Uxbridge Uxbridge 42 67 80 47
17 Arlesey Town Arlesey Town 42 52 69 47
18 Chalfont St Peter Chalfont 42 49 77 47
19 Aylesbury Aylesbury 42 54 75 44
20 Northwood Northwood 42 57 88 39
21 Histon Histon 42 54 93 34
22 Petersfield Town Petersfield 42 32 127 9
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Kings Langley Kings 42 83 44 87
2 Egham Town Egham Town 42 81 39 83
3 Royston Town Royston Town 42 99 55 80
4 St Ives Town Ives Town 42 72 39 78
5 Rushden & Diamonds Rushden 42 81 44 77
6 Chalfont St Peter Chalfont 42 76 71 71
7 Northwood Northwood 42 62 49 69
8 Aylesbury Aylesbury 42 72 52 68
9 Beaconsfield Beaconsfield 42 77 54 67
10 Godalming Town Godalming 42 51 45 67
11 Ware Ware 42 67 69 63
12 Potters Bar Town Potters Town 42 62 64 58
13 Petersfield Town Petersfield 42 71 80 55
14 Bedford Town Bedford Town 42 57 60 49
15 Uxbridge Uxbridge 42 59 71 48
16 Fleet Town Fleet Town 42 64 78 48
17 Arlesey Town Arlesey Town 42 48 87 47
18 Barton Rovers Barton 42 51 75 42
19 Aylesbury United Aylesbury 42 45 81 40
20 Hanwell Town Hanwell Town 42 38 64 39
21 Leighton Town Leighton 42 47 86 35
22 North Greenford United North 42 51 107 24
Ver
TEMPORADA 2014/2015
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
Ver
TEMPORADA 2013/2014
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
Ver
TEMPORADA 2012/2013
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
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 St. Neots Town Neots Town 42 115 36 93
2 Slough Town Slough Town 42 74 42 87
3 Bedworth United Bedworth 42 90 57 78
4 Uxbridge Uxbridge 42 79 59 74
5 Beaconsfield Beaconsfield 42 65 55 69
6 Rugby Town Rugby Town 42 67 65 67
7 Northwood Northwood 42 74 62 66
8 Biggleswade Town Biggleswade 42 75 54 64
9 Ashford Town Ashford Town 42 62 61 59
10 AFC Hayes AFC Hayes 42 58 59 58
11 Barton Rovers Barton 42 64 63 56
12 Chalfont St Peter Chalfont 42 65 68 56
13 Leighton Town Leighton 42 60 67 55
14 Bedfont Town Bedfont Town 42 53 64 54
15 Burnham Burnham 42 64 67 52
16 Daventry Town Daventry 42 52 72 50
17 Chertsey Town Chertsey 42 65 93 50
18 North Greenford United North 42 56 72 49
19 Woodford United Woodford 42 56 70 44
20 Aylesbury Aylesbury 42 50 82 44
21 Fleet Town Fleet Town 42 43 83 32
22 Marlow FC Marlow FC 42 50 86 28
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 East Thurrock United FC East 40 92 38 95
2 Needham Market Needham 40 95 49 87
3 Wingate & Finchley Wingate 40 72 54 72
4 Harlow Town Harlow Town 40 61 51 71
5 Brentwood Town Brentwood 40 75 55 69
6 Enfield Town Enfield Town 40 76 44 68
7 AFC Sudbury AFC Sudbury 40 82 64 66
8 Maldon & Tiptree Maldon 40 70 67 63
9 Heybridge Swifts Heybridge 40 81 59 61
10 Grays Athletic Grays 40 69 51 61
11 Waltham Abbey Waltham 40 75 63 58
12 Romford Romford 40 63 66 55
13 Potters Bar Town Potters Town 40 60 68 51
14 Ware Ware 40 57 77 45
15 Great Wakering Rovers Great 40 60 82 44
16 Redbridge Redbridge 40 51 79 39
17 Thamesmead Town FC Thamesmead 40 42 71 39
18 Cheshunt Cheshunt 40 49 81 38
19 Tilbury Tilbury 40 41 66 37
20 Ilford FC Ilford FC 40 42 81 32
21 Walthamstow Walthamstow 40 43 90 26
Ver
TEMPORADA 2009/2010
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
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Retford United FC Retford 38 88 34 81
2 Belper Town FC Belper Town 37 78 36 81
3 Stocksbridge Park Steels Stocksbridge 38 92 44 75
4 Rushall Olympic Rushall 38 63 42 68
5 Glapwell Glapwell 38 78 58 68
6 Carlton Town Carlton Town 37 78 49 67
7 Stamford Stamford 38 65 51 61
8 Shepshed Shepshed 38 61 61 56
9 Leek Town Leek Town 38 63 60 54
10 Lincoln United FC Lincoln 39 58 69 51
11 Sheffield FC Sheffield 38 67 69 50
12 Quorn Quorn 38 54 63 48
13 Grantham Town Grantham 38 49 65 47
14 Loughborough Dynamo FC Loughborough 38 45 58 46
15 Goole Goole 38 62 85 44
16 Kidsgrove Athletic Kidsgrove 38 49 62 41
17 Spalding United Spalding 39 45 82 40
18 Willenhall Town FC Willenhall 38 55 74 38
19 Gresley Gresley 38 41 78 25
20 Brigg Town Brigg Town 38 41 92 14
Ver
TEMPORADA 2007/2008
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
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Buxton Buxton 43 91 36 94
2 Cammell Laird Cammell 43 100 53 89
3 Eastwood Town Eastwood 43 87 43 80
4 Bradford Park Avenue Bradford 43 70 44 76
5 Stocksbridge Park Steels Stocksbridge 42 78 44 70
6 Colwyn Bay Colwyn Bay 42 70 59 70
7 Rossendale United Rossendale 42 60 49 68
8 Ossett Albion Ossett 43 65 59 65
9 Goole Goole 42 73 79 65
10 Kidsgrove Athletic Kidsgrove 42 86 76 64
11 Woodley Sports Woodley 43 81 65 63
12 Harrogate Railway Harrogate 43 64 75 61
13 Skelmersdale United Skelmersdale 42 65 65 58
14 Bamber Bridge Bamber 42 70 69 57
15 Brigg Town Brigg Town 42 53 69 53
16 Alsager Town Alsager Town 42 65 74 52
17 Clitheroe Clitheroe 43 69 74 51
18 Gresley Gresley 42 54 68 51
19 Belper Town FC Belper Town 43 52 81 51
20 Wakefield Wakefield 43 47 66 49
21 Shepshed Shepshed 42 57 92 46
22 Warrington Town Warrington 42 60 75 44
23 Chorley Chorley 43 51 92 36
24 Bridlington Town Bridlington 43 33 94 22
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Ramsgate Ramsgate 42 84 37 85
2 Horsham Horsham 42 84 53 80
3 Kingstonian Kingstonian 43 78 53 73
4 Tonbridge Angels Tonbridge 41 67 47 73
5 Tooting and Mitcham Tooting 42 91 59 72
6 Metropolitan Police Metropolitan 42 69 46 72
7 Dover Athletic Dover 42 63 44 71
8 Croydon Athletic Croydon 42 54 40 69
9 Hastings United Hastings 42 63 54 68
10 Cray Wanderers Cray 42 78 70 65
11 Bashley Bashley 41 58 53 64
12 Dulwich Hamlet FC Dulwich 42 52 41 62
13 Leatherhead Leatherhead 42 58 50 62
14 Walton Casuals Walton 44 68 76 58
15 Fleet Town Fleet Town 42 48 53 57
16 Whyteleafe Whyteleafe 43 49 62 44
17 New Milton Town Milton Town 41 58 74 44
18 Molesey FC Molesey FC 41 52 73 43
19 Burgess Hill Town Burgess Hill 42 56 79 39
20 Banstead Athletic Banstead 42 40 69 35
21 Ashford Town Kent Ashford Town 42 40 78 34
22 Newport Isle of Wight FC Newport Isle 42 37 92 29
23 Corinthian-Casuals Corinthian-C 42 37 81 26
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Mangotsfield United Mangotsfield 41 88 48 82
2 Yate Town Yate Town 42 83 40 81
3 Clevedon Town Clevedon 43 84 50 81
4 Evesham United Evesham 42 66 31 79
5 Bromsgrove Rovers Bromsgrove 41 59 39 72
6 Brackley Town Brackley 42 69 53 64
7 Ashford Town Ashford Town 41 62 45 63
8 Paulton Rovers Paulton 42 62 61 61
9 Sutton Coldfield Town Sutton 42 54 61 59
10 Rothwell Town Rothwell 42 57 57 58
11 Thame United FC Thame United 43 59 71 57
12 Burnham Burnham 41 61 63 55
13 Corby Town Corby Town 42 52 62 54
14 Marlow FC Marlow FC 42 58 67 53
15 Stourport Swifts Stourport 42 62 63 52
16 Bedworth United Bedworth 42 51 60 52
17 Cinderford Town Cinderford 42 50 64 51
18 Taunton Town Taunton Town 42 66 75 50
19 Swindon Supermarine Swindon 42 43 60 48
20 Bracknell Town FC Bracknell 42 53 75 43
21 Oxford City Oxford City 42 49 71 41
22 Egham Town Egham Town 42 25 97 22

  USO DE MEMORIA  
7,797,592 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5351
Total Execution Time  0.5371
  CADENA URL  
/non_league_div_one2020/grupo3/historico
  GET DATOS  
$_GET['/non_league_div_one2020/grupo3/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0125  SELECT type FROM routes WHERE alias = 'non_league_div_one2020'
0.0254  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'non_league_div_one' AND (l.group_code = 3 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=3 DESC LIMIT 1
0.0130  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 50968 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0143  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 565 AND group_code = 3 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 = 50968 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 44458 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 39170 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 `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 = 33754 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 `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 = 15615 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 `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.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 `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.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 `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 = 24884 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 `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 = 24900 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 `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.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 `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 = 25007 AND t.round = 38 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 `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
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 `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 = 25058 AND t.round = 43 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 `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 = 25099 AND t.round = 44 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 = 25117 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 15:05:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 15:05:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 15:05:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 15:05:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'non_league_div_one' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0127  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 50968 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50968 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 50968 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50968 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0127  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 50968 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50968 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0138  SELECT *,(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 = 50968 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC