4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Juventus Sub 17
TEMPORADA 2023/2024
CAMPEONATO NACIONAL SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Juventus Sub 17 Juventus 21 57 22 47
2 Sassuolo Sub 17 Sassuolo 21 42 29 42
3 Bologna Sub 17 Bologna 21 50 28 39
4 Genoa Sub 17 Genoa 21 38 19 39
5 Parma Sub 17 Parma 22 32 24 39
6 Torino Sub 17 Torino 20 33 21 33
7 Spezia Sub 17 Spezia 22 40 34 30
8 Sampdoria Sub 17 Sampdoria 21 35 41 30
9 Pisa SC Sub 17 Pisa 21 29 31 25
10 Modena Sub 17 Modena 22 28 45 20
11 Cremonese Sub 17 Cremonese 21 24 45 17
12 Napoli Sub 17 Napoli 21 27 59 12
13 Reggiana Sub 17 Reggiana 20 11 48 9
TEMPORADA 2022/2023
CAMPEONATO NACIONAL SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Fiorentina Sub 17 Fiorentina 24 79 33 57
2 Juventus Sub 17 Juventus 24 58 21 51
3 Parma Sub 17 Parma 24 52 24 49
4 Genoa Sub 17 Genoa 24 55 35 48
5 Bologna Sub 17 Bologna 24 60 34 46
6 Torino Sub 17 Torino 24 39 41 32
7 Pisa SC Sub 17 Pisa 24 30 40 32
8 Sassuolo Sub 17 Sassuolo 24 31 43 29
9 Napoli Sub 17 Napoli 24 37 54 28
10 Empoli Sub 17 Empoli 24 30 45 27
11 Sampdoria Sub 17 Sampdoria 24 21 39 24
12 Spezia Sub 17 Spezia 24 29 53 14
13 Modena Sub 17 Modena 24 13 72 3
TEMPORADA 2021/2022
CAMPEONATO NACIONAL SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Bologna Sub 17 Bologna 24 40 24 49
2 Juventus Sub 17 Juventus 24 54 22 48
3 Genoa Sub 17 Genoa 24 65 34 47
4 Fiorentina Sub 17 Fiorentina 24 51 22 44
5 Sampdoria Sub 17 Sampdoria 24 36 31 38
6 Empoli Sub 17 Empoli 24 36 38 35
7 Cremonese Sub 17 Cremonese 24 37 43 31
8 Spezia Sub 17 Spezia 24 41 48 29
9 US Alessandria Sub17 Alessandria 24 37 39 28
10 Sassuolo Sub 17 Sassuolo 24 37 44 24
11 Torino Sub 17 Torino 24 31 56 22
12 Parma Sub 17 Parma 24 29 54 19
13 Pisa SC Sub 17 Pisa 24 27 66 13
TEMPORADA 2020/2021
CAMPEONATO NACIONAL SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Bologna Sub 17 Bologna 4 8 3 10
2 Parma Sub 17 Parma 3 6 7 6
3 Lazio Sub 17 Lazio 3 5 3 5
4 Sampdoria Sub 17 Sampdoria 2 4 2 4
5 Torino Sub 17 Torino 2 4 3 4
6 Pisa SC Sub 17 Pisa 4 5 5 4
7 Juventus Sub 17 Juventus 1 6 2 3
8 Sassuolo Sub 17 Sassuolo 2 3 3 3
9 Reggiana Sub 17 Reggiana 3 4 7 3
10 Cremonese Sub 17 Cremonese 2 4 6 1
11 Genoa Sub 17 Genoa 3 5 8 1
12 Spezia Sub 17 Spezia 0 0 0 0
13 Virtus Entella Sub 17 Virtus 3 3 8 0
TEMPORADA 2019/2020
CAMPEONATO NACIONAL SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Juventus Sub 17 Juventus 18 75 19 52
2 Parma Sub 17 Parma 19 32 26 31
3 Genoa Sub 17 Genoa 18 30 25 30
4 Sassuolo Sub 17 Sassuolo 19 30 22 29
5 Empoli Sub 17 Empoli 18 38 35 28
6 Fiorentina Sub 17 Fiorentina 19 38 26 27
7 Spezia Sub 17 Spezia 18 31 24 27
8 Lazio Sub 17 Lazio 19 38 37 24
9 Torino Sub 17 Torino 17 21 21 24
10 Sampdoria Sub 17 Sampdoria 19 26 36 20
11 Virtus Entella Sub 17 Virtus 18 20 31 17
12 Pisa SC Sub 17 Pisa 20 19 61 12
13 Livorno Sub 17 Livorno 18 20 55 9
TEMPORADA 2018/2019
CAMPEONATO NACIONAL SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Juventus Sub 17 Juventus 24 56 31 51
2 Fiorentina Sub 17 Fiorentina 24 59 32 50
3 Genoa Sub 17 Genoa 24 43 26 46
4 Torino Sub 17 Torino 24 44 30 45
5 Empoli Sub 17 Empoli 24 39 25 42
6 Sampdoria Sub 17 Sampdoria 24 46 29 41
7 Lazio Sub 17 Lazio 24 45 34 41
8 Sassuolo Sub 17 Sassuolo 24 40 25 35
9 Parma Sub 17 Parma 24 39 49 25
10 Cremonese Sub 17 Cremonese 24 27 50 22
11 Carpi Sub 17 Carpi 24 20 50 17
12 Livorno Sub 17 Livorno 24 21 61 14
13 Spezia Sub 17 Spezia 24 23 60 11
TEMPORADA 2017/2018
CAMPEONATO NACIONAL SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Juventus Sub 17 Juventus 26 65 28 60
2 Torino Sub 17 Torino 26 46 18 60
3 Genoa Sub 17 Genoa 26 35 19 54
4 Novara Sub 17 Novara 26 45 31 47
5 Sampdoria Sub 17 Sampdoria 26 40 32 44
6 Fiorentina Sub 17 Fiorentina 26 48 35 42
7 Cremonese Sub 17 Cremonese 26 40 38 35
8 Sassuolo Sub 17 Sassuolo 26 36 31 32
9 Virtus Entella Sub 17 Virtus 26 35 46 32
10 Empoli Sub 17 Empoli 26 31 41 28
11 Carpi Sub 17 Carpi 26 24 47 21
12 Spezia Sub 17 Spezia 26 23 46 18
13 Pro Vercelli Sub 17 Vercelli 26 25 57 16
14 Parma Sub 17 Parma 26 19 43 14
TEMPORADA 2016/2017
CAMPEONATO NACIONAL SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Genoa Sub 17 Genoa 26 55 19 53
2 Torino Sub 17 Torino 26 62 34 52
3 Sassuolo Sub 17 Sassuolo 26 55 29 50
4 Juventus Sub 17 Juventus 26 53 32 50
5 Spezia Sub 17 Spezia 26 42 30 48
6 Empoli Sub 17 Empoli 26 35 24 45
7 Fiorentina Sub 17 Fiorentina 26 36 28 43
8 Pro Vercelli Sub 17 Vercelli 26 46 39 40
9 Novara Sub 17 Novara 26 35 36 35
10 Sampdoria Sub 17 Sampdoria 26 40 45 30
11 Carpi Sub 17 Carpi 26 28 51 23
12 Trapani Sub 17 Trapani 26 28 76 17
13 Virtus Entella Sub 17 Virtus 26 25 56 12
14 Pisa SC Sub 17 Pisa 26 20 61 11
TEMPORADA 2015/2016
CAMPEONATO NACIONAL SUB 17 GRUPO 5
Equipo PJ GF GC Puntos
1 Juventus Sub 17 Juventus 3 7 0 7
2 Inter Sub 17 Inter 3 4 5 6
3 Palermo Sub 17 Palermo 3 3 1 4
4 Napoli Sub 17 Napoli 3 2 10 0

  USO DE MEMORIA  
5,561,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  1.5923
Total Execution Time  1.5936
  CADENA URL  
/historico/Juventus-Sub-17
  GET DATOS  
$_GET['/historico/Juventus-Sub-17']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0158  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 = 'Juventus-Sub-17' AND l.year = 2024 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.0145  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=111193 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=111193 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0292  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 = 74022
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=111193 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2043 AND type_rel = 3
0.0148  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 = '111193' ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '111193' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '111193' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 74022 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0168  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=111193 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0151  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 (74022) 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.0186  SELECT count(id) as num_players from rel_players WHERE league_id = 74022 AND teamId = 111193
0.0149  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 = '111193' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '111193' and rp.type = 4
0.0147  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 = '111193' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0161  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 = 74022 WHERE rp.league_id = 74022 AND rp.teamId = 111193 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.0166  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 = 74022 WHERE rp.league_id = 74022 AND rp.teamId = 111193 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0167  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 = 74022 WHERE rp.league_id = 74022 AND rp.teamId = 111193 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152  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 = 111193 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74022 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.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 `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 = 68785 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 `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 = 63937 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.0152  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 = 62218 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 58747 AND t.round = 4 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 `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 = 51480 AND t.round = 21 ORDER BY team.conference ASC,t.position 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 `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 = 48433 AND t.round = 26 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 = 43503 AND t.round = 26 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 `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 = 43959 AND t.round = 26 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 `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 = 43963 AND t.round = 26 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 = 44018 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC