4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Cuneo Cuneo 34 49 28 66
2 Varese Varese 34 48 29 63
3 Borgosesia Borgosesia 34 49 22 62
4 Gozzano Gozzano 34 58 37 59
5 Inveruno Inveruno 34 71 51 59
6 Caronnese Caronnese 34 55 38 59
7 Chieri Chieri 34 65 47 55
8 Pro Sesto Pro Sesto 34 42 35 54
9 Casale Casale 34 39 40 48
10 AS Bra AS Bra 34 43 42 41
11 Folgore Caratese Folgore 34 45 47 41
12 Voghera Voghera 34 42 57 38
13 Varesina Varesina 34 39 61 34
14 Bustese Milano City FC Bustese 34 37 54 31
15 AC Legnano AC Legnano 34 34 61 31
16 Verbania Verbania 34 36 56 30
17 Pinerolo Pinerolo 34 38 61 28
18 ASD Pro Settimo Settimo 34 28 52 26
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Bellinzago Bellinzago 38 74 31 86
2 Caronnese Caronnese 38 74 23 82
3 Lavagnese Lavagnese 38 66 30 74
4 Chieri Chieri 38 74 41 72
5 Argentina SSD Argentina 38 48 25 66
6 Sestri Levante Sestri 38 41 23 62
7 Gozzano Gozzano 38 64 38 61
8 Pinerolo Pinerolo 38 50 47 61
9 Rapallo Boglia.. Rapallo 38 51 40 57
10 Voghera Voghera 38 53 44 53
11 Derthona Derthona 38 52 48 52
12 AS Bra AS Bra 38 53 55 51
13 Borgosesia Borgosesia 38 40 46 47
14 ASD Pro Settimo Settimo 38 35 45 43
15 Vado FC Vado FC 38 43 61 40
16 Ligorna Ligorna 38 45 73 40
17 Fezzanese Fezzanese 38 38 74 34
18 Acqui Acqui 38 30 70 28
19 Castellazzo Castellazzo 38 29 73 22
20 Novese Novese 38 26 99 19
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Cuneo Cuneo 38 63 30 79
2 Sestri Levante Sestri 38 47 25 75
3 Chieri Chieri 38 60 36 74
4 Borgosesia Borgosesia 38 72 47 70
5 Caronnese Caronnese 38 60 35 68
6 ASD Pro Settimo Settimo 38 56 41 66
7 AS Bra AS Bra 38 66 51 62
8 Voghera Voghera 38 59 50 61
9 Lavagnese Lavagnese 38 50 43 58
10 Acqui Acqui 38 53 49 54
11 Novese Novese 38 46 47 48
12 Bellinzago Bellinzago 38 55 61 48
13 Argentina SSD Argentina 38 60 68 47
14 Vado Vado 38 54 62 47
15 Asti FC Asti FC 38 41 49 47
16 Rapallo Boglia.. Rapallo 38 46 57 42
17 Sancolombano Sancolombano 38 31 46 36
18 Derthona Derthona 38 29 62 24
19 Vallée dAoste Vallée 38 38 73 24
20 Borgomanero ASD Borgomanero 38 30 84 17
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  
6,439,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4986
Total Execution Time  0.5005
  CADENA URL  
/serie_d2017/grupo1/historico
  GET DATOS  
$_GET['/serie_d2017/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0128  SELECT type FROM routes WHERE alias = 'serie_d2017'
0.0253  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 = 2017 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=222 AND type_rel = 3
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 222 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  SELECT /*53 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 (1244039,1222208,1221521,1177309,1176862) ORDER BY n.cover_points DESC, update_date DESC
0.0127  SELECT id,name,alias,stepParent FROM categories WHERE parentId=222 ORDER BY order_id ASC
0.0131  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 = 33449 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0137  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 222 AND group_code = 1 and tables = 1 AND year <= 2017 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0151  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 = 33449 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 15649 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 4814 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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.0133  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.0134  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.0136  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.0135  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.0139  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.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 21:16:32' 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-05-01 21:16:32' 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=4 AND last_update > '2024-05-01 21:16:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 21:16:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0138  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 = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2017 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0294  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 events2017 e ON e.player_id = p.id AND e.league_id = 33449 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 33449 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.0284  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 events2017 e ON e.player_id = p.id AND e.league_id = 33449 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 33449 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0140  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 events2017 e ON e.player_id = p.id AND e.league_id = 33449 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 33449 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0139  SELECT *,(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 = 33449 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC