4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Juventus Sub 19 Juventus 26 49 19 61
2 Fiorentina Sub 19 Fiorentina 26 59 25 56
3 Torino Sub 19 Torino 26 40 19 53
4 Genoa Sub 19 Genoa 26 41 31 46
5 Empoli Sub 19 Empoli 26 41 37 41
6 Parma Sub 19 Parma 26 37 39 36
7 Spezia Sub 19 Spezia 26 27 38 35
8 Novara Sub 19 Novara 26 35 42 31
9 Siena Sub 19 Siena 26 30 35 30
10 Pro Vercelli Sub 19 Vercelli 26 26 40 30
11 Sampdoria Sub 19 Sampdoria 26 33 32 28
12 Cagliari Sub 19 Cagliari 26 33 42 26
13 Livorno Sub 19 Livorno 26 36 53 25
14 Grosseto Sub 19 Grosseto 26 25 60 13
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Juventus Sub 19 Juventus 26 67 31 55
2 Torino Sub 19 Torino 26 38 23 49
3 Fiorentina Sub 19 Fiorentina 26 45 23 48
4 Genoa Sub 19 Genoa 26 39 29 43
5 Sampdoria Sub 19 Sampdoria 26 44 34 41
6 Livorno Sub 19 Livorno 26 47 42 40
7 Empoli Sub 19 Empoli 26 35 40 40
8 Novara Sub 19 Novara 26 44 35 35
9 Parma Sub 19 Parma 26 40 45 33
10 Cagliari Sub 19 Cagliari 26 33 46 29
11 Sassuolo Sub 19 Sassuolo 26 36 43 28
12 Siena Sub 19 Siena 26 34 38 22
13 Modena Sub 19 Modena 26 21 45 19
14 Grosseto Sub 19 Grosseto 26 18 67 12
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Genoa Sub 19 Genoa 26 45 25 62
2 Juventus Sub 19 Juventus 26 54 27 54
3 Fiorentina Sub 19 Fiorentina 26 55 25 52
4 Empoli Sub 19 Empoli 26 45 26 46
5 Torino Sub 19 Torino 26 43 32 46
6 Parma Sub 19 Parma 26 33 27 42
7 Novara Sub 19 Novara 26 46 37 41
8 Sampdoria Sub 19 Sampdoria 26 44 37 37
9 Bologna Sub 19 Bologna 26 39 43 34
10 Livorno Sub 19 Livorno 26 27 42 28
11 Sassuolo Sub 19 Sassuolo 26 38 53 27
12 Cesena Sub 19 Cesena 26 28 47 18
13 Modena Sub 19 Modena 26 14 54 14
14 Piacenza Sub 19 Piacenza 26 16 52 13
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Sampdoria Sub 19 Sampdoria 26 55 23 56
2 Juventus Sub 19 Juventus 26 54 26 55
3 Genoa Sub 19 Genoa 26 43 18 51
4 Empoli Sub 19 Empoli 26 36 18 48
5 Parma Sub 19 Parma 26 39 26 48
6 Fiorentina Sub 19 Fiorentina 26 48 27 45
7 Siena Sub 19 Siena 26 36 28 42
8 Piacenza Sub 19 Piacenza 26 31 48 35
9 Torino Sub 19 Torino 26 39 34 33
10 Cagliari Sub 19 Cagliari 26 26 49 24
11 Sassuolo Sub 19 Sassuolo 26 25 39 23
12 Livorno Sub 19 Livorno 26 19 41 20
13 Modena Sub 19 Modena 26 15 56 16
14 Grosseto Sub 19 Grosseto 26 17 50 15
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Juventus Sub 19 Juventus 26 52 18 55
2 Sampdoria Sub 19 Sampdoria 26 37 14 51
3 Genoa Sub 19 Genoa 26 43 20 50
4 Empoli Sub 19 Empoli 26 38 20 50
5 Siena Sub 19 Siena 26 39 31 47
6 Torino Sub 19 Torino 26 38 38 32
7 Sassuolo Sub 19 Sassuolo 26 30 35 31
8 Bologna Sub 19 Bologna 26 23 33 31
9 Modena Sub 19 Modena 26 25 34 29
10 Parma Sub 19 Parma 26 21 36 29
11 Piacenza Sub 19 Piacenza 26 36 39 27
12 Pisa SC Sub 19 Pisa 26 24 35 25
13 Livorno Sub 19 Livorno 26 29 41 25
14 Grosseto Sub 19 Grosseto 26 17 58 12
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Juventus Sub 19 Juventus 26 60 30 56
2 Sampdoria Sub 19 Sampdoria 26 45 18 55
3 Parma Sub 19 Parma 26 39 24 50
4 Genoa Sub 19 Genoa 26 46 31 43
5 Piacenza Sub 19 Piacenza 26 40 32 43
6 Brescia Sub 19 Brescia 26 38 30 42
7 Torino Sub 19 Torino 26 37 26 40
8 Spezia Sub 19 Spezia 26 38 45 33
9 Bologna Sub 19 Bologna 26 30 35 29
10 Cagliari Sub 19 Cagliari 26 34 45 28
11 Modena Sub 19 Modena 26 35 48 27
12 Mantova Sub 19 Mantova 26 32 59 19
13 Livorno Sub 19 Livorno 26 23 51 19
14 Pisa SC Sub 19 Pisa 26 28 51 18

  USO DE MEMORIA  
5,562,512 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.2912
Total Execution Time  0.2931
  CADENA URL  
/liga_primavera_italia2013/grupo1/historico
  GET DATOS  
$_GET['/liga_primavera_italia2013/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0106  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1554 ORDER BY order_id ASC
0.0108  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 = 44185 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1554 AND group_code = 1 and tables = 1 AND year <= 2013 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0109  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 `tables2013` 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 = 44185 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 `tables2012` 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 = 44188 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 `tables2011` 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 = 44191 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2010` 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 = 44194 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2009` 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 = 44197 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 `tables2008` 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 = 44200 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 22:34:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 22:34:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 22:34:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 22:34:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0201  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 events2013 e ON e.player_id = p.id AND e.league_id = 44185 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44185 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.0202  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 events2013 e ON e.player_id = p.id AND e.league_id = 44185 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44185 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0128  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 events2013 e ON e.player_id = p.id AND e.league_id = 44185 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44185 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0118  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` 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 = 44185 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC