4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Barton Town Old Boys
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,407,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0847
Total Execution Time  0.0860
  CADENA URL  
/historico/Barton-Town-Old-Boys
  GET DATOS  
$_GET['/historico/Barton-Town-Old-Boys']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0043  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.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16238 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2490 AND type_rel = 3
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 = '16238' 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 = 72985 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=16238 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 (72985,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 = 72985 AND teamId = 16238
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 16238
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 16238
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 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.0024  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 = '16238' 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 = '16238' 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 = '16238' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 16238 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.0020  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 = 16238 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 72985 WHERE rp.league_id = 72985 AND rp.teamId = 16238 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 16238 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.0030  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
0.0033  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 = 63783 AND t.round = 5 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 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 = 72985 ORDER BY nameShow LIMIT 100