Ver
TEMPORADA 2021/2022
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
Ver
TEMPORADA 2020/2021
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
Ver
TEMPORADA 2019/2020
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
Ver
TEMPORADA 2018/2019
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
Ver
TEMPORADA 2017/2018
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
Ver
TEMPORADA 2016/2017
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
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Juventus Sub 17 Juventus 26 63 28 53
2 Fiorentina Sub 17 Fiorentina 26 57 32 51
3 Genoa Sub 17 Genoa 26 48 30 50
4 Sampdoria Sub 17 Sampdoria 26 40 23 50
5 Torino Sub 17 Torino 26 42 24 47
6 Novara Sub 17 Novara 26 36 31 35
7 Spezia Sub 17 Spezia 26 33 35 35
8 Sassuolo Sub 17 Sassuolo 26 40 48 35
9 Modena Sub 17 Modena 26 30 34 34
10 Empoli Sub 17 Empoli 26 35 34 32
11 Pro Vercelli Sub 17 Vercelli 26 31 41 32
12 Virtus Entella Sub 17 Virtus 26 27 36 27
13 Livorno Sub 17 Livorno 26 20 48 15
14 Trapani Sub 17 Trapani 26 22 80 13
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Inter Sub 17 Inter 3 5 2 7
2 Roma Sub 17 Roma Sub 17 3 5 2 6
3 Fiorentina Sub 17 Fiorentina 3 4 6 3
4 Palermo Sub 17 Palermo 3 0 4 1

  USO DE MEMORIA  
5,658,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0025
Controller Execution Time ( Home / Category )  0.0938
Total Execution Time  0.0964
  CADENA URL  
/campeonato_nacional_sub172022/grupo1/historico
  GET DATOS  
$_GET['/campeonato_nacional_sub172022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0018  SELECT type FROM routes WHERE alias = 'campeonato_nacional_sub172022'
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'campeonato_nacional_sub17' 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.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2043 AND type_rel = 3
0.0019  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 = 63937 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2043 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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.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 `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.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 = 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.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 = 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.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 `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.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 = 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.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 `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.0020  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 = 63021 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-20 00:22:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-20 00:22:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-20 00:22:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-20 00:22:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'campeonato_nacional_sub17' 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.0074  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 = 63937 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63937 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.0071  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 = 63937 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63937 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0027  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 = 63937 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63937 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  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 = 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