4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Juventus Next Gen

Juventus Next Gen

Entrenador: Massimo Brambilla

Temporada 2023/2024
TEMPORADA 2023/2024
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Cesena Cesena 38 80 19 96
2 Sassari Torres Sassari 38 56 38 75
3 Carrarese Carrarese 38 54 30 73
4 Perugia Perugia 38 44 35 63
5 AS Gubbio 1910 Gubbio 1910 38 50 38 59
6 Pescara Pescara 38 60 55 55
7 Juventus Next Gen Juventus 38 50 44 54
8 SS Arezzo SS Arezzo 38 46 44 53
9 Pontedera Pontedera 38 53 54 52
10 Rimini Rimini 38 52 54 50
11 SPAL SPAL 38 41 40 49
12 Lucchese Libertas Lucchese 38 34 43 45
13 Virtus Entella Virtus 38 33 35 45
14 Pineto Pineto 38 38 42 45
15 Sestri Levante Sestri 38 42 55 44
16 Ancona Ancona 38 41 51 42
17 Vis Pesaro Vis Pesaro 38 39 47 39
18 Recanatese Recanatese 38 47 65 38
19 Fermana Fermana 38 30 59 31
20 Olbia Calcio Olbia Calcio 38 25 67 26
TEMPORADA 2022/2023
SERIE C GRUPO 1
Equipo PJ GF GC Puntos
1 Feralpisalò Feralpisalò 38 41 21 71
2 Pordenone Pordenone 38 53 35 62
3 Lecco Lecco 38 45 40 62
4 Pro Sesto Pro Sesto 38 46 45 60
5 Padova Padova 38 47 40 59
6 Virtus Verona Virtus 38 46 30 58
7 Vicenza Vicenza 38 64 47 58
8 Renate Renate 38 49 55 53
9 Arzignano Valchiampo Arzignano 38 43 38 53
10 Novara Novara 38 48 45 52
11 Pergolettese Pergolettese 38 43 42 51
12 Pro Patria Pro Patria 38 37 43 50
13 Juventus Next Gen Juventus 38 42 48 49
14 Trento Trento 38 40 42 46
15 Pro Vercelli Vercelli 38 38 47 46
16 Mantova Mantova 38 48 62 45
17 Sangiuliano City Nova Sangiuliano 38 38 46 42
18 Triestina Triestina 38 31 45 39
19 AlbinoLeffe AlbinoLeffe 38 43 54 38
20 Piacenza Piacenza 38 42 59 38
TEMPORADA 2021/2022
SERIE C GRUPO 1
Equipo PJ GF GC Puntos
1 FC Südtirol Südtirol 38 49 9 90
2 Padova Padova 38 60 26 85
3 Feralpisalò Feralpisalò 38 56 29 69
4 Renate Renate 38 59 43 62
5 Triestina Triestina 38 41 41 55
6 Lecco Lecco 38 51 42 55
7 Pro Vercelli Vercelli 38 41 40 55
8 Juventus Next Gen Juventus 38 43 43 54
9 Piacenza Piacenza 38 44 46 50
10 Pergolettese Pergolettese 38 42 55 46
11 Pro Patria Pro Patria 38 38 45 45
12 AlbinoLeffe AlbinoLeffe 38 42 43 45
13 Virtus Verona Virtus 38 35 38 45
14 Fiorenzuola Fiorenzuola 38 33 48 43
15 Mantova Mantova 38 37 42 42
16 Trento Trento 38 31 36 42
17 Pro Sesto Pro Sesto 38 33 46 38
18 Seregno Seregno 38 41 55 34
19 Giana Erminio Giana 38 25 41 34
20 Legnago Salus Legnago 38 32 65 30
TEMPORADA 2020/2021
SERIE C GRUPO 1
Equipo PJ GF GC Puntos
1 Como Como 38 59 44 75
2 US Alessandria Alessandria 38 48 29 68
3 Renate Renate 38 47 36 65
4 Pro Vercelli Vercelli 38 48 35 63
5 Pro Patria Pro Patria 38 37 28 61
6 Lecco Lecco 38 50 36 60
7 AlbinoLeffe AlbinoLeffe 38 43 36 57
8 Pontedera Pontedera 38 47 40 55
9 Grosseto Grosseto 38 43 41 54
10 Juventus Next Gen Juventus 38 52 50 52
11 Novara Novara 38 48 49 49
12 Piacenza Piacenza 38 47 48 49
13 Olbia Calcio Olbia Calcio 38 47 47 47
14 Giana Erminio Giana 38 36 45 44
15 Pergolettese Pergolettese 38 45 52 44
16 Carrarese Carrarese 38 34 40 44
17 Pro Sesto Pro Sesto 38 31 45 43
18 Pistoiese Pistoiese 38 27 52 31
19 Lucchese Libertas Lucchese 38 36 60 31
20 Livorno Livorno 38 41 53 29
TEMPORADA 2019/2020
SERIE C GRUPO 1
Equipo PJ GF GC Puntos
1 AC Monza AC Monza 27 53 18 61
2 Carrarese Carrarese 27 47 36 45
3 Renate Renate 27 34 22 43
4 Pontedera Pontedera 27 38 35 42
5 Siena Siena 27 32 30 40
6 US Alessandria Alessandria 27 34 30 40
7 AlbinoLeffe AlbinoLeffe 27 29 24 39
8 Novara Novara 26 35 29 38
9 SS Arezzo SS Arezzo 27 33 28 37
10 Juventus Next Gen Juventus 27 30 34 36
11 Pistoiese Pistoiese 27 24 22 33
12 Como Como 26 28 25 32
13 Pro Patria Pro Patria 26 32 30 32
14 Pro Vercelli Vercelli 26 27 28 31
15 Lecco Lecco 26 27 42 28
16 Pergolettese Pergolettese 27 21 36 27
17 Giana Erminio Giana 26 28 44 26
18 Olbia Calcio Olbia Calcio 27 28 44 25
19 Pianese Pianese 27 23 30 24
20 Gozzano Gozzano 27 22 38 22
TEMPORADA 2018/2019
SERIE C GRUPO 1
Equipo PJ GF GC Puntos
1 Piacenza Piacenza 38 59 34 77
2 Virtus Entella Virtus 37 58 26 75
3 Pisa SC Pisa SC 38 50 29 72
4 Pro Vercelli Vercelli 38 48 29 67
5 Siena Siena 38 59 41 66
6 Carrarese Carrarese 38 70 46 65
7 SS Arezzo SS Arezzo 38 50 34 64
8 Pro Patria Pro Patria 38 44 38 57
9 Novara Novara 37 44 36 50
10 Cuneo Cuneo 38 30 36 47
11 Pontedera Pontedera 37 33 39 45
12 US Alessandria Alessandria 38 36 43 45
13 Juventus Next Gen Juventus 37 41 48 42
14 Arzachena Arzachena 38 31 54 40
15 Olbia Calcio Olbia Calcio 38 40 50 38
16 Lucchese Libertas Lucchese 38 46 40 37
17 Pistoiese Pistoiese 38 39 50 36
18 Gozzano Gozzano 38 35 47 33
19 Albissola Albissola 38 34 59 31
20 Pro Piacenza Piacenza 34 17 85 15

  USO DE MEMORIA  
5,908,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0981
Total Execution Time  0.0993
  CADENA URL  
/historico/Juventus-Sub-23
  GET DATOS  
$_GET['/historico/Juventus-Sub-23']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0038  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 = 75937
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=112343 AND type_rel = 2
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 112343 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (593044,664081,673818,683843,701172) ORDER BY n.cover_points DESC, update_date DESC
0.0025  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 = '112343' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '112343' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0026  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 = 75937 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 74153 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=112343 AND l.year in (2023,2024,2025) 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 (75937,74153,71432) 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 = 75937 AND teamId = 112343
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 74153 AND teamId = 112343
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 112343
0.0018  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 = 75937 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '112343' 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 = '112343' and rp.type = 4
0.0020  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 = '112343' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 = 75937 WHERE rp.league_id = 75937 AND rp.teamId = 112343 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.0019  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 = 75937 WHERE rp.league_id = 75937 AND rp.teamId = 112343 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 75937 WHERE rp.league_id = 75937 AND rp.teamId = 112343 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 = 112343 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72300 AND t.round = 38 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 `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 = 68591 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 63824 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 58760 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 51021 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 44231 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC