4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Siracusa Siracusa 36 72 32 74
2 Nerostellati Frattese Nerostellati 36 70 34 71
3 Cavese 1919 Cavese 1919 36 54 36 68
4 US Vibonese Calcio Vibonese 36 49 41 54
5 Real Agro Aversa Real Agro A. 36 45 37 53
6 Reggina Reggina 36 45 40 53
7 Due Torri Due Torri 36 27 27 50
8 Roccella Roccella 36 44 50 48
9 Sarnese Sarnese 36 32 34 47
10 Rende Rende 36 37 33 46
11 Gragnano Gragnano 36 45 42 44
12 Noto Noto 36 31 32 41
13 Marsala Marsala 36 35 40 40
14 Agropoli Agropoli 36 32 44 40
15 Leonfortese Leonfortese 36 26 39 40
16 Palmese Palmese 36 37 49 36
17 Gelbison Gelbison 36 32 48 34
18 Scordia Scordia 36 32 56 31
19 Vigor Lamezia Vigor 36 24 55 31
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Akragas Akragas 34 79 29 73
2 Rende Rende 34 53 29 64
3 Agropoli Agropoli 34 66 34 62
4 Torrecuso Torrecuso 34 64 45 60
5 Turris Neapolis Turris 34 54 28 57
6 Nerostellati Frattese Nerostellati 34 64 57 54
7 Due Torri Due Torri 34 35 27 52
8 Leonfortese Leonfortese 34 45 38 52
9 Progreditur Marcianise Progreditur 34 41 44 47
10 ASD HinterReggio HinterReggio 34 50 42 46
11 Nuova Gioiese Nuova 34 46 42 44
12 Roccella Roccella 34 49 52 43
13 Noto Noto 34 36 42 40
14 Sorrento Sorrento 34 40 44 38
15 Battipagliese Battipaglies 34 39 44 37
16 Tiger Brolo Tiger Brolo 34 32 45 33
17 Montalto Comprensorio Montalto 34 50 66 29
18 Orlandina Orlandina 34 11 146 8
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 ACR Messina ACR Messina 34 59 24 77
2 Cosenza Cosenza 34 65 41 73
3 Gelbison Gelbison 34 39 28 60
4 FC Messina FC Messina 34 55 40 58
5 US Vibonese Calcio Vibonese 34 42 31 51
6 Comprensorio Normanno Comprensorio 34 40 37 50
7 FC Savoia 1908 Savoia 1908 34 54 52 48
8 Cavese 1919 Cavese 1919 34 47 38 47
9 Noto Noto 34 46 36 46
10 Licata Licata 34 50 46 46
11 Rios Renovables Ribera Nava Rios 34 39 37 46
12 Montalto Comprensorio Montalto 34 44 38 45
13 AC Palazzolo Palazzolo 34 44 45 44
14 Agropoli Agropoli 34 35 37 44
15 Ragusa Ragusa 34 38 42 39
16 ASD Sambiase Sambiase 34 42 43 38
17 Acireale Acireale 34 21 74 15
18 Nissa FC ASD Nissa 34 12 83 8
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 ASD HinterReggio HinterReggio 34 58 34 60
2 Cosenza Cosenza 34 56 35 59
3 ACR Messina ACR Messina 34 49 36 58
4 AC Palazzolo Palazzolo 34 50 30 53
5 Battipagliese Battipaglies 33 53 41 53
6 Nuvla San Felice Nuvla Felice 34 43 41 50
7 Polisportiva A… Polisportiva 34 43 45 49
8 Noto Noto 34 51 39 48
9 AC Sant Antoni… Sant 34 55 54 47
10 Licata Licata 34 50 50 47
11 Serre Alburni Serre 34 38 37 45
12 ASD Sambiase Sambiase 34 41 44 45
13 Acri Acri 33 40 42 43
14 Acireale Acireale 33 29 35 39
15 Marsala Marsala 34 34 44 38
16 Nissa FC ASD Nissa 34 30 37 36
17 Valle Grecanica Valle 33 29 46 30
18 Cittanova Interpiana Cittanova 34 20 79 20
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Bacoli Sibilla Bacoli 2 5 3 4
2 Sandonà Sandonà 1 2 2 1
3 Pontedera Pontedera 1 1 3 0
4 Vallée dAoste Vallée 1 3 2 3
5 Rimini Rimini 1 1 1 1
6 Pomigliano Pomigliano 2 3 4 1
7 Voghera Voghera 1 1 0 3
8 Sansepolcro Calcio Sansepolcro 1 3 3 1
9 Forza e Coraggio Forza 2 3 4 1
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Milazzo Milazzo 33 41 25 65
2 Trapani Trapani 33 55 27 64
3 Rosarno Rosarno 33 39 21 61
4 Avellino Avellino 33 54 31 59
5 Vigor Lamezia Vigor 33 51 32 57
6 FC Rossanese 1909 Rossanese 33 38 26 56
7 Sapri Calcio Sapri Calcio 33 43 37 50
8 Modica Modica 33 46 49 47
9 Nissa FC ASD Nissa 33 39 36 46
10 ASD Sambiase Sambiase 33 47 36 45
11 ASD HinterReggio HinterReggio 33 45 49 42
12 GSD Mazara 1946 Mazara 1946 33 31 40 41
13 AC Palazzolo Palazzolo 33 45 48 39
14 ACR Messina ACR Messina 33 39 37 38
15 Viribus Unitis Viribus 33 34 52 32
16 Castrovillari Castrovillar 33 33 58 25
17 ACRD Acicatena ACRD 33 23 57 24
18 Comprensorio Normanno Comprensorio 33 26 68 22
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Siracusa Siracusa 36 72 29 81
2 Vico Equense Vico Equense 35 53 24 63
3 Sapri Calcio Sapri Calcio 36 55 36 61
4 Nissa FC ASD Nissa 35 59 38 59
5 Comprensorio Normanno Comprensorio 36 46 35 55
6 Rosarno Rosarno 36 48 36 53
7 Viribus Unitis Viribus 36 44 43 52
8 Turris Neapolis Turris 36 47 44 51
9 ASD HinterReggio HinterReggio 36 41 37 50
10 Modica Modica 36 31 35 49
11 ACRD Acicatena ACRD 35 37 34 47
12 ACR Messina ACR Messina 36 29 34 47
13 Trapani Trapani 36 38 40 46
14 AC Palazzolo Palazzolo 36 37 47 41
15 Puteolana Puteolana 36 23 42 41
16 Castrovillari Castrovillar 36 28 41 40
17 FC Savoia 1908 Savoia 1908 36 30 53 31
18 Vittoria Vittoria 35 34 61 30
19 Castiglione Castiglione 36 25 68 20

  USO DE MEMORIA  
6,020,472 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4151
Total Execution Time  0.4170
  CADENA URL  
/serie_d2016/grupo9/historico
  GET DATOS  
$_GET['/serie_d2016/grupo9/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0262  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 = 9 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2016 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=9 DESC LIMIT 1
0.0128  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 = 15657 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 222 AND group_code = 9 and tables = 1 AND year <= 2016 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 15657 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 4822 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 24687 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 2092 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 1699 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 = 24706 AND t.round = 2 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 `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 = 24717 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 `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 = 24736 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0177  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 17:28:46' 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=2 AND last_update > '2024-05-08 17:28:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-08 17:28:46' 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=3 AND last_update > '2024-05-08 17:28:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0278  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 events2016 e ON e.player_id = p.id AND e.league_id = 15657 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 15657 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.0333  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 events2016 e ON e.player_id = p.id AND e.league_id = 15657 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 15657 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0172  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 events2016 e ON e.player_id = p.id AND e.league_id = 15657 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 15657 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0138  SELECT *,(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 = 15657 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC