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 2023/2024
TEMPORADA 2023/2024
PREMIER LEAGUE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 Chelsea Sub 18 Chelsea 21 67 33 51
2 West Ham Sub 18 West 22 66 44 46
3 Arsenal Sub 18 Arsenal 22 76 38 44
4 Fulham Sub 18 Fulham 23 61 48 41
5 Tottenham Hotspur Sub 18 Tottenham 22 67 53 39
6 Crystal Palace Sub 18 Crystal 22 56 44 38
7 Brighton & Hove Sub 18 Brighton 22 51 51 31
8 Leicester Sub 18 Leicester 22 39 48 25
9 West Bromwich Albion Sub 18 West 22 40 59 25
10 Southampton Sub 18 Southampton 22 43 53 20
11 Aston Villa Sub 18 Aston Villa 21 44 60 17
12 Norwich City Sub 18 Norwich City 22 37 74 16
13 Reading Sub 18 Reading 21 22 64 11
TEMPORADA 2022/2023
PREMIER LEAGUE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 West Ham Sub 18 West 22 75 32 57
2 Fulham Sub 18 Fulham 22 70 39 40
3 Crystal Palace Sub 18 Crystal 22 60 41 39
4 Chelsea Sub 18 Chelsea 22 54 42 37
5 Tottenham Hotspur Sub 18 Tottenham 22 51 45 36
6 Brighton & Hove Sub 18 Brighton 22 32 48 29
7 West Bromwich Albion Sub 18 West 22 32 42 24
8 Southampton Sub 18 Southampton 22 45 58 24
9 Leicester Sub 18 Leicester 22 34 50 24
10 Aston Villa Sub 18 Aston Villa 22 43 63 24
11 Arsenal Sub 18 Arsenal 22 43 51 23
12 Norwich City Sub 18 Norwich City 22 32 60 16
TEMPORADA 2021/2022
PREMIER LEAGUE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 Southampton Sub 18 Southampton 26 80 34 62
2 West Ham Sub 18 West 26 70 25 58
3 Crystal Palace Sub 18 Crystal 26 61 31 53
4 Arsenal Sub 18 Arsenal 26 58 43 48
5 Leicester Sub 18 Leicester 26 47 31 47
6 Fulham Sub 18 Fulham 26 53 30 46
7 Chelsea Sub 18 Chelsea 26 66 49 46
8 Brighton & Hove Sub 18 Brighton 26 57 58 33
9 Tottenham Hotspur Sub 18 Tottenham 26 52 66 31
10 West Bromwich Albion Sub 18 West 26 42 63 29
11 Reading Sub 18 Reading 26 36 62 24
12 Aston Villa Sub 18 Aston Villa 26 44 69 20
13 Birmingham City Sub 18 Birmingham 26 29 76 14
14 Norwich City Sub 18 Norwich City 26 20 78 10
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  
6,220,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1381
Total Execution Time  0.1394
  CADENA URL  
/historico/Arsenal-Sub18
  GET DATOS  
$_GET['/historico/Arsenal-Sub18']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0056  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 = 73464
0.0025  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 = 73675
0.0022  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 = 75672
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60448 AND type_rel = 2
0.0019  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.0020  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.0024  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.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 = 73675 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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.0030  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 = 73464 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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 (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 (75672,74630,73464) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 73464 AND teamId = 60448
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 75672 AND teamId = 60448
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 74630 AND teamId = 60448
0.0021  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 = 73464 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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.0017  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '60448' and rp.type = 4
0.0019  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.0038  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 = 73464 WHERE rp.league_id = 73464 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.0031  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 = 73464 WHERE rp.league_id = 73464 AND rp.teamId = 60448 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 73464 WHERE rp.league_id = 73464 AND rp.teamId = 60448 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 = 60448 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021  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 = 73464 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 68466 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 63653 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.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 `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.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 `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.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 `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.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 `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.0031  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.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 `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.0022  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.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 `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