4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Harpenden Town
TEMPORADA 2023/2024
COMBINED COUNTIES LEAGUE GRUPO 11
Equipo PJ GF GC Puntos
1 Real Bedford Real Bedford 37 120 28 91
2 Milton Keynes Irish Milton 37 96 25 86
3 Leverstock Green Leverstock 38 75 53 72
4 Harpenden Town Harpenden 38 76 52 71
5 FC Romania FC Romania 37 78 66 62
6 Tring Athletic Tring 38 66 54 62
7 Colney Heath Colney Heath 38 58 49 60
8 Cockfosters Cockfosters 38 73 60 55
9 Potton United Potton 38 52 61 53
10 St. Panteleimon Panteleimon 30 55 40 50
11 London Lions London Lions 38 76 77 48
12 Biggleswade United Biggleswade 38 70 85 46
13 Aylesbury Aylesbury 36 58 78 46
14 Dunstable Town Dunstable 38 54 68 41
15 Stansted Stansted 37 50 71 40
16 Baldock Town Baldock Town 37 65 90 37
17 Shefford Town & Campton Shefford 37 53 93 36
18 Arlesey Town Arlesey Town 37 36 70 34
19 Crawley Green Crawley 37 51 88 33
20 Sawbridgeworth Town Sawbridgewor 38 32 86 16
TEMPORADA 2022/2023
COMBINED COUNTIES LEAGUE GRUPO 14
Equipo PJ GF GC Puntos
1 Leighton Town Leighton 37 93 30 88
2 Stotfold FC Stotfold FC 37 72 35 76
3 Risborough Rangers Risborough 37 97 54 71
4 Dunstable Town Dunstable 36 70 33 71
5 Cockfosters Cockfosters 37 75 43 66
6 St. Panteleimon Panteleimon 38 65 55 64
7 Leverstock Green Leverstock 38 60 51 57
8 Biggleswade United Biggleswade 38 64 70 56
9 Tring Athletic Tring 38 59 60 54
10 Potton United Potton 38 51 47 53
11 Harpenden Town Harpenden 38 54 61 50
12 Crawley Green Crawley 37 67 63 49
13 Aylesbury Aylesbury 37 66 71 49
14 Ardley United Ardley 38 68 69 48
15 Shefford Town & Campton Shefford 37 72 77 47
16 Baldock Town Baldock Town 38 56 75 41
17 Arlesey Town Arlesey Town 38 42 70 33
18 Colney Heath Colney Heath 38 34 76 30
19 Hoddesdon Town Hoddesdon 38 39 87 28
20 London Colney London 37 28 105 16
TEMPORADA 2021/2022
COMBINED COUNTIES LEAGUE GRUPO 13
Equipo PJ GF GC Puntos
1 New Salamis New Salamis 38 123 36 94
2 Risborough Rangers Risborough 38 101 23 93
3 Hadley Hadley 38 78 33 83
4 Leighton Town Leighton 38 78 42 71
5 Harpenden Town Harpenden 38 69 45 68
6 Flackwell Heath Flackwell 38 66 42 68
7 Ardley United Ardley 38 67 45 60
8 Leverstock Green Leverstock 38 63 57 56
9 Dunstable Town Dunstable 38 50 60 50
10 Arlesey Town Arlesey Town 38 58 77 47
11 Harefield United Harefield 38 70 67 46
12 Milton Keynes Irish Milton 38 55 59 46
13 Tring Athletic Tring 38 51 61 43
14 Aylesbury Aylesbury 38 57 85 43
15 Oxhey Jets Oxhey Jets 38 60 101 42
16 Broadfields United Broadfields 38 55 81 37
17 Baldock Town Baldock Town 38 51 73 35
18 Crawley Green Crawley 38 57 92 30
19 London Colney London 38 38 99 30
20 Holmer Green Holmer Green 38 44 113 29

  USO DE MEMORIA  
5,289,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.3910
Total Execution Time  0.3921
  CADENA URL  
/historico/Harpenden-Town
  GET DATOS  
$_GET['/historico/Harpenden-Town']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0115  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 = 'Harpenden-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.0106  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=90411 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=90411 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=90411 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0215  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 = 73101
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=90411 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2490 AND type_rel = 3
0.0110  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 = '90411' ORDER BY l.year DESC,cat.coefficient DESC
0.0112  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 = '90411' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0112  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 = '90411' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0109  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 = 73101 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110  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=90411 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0107  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 (73101,72728) 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.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 73101 AND teamId = 90411
0.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 90411
0.0126  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 = 73101 AND t.round = 9 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0115  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 = '90411' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0109  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '90411' and rp.type = 4
0.0106  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 = '90411' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0107  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 = 73101 WHERE rp.league_id = 73101 AND rp.teamId = 90411 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.0106  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 = 73101 WHERE rp.league_id = 73101 AND rp.teamId = 90411 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0106  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 = 73101 WHERE rp.league_id = 73101 AND rp.teamId = 90411 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0110  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 = 90411 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0112  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 = 73101 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 68444 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.0112  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 = 63790 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.0110  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 = 73101 ORDER BY nameShow LIMIT 100