4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2003
Temporada Siguiente »
National League 2003
2002/2003

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

National League 2003

  • Yeovil Town
  • Morecambe
  • Doncaster Rovers
  • Chester
  • Dagenham & Redbridge
  • Hereford United
  • Scarborough
  • FC Halifax Town
  • Forest Green Rovers
  • Margate
  • Barnet
  • Stevenage
  • Farnborough
  • Northwich Victoria
  • AFC Telford United
  • Burton Albion
  • Ebbsfleet United
  • Leigh
  • Woking
  • Nuneaton Town
  • Southport
  • Kettering Town
  • Conference National
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  
5,527,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0770
Total Execution Time  0.0789
  CADENA URL  
/conference2003/grupo1/historico
  GET DATOS  
$_GET['/conference2003/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0018  SELECT type FROM routes WHERE alias = 'conference2003'
0.0040  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 = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=102 AND type_rel = 3
0.0023  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.0023  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.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 = 578 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 102 AND group_code = 1 and tables = 1 AND year <= 2003 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 `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.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 `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.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 `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.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 05:24:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 05:24:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 05:24:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 05:24:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  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 = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  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 events2003 e ON e.player_id = p.id AND e.league_id = 578 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 578 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.0020  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 events2003 e ON e.player_id = p.id AND e.league_id = 578 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 578 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  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 events2003 e ON e.player_id = p.id AND e.league_id = 578 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 578 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0055  SELECT *,(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