4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hartley Wintney
TEMPORADA 2023/2024
NON LEAGUE DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Chertsey Town Chertsey 40 103 32 101
2 Marlow FC Marlow FC 40 106 49 89
3 Leatherhead Leatherhead 40 71 32 86
4 Westfield FC Westfield 40 81 50 83
5 Southall Southall 39 79 43 80
6 Raynes Park Vale Raynes Park 40 70 49 78
7 Hanworth Villa FC Hanworth 40 77 59 65
8 Thatcham Town Thatcham 40 72 62 62
9 South Park FC South Park 40 72 61 61
10 Hartley Wintney Hartley 40 64 79 55
11 Badshot Lea FC Badshot 40 65 70 54
12 Uxbridge Uxbridge 40 70 71 51
13 Ascot United Ascot United 40 56 67 45
14 Sutton Common Rovers Sutton 40 49 69 40
15 Northwood Northwood 40 69 75 39
16 Metropolitan Police Metropolitan 40 37 63 37
17 Ashford Town Ashford Town 40 42 70 36
18 Guernsey Guernsey 40 68 97 34
19 Binfield Binfield 40 59 109 34
20 Chipstead Chipstead 39 44 80 30
21 Corinthian-Casuals Corinthian-C 40 34 101 21
TEMPORADA 2022/2023
NON LEAGUE PREMIER GRUPO 2
Equipo PJ GF GC Puntos
1 Weston-super-Mare Weston-super 42 89 32 93
2 Bracknell Town FC Bracknell 42 100 53 90
3 Truro City Truro City 42 88 41 89
4 Poole Town Poole Town 42 86 51 80
5 Chesham United Chesham 42 88 57 79
6 Swindon Supermarine Swindon 42 88 66 77
7 Hayes & Yeading United Hayes 42 80 58 71
8 Metropolitan Police Metropolitan 42 61 59 61
9 Merthyr Town Merthyr Town 42 73 64 60
10 Plymouth Parkway Plymouth 42 63 62 58
11 Beaconsfield Beaconsfield 42 75 73 57
12 Tiverton Town Tiverton 42 62 77 55
13 Dorchester Town Dorchester 42 57 79 54
14 Hanwell Town Hanwell Town 42 55 65 50
15 Salisbury City Salisbury 42 55 71 49
16 Winchester City Winchester 42 56 72 48
17 Gosport Borough Gosport 42 58 78 47
18 Hendon Hendon 42 55 81 38
19 Harrow Borough Harrow 42 44 80 37
20 North Leigh North Leigh 42 50 86 34
21 Yate Town Yate Town 42 50 92 34
22 Hartley Wintney Hartley 42 40 76 32
TEMPORADA 2021/2022
NON LEAGUE PREMIER GRUPO 4
Equipo PJ GF GC Puntos
1 Taunton Town Taunton Town 42 83 42 91
2 Hayes & Yeading United Hayes 42 100 39 86
3 Farnborough Farnborough 42 73 44 85
4 Metropolitan Police Metropolitan 42 72 46 81
5 Weston-super-Mare Weston-super 42 72 42 78
6 Chesham United Chesham 42 80 50 77
7 Yate Town Yate Town 42 66 48 72
8 Truro City Truro City 42 62 54 70
9 Gosport Borough Gosport 42 65 56 66
10 Poole Town Poole Town 42 74 69 64
11 Walton Casuals Walton 42 53 61 58
12 Swindon Supermarine Swindon 42 63 63 57
13 Tiverton Town Tiverton 42 61 63 53
14 Harrow Borough Harrow 42 63 77 52
15 Salisbury City Salisbury 42 49 75 48
16 Hendon Hendon 42 58 70 47
17 Beaconsfield Beaconsfield 42 70 92 46
18 Hartley Wintney Hartley 42 56 75 44
19 Dorchester Town Dorchester 42 41 58 41
20 Kings Langley Kings 42 49 68 37
21 Merthyr Town Merthyr Town 42 47 94 26
22 Wimborne Town Wimborne 42 35 106 19
TEMPORADA 2020/2021
NON LEAGUE PREMIER GRUPO 3
Equipo PJ GF GC Puntos
1 Poole Town Poole Town 7 16 7 19
2 Tiverton Town Tiverton 7 21 4 18
3 Salisbury City Salisbury 7 17 7 17
4 Truro City Truro City 8 17 9 16
5 Metropolitan Police Metropolitan 8 14 11 14
6 Swindon Supermarine Swindon 7 12 10 12
7 Chesham United Chesham 7 6 4 12
8 Taunton Town Taunton Town 6 8 5 11
9 Hendon Hendon 8 12 10 11
10 Hayes & Yeading United Hayes 7 11 8 10
11 Gosport Borough Gosport 7 11 9 8
12 Walton Casuals Walton 6 8 13 7
13 Wimborne Town Wimborne 6 5 12 7
14 Hartley Wintney Hartley 6 5 9 6
15 Weston-super-Mare Weston-super 6 8 10 5
16 Harrow Borough Harrow 7 11 14 5
17 Yate Town Yate Town 8 8 17 5
18 Farnborough Farnborough 8 7 16 4
19 Dorchester Town Dorchester 7 5 17 4
20 Beaconsfield Beaconsfield 7 4 14 2
21 Merthyr Town Merthyr Town 0 0 0 0
TEMPORADA 2019/2020
NON LEAGUE PREMIER GRUPO 3
Equipo PJ GF GC Puntos
1 Truro City Truro City 31 65 30 67
2 Chesham United Chesham 33 70 45 64
3 Hayes & Yeading United Hayes 32 65 42 57
4 Swindon Supermarine Swindon 32 50 41 57
5 Tiverton Town Tiverton 29 69 41 55
6 Taunton Town Taunton Town 31 63 53 53
7 Salisbury City Salisbury 30 57 42 51
8 Gosport Borough Gosport 33 35 32 49
9 Poole Town Poole Town 26 45 28 45
10 Weston-super-Mare Weston-super 28 49 45 42
11 Farnborough Farnborough 30 41 43 42
12 Metropolitan Police Metropolitan 29 43 47 40
13 Hendon Hendon 31 48 51 39
14 Merthyr Town Merthyr Town 31 37 37 38
15 Wimborne Town Wimborne 32 39 47 37
16 Hartley Wintney Hartley 27 38 39 36
17 Harrow Borough Harrow 34 44 62 36
18 Blackfield & Langley Blackfield 30 31 48 32
19 Yate Town Yate Town 31 38 56 29
20 Walton Casuals Walton 32 38 69 26
21 Beaconsfield Beaconsfield 31 28 51 25
22 Dorchester Town Dorchester 31 36 80 18
TEMPORADA 2018/2019
NON LEAGUE PREMIER GRUPO 3
Equipo PJ GF GC Puntos
1 Weymouth Weymouth 42 96 51 86
2 Taunton Town Taunton Town 42 89 56 85
3 Metropolitan Police Metropolitan 42 91 64 78
4 Salisbury City Salisbury 42 97 69 77
5 Poole Town Poole Town 42 84 59 70
6 Kings Langley Kings 42 65 61 69
7 Harrow Borough Harrow 42 97 77 63
8 Hartley Wintney Hartley 42 82 70 63
9 Farnborough Farnborough 42 72 72 62
10 Chesham United Chesham 42 54 55 59
11 Swindon Supermarine Swindon 42 70 59 58
12 Beaconsfield Beaconsfield 42 65 65 58
13 Merthyr Town Merthyr Town 42 68 67 54
14 Wimborne Town Wimborne 42 72 75 52
15 Dorchester Town Dorchester 42 67 75 52
16 Hendon Hendon 42 64 74 52
17 Walton Casuals Walton 42 69 78 51
18 Tiverton Town Tiverton 42 65 75 51
19 Gosport Borough Gosport 42 63 70 50
20 Basingstoke Town Basingstoke 42 81 82 49
21 Frome Town Frome Town 42 45 74 37
22 Staines Town Staines Town 42 40 168 12
TEMPORADA 2017/2018
NON LEAGUE DIVISION 1 GRUPO 5
Equipo PJ GF GC Puntos
1 Beaconsfield Beaconsfield 42 99 46 92
2 Rushden & Diamonds Rushden 42 92 25 91
3 Hayes & Yeading United Hayes 42 103 49 83
4 Hartley Wintney Hartley 42 96 53 82
5 AFC Dunstable Dunstable 42 80 37 79
6 Cambridge City Cambridge 42 99 53 77
7 Kempston Rovers Kempston 42 80 68 73
8 Bedford Town Bedford Town 42 70 48 72
9 Chalfont St Peter Chalfont 42 56 39 72
10 Moneyfields Moneyfields 42 79 63 69
11 Thame United FC Thame United 42 84 78 64
12 Ashford Town Ashford Town 42 81 68 56
13 Aylesbury United Aylesbury 42 52 73 55
14 Marlow FC Marlow FC 42 54 75 49
15 Uxbridge Uxbridge 42 58 87 49
16 Egham Town Egham Town 42 54 88 48
17 Northwood Northwood 42 54 71 41
18 Hanwell Town Hanwell Town 42 48 88 34
19 Fleet Town Fleet Town 42 38 86 34
20 Barton Rovers Barton 42 39 86 33
21 Aylesbury Aylesbury 42 40 88 33
22 Arlesey Town Arlesey Town 42 36 123 14

  USO DE MEMORIA  
6,431,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5140
Total Execution Time  0.5152
  CADENA URL  
/historico/Hartley-Wintney
  GET DATOS  
$_GET['/historico/Hartley-Wintney']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
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 = 'Hartley-Wintney' 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.0125  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=10526 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=10526 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=10526 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=10526 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=10526 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10526 AND type_rel = 2
0.0130  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 = '10526' ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '10526' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '10526' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=10526 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (72977,72728,72677,71432,68451) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 68451 AND teamId = 10526
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 72977 AND teamId = 10526
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 10526
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 10526
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 10526
0.0129  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 = '10526' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10526' and rp.type = 4
0.0126  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 = '10526' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0126  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 = 72977 WHERE rp.league_id = 72977 AND rp.teamId = 10526 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.0126  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 = 72977 WHERE rp.league_id = 72977 AND rp.teamId = 10526 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 72977 WHERE rp.league_id = 72977 AND rp.teamId = 10526 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 10526 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0255  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 = 72977 AND t.round = 42 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 `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 = 68451 AND t.round = 42 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 = 63527 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 58615 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 50619 AND t.round = 34 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 `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 = 44471 AND t.round = 42 ORDER BY team.conference 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 `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 = 39172 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC