4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Giana Erminio Giana 34 68 29 73
2 Rapallo Boglia.. Rapallo 34 60 32 68
3 Borgosesia Borgosesia 34 74 36 67
4 Caronnese Caronnese 34 52 29 62
5 Lavagnese Lavagnese 34 46 28 61
6 Chieri Chieri 34 53 44 60
7 Vado FC Vado FC 34 55 46 51
8 Chiavari Caperana Chiavari 34 35 30 46
9 Asti FC Asti FC 34 46 38 44
10 Novese Novese 34 40 50 44
11 Vallée dAoste Vallée 34 41 42 42
12 Folgore Caratese Folgore 34 33 48 41
13 Derthona Derthona 34 37 44 39
14 Albese Calcio Albese 34 38 52 39
15 Sestri Levante Sestri 34 38 52 35
16 Pro Dronero Pro Dronero 34 51 75 30
17 Santhià Santhià 34 26 69 22
18 Verbania Verbania 34 18 67 13
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 AS Bra AS Bra 34 64 35 72
2 Santhià Santhià 34 69 42 69
3 Lavagnese Lavagnese 34 53 36 62
4 Chieri Chieri 34 47 34 61
5 Borgosesia Borgosesia 34 65 32 56
6 Chiavari Caperana Chiavari 34 53 43 51
7 Folgore Caratese Folgore 34 35 32 50
8 Sestri Levante Sestri 34 51 43 47
9 Derthona Derthona 34 29 33 45
10 Verbania Verbania 34 44 38 44
11 Bogliasco FC Bogliasco 34 47 46 43
12 Gozzano Gozzano 34 40 40 43
13 Verbano Calcio Verbano 34 37 44 40
14 Asti FC Asti FC 34 31 49 39
15 Tortona Villalvernia Tortona 34 32 50 35
16 Novese Novese 34 33 55 33
17 Trezzano Calcio Trezzano 34 27 49 28
18 Imperia Imperia 34 33 89 20
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 S. Christophe Christophe 36 88 44 83
2 Chieri Chieri 36 66 34 82
3 Santhià Santhià 36 69 39 67
4 Novese Novese 36 54 41 60
5 Lavagnese Lavagnese 36 55 35 58
6 Borgosesia Borgosesia 36 55 39 55
7 Villalvernia Villalvernia 36 55 45 55
8 Derthona Derthona 36 52 46 54
9 Folgore Caratese Folgore 36 55 38 52
10 Chiavari Chiavari 36 52 50 51
11 Imperia Imperia 36 46 49 50
12 Bogliasco Bogliasco 36 49 48 48
13 Naviglio Trezzano Naviglio 36 46 45 47
14 Verbano Calcio Verbano 36 50 53 46
15 Acqui Acqui 35 35 48 40
16 Asti FC Asti FC 36 45 55 39
17 Albese Calcio Albese 36 40 62 31
18 Cantù San Paolo Cantù Paolo 35 16 90 8
19 Lascaris Lascaris 36 30 97 7
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Cuneo Cuneo 38 87 44 82
2 Asti FC Asti FC 38 66 43 73
3 Vallée dAoste Vallée 38 63 41 73
4 Aquanera Aquanera 38 65 41 66
5 Seregno Seregno 38 52 35 63
6 Santhià Santhià 38 44 33 59
7 Gallaratese Gallaratese 38 49 38 57
8 Lavagnese Lavagnese 38 49 43 57
9 Borgosesia Borgosesia 38 46 43 57
10 Acqui Acqui 38 37 38 53
11 Sarzanese Sarzanese 38 44 43 52
12 Chiavari Caperana Chiavari 38 54 62 51
13 Chieri Chieri 38 52 52 50
14 Novese Novese 38 48 50 48
15 Derthona Derthona 38 54 51 46
16 ACD Rivoli ACD Rivoli 38 42 63 44
17 Albese Calcio Albese 38 40 52 38
18 Pro Vigevano Suardese Vigevano 38 40 76 29
19 Borgorosso Arenzano Borgorosso 38 25 64 25
20 Settimo Milanese Settimo 38 24 69 17
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Savona Savona 34 84 23 85
2 Virtus Entella Virtus 34 55 20 67
3 Casale Casale 34 53 29 67
4 Albese Calcio Albese 34 51 37 56
5 Sarzanese Sarzanese 34 43 28 54
6 Acqui Acqui 34 39 34 49
7 Lavagnese Lavagnese 34 47 34 48
8 Borgorosso Arenzano Borgorosso 34 55 56 45
9 Settimo Milanese Settimo 34 42 49 45
10 Aquanera Aquanera 34 49 61 44
11 Cuneo Cuneo 34 37 34 42
12 Chieri Chieri 34 47 50 39
13 Pro Vigevano Suardese Vigevano 34 36 49 39
14 ACD Rivoli ACD Rivoli 34 44 59 37
15 ASD Pro Settimo Settimo 34 36 56 33
16 Derthona Derthona 34 34 54 28
17 Sestrese Calcio Sestrese 34 27 59 27
18 Vallée dAoste Vallée 34 27 74 17
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Biellese Biellese 34 67 26 78
2 Spezia Spezia 34 55 25 72
3 Casale Casale 34 57 37 60
4 Sarzanese Sarzanese 34 40 24 59
5 ASD Pro Settimo Settimo 34 46 37 56
6 Albese Calcio Albese 33 44 37 54
7 Derthona Derthona 34 39 40 51
8 Savona Savona 34 42 33 50
9 Virtus Entella Virtus 34 41 33 46
10 Cuneo Cuneo 33 26 24 44
11 Lavagnese Lavagnese 34 33 33 44
12 ACD Rivoli ACD Rivoli 34 37 42 40
13 USD Rivarolese 1906 Rivarolese 34 41 45 39
14 Sestri Levante Sestri 34 33 48 34
15 Vallée dAoste Vallée 35 36 45 33
16 FCD Lottogiaveno Lottogiaveno 34 27 43 29
17 Sestrese Calcio Sestrese 34 34 58 29
18 USD Ciriè Calcio Ciriè 34 28 54 29
19 Novese Novese 35 21 63 26

  USO DE MEMORIA  
5,789,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4010
Total Execution Time  0.4030
  CADENA URL  
/serie_d2014/grupo1/historico
  GET DATOS  
$_GET['/serie_d2014/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0301  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'serie_d' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2014 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0150  SELECT id,name,alias,stepParent FROM categories WHERE parentId=222 ORDER BY order_id ASC
0.0154  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 = 24665 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0158  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 222 AND group_code = 1 and tables = 1 AND year <= 2014 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0160  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 `tables2014` 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 = 24665 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 2087 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 1691 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 24694 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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 = 24709 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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 = 24718 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 11:54:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0152  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-03 11:54:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0152  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-03 11:54:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-03 11:54:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  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 events2014 e ON e.player_id = p.id AND e.league_id = 24665 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 24665 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.0147  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 events2014 e ON e.player_id = p.id AND e.league_id = 24665 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 24665 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0150  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 events2014 e ON e.player_id = p.id AND e.league_id = 24665 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 24665 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0168  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` 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 = 24665 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC