4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hertford Town
TEMPORADA 2023/2024
NON LEAGUE DIVISION 1 GRUPO 7
Equipo PJ GF GC Puntos
1 Biggleswade Town Biggleswade 36 78 39 72
2 Bedford Town Bedford Town 36 77 37 69
3 Ware Ware 36 69 60 62
4 Waltham Abbey Waltham 36 70 55 61
5 AFC Dunstable Dunstable 36 75 66 61
6 Cirencester Town Cirencester 36 66 44 57
7 Stotfold FC Stotfold FC 36 67 56 55
8 Welwyn Garden City Welwyn 36 79 79 54
9 Hadley Hadley 35 62 60 52
10 Biggleswade Biggleswade 36 62 58 48
11 Kings Langley Kings 36 71 74 48
12 Barton Rovers Barton 36 58 65 44
13 Kidlington Kidlington 36 49 60 44
14 Hertford Town Hertford 36 55 72 44
15 Aylesbury United Aylesbury 36 61 74 43
16 North Leigh North Leigh 35 52 78 43
17 Leighton Town Leighton 36 51 62 42
18 Thame United FC Thame United 36 51 70 37
19 Kempston Rovers Kempston 36 36 80 29
TEMPORADA 2022/2023
NON LEAGUE DIVISION 1 GRUPO 7
Equipo PJ GF GC Puntos
1 Berkhamsted Berkhamsted 36 91 32 88
2 Biggleswade Biggleswade 37 75 46 70
3 Didcot Town Didcot Town 37 58 43 69
4 Walthamstow Walthamstow 36 58 49 63
5 Ware Ware 36 76 60 62
6 Cirencester Town Cirencester 37 69 39 61
7 Biggleswade Town Biggleswade 37 76 56 61
8 Hadley Hadley 37 66 55 56
9 Welwyn Garden City Welwyn 36 56 60 55
10 Kidlington Kidlington 36 47 48 53
11 Thame United FC Thame United 37 64 55 50
12 Waltham Abbey Waltham 37 56 52 49
13 AFC Dunstable Dunstable 36 53 47 46
14 Aylesbury United Aylesbury 37 42 64 43
15 Hertford Town Hertford 36 70 70 41
16 Kempston Rovers Kempston 36 51 69 34
17 Highworth Town Highworth 37 54 96 29
18 FC Romania FC Romania 36 36 97 24
19 Barton Rovers Barton 37 32 81 23
20 Harlow Town Harlow Town 10 13 24 6
TEMPORADA 2021/2022
NON LEAGUE DIVISION 1 GRUPO 7
Equipo PJ GF GC Puntos
1 Bedford Town Bedford Town 38 100 28 91
2 Berkhamsted Berkhamsted 38 64 29 81
3 AFC Dunstable Dunstable 38 64 33 73
4 Ware Ware 38 90 47 71
5 Welwyn Garden City Welwyn 38 80 48 71
6 North Leigh North Leigh 38 69 42 68
7 Harlow Town Harlow Town 38 71 49 61
8 Thame United FC Thame United 38 64 45 60
9 Biggleswade Biggleswade 38 62 56 60
10 St. Neots Town Neots Town 38 57 53 53
11 Waltham Abbey Waltham 38 64 64 52
12 FC Romania FC Romania 38 71 83 48
13 Didcot Town Didcot Town 38 50 69 47
14 Aylesbury United Aylesbury 38 64 70 43
15 Barton Rovers Barton 38 47 63 41
16 Hertford Town Hertford 38 58 82 36
17 Kidlington Kidlington 38 47 86 35
18 Kempston Rovers Kempston 38 50 102 29
19 Colney Heath Colney Heath 38 35 92 23
20 Wantage Town Wantage Town 38 37 103 20
TEMPORADA 2020/2021
NON LEAGUE DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Waltham Abbey Waltham 8 13 9 16
2 Staines Town Staines Town 8 17 17 16
3 Ware Ware 7 20 10 15
4 Tooting and Mitcham Tooting 7 12 3 15
5 Bracknell Town FC Bracknell 5 14 5 13
6 Chertsey Town Chertsey 7 14 9 13
7 Hanwell Town Hanwell Town 8 15 12 13
8 Ashford Town Ashford Town 8 8 8 13
9 Hertford Town Hertford 7 10 10 12
10 Marlow FC Marlow FC 7 16 8 11
11 Westfield (Surrey) Westfield 7 15 11 10
12 Barking Barking 7 9 9 10
13 Chipstead Chipstead 8 12 19 10
14 Bedfont Sports Bedfont 6 10 8 9
15 Chalfont St Peter Chalfont 8 6 10 9
16 FC Romania FC Romania 7 8 14 6
17 Uxbridge Uxbridge 6 5 11 5
18 South Park FC South Park 7 12 20 5
19 Northwood Northwood 8 7 19 4
20 Harlow Town Harlow Town 8 6 17 3
TEMPORADA 2019/2020
NON LEAGUE DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Ware Ware 29 77 42 61
2 Hanwell Town Hanwell Town 28 72 32 58
3 Uxbridge Uxbridge 29 59 35 55
4 Chertsey Town Chertsey 28 74 40 52
5 Westfield (Surrey) Westfield 28 65 32 52
6 Bracknell Town FC Bracknell 26 63 33 50
7 Waltham Abbey Waltham 29 68 52 50
8 Tooting and Mitcham Tooting 27 53 29 47
9 Barking Barking 28 49 41 46
10 Chipstead Chipstead 28 53 40 45
11 Marlow FC Marlow FC 28 39 30 43
12 Bedfont Sports Bedfont 29 42 44 39
13 Chalfont St Peter Chalfont 30 45 59 37
14 Harlow Town Harlow Town 29 42 57 34
15 South Park FC South Park 26 37 52 27
16 Hertford Town Hertford 29 39 81 22
17 Ashford Town Ashford Town 29 30 70 20
18 Northwood Northwood 29 34 81 20
19 FC Romania FC Romania 28 35 84 16
20 Staines Town Staines Town 29 39 81 14
TEMPORADA 2018/2019
NON LEAGUE DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Hayes & Yeading United Hayes 38 129 36 93
2 Cheshunt Cheshunt 38 79 43 76
3 Bracknell Town FC Bracknell 38 102 55 75
4 Marlow FC Marlow FC 38 66 37 73
5 Westfield (Surrey) Westfield 38 77 54 70
6 Tooting and Mitcham Tooting 38 66 52 65
7 Ware Ware 38 90 59 63
8 Hanwell Town Hanwell Town 38 71 65 60
9 Waltham Abbey Waltham 38 63 68 56
10 Northwood Northwood 38 65 71 54
11 Ashford Town Ashford Town 38 61 70 51
12 Bedfont Sports Bedfont 38 75 76 48
13 Chipstead Chipstead 38 54 63 45
14 Chalfont St Peter Chalfont 38 52 60 43
15 Uxbridge Uxbridge 38 50 71 42
16 FC Romania FC Romania 38 46 86 36
17 South Park FC South Park 38 47 92 33
18 Hertford Town Hertford 38 55 85 31
19 Molesey FC Molesey FC 38 36 76 28
20 Egham Town Egham Town 38 29 94 18
TEMPORADA 2017/2018
NON LEAGUE DIVISION 1 GRUPO 1
Equipo PJ GF GC Puntos
1 AFC Hornchurch Hornchurch 46 97 35 103
2 Potters Bar Town Potters Town 46 87 42 93
3 Bowers and Pitsea Bowers 46 94 48 89
4 Haringey Borough Haringey 46 84 49 89
5 Heybridge Swifts Heybridge 46 105 53 87
6 Canvey Island Canvey 46 100 65 80
7 Dereham Town Dereham Town 46 75 63 71
8 Maldon & Tiptree Maldon 46 94 83 69
9 Bury Town Bury Town 46 67 65 65
10 Barking Barking 45 63 62 64
11 Witham Town Witham Town 46 59 66 62
12 AFC Sudbury AFC Sudbury 46 57 66 59
13 Soham Town Rangers Soham Town. 46 67 73 58
14 Aveley Aveley 46 61 67 57
15 Hertford Town Hertford 46 55 85 57
16 Tilbury Tilbury 46 73 95 56
17 Grays Athletic Grays 45 71 80 53
18 Cheshunt Cheshunt 46 72 103 50
19 Waltham Abbey Waltham 46 73 87 49
20 Ware Ware 46 49 81 48
21 Brentwood Town Brentwood 46 71 96 46
22 Mildenhall Town FC Mildenhall 46 54 86 46
23 Romford Romford 46 51 97 41
24 Norwich United Norwich 46 63 95 40

  USO DE MEMORIA  
6,318,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5544
Total Execution Time  0.5556
  CADENA URL  
/historico/Hertford-Town
  GET DATOS  
$_GET['/historico/Hertford-Town']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0138  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 = 'Hertford-Town' AND l.year = 2024 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.0126  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=16205 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=16205 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=16205 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=16205 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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=16205 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0263  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 = 72986
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16205 AND type_rel = 2
0.0154  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 = '16205' ORDER BY l.year DESC,cat.coefficient DESC
0.0168  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 = '16205' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '16205' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = 72986 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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=16205 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (72986,72728,72677,71432) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 72986 AND teamId = 16205
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 16205
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 16205
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 16205
0.0134  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 72986 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '16205' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '16205' and rp.type = 4
0.0136  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 = '16205' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0144  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 events2024 e ON e.player_id = p.id AND e.league_id = 72986 WHERE rp.league_id = 72986 AND rp.teamId = 16205 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.0137  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 events2024 e ON e.player_id = p.id AND e.league_id = 72986 WHERE rp.league_id = 72986 AND rp.teamId = 16205 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 events2024 e ON e.player_id = p.id AND e.league_id = 72986 WHERE rp.league_id = 72986 AND rp.teamId = 16205 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 16205 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130  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 `tables2024` 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 = 72986 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables2023` 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 = 68460 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables2022` 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 = 63534 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2021` 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 = 58740 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables2020` 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 = 50967 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables2019` 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 = 44457 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables2018` 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 = 39168 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC