4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del AFC Bournemouth Sub 18
TEMPORADA 2023/2024
PROFESSIONAL DEVELOPMENT LEAGUE SUB 18
Equipo PJ GF GC Puntos
1 Birmingham City Sub 18 Birmingham 27 70 35 63
2 Barnsley Sub 18 Barnsley 23 59 36 44
3 Sheffield Wednesday Sub 18 Sheffield 26 47 34 43
4 Burnley Sub 18 Burnley 27 52 34 42
5 Sheffield United Sub 18 Sheffield 27 53 39 39
6 Crewe Alexandra Sub 18 Crewe 25 59 60 35
7 Fleetwood Town Sub 18 Fleetwood 27 39 57 35
8 Hull City Sub 18 Hull City 25 43 59 34
9 Coventry City Sub 18 Coventry 26 46 62 31
10 Wigan Athletic Sub 18 Wigan 27 44 64 22
11 Peterborough United Sub 18 Peterborough 26 38 83 13
12 Bristol City Sub 18 Bristol City 27 68 32 56
13 Charlton Athletic Sub 18 Charlton 24 74 44 53
14 Watford Sub 18 Watford 25 58 32 46
15 Cardiff City Sub 18 Cardiff City 24 64 42 45
16 Millwall Sub 18 Millwall 23 67 48 32
17 Swansea City Sub 18 Swansea City 25 45 56 31
18 AFC Bournemouth Sub 18 Bournemouth 23 51 53 30
19 Ipswich Town Sub 18 Ipswich Town 25 56 64 30
20 Queens Park Rangers Sub 18 Queens Park 27 53 102 26
21 Colchester United Sub 18 Colchester 25 36 86 15
TEMPORADA 2022/2023
YOUTH ALLIANCE
Equipo PJ GF GC Puntos
1 Harrogate Town Sub 18 Harrogate 22 43 19 46
2 Bradford City Sub 18 Bradford 21 57 28 42
3 Grimsby Town Sub 18 Grimsby Town 21 42 31 40
4 Doncaster Rovers Sub 18 Doncaster 22 42 42 38
5 Burton Albion Sub 18 Burton 21 43 33 33
6 Scunthorpe United Sub 18 Scunthorpe 22 37 32 29
7 Lincoln City Sub 18 Lincoln City 21 59 55 29
8 Mansfield Town Sub 18 Mansfield 21 44 45 29
9 Huddersfield Town Sub 18 Huddersfield 21 37 55 22
10 Hartlepool United Sub 18 Hartlepool 23 24 58 18
11 Rotherham United Sub 18 Rotherham 23 29 59 9
12 Blackpool Sub 18 Blackpool 27 53 30 54
13 Accrington Stanley Sub 18 Accrington 26 76 45 49
14 Fleetwood Town Sub 18 Fleetwood 26 55 44 44
15 Salford City Sub 18 Salford City 26 58 45 43
16 Bolton Wanderers Sub 18 Bolton 27 50 37 43
17 Oldham Athletic Sub 18 Oldham 26 63 56 43
18 Carlisle United Sub 18 Carlisle 27 47 47 42
19 Shrewsbury Town Sub 18 Shrewsbury 26 38 40 37
20 Rochdale Sub 18 Rochdale 26 47 45 35
21 Preston North End Sub 18 Preston 27 67 53 34
22 Morecambe Sub 18 Morecambe 26 46 62 27
23 Stockport County Sub 18 Stockport 25 36 53 27
24 Port Vale Sub 18 Port Vale 26 46 67 25
25 Walsall Sub 18 Walsall 27 28 86 14
26 Luton Town Sub 18 Luton Town 21 90 12 57
27 AFC Wimbledon Sub 18 Wimbledon 22 56 29 48
28 Gillingham Sub 18 Gillingham 23 61 40 42
29 Stevenage Sub 18 Stevenage 22 48 36 39
30 Sutton United Sub 18 Sutton 23 35 52 31
31 Cambridge United Sub 18 Cambridge 22 42 38 27
32 Milton Keynes Dons Sub 18 Milton 23 35 61 24
33 Southend United Sub 18 Southend 22 33 68 23
34 Northampton Sub 18 Northampton 21 29 36 22
35 Brentford Sub 18 Brentford 21 29 55 22
36 Leyton Orient Sub 18 Leyton 22 22 48 15
37 Plymouth Argyle Sub 18 Plymouth 21 55 19 45
38 AFC Bournemouth Sub 18 Bournemouth 20 49 27 45
39 Portsmouth Sub 18 Portsmouth 18 44 27 36
40 Oxford United Sub 18 Oxford 20 45 31 32
41 Swindon Town Sub 18 Swindon Town 19 35 45 28
42 Exeter City Sub 18 Exeter City 19 37 42 24
43 Newport County Sub 18 Newport 21 36 53 19
44 Bristol Rovers Sub 18 Bristol 19 23 41 15
45 Cheltenham Town Sub 18 Cheltenham 19 26 45 15
46 Forest Green Rovers Sub 18 Forest Green 20 20 45 12

  USO DE MEMORIA  
5,551,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5303
Total Execution Time  0.5316
  CADENA URL  
/historico/Afc-Bournemouth-Sub-18
  GET DATOS  
$_GET['/historico/Afc-Bournemouth-Sub-18']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0137  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 = 'Afc-Bournemouth-Sub-18' 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.0126  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=111621 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=111621 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=111621 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=111621 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0260  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 = 73471
0.0156  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 = 73912
0.0155  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 = 74630
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=111621 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1540 AND type_rel = 3
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 = '111621' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '111621' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '111621' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = 74630 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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 = 73912 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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 = 73471 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=111621 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (74630,73912,73471,68476) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 73471 AND teamId = 111621
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 68476 AND teamId = 111621
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 73912 AND teamId = 111621
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 74630 AND teamId = 111621
0.0133  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 = 73471 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '111621' 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 = '111621' 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 = '111621' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 73471 WHERE rp.league_id = 73471 AND rp.teamId = 111621 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 = 73471 WHERE rp.league_id = 73471 AND rp.teamId = 111621 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 = 73471 WHERE rp.league_id = 73471 AND rp.teamId = 111621 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 111621 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73471 AND t.round = 31 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 = 68476 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