4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Man. City Sub 18 Man. City 26 87 26 61
2 Liverpool Sub 18 Liverpool 26 85 45 51
3 Man. Utd Sub 18 Man. 26 58 47 42
4 Nottingham Forest Sub 18 Nottingham 26 36 32 42
5 Blackburn Rovers Sub 18 Blackburn 26 56 38 38
6 Middlesbrough Sub 18 Middlesbroug 26 38 45 38
7 Burnley Sub 18 Burnley 26 40 44 36
8 Wolves Sub 18 Wolves 26 41 46 36
9 Leeds United Sub 18 Leeds United 26 66 70 34
10 Everton Sub 18 Everton 26 28 37 31
11 Sunderland Sub 18 Sunderland 26 39 48 29
12 Derby County Sub 18 Derby County 26 31 62 27
13 Stoke City Sub 18 Stoke City 26 33 56 22
14 Newcastle Sub 18 Newcastle 26 27 69 17
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Man. City Sub 18 Man. City 23 71 18 60
2 Man. Utd Sub 18 Man. 23 71 26 57
3 Liverpool Sub 18 Liverpool 24 75 26 52
4 Middlesbrough Sub 18 Middlesbroug 23 47 40 39
5 Everton Sub 18 Everton 23 39 38 35
6 Wolves Sub 18 Wolves 23 38 44 33
7 Derby County Sub 18 Derby County 23 41 53 30
8 Blackburn Rovers Sub 18 Blackburn 23 34 43 29
9 Burnley Sub 18 Burnley 23 33 36 28
10 Stoke City Sub 18 Stoke City 23 28 56 23
11 Newcastle Sub 18 Newcastle 23 44 57 21
12 Leeds United Sub 18 Leeds United 23 30 71 15
13 Sunderland Sub 18 Sunderland 23 31 74 11
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Man. City Sub 18 Man. City 17 56 16 43
2 Liverpool Sub 18 Liverpool 15 48 28 31
3 Everton Sub 18 Everton 16 48 33 31
4 Derby County Sub 18 Derby County 17 38 25 28
5 Stoke City Sub 18 Stoke City 15 33 22 28
6 Man. Utd Sub 18 Man. 16 34 32 23
7 Wolves Sub 18 Wolves 15 22 23 21
8 Middlesbrough Sub 18 Middlesbroug 16 28 38 21
9 West Bromwich Albion Sub 18 West 16 34 42 20
10 Newcastle Sub 18 Newcastle 16 23 38 15
11 Blackburn Rovers Sub 18 Blackburn 15 24 35 14
12 Sunderland Sub 18 Sunderland 16 11 67 0
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Derby County Sub 18 Derby County 22 63 27 51
2 Liverpool Sub 18 Liverpool 22 59 32 51
3 Everton Sub 18 Everton 22 65 34 44
4 Man. Utd Sub 18 Man. 22 60 39 43
5 Middlesbrough Sub 18 Middlesbroug 22 52 48 35
6 Stoke City Sub 18 Stoke City 22 42 39 32
7 Man. City Sub 18 Man. City 22 46 34 29
8 Blackburn Rovers Sub 18 Blackburn 21 44 48 27
9 West Bromwich Albion Sub 18 West 21 43 60 18
10 Newcastle Sub 18 Newcastle 22 17 62 14
11 Wolves Sub 18 Wolves 21 20 46 11
12 Sunderland Sub 18 Sunderland 21 19 61 10
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Man. Utd Sub 18 Man. 22 65 33 48
2 Man. City Sub 18 Man. City 22 58 34 42
3 Liverpool Sub 18 Liverpool 22 50 35 38
4 Stoke City Sub 18 Stoke City 22 49 34 37
5 Everton Sub 18 Everton 22 51 41 37
6 Derby County Sub 18 Derby County 22 45 38 33
7 Sunderland Sub 18 Sunderland 22 39 44 32
8 West Bromwich Albion Sub 18 West 22 49 57 26
9 Middlesbrough Sub 18 Middlesbroug 22 37 52 25
10 Newcastle Sub 18 Newcastle 22 37 48 24
11 Wolves Sub 18 Wolves 22 31 53 19
12 Blackburn Rovers Sub 18 Blackburn 22 28 70 10
Ver
TEMPORADA 2016/2017
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
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Man. City Sub 18 Man. City 22 53 23 48
2 Everton Sub 18 Everton 22 57 33 48
3 Liverpool Sub 18 Liverpool 22 45 28 43
4 Blackburn Rovers Sub 18 Blackburn 22 45 31 37
5 Sunderland Sub 18 Sunderland 22 44 40 36
6 Middlesbrough Sub 18 Middlesbroug 22 43 38 34
7 Wolves Sub 18 Wolves 22 42 40 28
8 West Bromwich Albion Sub 18 West 22 29 44 25
9 Newcastle Sub 18 Newcastle 22 27 59 20
10 Derby County Sub 18 Derby County 22 39 51 18
11 Man. Utd Sub 18 Man. 22 29 44 18
12 Stoke City Sub 18 Stoke City 22 23 45 16
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Middlesbrough Sub 18 Middlesbroug 22 59 30 50
2 Everton Sub 18 Everton 22 49 30 41
3 Man. City Sub 18 Man. City 22 45 29 40
4 Man. Utd Sub 18 Man. 22 29 24 38
5 Wolves Sub 18 Wolves 22 38 36 37
6 Derby County Sub 18 Derby County 22 47 36 33
7 Liverpool Sub 18 Liverpool 22 51 51 29
8 Sunderland Sub 18 Sunderland 22 33 35 29
9 Newcastle Sub 18 Newcastle 22 36 50 21
10 Blackburn Rovers Sub 18 Blackburn 22 31 50 20
11 Stoke City Sub 18 Stoke City 22 23 39 19
12 Bolton Wanderers Sub 18 Bolton 22 22 53 14

  USO DE MEMORIA  
5,779,704 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.5177
Total Execution Time  0.5198
  CADENA URL  
/premier_league_sub_182022/grupo1/historico
  GET DATOS  
$_GET['/premier_league_sub_182022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0144  SELECT type FROM routes WHERE alias = 'premier_league_sub_182022'
0.0293  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_sub_18' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1539 AND type_rel = 3
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1539 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147  SELECT /*53 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 (1288249,1181899,1178797,1128743,1117192) ORDER BY n.cover_points DESC, update_date DESC
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1539 ORDER BY order_id ASC
0.0148  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 63652 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1539 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0150  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 = 63652 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.0148  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 = 58677 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 50824 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.0150  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 = 44823 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 39917 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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.0148  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 = 15607 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 9256 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 02:22:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-26 02:22:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-26 02:22:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-26 02:22:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_sub_18' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0264  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63652 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63652 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0236  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63652 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63652 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0153  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63652 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63652 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0158  SELECT *,(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 = 63652 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