4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Bishop Auckland
TEMPORADA 2023/2024
COMBINED COUNTIES LEAGUE GRUPO 5
Equipo PJ GF GC Puntos
1 Bishop Auckland Bishop 38 133 32 100
2 Shildon AFC Shildon AFC 38 126 32 91
3 Heaton Stannington Heaton 38 76 42 78
4 Birtley Town Birtley Town 37 98 55 75
5 West Auckland Town West 38 88 49 75
6 Guisborough Town Guisborough 38 75 40 73
7 Boro Rangers Boro Rangers 38 82 42 68
8 Carlisle City Carlisle 38 73 81 60
9 West Allotment Celtic West 38 85 53 59
10 Whitley Bay Whitley Bay 37 73 75 56
11 Redcar Athletic Redcar 38 82 67 51
12 Whickham Whickham 37 66 67 51
13 Crook Town AFC Crook Town 36 47 59 45
14 North Shields North 37 54 62 43
15 Penrith AFC Penrith AFC 38 82 89 41
16 Newcastle Benfield Newcastle 36 54 96 32
17 Seaham Red Star Seaham Star 38 45 74 30
18 Northallerton Town Northallerto 37 37 106 18
19 Tow Law Town Town 37 31 155 13
20 Sunderland RCA Sunderland 36 27 158 4
TEMPORADA 2022/2023
COMBINED COUNTIES LEAGUE GRUPO 2
Equipo PJ GF GC Puntos
1 Newton Aycliffe Newton 38 102 48 85
2 Ashington AFC Ashington 38 79 35 80
3 Bishop Auckland Bishop 38 99 48 78
4 Whitley Bay Whitley Bay 38 68 55 73
5 West Allotment Celtic West 38 74 55 67
6 Whickham Whickham 37 56 47 61
7 Heaton Stannington Heaton 38 81 62 59
8 Redcar Athletic Redcar 37 81 70 58
9 Guisborough Town Guisborough 37 68 51 57
10 Newcastle Benfield Newcastle 38 67 57 53
11 West Auckland Town West 38 65 65 47
12 Carlisle City Carlisle 38 57 63 43
13 Tow Law Town Town 37 56 83 43
14 Penrith AFC Penrith AFC 38 45 64 41
15 Crook Town AFC Crook Town 38 47 77 41
16 Northallerton Town Northallerto 38 53 73 38
17 Sunderland RCA Sunderland 38 43 94 38
18 Seaham Red Star Seaham Star 38 46 61 36
19 Pickering Town CFC Pickering 38 45 94 36
20 Thornaby Thornaby 38 42 72 34
TEMPORADA 2021/2022
COMBINED COUNTIES LEAGUE GRUPO 7
Equipo PJ GF GC Puntos
1 North Shields North 23 56 16 51
2 Consett AFC Consett AFC 23 57 29 48
3 West Auckland Town West 23 61 34 43
4 Newton Aycliffe Newton 23 49 33 40
5 Sunderland Ryhope Sunderland 23 42 27 40
6 Ashington AFC Ashington 23 58 45 38
7 Thornaby Thornaby 22 47 32 37
8 Newcastle Benfield Newcastle 23 46 46 37
9 Sunderland RCA Sunderland 23 37 37 33
10 Crook Town AFC Crook Town 24 32 47 33
11 Whitley Bay Whitley Bay 23 37 52 32
12 Seaham Red Star Seaham Star 23 34 35 31
13 Whickham Whickham 23 26 29 30
14 West Allotment Celtic West 23 37 48 28
15 Redcar Athletic Redcar 23 32 50 27
16 Guisborough Town Guisborough 22 26 31 24
17 Billingham Town Billingham 25 28 50 22
18 Penrith AFC Penrith AFC 23 28 56 21
19 Northallerton Town Northallerto 22 29 43 20
20 Bishop Auckland Bishop 23 26 48 19
TEMPORADA 2005/2006
NON LEAGUE DIVISION 1 GRUPO 4
Equipo PJ GF GC Puntos
1 Kendal Town Kendal Town 41 81 55 76
2 Fleetwood Town Fleetwood 43 72 52 76
3 Mossley Mossley 41 81 54 75
4 Woodley Sports Woodley 42 85 53 74
5 Gresley Gresley 42 79 64 70
6 Stocksbridge Park Steels Stocksbridge 42 66 43 67
7 Brigg Town Brigg Town 43 73 66 65
8 Eastwood Town Eastwood 42 66 58 62
9 Shepshed Shepshed 43 61 56 61
10 Bridlington Town Bridlington 42 61 68 58
11 Ossett Albion Ossett 43 55 64 57
12 Colwyn Bay Colwyn Bay 43 56 54 56
13 Belper Town FC Belper Town 41 50 55 56
14 Rossendale United Rossendale 42 58 61 53
15 Clitheroe Clitheroe 42 54 73 53
16 Bamber Bridge Bamber 41 64 59 51
17 Kidsgrove Athletic Kidsgrove 42 66 69 51
18 Chorley Chorley 41 57 56 50
19 Warrington Town Warrington 43 64 77 48
20 Goole Goole 41 55 84 44
21 Spalding United Spalding 41 46 70 42
22 Bishop Auckland Bishop 41 38 97 15
TEMPORADA 2004/2005
NON LEAGUE PREMIER GRUPO 3
Equipo PJ GF GC Puntos
1 Workington Workington 43 75 31 88
2 Hyde Hyde 42 80 43 86
3 Farsley Celtic Farsley 42 81 41 83
4 Whitby Town Whitby Town 41 63 47 79
5 Burscough Burscough 42 93 74 70
6 Guiseley Guiseley 43 74 65 64
7 Prescot Cables Prescot 41 61 53 64
8 Witton Albion Witton 41 54 42 61
9 Radcliffe Borough Radcliffe 43 61 64 60
10 Leek Town Leek Town 41 62 50 59
11 Matlock Town Matlock Town 43 60 69 55
12 Wakefield Wakefield 42 60 67 52
13 Blyth Spartans Blyth 41 51 55 49
14 Lincoln United FC Lincoln 41 53 64 47
15 Marine Marine 42 53 60 46
16 Ossett Town Ossett Town 42 53 62 46
17 Spennymoor Town Spennymoor 42 44 65 46
18 Gateshead Gateshead 42 61 84 45
19 Frickley Athletic Frickley 42 44 57 44
20 Bishop Auckland Bishop 42 51 74 40
21 Bamber Bridge Bamber 42 48 92 34
22 Bridlington Town Bridlington 42 43 66 33

  USO DE MEMORIA  
5,766,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0908
Total Execution Time  0.0920
  CADENA URL  
/historico/Bishop-Auckland
  GET DATOS  
$_GET['/historico/Bishop-Auckland']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0028  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 = 'Bishop-Auckland' 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.0018  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=9866 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9866 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9866 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9866 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 73095
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9866 AND type_rel = 2
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2490 AND type_rel = 3
0.0023  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 = '9866' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '9866' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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=9866 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (73095,72728,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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73095 AND teamId = 9866
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 9866
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9866
0.0020  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 = '9866' 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 = '9866' and rp.type = 4
0.0020  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 = '9866' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 = 73095 WHERE rp.league_id = 73095 AND rp.teamId = 9866 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.0019  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 = 73095 WHERE rp.league_id = 73095 AND rp.teamId = 9866 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 73095 WHERE rp.league_id = 73095 AND rp.teamId = 9866 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 9866 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73095 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 68432 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.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 `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 = 63784 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 `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 = 25101 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 `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 = 24370 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC