4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Radcliffe Borough Radcliffe 41 108 60 90
2 Macclesfield Town Macclesfield 41 85 47 80
3 Marine Marine 41 89 45 79
4 Warrington Rylands 1906 FC Warrington 40 65 42 75
5 Worksop Town Worksop Town 41 75 49 73
6 Hyde Hyde 41 71 48 70
7 Ashton United Ashton 42 76 65 70
8 Ilkeston Town FC Ilkeston 42 75 64 66
9 Gainsborough Trinity Gainsborough 41 68 66 63
10 Whitby Town Whitby Town 41 64 52 62
11 Lancaster City Lancaster 40 60 62 62
12 Guiseley Guiseley 41 71 66 61
13 Morpeth Town Morpeth Town 42 82 83 56
14 Matlock Town Matlock Town 42 70 77 53
15 United of Manchester United 41 60 79 52
16 Bamber Bridge Bamber 41 64 85 47
17 Workington Workington 42 67 85 44
18 Basford United Basford 41 44 66 37
19 Bradford Park Avenue Bradford 41 51 85 33
20 Stafford Rangers Stafford 40 36 81 30
21 Atherton Collieries Atherton 41 48 100 25
22 Marske United Marske 23 31 53 24
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 South Shields South 42 71 39 85
2 Warrington Town Warrington 42 70 39 77
3 Bamber Bridge Bamber 42 62 63 73
4 Gainsborough Trinity Gainsborough 42 74 41 69
5 Matlock Town Matlock Town 42 56 49 68
6 Hyde Hyde 42 64 42 66
7 Radcliffe Borough Radcliffe 42 55 49 66
8 United of Manchester United 42 68 48 63
9 Marine Marine 42 56 45 61
10 Warrington Rylands 1906 FC Warrington 42 64 55 60
11 Lancaster City Lancaster 42 51 51 58
12 Stafford Rangers Stafford 42 52 53 57
13 Guiseley Guiseley 42 54 54 55
14 Ashton United Ashton 42 58 64 53
15 Whitby Town Whitby Town 42 45 54 52
16 Marske United Marske 42 57 79 50
17 Morpeth Town Morpeth Town 42 55 63 49
18 Atherton Collieries Atherton 42 38 57 47
19 Nantwich Town Nantwich 42 44 55 46
20 Stalybridge Celtic Stalybridge 42 50 64 42
21 Liversedge Liversedge 42 48 86 40
22 Belper Town FC Belper Town 42 44 86 30
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Taunton Town Taunton Town 42 83 42 91
2 Hayes & Yeading United Hayes 42 100 39 86
3 Farnborough Farnborough 42 73 44 85
4 Metropolitan Police Metropolitan 42 72 46 81
5 Weston-super-Mare Weston-super 42 72 42 78
6 Chesham United Chesham 42 80 50 77
7 Yate Town Yate Town 42 66 48 72
8 Truro City Truro City 42 62 54 70
9 Gosport Borough Gosport 42 65 56 66
10 Poole Town Poole Town 42 74 69 64
11 Walton Casuals Walton 42 53 61 58
12 Swindon Supermarine Swindon 42 63 63 57
13 Tiverton Town Tiverton 42 61 63 53
14 Harrow Borough Harrow 42 63 77 52
15 Salisbury City Salisbury 42 49 75 48
16 Hendon Hendon 42 58 70 47
17 Beaconsfield Beaconsfield 42 70 92 46
18 Hartley Wintney Hartley 42 56 75 44
19 Dorchester Town Dorchester 42 41 58 41
20 Kings Langley Kings 42 49 68 37
21 Merthyr Town Merthyr Town 42 47 94 26
22 Wimborne Town Wimborne 42 35 106 19
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Mickleover Sports FC Mickleover 10 23 11 22
2 Buxton Buxton 9 23 11 20
3 Basford United Basford 9 15 9 19
4 Warrington Town Warrington 10 16 12 16
5 Witton Albion Witton 7 13 7 15
6 South Shields South 9 12 8 15
7 Matlock Town Matlock Town 6 10 4 13
8 Atherton Collieries Atherton 8 13 8 13
9 Gainsborough Trinity Gainsborough 8 13 12 12
10 Whitby Town Whitby Town 8 13 13 11
11 Scarborough Athletic Scarborough 8 10 11 11
12 Lancaster City Lancaster 7 12 10 10
13 United of Manchester United 7 9 7 10
14 Radcliffe Borough Radcliffe 9 15 23 10
15 Nantwich Town Nantwich 6 9 9 9
16 Morpeth Town Morpeth Town 6 8 8 9
17 Hyde Hyde 6 5 6 6
18 Stalybridge Celtic Stalybridge 9 7 17 6
19 Ashton United Ashton 7 5 13 5
20 Bamber Bridge Bamber 9 6 17 4
21 Grantham Town Grantham 8 5 14 3
22 Stafford Rangers Stafford 8 3 15 1
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 South Shields South 33 64 34 69
2 United of Manchester United 32 73 51 57
3 Warrington Town Warrington 32 57 44 55
4 Basford United Basford 32 49 39 55
5 Lancaster City Lancaster 34 58 46 53
6 Nantwich Town Nantwich 31 55 39 52
7 Whitby Town Whitby Town 31 54 42 50
8 Scarborough Athletic Scarborough 35 44 47 50
9 Morpeth Town Morpeth Town 27 48 37 48
10 Hyde Hyde 33 55 55 43
11 Gainsborough Trinity Gainsborough 32 53 50 42
12 Stalybridge Celtic Stalybridge 33 42 50 42
13 Bamber Bridge Bamber 33 53 64 40
14 Witton Albion Witton 31 40 43 39
15 Mickleover Sports FC Mickleover 29 42 52 38
16 Radcliffe Borough Radcliffe 32 34 50 38
17 Ashton United Ashton 29 40 45 36
18 Buxton Buxton 32 56 52 35
19 Grantham Town Grantham 32 38 71 30
20 Matlock Town Matlock Town 28 36 43 29
21 Atherton Collieries Atherton 26 36 49 28
22 Stafford Rangers Stafford 33 29 53 23
Ver
TEMPORADA 2018/2019
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
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Hemel Hempstead Town Hemel 2 4 2 4
2 Gosport Borough Gosport 2 4 3 4
3 Stourbridge Stourbridge 1 1 2 0
4 Chesham United Chesham 1 0 2 0

  USO DE MEMORIA  
6,320,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4064
Total Execution Time  0.4083
  CADENA URL  
/non_league_premier2024/grupo4/historico
  GET DATOS  
$_GET['/non_league_premier2024/grupo4/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0144  SELECT type FROM routes WHERE alias = 'non_league_premier2024'
0.0294  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'non_league_premier' AND (l.group_code = 4 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=4 DESC LIMIT 1
0.0147  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 = 72855 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 562 AND group_code = 4 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 68453 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.0153  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 = 63527 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.0149  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 = 58616 AND t.round = 18 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 = 50617 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.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 `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 = 24451 AND t.round = 2 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 21:55:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 21:55:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 21:55:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 21:55:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0330  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 events2024 e ON e.player_id = p.id AND e.league_id = 72855 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72855 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.0155  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 events2024 e ON e.player_id = p.id AND e.league_id = 72855 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72855 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0170  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 events2024 e ON e.player_id = p.id AND e.league_id = 72855 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72855 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0170  SELECT *,(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 = 72855 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