4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Penistone Church
TEMPORADA 2023/2024
COMBINED COUNTIES LEAGUE GRUPO 2
Equipo PJ GF GC Puntos
1 AFC Emley AFC Emley 38 99 29 85
2 Campion AFC Campion AFC 38 106 68 76
3 Garforth Town Garforth 38 102 47 75
4 Rossington Main Rossington 38 72 49 72
5 Albion Sports Albion 38 65 48 68
6 Penistone Church Penistone 38 80 63 65
7 Thackley Thackley 38 61 57 61
8 Knaresborough Town Knaresboroug 38 74 58 60
9 Hallam FC Hallam FC 38 71 59 59
10 Silsden Silsden 38 68 74 55
11 Tadcaster Albion Tadcaster 38 62 65 53
12 Golcar United Golcar 38 76 66 52
13 Frickley Athletic Frickley 38 62 79 42
14 Eccleshill United Eccleshill 36 53 68 41
15 Handsworth Parramore Handsworth 37 57 77 41
16 Barton Town Old Boys Barton Town 37 62 79 40
17 Bottesford Town Bottesford 38 51 89 35
18 Pickering Town CFC Pickering 38 60 90 33
19 Goole Goole 38 52 116 31
20 Maltby Main Maltby Main 38 44 96 27
TEMPORADA 2022/2023
COMBINED COUNTIES LEAGUE GRUPO 1
Equipo PJ GF GC Puntos
1 North Ferriby United North 38 93 38 95
2 Winterton Rangers FC Winterton 38 86 46 81
3 AFC Emley AFC Emley 37 85 39 77
4 Garforth Town Garforth 38 83 47 70
5 Penistone Church Penistone 38 70 51 68
6 Hallam FC Hallam FC 38 75 54 67
7 Barton Town Old Boys Barton Town 37 61 43 61
8 Hemsworth MW Hemsworth 38 68 60 55
9 Golcar United Golcar 38 72 59 54
10 Knaresborough Town Knaresboroug 38 58 60 53
11 Albion Sports Albion 38 49 53 51
12 Silsden Silsden 37 54 63 48
13 Maltby Main Maltby Main 38 59 74 48
14 Thackley Thackley 38 72 76 46
15 Eccleshill United Eccleshill 38 58 69 43
16 Handsworth Parramore Handsworth 38 60 73 42
17 Frickley Athletic Frickley 38 51 71 36
18 Bottesford Town Bottesford 38 48 85 29
19 Goole Goole 37 30 91 25
20 Yorkshire Amateur Yorkshire 38 33 113 15
TEMPORADA 2021/2022
COMBINED COUNTIES LEAGUE GRUPO 6
Equipo PJ GF GC Puntos
1 Handsworth Parramore Handsworth 5 11 7 12
2 Sherwood Colliery Sherwood 5 14 7 11
3 Knaresborough Town Knaresboroug 5 8 1 11
4 Grimsby Borough Grimsby 5 10 4 11
5 Winterton Rangers FC Winterton 5 11 1 10
6 Garforth Town Garforth 5 13 7 10
7 Maltby Main Maltby Main 5 12 4 9
8 AFC Mansfield Mansfield 5 7 4 9
9 Eccleshill United Eccleshill 5 10 7 8
10 Staveley MW Staveley MW 5 4 4 6
11 Goole Goole 5 10 12 5
12 Penistone Church Penistone 5 6 8 5
13 AFC Emley AFC Emley 5 5 9 5
14 Silsden Silsden 5 5 9 5
15 Bottesford Town Bottesford 5 6 11 5
16 Thackley Thackley 5 8 15 4
17 Hemsworth MW Hemsworth 5 8 13 3
18 Athersley Recreation Athersley 5 2 14 3
19 Barton Town Old Boys Barton Town 5 5 10 2
20 Albion Sports Albion 5 3 11 1

  USO DE MEMORIA  
5,290,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.3695
Total Execution Time  0.3708
  CADENA URL  
/historico/Penistone-Church
  GET DATOS  
$_GET['/historico/Penistone-Church']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0164  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 = 'Penistone-Church' 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.0110  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=65557 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  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=65557 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  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=65557 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0249  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 = 72985
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65557 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2490 AND type_rel = 3
0.0109  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 = '65557' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0110  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 = '65557' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0108  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 = 72985 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  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=65557 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (72985,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.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 72985 AND teamId = 65557
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 65557
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 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 = 72985 AND t.round = 10 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0107  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 = '65557' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65557' 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 = '65557' 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 = 72985 WHERE rp.league_id = 72985 AND rp.teamId = 65557 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 = 72985 WHERE rp.league_id = 72985 AND rp.teamId = 65557 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 = 72985 WHERE rp.league_id = 72985 AND rp.teamId = 65557 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0109  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 = 65557 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72985 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.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 = 68431 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