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 Thatcham Town Thatcham 27 66 28 58
2 Frome Town Frome Town 27 56 26 57
3 Larkhall Athletic Larkhall 27 45 37 49
4 Winchester City Winchester 27 53 37 48
5 Melksham Town Melksham 28 58 51 47
6 Cirencester Town Cirencester 27 58 38 45
7 Paulton Rovers Paulton 27 61 43 45
8 Cinderford Town Cinderford 26 59 45 43
9 Evesham United Evesham 27 51 49 40
10 Sholing Sholing 25 39 33 38
11 Bideford Bideford 28 49 50 37
12 Slimbridge Slimbridge 26 54 53 35
13 Highworth Town Highworth 28 36 41 32
14 Willand Rovers Willand 24 32 37 32
15 Bristol Manor Farm Bristol 27 31 44 30
16 AFC Totton AFC Totton 27 39 53 29
17 Mangotsfield United Mangotsfield 29 46 65 28
18 Moneyfields Moneyfields 25 37 50 27
19 Basingstoke Town Basingstoke 27 34 76 18
20 Barnstaple Town Barnstaple 27 26 74 16
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Atherton Collieries Atherton 38 89 34 82
2 Radcliffe Borough Radcliffe 38 73 34 75
3 Leek Town Leek Town 38 78 34 74
4 Colne FC Colne FC 38 71 44 73
5 Ramsbottom United Ramsbottom 38 78 41 72
6 Runcorn Linnets Runcorn 38 69 50 72
7 Prescot Cables Prescot 38 84 54 69
8 Mossley Mossley 38 66 51 65
9 Trafford Trafford 38 53 44 61
10 Kidsgrove Athletic Kidsgrove 38 58 40 58
11 Colwyn Bay Colwyn Bay 38 73 66 52
12 Widnes Widnes 38 60 61 51
13 Chasetown Chasetown 38 61 63 46
14 Droylsden Droylsden 38 61 72 43
15 Newcastle Town Newcastle 38 52 74 40
16 Market Drayton Town Market 37 53 90 40
17 Glossop Glossop 38 41 74 31
18 Clitheroe Clitheroe 38 45 88 28
19 Kendal Town Kendal Town 37 28 92 16
20 Skelmersdale United Skelmersdale 38 24 111 13

  USO DE MEMORIA  
5,230,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3529
Total Execution Time  0.3548
  CADENA URL  
/non_league_div_one2020/grupo7/historico
  GET DATOS  
$_GET['/non_league_div_one2020/grupo7/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0295  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 = 7 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=7 DESC LIMIT 1
0.0154  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 = 50972 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0161  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 565 AND group_code = 7 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0163  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 = 50972 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.0296  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 = 44462 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 15:46:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 15:46:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 15:46:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 15:46:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0156  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 = 50972 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50972 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 events2020 e ON e.player_id = p.id AND e.league_id = 50972 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50972 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0156  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 = 50972 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50972 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0341  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 = 50972 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