4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Kettering Town
TEMPORADA 2006/2007
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 Droylsden Droylsden 42 85 55 78
2 Kettering Town Kettering 42 75 58 73
3 Workington Workington 42 61 46 70
4 Hinckley United Hinckley 42 68 54 69
5 Farsley Celtic Farsley 42 58 51 68
6 Harrogate Town Harrogate 42 58 41 67
7 Blyth Spartans Blyth 42 57 49 66
8 Hyde Hyde 42 79 62 65
9 Worcester City Worcester 42 67 54 62
10 Nuneaton Town Nuneaton 42 54 45 60
11 Moor Green Moor Green 42 53 51 59
12 Gainsborough Trinity Gainsborough 42 51 57 56
13 Hucknall Town Hucknall 42 69 69 54
14 Alfreton Town Alfreton 42 44 50 54
15 Vauxhall Motors Vauxhall 42 62 64 51
16 Barrow Barrow 42 47 48 50
17 Leigh Leigh 42 47 61 49
18 Stalybridge Celtic Stalybridge 42 64 81 49
19 Redditch United Redditch 42 61 68 48
20 Scarborough Scarborough 42 50 45 45
21 Worksop Town Worksop Town 42 44 62 45
22 Lancaster City Lancaster 42 27 110 1
TEMPORADA 2005/2006
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 Northwich Victoria Northwich 42 97 49 92
2 Stafford Rangers Stafford 42 68 34 85
3 Nuneaton Town Nuneaton 42 68 43 77
4 Droylsden Droylsden 42 80 56 72
5 Harrogate Town Harrogate 42 66 56 71
6 Kettering Town Kettering 42 63 49 67
7 Stalybridge Celtic Stalybridge 42 74 54 66
8 Worcester City Worcester 42 58 46 62
9 Moor Green Moor Green 42 67 64 61
10 Hinckley United Hinckley 42 60 55 58
11 Hyde Hyde 42 68 61 56
12 Hucknall Town Hucknall 42 56 54 55
13 Workington Workington 42 60 62 55
14 Barrow Barrow 42 62 67 47
15 Lancaster City Lancaster 42 52 66 47
16 Gainsborough Trinity Gainsborough 42 45 65 46
17 Alfreton Town Alfreton 42 46 58 45
18 Vauxhall Motors Vauxhall 42 50 71 43
19 Worksop Town Worksop Town 42 46 71 41
20 Leigh Leigh 42 45 79 40
21 Redditch United Redditch 42 52 78 39
22 Hednesford Town Hednesford 42 42 87 35
TEMPORADA 2004/2005
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 Southport Southport 42 83 45 84
2 Nuneaton Town Nuneaton 42 68 45 81
3 Droylsden Droylsden 42 82 52 79
4 Kettering Town Kettering 42 56 50 70
5 Altrincham Altrincham 42 66 46 69
6 Harrogate Town Harrogate 42 62 49 68
7 Worcester City Worcester 42 59 53 60
8 Stafford Rangers Stafford 42 52 44 59
9 Redditch United Redditch 42 65 59 59
10 Hucknall Town Hucknall 42 59 57 59
11 Gainsborough Trinity Gainsborough 42 55 55 57
12 Hinckley United Hinckley 42 55 62 56
13 Lancaster City Lancaster 42 51 59 54
14 Alfreton Town Alfreton 42 53 55 53
15 Vauxhall Motors Vauxhall 42 48 57 53
16 Barrow Barrow 42 50 64 52
17 Worksop Town Worksop Town 42 59 59 50
18 Moor Green Moor Green 42 55 64 49
19 Stalybridge Celtic Stalybridge 42 52 70 48
20 Runcorn Linnets Runcorn 42 44 63 42
21 Ashton United Ashton 42 46 79 33
22 Bradford Park Avenue Bradford 42 37 70 24
TEMPORADA 2002/2003
NATIONAL LEAGUE
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
TEMPORADA 2000/2001
NATIONAL LEAGUE
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,755,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6208
Total Execution Time  0.6222
  CADENA URL  
/historico/Kettering-Town/2007
  GET DATOS  
$_GET['/historico/Kettering-Town/2007']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0159  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Kettering-Town' AND l.year = 2007 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=4467 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=4467 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=4467 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0302  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 12901
0.0149  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 12732
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4467 AND type_rel = 2
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4467 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0146  SELECT /*35 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 (52456,303050) ORDER BY n.cover_points DESC, update_date DESC
0.0163  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '4467' ORDER BY l.year DESC,cat.coefficient DESC
0.0157  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '4467' AND l.year = 2007 ORDER BY l.year DESC,cat.coefficient DESC
0.0151  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '4467' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 12901 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 12732 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0155  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=4467 AND l.year in (2006,2007,2008) ORDER BY l.id DESC, l.year DESC ;
0.0146  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (12902,12886) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 12902 AND teamId = 4467
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 12886 AND teamId = 4467
0.0153  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 12901 AND t.round = 42 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0148  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '4467' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4467' and rp.type = 4
0.0147  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '4467' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2007 e ON e.player_id = p.id AND e.league_id = 12901 WHERE rp.league_id = 12901 AND rp.teamId = 4467 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2007 e ON e.player_id = p.id AND e.league_id = 12901 WHERE rp.league_id = 12901 AND rp.teamId = 4467 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2007 e ON e.player_id = p.id AND e.league_id = 12901 WHERE rp.league_id = 12901 AND rp.teamId = 4467 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0196  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 4467 AND l.year <= 2007 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0151  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 = 12901 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 12900 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 12899 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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.0151  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.0146  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 12901 ORDER BY nameShow LIMIT 100