4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Histon Histon 42 93 57 78
2 Chippenham Town Chippenham 42 81 55 75
3 Merthyr Tydfil FC Merthyr 42 62 47 71
4 Hednesford Town Hednesford 42 68 40 70
5 Bedford Town Bedford Town 42 70 52 69
6 Bath City Bath City 42 57 43 69
7 Tiverton Town Tiverton 42 70 55 67
8 Cirencester Town Cirencester 41 60 52 65
9 Kings Lynn Town Kings Lynn. 43 79 69 64
10 Halesowen Town Halesowen 41 62 52 63
11 Aylesbury United Aylesbury 43 67 67 63
12 Grantham Town Grantham 41 57 53 58
13 Chesham United Chesham 41 82 82 56
14 Team Bath Team Bath 41 54 66 54
15 Gloucester City Gloucester 42 63 61 53
16 Rugby Town Rugby Town 42 48 60 51
17 Banbury United Banbury 42 56 69 48
18 Hitchin Town Hitchin Town 42 55 77 48
19 Hemel Hempstead Town Hemel 42 60 88 43
20 Dunstable Town Dunstable 42 56 98 39
21 Stamford Stamford 41 40 57 36
22 Solihull Borough Solihull 42 45 85 34

  USO DE MEMORIA  
5,167,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3336
Total Execution Time  0.3357
  CADENA URL  
/non_league_premier2005/grupo2/historico
  GET DATOS  
$_GET['/non_league_premier2005/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0144  SELECT type FROM routes WHERE alias = 'non_league_premier2005'
0.0292  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 = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2005 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0151  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 = 24368 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 562 AND group_code = 2 and tables = 1 AND year <= 2005 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0167  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 = 24368 AND t.round = 42 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-05-10 07:46:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-10 07:46:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-10 07:46:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-10 07:46:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0155  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 = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2005 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0154  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 events2005 e ON e.player_id = p.id AND e.league_id = 24368 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 24368 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.0157  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 events2005 e ON e.player_id = p.id AND e.league_id = 24368 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 24368 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0146  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 events2005 e ON e.player_id = p.id AND e.league_id = 24368 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 24368 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0162  SELECT *,(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 = 24368 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC