4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
National League 2009
2008/2009

conference inglaterra, national league, conference inglesa, national league inglesa, conference national inglesa, conference national inglaterra, Vanarama National League

National League 2009

  • Burton Albion
  • Cambridge United
  • Histon
  • Torquay United
  • Oxford United
  • Stevenage
  • Kidderminster Harriers
  • Kettering Town
  • Crawley Town
  • Wrexham AFC
  • Mansfield Town
  • Rushden & Diamonds
  • Eastbourne Borough
  • Ebbsfleet United
  • Altrincham
  • Salisbury City
  • York City
  • Forest Green Rovers
  • Grays Athletic
  • Barrow
  • Woking
  • Northwich Victoria
  • Weymouth
  • Lewes
  • Conference National
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Burton Albion Burton 46 81 52 88
2 Cambridge United Cambridge 46 65 39 86
3 Histon Histon 46 78 48 83
4 Torquay United Torquay 46 72 47 83
5 Oxford United Oxford 46 72 51 82
6 Stevenage Stevenage 46 73 54 81
7 Kidderminster Harriers Kidderminste 46 69 48 79
8 Kettering Town Kettering 46 50 37 76
9 Crawley Town Crawley Town 46 77 55 71
10 Wrexham AFC Wrexham AFC 46 64 48 66
11 Mansfield Town Mansfield 46 57 55 66
12 Rushden & Diamonds Rushden 46 61 50 63
13 Eastbourne Borough Eastbourne 46 58 70 60
14 Ebbsfleet United Ebbsfleet 46 52 60 58
15 Altrincham Altrincham 46 49 66 56
16 Salisbury City Salisbury 46 54 64 55
17 York City York City 46 47 51 52
18 Forest Green Rovers Forest Green 46 70 76 52
19 Grays Athletic Grays 46 44 64 52
20 Barrow Barrow 46 51 65 51
21 Woking Woking 46 37 60 44
22 Northwich Victoria Northwich 46 56 75 43
23 Weymouth Weymouth 46 45 86 43
24 Lewes Lewes 46 28 89 24
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Aldershot Town Aldershot 46 82 48 101
2 Cambridge United Cambridge 46 68 41 86
3 Torquay United Torquay 46 83 57 86
4 Exeter City Exeter City 46 83 58 83
5 Burton Albion Burton 46 79 56 81
6 Stevenage Stevenage 46 82 55 79
7 Histon Histon 46 76 67 72
8 Forest Green Rovers Forest Green 46 76 59 71
9 Oxford United Oxford 46 56 48 71
10 Grays Athletic Grays 46 58 47 70
11 Ebbsfleet United Ebbsfleet 46 65 61 69
12 Salisbury City Salisbury 46 70 60 68
13 Kidderminster Harriers Kidderminste 46 74 57 67
14 Crawley Town Crawley Town 46 73 67 66
15 York City York City 46 71 74 62
16 Rushden & Diamonds Rushden 46 55 55 59
17 Woking Woking 46 53 61 53
18 FC Halifax Town Halifax Town 46 61 70 52
19 Weymouth Weymouth 46 53 73 46
20 Northwich Victoria Northwich 46 52 78 44
21 Altrincham Altrincham 46 56 82 41
22 Farsley Celtic Farsley 46 48 86 39
23 Stafford Rangers Stafford 46 42 99 25
24 Droylsden Droylsden 46 46 103 24
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Dagenham & Redbridge Dagenham 46 93 48 95
2 Oxford United Oxford 46 66 33 81
3 Morecambe Morecambe 46 64 46 81
4 York City York City 46 65 45 80
5 Exeter City Exeter City 46 67 48 78
6 Burton Albion Burton 46 52 47 75
7 Ebbsfleet United Ebbsfleet 46 63 56 74
8 Stevenage Stevenage 46 76 66 70
9 Aldershot Town Aldershot 46 64 62 65
10 Crawley Town Crawley Town 46 52 52 63
11 Kidderminster Harriers Kidderminste 46 43 50 63
12 Weymouth Weymouth 46 57 73 63
13 Rushden & Diamonds Rushden 46 58 54 62
14 Northwich Victoria Northwich 46 51 69 58
15 Forest Green Rovers Forest Green 46 59 64 57
16 Woking Woking 46 56 61 57
17 FC Halifax Town Halifax Town 46 55 62 55
18 Cambridge United Cambridge 46 57 66 55
19 Grays Athletic Grays 46 56 55 52
20 Stafford Rangers Stafford 46 49 71 52
21 Altrincham Altrincham 46 53 67 51
22 Tamworth Tamworth 46 43 61 48
23 Southport Southport 46 57 68 47
24 St. Albans City Albans City 46 57 89 40
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Accrington Stanley Accrington 42 76 45 91
2 Hereford United Hereford 42 59 33 80
3 Grays Athletic Grays 42 94 55 76
4 FC Halifax Town Halifax Town 42 55 40 75
5 Morecambe Morecambe 42 68 41 74
6 Stevenage Stevenage 42 63 47 69
7 Exeter City Exeter City 42 65 48 63
8 York City York City 42 63 48 63
9 Burton Albion Burton 42 50 52 60
10 Dagenham & Redbridge Dagenham 42 63 59 58
11 Woking Woking 42 58 47 56
12 Cambridge United Cambridge 42 51 57 55
13 Aldershot Town Aldershot 42 61 74 54
14 Canvey Island Canvey 42 47 58 51
15 Kidderminster Harriers Kidderminste 42 39 55 50
16 Ebbsfleet United Ebbsfleet 42 45 57 49
17 Crawley Town Crawley Town 42 48 55 47
18 Altrincham Altrincham 42 40 72 41
19 Southport Southport 42 36 68 40
20 Forest Green Rovers Forest Green 42 49 62 38
21 Tamworth Tamworth 42 32 63 38
22 Scarborough Scarborough 42 40 66 37
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Barnet Barnet 42 90 44 86
2 Hereford United Hereford 42 68 41 74
3 Carlisle United Carlisle 42 74 37 73
4 Aldershot Town Aldershot 42 68 52 73
5 Stevenage Stevenage 42 65 52 72
6 Exeter City Exeter City 42 71 50 71
7 Morecambe Morecambe 42 69 50 71
8 Woking Woking 42 58 45 68
9 FC Halifax Town Halifax Town 42 74 56 66
10 Accrington Stanley Accrington 42 72 58 65
11 Dagenham & Redbridge Dagenham 42 68 60 65
12 Crawley Town Crawley Town 42 50 50 57
13 Scarborough Scarborough 42 60 46 56
14 Tamworth Tamworth 42 53 63 53
15 Northwich Victoria Northwich 42 58 72 52
16 Ebbsfleet United Ebbsfleet 42 58 64 50
17 Burton Albion Burton 42 50 66 50
18 York City York City 42 39 66 43
19 Canvey Island Canvey 42 53 65 42
20 Forest Green Rovers Forest Green 42 41 81 33
21 Farnborough Farnborough 42 35 89 29
22 Leigh Leigh 42 31 98 18
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Chester Chester 42 85 34 92
2 Hereford United Hereford 42 103 44 91
3 Shrewsbury Town Shrewsbury 42 67 42 74
4 Barnet Barnet 42 61 47 71
5 Aldershot Town Aldershot 42 80 67 70
6 Exeter City Exeter City 42 71 57 69
7 Morecambe Morecambe 42 66 66 67
8 Stevenage Stevenage 42 58 52 63
9 Woking Woking 42 65 52 61
10 Accrington Stanley Accrington 42 68 61 58
11 Ebbsfleet United Ebbsfleet 42 69 66 57
12 AFC Telford United Telford 42 49 51 55
13 Dagenham & Redbridge Dagenham 42 59 64 54
14 Burton Albion Burton 42 57 59 52
15 Scarborough Scarborough 42 51 54 51
16 Margate Margate 42 56 64 51
17 Tamworth Tamworth 42 49 68 49
18 Forest Green Rovers Forest Green 42 58 80 48
19 FC Halifax Town Halifax Town 42 43 65 44
20 Farnborough Farnborough 42 54 75 39
21 Leigh Leigh 42 46 97 29
22 Northwich Victoria Northwich 42 30 80 23
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Yeovil Town Yeovil Town 42 100 37 95
2 Morecambe Morecambe 42 86 42 78
3 Doncaster Rovers Doncaster 42 73 47 78
4 Chester Chester 42 59 31 75
5 Dagenham & Redbridge Dagenham 42 71 59 72
6 Hereford United Hereford 42 64 51 64
7 Scarborough Scarborough 42 63 54 64
8 FC Halifax Town Halifax Town 42 50 51 64
9 Forest Green Rovers Forest Green 42 61 62 59
10 Margate Margate 42 60 66 56
11 Barnet Barnet 42 65 68 53
12 Stevenage Stevenage 42 61 55 52
13 Farnborough Farnborough 42 57 56 51
14 Northwich Victoria Northwich 42 66 72 51
15 AFC Telford United Telford 42 54 69 49
16 Burton Albion Burton 42 52 77 49
17 Ebbsfleet United Ebbsfleet 42 62 73 48
18 Leigh Leigh 42 44 71 48
19 Woking Woking 42 52 81 47
20 Nuneaton Town Nuneaton 42 51 78 46
21 Southport Southport 42 54 69 45
22 Kettering Town Kettering 42 37 73 31
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Boston United Boston 42 84 42 84
2 Dagenham & Redbridge Dagenham 42 70 47 84
3 Yeovil Town Yeovil Town 42 66 53 70
4 Doncaster Rovers Doncaster 42 68 46 67
5 Barnet Barnet 42 64 48 67
6 Morecambe Morecambe 42 63 67 62
7 Farnborough Farnborough 42 66 54 61
8 Margate Margate 42 59 53 58
9 AFC Telford United Telford 42 63 58 57
10 Nuneaton Town Nuneaton 42 57 57 57
11 Scarborough Scarborough 42 55 63 56
12 Stevenage Stevenage 42 57 60 55
13 Northwich Victoria Northwich 42 57 70 55
14 Chester Chester 42 54 51 54
15 Southport Southport 42 53 49 53
16 Leigh Leigh 42 56 58 53
17 Hereford United Hereford 42 50 53 52
18 Forest Green Rovers Forest Green 42 54 76 51
19 Woking Woking 42 59 70 48
20 Hayes FC Hayes FC 42 53 80 44
21 Stalybridge Celtic Stalybridge 42 40 69 43
22 Dover Athletic Dover 42 41 65 39
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 Rushden & Diamonds Rushden 42 78 36 86
2 Yeovil Town Yeovil Town 42 72 50 78
3 Dagenham & Redbridge Dagenham 42 71 54 77
4 Southport Southport 42 58 46 69
5 Leigh Leigh 42 63 57 68
6 AFC Telford United Telford 42 51 51 65
7 Stevenage Stevenage 42 71 61 63
8 Chester Chester 42 49 43 62
9 Doncaster Rovers Doncaster 42 47 43 58
10 Scarborough Scarborough 42 56 54 58
11 Hereford United Hereford 42 59 46 56
12 Boston United Boston 42 74 63 56
13 Nuneaton Town Nuneaton 42 60 59 56
14 Woking Woking 42 52 57 54
15 Dover Athletic Dover 42 54 56 53
16 Forest Green Rovers Forest Green 42 43 54 48
17 Northwich Victoria Northwich 42 49 67 46
18 Hayes FC Hayes FC 42 44 71 46
19 Morecambe Morecambe 42 64 66 45
20 Kettering Town Kettering 42 46 62 43
21 Kingstonian Kingstonian 42 47 73 34
22 Hednesford Town Hednesford 42 46 85 29

  USO DE MEMORIA  
6,714,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1245
Total Execution Time  0.1266
  CADENA URL  
/conference2009/grupo1/historico
  GET DATOS  
$_GET['/conference2009/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0017  SELECT type FROM routes WHERE alias = 'conference2009'
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'conference' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2009 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=102 AND type_rel = 3
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 102 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1313305,1250455,1249509,1248759,1247981) ORDER BY n.cover_points DESC, update_date DESC
0.0019  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 102 GROUP BY l.categoryId
0.0019  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=102 GROUP BY l.year ORDER BY l.year DESC
0.0021  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 = 1049 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 102 AND group_code = 1 and tables = 1 AND year <= 2009 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0028  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 = 1049 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 529 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 531 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 532 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 `tables2004` 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 = 533 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 `tables2003` 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 = 578 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 `tables2002` 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 = 579 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 `tables2001` 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 = 580 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-05-09 23:06:15' 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-05-09 23:06:15' 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-05-09 23:06:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 23:06:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0037  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'conference' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0028  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 events2009 e ON e.player_id = p.id AND e.league_id = 1049 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1049 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.0029  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 events2009 e ON e.player_id = p.id AND e.league_id = 1049 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1049 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 events2009 e ON e.player_id = p.id AND e.league_id = 1049 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1049 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0137  SELECT *,(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 = 1049 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC