4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hereford
TEMPORADA 2023/2024
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 Tamworth Tamworth 46 74 29 96
2 Scunthorpe United Scunthorpe 46 84 38 88
3 Brackley Town Brackley 46 65 37 85
4 Chorley Chorley 46 81 50 83
5 Alfreton Town Alfreton 46 76 50 80
6 Boston United Boston 46 68 46 75
7 Curzon Ashton Curzon 46 62 49 75
8 South Shields South 46 79 53 74
9 Spennymoor Town Spennymoor 46 74 62 74
10 Chester Chester 46 58 37 69
11 Hereford Hereford 46 62 66 69
12 Warrington Town Warrington 46 64 60 64
13 Scarborough Athletic Scarborough 46 53 55 64
14 Buxton Buxton 46 70 63 62
15 Peterborough Sports Peterborough 46 55 65 58
16 Darlington FC Darlington 46 52 72 56
17 Southport Southport 46 54 75 56
18 Kings Lynn Town Kings Lynn. 46 54 66 55
19 Rushall Olympic Rushall 46 61 73 54
20 Farsley Celtic Farsley 46 40 59 53
21 Blyth Spartans Blyth 46 66 82 50
22 Banbury United Banbury 46 38 86 38
23 Gloucester City Gloucester 46 49 89 36
24 Bishops Stortford Bishops 46 35 112 21
TEMPORADA 2022/2023
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 Fylde Fylde 46 80 44 95
2 Kings Lynn Town Kings Lynn. 46 84 43 93
3 Chester Chester 46 72 41 84
4 Brackley Town Brackley 46 57 47 69
5 Alfreton Town Alfreton 46 54 44 69
6 Kidderminster Harriers Kidderminste 46 49 42 69
7 Gloucester City Gloucester 46 75 68 68
8 Scarborough Athletic Scarborough 46 74 69 68
9 Spennymoor Town Spennymoor 46 68 67 68
10 Darlington FC Darlington 46 72 64 67
11 Buxton Buxton 46 55 54 67
12 Chorley Chorley 46 62 50 66
13 Curzon Ashton Curzon 46 58 55 65
14 Peterborough Sports Peterborough 46 50 55 57
15 Boston United Boston 46 68 66 56
16 Hereford Hereford 46 47 56 55
17 Banbury United Banbury 46 55 62 54
18 Southport Southport 46 50 62 50
19 Blyth Spartans Blyth 46 49 62 50
20 Farsley Celtic Farsley 46 51 75 50
21 Kettering Town Kettering 46 41 63 49
22 Leamington Leamington 46 41 60 48
23 Bradford Park Avenue Bradford 46 43 65 46
24 AFC Telford United Telford 46 35 76 32
TEMPORADA 2021/2022
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 Gateshead Gateshead 42 99 47 94
2 Brackley Town Brackley 42 53 23 87
3 Fylde Fylde 42 68 37 80
4 Kidderminster Harriers Kidderminste 42 72 35 74
5 York City York City 42 58 50 66
6 Chorley Chorley 42 62 49 65
7 Boston United Boston 42 63 57 63
8 Kettering Town Kettering 42 54 48 61
9 Alfreton Town Alfreton 42 58 59 61
10 Spennymoor Town Spennymoor 42 55 51 60
11 Southport Southport 42 60 55 57
12 Hereford Hereford 42 51 52 55
13 Darlington FC Darlington 42 57 58 53
14 Curzon Ashton Curzon 42 51 63 52
15 Leamington Leamington 42 39 47 48
16 Chester Chester 42 70 71 47
17 Gloucester City Gloucester 42 47 60 46
18 Bradford Park Avenue Bradford 42 46 70 44
19 Blyth Spartans Blyth 42 41 76 43
20 AFC Telford United Telford 42 48 65 37
21 Farsley Celtic Farsley 42 37 78 37
22 Guiseley Guiseley 42 31 69 35
TEMPORADA 2020/2021
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 Gloucester City Gloucester 18 36 22 35
2 Fylde Fylde 15 26 16 30
3 Chester Chester 17 32 24 28
4 Brackley Town Brackley 16 22 19 27
5 Kidderminster Harriers Kidderminste 15 24 17 25
6 Boston United Boston 13 20 10 23
7 Chorley Chorley 18 21 25 23
8 York City York City 13 22 17 22
9 Leamington Leamington 15 22 20 22
10 Gateshead Gateshead 14 17 15 21
11 Farsley Celtic Farsley 17 21 26 21
12 Hereford Hereford 13 20 16 20
13 Spennymoor Town Spennymoor 13 18 14 20
14 AFC Telford United Telford 17 17 23 19
15 Bradford Park Avenue Bradford 16 26 30 18
16 Curzon Ashton Curzon 17 18 26 17
17 Southport Southport 14 16 19 16
18 Kettering Town Kettering 14 21 23 15
19 Darlington FC Darlington 11 17 11 13
20 Guiseley Guiseley 15 17 22 12
21 Alfreton Town Alfreton 15 15 27 12
22 Blyth Spartans Blyth 14 10 36 6
TEMPORADA 2019/2020
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 Kings Lynn Town Kings Lynn. 32 63 39 64
2 York City York City 34 52 28 66
3 Boston United Boston 32 46 32 58
4 Brackley Town Brackley 34 61 25 60
5 Altrincham Altrincham 33 62 40 57
6 Chester Chester 32 58 38 54
7 Gateshead Gateshead 31 47 31 52
8 Spennymoor Town Spennymoor 34 63 45 55
9 Guiseley Guiseley 33 52 41 50
10 Darlington FC Darlington 33 43 50 48
11 Farsley Celtic Farsley 34 50 45 48
12 Southport Southport 32 40 41 43
13 Alfreton Town Alfreton 32 48 55 40
14 AFC Telford United Telford 34 51 56 42
15 Kidderminster Harriers Kidderminste 33 39 43 38
16 Hereford Hereford 35 39 56 39
17 Gloucester City Gloucester 30 39 57 33
18 Leamington Leamington 32 39 51 35
19 Kettering Town Kettering 31 36 46 32
20 Curzon Ashton Curzon 33 34 42 34
21 Blyth Spartans Blyth 33 32 78 23
22 Bradford Park Avenue Bradford 33 25 80 20
TEMPORADA 2018/2019
NATIONAL LEAGUE NORTH
Equipo PJ GF GC Puntos
1 Stockport County Stockport 42 77 36 82
2 Chorley Chorley 42 83 41 81
3 Brackley Town Brackley 42 72 40 77
4 Spennymoor Town Spennymoor 42 78 48 76
5 Altrincham Altrincham 42 85 56 71
6 Blyth Spartans Blyth 42 74 62 69
7 Bradford Park Avenue Bradford 42 71 61 65
8 AFC Telford United Telford 42 64 55 65
9 Chester Chester 42 60 62 62
10 Kidderminster Harriers Kidderminste 42 68 62 60
11 Boston United Boston 42 62 60 58
12 York City York City 42 58 63 58
13 Leamington Leamington 42 57 60 54
14 Southport Southport 42 58 55 53
15 Alfreton Town Alfreton 42 53 67 51
16 Darlington FC Darlington 42 56 62 50
17 Hereford Hereford 42 47 58 49
18 Curzon Ashton Curzon 42 44 71 49
19 Guiseley Guiseley 42 46 60 44
20 Ashton United Ashton 42 43 86 35
21 United of Manchester United 42 49 82 34
22 Nuneaton Town Nuneaton 42 38 96 19
TEMPORADA 2017/2018
NON LEAGUE PREMIER GRUPO 3
Equipo PJ GF GC Puntos
1 Hereford Hereford 46 110 34 110
2 Slough Town Slough Town 46 111 49 99
3 Kettering Town Kettering 46 122 56 97
4 Kings Lynn Town Kings Lynn. 46 96 40 97
5 Weymouth Weymouth 46 103 48 97
6 Tiverton Town Tiverton 46 78 69 78
7 Chesham United Chesham 46 86 58 77
8 Royston Town Royston Town 46 84 65 77
9 Banbury United Banbury 46 90 59 72
10 Basingstoke Town Basingstoke 46 91 73 68
11 Hitchin Town Hitchin Town 46 67 66 66
12 St. Neots Town Neots Town 46 79 79 64
13 Frome Town Frome Town 46 78 96 61
14 Biggleswade Town Biggleswade 46 53 62 56
15 Redditch United Redditch 46 73 73 55
16 Stratford Town Stratford 46 68 81 55
17 Merthyr Town Merthyr Town 46 76 98 53
18 Bishops Stortford Bishops 46 74 79 52
19 Dorchester Town Dorchester 46 62 83 51
20 Farnborough Farnborough 46 82 120 51
21 Kings Langley Kings 46 64 97 41
22 St Ives Town Ives Town 46 54 105 33
23 Gosport Borough Gosport 46 41 142 20
24 Dunstable Town Dunstable 46 27 137 17
TEMPORADA 2016/2017
NON LEAGUE DIVISION 1 GRUPO 4
Equipo PJ GF GC Puntos
1 Hereford Hereford 42 108 32 107
2 Salisbury City Salisbury 42 118 52 89
3 Taunton Town Taunton Town 42 114 42 88
4 Tiverton Town Tiverton 42 92 50 88
5 Evesham United Evesham 42 88 50 80
6 North Leigh North Leigh 42 84 65 75
7 Swindon Supermarine Swindon 42 85 57 72
8 Mangotsfield United Mangotsfield 42 73 69 70
9 Shortwood United Shortwood 42 65 77 62
10 Bideford Bideford 42 61 58 57
11 Wimborne Town Wimborne 42 67 68 57
12 Didcot Town Didcot Town 42 70 71 54
13 Larkhall Athletic Larkhall 42 69 69 53
14 Winchester City Winchester 42 62 70 53
15 Paulton Rovers Paulton 42 62 69 51
16 Bishop's Cleeve Bishop's 42 66 86 50
17 Barnstaple Town Barnstaple 42 52 68 45
18 Yate Town Yate Town 42 49 77 44
19 AFC Totton AFC Totton 42 49 86 39
20 Slimbridge Slimbridge 42 47 90 37
21 Wantage Town Wantage Town 42 29 110 21
22 Bridgwater Town Bridgwater 42 23 117 10

  USO DE MEMORIA  
6,935,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1112
Total Execution Time  0.1124
  CADENA URL  
/historico/Hereford-Fc
  GET DATOS  
$_GET['/historico/Hereford-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=89490 AND type_rel = 2
0.0023  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 = '89490' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 72550 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  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 = 72677 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=89490 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (72728,72677,72550,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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72550 AND teamId = 89490
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 89490
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 89490
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 89490
0.0043  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 = 72550 AND t.round = 46 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '89490' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '89490' and rp.type = 4
0.0021  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 = '89490' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0041  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 = 72550 WHERE rp.league_id = 72550 AND rp.teamId = 89490 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.0040  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 = 72550 WHERE rp.league_id = 72550 AND rp.teamId = 89490 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 72550 WHERE rp.league_id = 72550 AND rp.teamId = 89490 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 89490 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0047  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 = 68218 AND t.round = 46 ORDER BY team.conference ASC,t.position 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 `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 = 63261 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.0027  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 = 58732 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 50296 AND t.round = 35 ORDER BY team.conference ASC,t.position 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 `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 = 44237 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 `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 = 39019 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2017` 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 = 33755 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC