4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Leicester Sub 18
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
Equipo PJ GF GC Puntos
1 Man. City Sub 18 Man. City 22 70 22 55
2 Man. Utd Sub 18 Man. 22 63 31 46
3 Liverpool Sub 18 Liverpool 22 50 33 46
4 Blackburn Rovers Sub 18 Blackburn 22 40 27 44
5 Everton Sub 18 Everton 22 49 35 39
6 Derby County Sub 18 Derby County 22 38 45 32
7 Middlesbrough Sub 18 Middlesbroug 22 33 40 24
8 Stoke City Sub 18 Stoke City 22 34 49 23
9 Newcastle Sub 18 Newcastle 22 25 43 22
10 West Bromwich Albion Sub 18 West 22 29 42 18
11 Sunderland Sub 18 Sunderland 22 23 55 13
12 Wolves Sub 18 Wolves 22 30 62 10
13 Chelsea Sub 18 Chelsea 22 68 21 52
14 Arsenal Sub 18 Arsenal 22 46 26 41
15 Reading Sub 18 Reading 22 51 40 39
16 West Ham Sub 18 West 22 37 31 34
17 Fulham Sub 18 Fulham 22 39 32 33
18 Aston Villa Sub 18 Aston Villa 22 31 39 33
19 Tottenham Hotspur Sub 18 Tottenham 22 48 36 31
20 Norwich City Sub 18 Norwich City 22 46 38 31
21 Southampton Sub 18 Southampton 22 28 41 26
22 Brighton & Hove Sub 18 Brighton 22 28 51 23
23 Swansea City Sub 18 Swansea City 22 23 60 12
24 Leicester Sub 18 Leicester 22 17 47 11
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 4
Equipo PJ GF GC Puntos
1 Sunderland Sub 18 Sunderland 7 9 5 14
2 Reading Sub 18 Reading 7 10 6 13
3 Wolves Sub 18 Wolves 7 16 5 12
4 Derby County Sub 18 Derby County 7 10 10 12
5 Leicester Sub 18 Leicester 7 14 13 9
6 West Ham Sub 18 West 7 6 10 7
7 Liverpool Sub 18 Liverpool 7 12 17 7
8 Brighton & Hove Sub 18 Brighton 7 9 20 5

  USO DE MEMORIA  
5,487,600 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1176
Total Execution Time  0.1188
  CADENA URL  
/historico/Leicester-City-Sub18/2020
  GET DATOS  
$_GET['/historico/Leicester-City-Sub18/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0030  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 = 'Leicester-City-Sub18' AND l.year = 2020 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.0018  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=60444 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=60444 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=60444 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=60444 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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 = 50825
0.0024  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 = 71683
0.0028  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 = 53554
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60444 AND type_rel = 2
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 60444 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0029  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 = '60444' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '60444' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '60444' 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 = 71683 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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 = 53554 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 50825 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=60444 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (71683,60099,58678) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 58678 AND teamId = 60444
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 71683 AND teamId = 60444
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 60099 AND teamId = 60444
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '60444' 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 = '60444' 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 = '60444' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2020 e ON e.player_id = p.id AND e.league_id = 50825 WHERE rp.league_id = 50825 AND rp.teamId = 60444 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.0027  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 events2020 e ON e.player_id = p.id AND e.league_id = 50825 WHERE rp.league_id = 50825 AND rp.teamId = 60444 AND (e.action = 4 or e.action = 5) 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 events2020 e ON e.player_id = p.id AND e.league_id = 50825 WHERE rp.league_id = 50825 AND rp.teamId = 60444 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 60444 AND l.year <= 2020 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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 = 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.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 = 15602 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 50825 ORDER BY nameShow LIMIT 100