4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Arsenal Sub 18

Arsenal Sub 18

Entrenador: Jack Wilshere

Temporada 2020/2021
TEMPORADA 2020/2021
PREMIER LEAGUE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 Fulham Sub 18 Fulham 24 75 23 56
2 Crystal Palace Sub 18 Crystal 24 67 32 56
3 Brighton & Hove Sub 18 Brighton 24 61 37 45
4 Arsenal Sub 18 Arsenal 24 52 45 40
5 Aston Villa Sub 18 Aston Villa 24 45 52 38
6 Tottenham Hotspur Sub 18 Tottenham 24 52 37 37
7 Chelsea Sub 18 Chelsea 24 57 43 36
8 Norwich City Sub 18 Norwich City 24 58 58 29
9 West Bromwich Albion Sub 18 West 24 49 64 28
10 West Ham Sub 18 West 24 35 57 25
11 Reading Sub 18 Reading 24 53 81 20
12 Leicester Sub 18 Leicester 25 40 81 18
13 Southampton Sub 18 Southampton 25 43 77 16
TEMPORADA 2019/2020
PREMIER LEAGUE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 Fulham Sub 18 Fulham 17 53 24 40
2 West Ham Sub 18 West 17 51 28 37
3 Chelsea Sub 18 Chelsea 16 44 21 36
4 Leicester Sub 18 Leicester 18 44 35 27
5 Tottenham Hotspur Sub 18 Tottenham 17 43 33 26
6 Brighton & Hove Sub 18 Brighton 17 30 33 24
7 Aston Villa Sub 18 Aston Villa 17 33 37 22
8 Southampton Sub 18 Southampton 18 27 40 19
9 Arsenal Sub 18 Arsenal 16 28 34 17
10 Reading Sub 18 Reading 16 25 34 15
11 Norwich City Sub 18 Norwich City 16 32 48 11
12 Swansea City Sub 18 Swansea City 15 20 63 5
TEMPORADA 2018/2019
PREMIER LEAGUE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 Arsenal Sub 18 Arsenal 22 86 23 60
2 Tottenham Hotspur Sub 18 Tottenham 22 81 26 56
3 Chelsea Sub 18 Chelsea 22 42 24 44
4 Southampton Sub 18 Southampton 22 48 41 35
5 Brighton & Hove Sub 18 Brighton 22 40 37 34
6 Aston Villa Sub 18 Aston Villa 22 51 43 32
7 Leicester Sub 18 Leicester 22 37 46 29
8 West Ham Sub 18 West 22 38 52 29
9 Fulham Sub 18 Fulham 22 36 45 24
10 Reading Sub 18 Reading 22 22 53 19
11 Swansea City Sub 18 Swansea City 22 19 53 12
12 Norwich City Sub 18 Norwich City 22 20 77 8
TEMPORADA 2017/2018
PREMIER LEAGUE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 Chelsea Sub 18 Chelsea 22 64 21 54
2 Arsenal Sub 18 Arsenal 22 61 33 45
3 Southampton Sub 18 Southampton 22 38 25 42
4 Tottenham Hotspur Sub 18 Tottenham 22 58 39 34
5 Leicester Sub 18 Leicester 22 38 33 33
6 Swansea City Sub 18 Swansea City 22 32 44 31
7 Fulham Sub 18 Fulham 22 40 33 30
8 Brighton & Hove Sub 18 Brighton 22 36 43 24
9 Aston Villa Sub 18 Aston Villa 22 27 36 23
10 West Ham Sub 18 West 22 27 51 21
11 Reading Sub 18 Reading 22 24 50 21
12 Norwich City Sub 18 Norwich City 22 22 59 13
TEMPORADA 2016/2017
PREMIER LEAGUE SUB 18 GRUPO 0
Equipo PJ GF GC Puntos
1 Chelsea Sub 18 Chelsea 1 4 0 3
2 Newcastle Sub 18 Newcastle 1 3 0 3
3 Norwich City Sub 18 Norwich City 1 5 3 3
4 Swansea City Sub 18 Swansea City 1 3 1 3
5 Southampton Sub 18 Southampton 1 2 0 3
6 Wolves Sub 18 Wolves 1 2 0 3
7 Man. City Sub 18 Man. City 1 3 2 3
8 Everton Sub 18 Everton 1 2 1 3
9 Arsenal Sub 18 Arsenal 1 2 2 1
10 Aston Villa Sub 18 Aston Villa 1 2 2 1
11 Fulham Sub 18 Fulham 1 2 2 1
12 Liverpool Sub 18 Liverpool 1 2 2 1
13 Man. Utd Sub 18 Man. 1 2 2 1
14 Reading Sub 18 Reading 1 2 2 1
15 Stoke City Sub 18 Stoke City 1 2 2 1
16 Tottenham Hotspur Sub 18 Tottenham 1 2 2 1
17 Blackburn Rovers Sub 18 Blackburn 1 2 3 0
18 Middlesbrough Sub 18 Middlesbroug 1 1 2 0
19 Derby County Sub 18 Derby County 1 3 5 0
20 Leicester Sub 18 Leicester 1 1 3 0
21 Brighton & Hove Sub 18 Brighton 1 0 2 0
22 West Bromwich Albion Sub 18 West 1 0 2 0
23 Sunderland Sub 18 Sunderland 1 0 3 0
24 West Ham Sub 18 West 1 0 4 0
TEMPORADA 2015/2016
PREMIER LEAGUE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 Chelsea Sub 18 Chelsea 22 65 27 50
2 Reading Sub 18 Reading 22 47 27 42
3 Fulham Sub 18 Fulham 22 44 29 39
4 West Ham Sub 18 West 22 30 29 37
5 Aston Villa Sub 18 Aston Villa 22 42 34 36
6 Arsenal Sub 18 Arsenal 22 49 45 35
7 Leicester Sub 18 Leicester 22 39 37 32
8 Tottenham Hotspur Sub 18 Tottenham 22 43 40 31
9 Brighton & Hove Sub 18 Brighton 22 32 51 22
10 Norwich City Sub 18 Norwich City 22 28 48 21
11 Southampton Sub 18 Southampton 22 34 57 15
12 Swansea City Sub 18 Swansea City 22 25 54 13
TEMPORADA 2014/2015
PREMIER LEAGUE SUB 18 GRUPO 5
Equipo PJ GF GC Puntos
1 Stoke City Sub 18 Stoke City 7 18 11 14
2 Blackburn Rovers Sub 18 Blackburn 7 13 8 14
3 Newcastle Sub 18 Newcastle 7 14 9 10
4 Southampton Sub 18 Southampton 7 10 12 10
5 Fulham Sub 18 Fulham 7 13 11 9
6 Bolton Wanderers Sub 18 Bolton 7 9 10 9
7 Norwich City Sub 18 Norwich City 7 11 15 7
8 Arsenal Sub 18 Arsenal 7 10 22 4

  USO DE MEMORIA  
5,593,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.6303
Total Execution Time  0.6321
  CADENA URL  
/historico/Arsenal-Sub18/2021
  GET DATOS  
$_GET['/historico/Arsenal-Sub18/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0136  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 = 'Arsenal-Sub18' AND l.year = 2021 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.0125  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=60448 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=60448 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=60448 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0254  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 = 58678
0.0151  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 = 60099
0.0131  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60448 AND type_rel = 2
0.0138  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 60448 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (44108,897217,1031635,1077137,1092634) ORDER BY n.cover_points DESC, update_date DESC
0.0161  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 = '60448' ORDER BY l.year DESC,cat.coefficient DESC
0.0134  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 = '60448' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0144  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 = '60448' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0133  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 = 60099 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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 = 58678 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0138  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=60448 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0132  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 (71675,63653,62827) 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.0144  SELECT count(id) as num_players from rel_players WHERE league_id = 63653 AND teamId = 60448
0.0140  SELECT count(id) as num_players from rel_players WHERE league_id = 71675 AND teamId = 60448
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 62827 AND teamId = 60448
0.0142  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 58678 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0138  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 = '60448' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '60448' and rp.type = 4
0.0137  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 = '60448' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0184  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 events2021 e ON e.player_id = p.id AND e.league_id = 58678 WHERE rp.league_id = 58678 AND rp.teamId = 60448 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.0176  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 events2021 e ON e.player_id = p.id AND e.league_id = 58678 WHERE rp.league_id = 58678 AND rp.teamId = 60448 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 events2021 e ON e.player_id = p.id AND e.league_id = 58678 WHERE rp.league_id = 58678 AND rp.teamId = 60448 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 60448 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 = 58678 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 50825 AND t.round = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 44824 AND t.round = 22 ORDER BY team.conference 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 `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 = 39918 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 39167 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 63067 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 `tables2016` 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 = 15608 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 `tables2015` 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 = 9257 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables2015` 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 = 15603 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 58678 ORDER BY nameShow LIMIT 100