4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Man. City Sub 18
TEMPORADA 2023/2024
PREMIER LEAGUE SUB 18 GRUPO 1
Equipo PJ GF GC Puntos
1 Man. Utd Sub 18 Man. 23 75 27 59
2 Man. City Sub 18 Man. City 22 65 24 50
3 Wolves Sub 18 Wolves 22 38 32 35
4 Derby County Sub 18 Derby County 22 49 47 34
5 Leeds United Sub 18 Leeds United 22 52 47 33
6 Liverpool Sub 18 Liverpool 23 55 57 32
7 Newcastle Sub 18 Newcastle 21 43 49 26
8 Nottingham Forest Sub 18 Nottingham 22 32 44 26
9 Middlesbrough Sub 18 Middlesbroug 22 26 41 24
10 Blackburn Rovers Sub 18 Blackburn 21 34 54 24
11 Everton Sub 18 Everton 21 28 33 22
12 Stoke City Sub 18 Stoke City 22 38 56 20
13 Sunderland Sub 18 Sunderland 21 27 51 18
TEMPORADA 2022/2023
PREMIER LEAGUE SUB 18 GRUPO 1
Equipo PJ GF GC Puntos
1 Man. City Sub 18 Man. City 24 81 23 57
2 Sunderland Sub 18 Sunderland 24 63 30 53
3 Man. Utd Sub 18 Man. 24 56 39 44
4 Everton Sub 18 Everton 24 43 41 33
5 Stoke City Sub 18 Stoke City 24 31 39 32
6 Liverpool Sub 18 Liverpool 24 55 54 31
7 Derby County Sub 18 Derby County 24 48 47 31
8 Middlesbrough Sub 18 Middlesbroug 24 34 55 30
9 Nottingham Forest Sub 18 Nottingham 24 37 43 29
10 Blackburn Rovers Sub 18 Blackburn 24 37 56 26
11 Wolves Sub 18 Wolves 24 31 54 26
12 Newcastle Sub 18 Newcastle 24 42 54 24
13 Leeds United Sub 18 Leeds United 24 44 67 20
TEMPORADA 2021/2022
PREMIER LEAGUE SUB 18 GRUPO 1
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
TEMPORADA 2020/2021
PREMIER LEAGUE SUB 18 GRUPO 1
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
TEMPORADA 2019/2020
PREMIER LEAGUE SUB 18 GRUPO 1
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
TEMPORADA 2018/2019
PREMIER LEAGUE SUB 18 GRUPO 1
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
TEMPORADA 2017/2018
PREMIER LEAGUE SUB 18 GRUPO 1
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
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 1
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
TEMPORADA 2014/2015
PREMIER LEAGUE SUB 18 GRUPO 3
Equipo PJ GF GC Puntos
1 Middlesbrough Sub 18 Middlesbroug 7 17 10 16
2 Everton Sub 18 Everton 7 17 7 14
3 Chelsea Sub 18 Chelsea 7 18 14 13
4 Man. Utd Sub 18 Man. 7 9 8 11
5 West Bromwich Albion Sub 18 West 7 17 15 9
6 Aston Villa Sub 18 Aston Villa 7 10 17 8
7 Man. City Sub 18 Man. City 7 9 17 4
8 Tottenham Hotspur Sub 18 Tottenham 7 12 21 4

  USO DE MEMORIA  
6,226,512 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1245
Total Execution Time  0.1257
  CADENA URL  
/historico/Manchester-City-Sub18
  GET DATOS  
$_GET['/historico/Manchester-City-Sub18']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60433 AND type_rel = 2
0.0025  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 60433 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0026  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 (43108,457980,576930,808770,857571) ORDER BY n.cover_points DESC, update_date DESC
0.0033  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 = '60433' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 73463 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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=60433 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0022  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,73463) 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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 73463 AND teamId = 60433
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 75672 AND teamId = 60433
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 74630 AND teamId = 60433
0.0024  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 = 73463 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '60433' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '60433' and rp.type = 4
0.0022  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 = '60433' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0043  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 = 73463 WHERE rp.league_id = 73463 AND rp.teamId = 60433 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.0039  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 = 73463 WHERE rp.league_id = 73463 AND rp.teamId = 60433 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 = 73463 WHERE rp.league_id = 73463 AND rp.teamId = 60433 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 60433 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0026  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 = 73463 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.0026  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 = 68465 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.0027  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.0027  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.0030  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.0030  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.0036  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.0040  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.0039  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.0036  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.0035  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.0037  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 = 15601 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 73463 ORDER BY nameShow LIMIT 100