4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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,312,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3215
Total Execution Time  0.3234
  CADENA URL  
/campeonato_nacional_sub172019/grupo1/historico
  GET DATOS  
$_GET['/campeonato_nacional_sub172019/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2043 AND type_rel = 3
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2043 ORDER BY order_id ASC
0.0126  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2043 AND group_code = 1 and tables = 1 AND year <= 2019 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0128  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.0128  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.0128  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.0128  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.0127  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.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 11:40:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 11:40:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 11:40:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 11:40:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0262  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 events2019 e ON e.player_id = p.id AND e.league_id = 48433 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 48433 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.0228  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 events2019 e ON e.player_id = p.id AND e.league_id = 48433 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 48433 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0135  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 events2019 e ON e.player_id = p.id AND e.league_id = 48433 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 48433 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0137  SELECT *,(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