4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Chelmsford City Chelmsford 42 84 39 87
2 AFC Wimbledon Wimbledon 42 81 47 75
3 Staines Town Staines Town 41 84 54 75
4 AFC Hornchurch Hornchurch 42 68 44 70
5 Ramsgate Ramsgate 42 67 53 68
6 Ashford Town Ashford Town 42 79 65 66
7 Hendon Hendon 42 79 67 65
8 Margate Margate 43 75 70 65
9 Tonbridge Angels Tonbridge 42 77 57 63
10 Billericay Town Billericay 42 66 57 60
11 Horsham Horsham 42 63 63 59
12 Hastings United Hastings 43 59 67 56
13 Wealdstone Wealdstone 42 68 75 54
14 Harlow Town Harlow Town 41 56 51 52
15 Heybridge Swifts Heybridge 41 60 63 52
16 Harrow Borough Harrow 41 61 73 52
17 East Thurrock United FC East 43 49 68 52
18 Boreham Wood Boreham Wood 41 55 69 50
19 Carshalton Athletic Carshalton 43 52 66 50
20 Folkestone Invicta Folkestone 43 50 71 50
21 Maidstone United Maidstone 41 55 79 49
22 Leyton FC Leyton FC 43 37 127 16
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Hampton & Richmond Hampton 42 77 53 82
2 Bromley Bromley 42 83 43 80
3 AFC Wimbledon Wimbledon 42 76 37 78
4 Chelmsford City Chelmsford 42 96 51 77
5 Billericay Town Billericay 41 69 39 77
6 Margate Margate 42 79 48 71
7 Horsham Horsham 43 72 57 71
8 Boreham Wood Boreham Wood 41 66 45 66
9 Ramsgate Ramsgate 43 63 65 65
10 Heybridge Swifts Heybridge 42 57 40 64
11 Tonbridge Angels Tonbridge 43 75 74 64
12 Staines Town Staines Town 42 64 64 57
13 Hendon Hendon 42 53 64 54
14 Carshalton Athletic Carshalton 41 51 57 51
15 Leyton FC Leyton FC 42 55 77 49
16 East Thurrock United FC East 42 56 70 48
17 Ashford Town Ashford Town 41 55 66 46
18 Folkestone Invicta Folkestone 42 45 66 46
19 Harrow Borough Harrow 41 59 70 42
20 Walton & Hersham Walton 43 40 84 36
21 Worthing Worthing 41 56 80 35
22 Slough Town Slough Town 42 26 123 18
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Salisbury City Salisbury 42 84 27 95
2 Bath City Bath City 42 66 33 83
3 Kings Lynn Town Kings Lynn. 42 73 41 82
4 Chippenham Town Chippenham 42 69 45 77
5 Bedford Town Bedford Town 42 69 53 76
6 Yate Town Yate Town 41 78 71 68
7 Banbury United Banbury 42 66 61 62
8 Halesowen Town Halesowen 41 54 44 60
9 Merthyr Tydfil FC Merthyr 42 62 58 60
10 Mangotsfield United Mangotsfield 41 67 64 58
11 Grantham Town Grantham 42 49 49 56
12 Tiverton Town Tiverton 42 69 65 52
13 Hitchin Town Hitchin Town 42 60 76 51
14 Rugby Town Rugby Town 42 58 66 50
15 Gloucester City Gloucester 41 55 61 49
16 Cheshunt Cheshunt 42 57 70 48
17 Cirencester Town Cirencester 42 49 68 46
18 Team Bath Team Bath 42 52 71 45
19 Northwood Northwood 42 53 88 42
20 Evesham United Evesham 42 46 58 41
21 Aylesbury United Aylesbury 42 43 69 39
22 Chesham United Chesham 42 43 84 36
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Yeading Yeading 42 74 48 86
2 Billericay Town Billericay 42 78 40 80
3 Eastleigh Eastleigh 42 84 49 79
4 Braintree Town Braintree 42 67 33 74
5 Leyton FC Leyton FC 42 71 57 71
6 Hampton & Richmond Hampton 42 64 53 71
7 Chelmsford City Chelmsford 42 63 58 62
8 Heybridge Swifts Heybridge 41 73 64 60
9 Staines Town Staines Town 42 59 53 60
10 Worthing Worthing 43 50 45 60
11 Hendon Hendon 43 48 60 59
12 Salisbury City Salisbury 43 61 66 57
13 Slough Town Slough Town 42 61 66 55
14 Folkestone Invicta Folkestone 41 50 50 52
15 Harrow Borough Harrow 43 43 55 52
16 Windsor & Eton FC Windsor Eton 42 48 62 50
17 Northwood Northwood 42 49 66 49
18 Wealdstone Wealdstone 42 60 73 47
19 Cheshunt Cheshunt 41 55 71 44
20 Tonbridge Angels Tonbridge 42 47 73 43
21 Dover Athletic Dover 42 50 66 39
22 Kingstonian Kingstonian 41 43 90 26

  USO DE MEMORIA  
5,752,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0937
Total Execution Time  0.0956
  CADENA URL  
/non_league_premier2008/grupo1/historico
  GET DATOS  
$_GET['/non_league_premier2008/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0021  SELECT type FROM routes WHERE alias = 'non_league_premier2008'
0.0041  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 = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=562 AND type_rel = 3
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 562 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1290901,1227363,1202560,1153265,1096842) ORDER BY n.cover_points DESC, update_date DESC
0.0020  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 = 24398 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 562 AND group_code = 1 and tables = 1 AND year <= 2008 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0027  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 = 24398 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 24383 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 = 24375 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 24363 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 21:06:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 21:06:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 21:06:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 21:06:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  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 = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0030  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 events2008 e ON e.player_id = p.id AND e.league_id = 24398 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 24398 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.0027  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 events2008 e ON e.player_id = p.id AND e.league_id = 24398 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 24398 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0027  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 events2008 e ON e.player_id = p.id AND e.league_id = 24398 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 24398 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0105  SELECT *,(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 = 24398 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC