4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Pol. Ciliverghe
TEMPORADA 2019/2020
SERIE D GRUPO 4
Equipo PJ GF GC Puntos
1 Mantova Mantova 24 59 31 51
2 Fiorenzuola Fiorenzuola 24 36 27 44
3 Correggese Correggese 25 42 31 41
4 Calvina Calvina 25 40 32 41
5 Lentigione Lentigione 24 39 31 40
6 Fanfulla Fanfulla 24 38 31 40
7 Mezzolara Mezzolara 25 34 33 36
8 Forli Forli 24 26 26 32
9 Franciacorta Franciacorta 24 41 44 31
10 Breno Futura Breno Futura 24 32 28 30
11 Sasso Marconi Sasso 25 41 43 29
12 Vigor Carpaneto Vigor 24 33 38 29
13 Progresso Progresso 24 24 33 29
14 Sammaurese Sammaurese 25 33 38 26
15 Crema Crema 24 27 34 25
16 Pol. Ciliverghe Pol. 25 28 41 25
17 Alfonsine FC 1921 Alfonsine 25 15 33 22
18 Savignanese Savignanese 25 24 38 21
TEMPORADA 2018/2019
SERIE D GRUPO 4
Equipo PJ GF GC Puntos
1 Modena Modena 34 60 27 73
2 Pergolettese Pergolettese 34 62 32 73
3 Reggiana Reggiana 34 57 28 66
4 Fanfulla Fanfulla 34 58 52 57
5 Fiorenzuola Fiorenzuola 34 52 31 56
6 Crema Crema 34 52 50 49
7 Vigor Carpaneto Vigor 34 42 35 47
8 Franciacorta Franciacorta 34 45 45 47
9 Axys Zola Axys Zola 34 40 45 41
10 Pol. Ciliverghe Pol. 34 38 48 41
11 Lentigione Lentigione 34 34 36 39
12 Calvina Calvina 34 40 51 39
13 Pavia Pavia 34 32 46 36
14 Mezzolara Mezzolara 34 39 50 35
15 Sasso Marconi Sasso 34 31 50 34
16 San Marino Calcio Marino 34 24 32 31
17 Classe Classe 34 25 51 30
18 OltrepòVoghera OltrepòVogh 34 22 44 23
TEMPORADA 2017/2018
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 Pro Patria Pro Patria 36 58 22 79
2 Rezzato Rezzato 36 84 35 78
3 Pontisola Pontisola 36 67 44 70
4 Pergolettese Pergolettese 36 57 37 67
5 Darfo Boario Darfo Boario 36 51 30 62
6 Virtus Bergamo Virtus 36 57 46 58
7 Lecco Lecco 36 46 35 58
8 Crema Crema 36 43 40 48
9 Bustese Milano City FC Bustese 36 44 43 47
10 Caravaggio Caravaggio 36 47 52 47
11 Pol. Ciliverghe Pol. 36 47 46 45
12 Levico Levico 36 45 56 44
13 Scanzorosciate Scanzoroscia 36 41 51 43
14 Trento Trento 36 42 64 43
15 Lumezzane Lumezzane 36 37 51 42
16 Ciserano Ciserano 36 42 58 36
17 Grumellese Grumellese 36 34 55 34
18 Dro Calcio Dro Calcio 36 33 62 31
19 Romanese Romanese 36 30 78 11
TEMPORADA 2016/2017
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 AC Monza AC Monza 34 70 17 80
2 Pol. Ciliverghe Pol. 34 75 45 73
3 Pergolettese Pergolettese 34 58 38 65
4 Virtus Bergamo Virtus 34 57 34 63
5 Pro Patria Pro Patria 34 50 34 62
6 Pontisola Pontisola 34 59 37 59
7 Darfo Boario Darfo Boario 34 46 38 54
8 Caravaggio Caravaggio 34 45 48 47
9 Seregno Seregno 34 51 49 45
10 Grumellese Grumellese 34 37 51 42
11 Ciserano Ciserano 34 44 54 40
12 Dro Calcio Dro Calcio 34 33 48 36
13 Olginatese Olginatese 34 39 56 36
14 Scanzorosciate Scanzoroscia 34 30 61 34
15 Levico Levico 34 42 53 31
16 Lecco Lecco 34 31 64 31
17 Virtus Bolzano Virtus 34 31 54 29
18 Fanfulla Fanfulla 34 38 55 27
TEMPORADA 2015/2016
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 Piacenza Piacenza 38 85 27 96
2 Lecco Lecco 38 83 41 80
3 Seregno Seregno 38 63 47 64
4 Pontisola Pontisola 38 63 48 61
5 Pol. Ciliverghe Pol. 38 48 49 61
6 Olginatese Olginatese 38 57 50 56
7 Inveruno Inveruno 38 65 57 53
8 Ciserano Ciserano 38 48 55 53
9 Folgore Caratese Folgore 38 52 48 50
10 AC Monza AC Monza 38 52 49 49
11 Grumellese Grumellese 38 49 53 48
12 Pro Sesto Pro Sesto 38 50 51 47
13 Varesina Varesina 38 42 49 47
14 Pergolettese Pergolettese 38 38 42 46
15 Bustese Milano City FC Bustese 38 47 58 45
16 Virtus Bergamo Virtus 38 44 61 45
17 Caravaggio Caravaggio 38 35 56 34
18 Fiorenzuola Fiorenzuola 38 28 51 33
19 MapelloBonate MapelloBonat 38 36 59 31
20 Sondrio Sondrio 38 39 73 27
TEMPORADA 2014/2015
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 Castiglione Castiglione 36 54 26 74
2 Lecco Lecco 36 65 42 66
3 Seregno Seregno 36 64 37 65
4 Ciserano Ciserano 36 53 39 60
5 Virtus Verona Virtus 36 58 34 59
6 Pergolettese Pergolettese 36 46 44 55
7 Olginatese Olginatese 36 44 34 54
8 Pontisola Pontisola 36 50 42 52
9 Pol. Ciliverghe Pol. 36 37 40 51
10 Sondrio Sondrio 36 46 50 51
11 Aurora Seriate Aurora 36 42 43 50
12 Inveruno Inveruno 36 47 48 49
13 Pro Sesto Pro Sesto 36 38 41 47
14 Villafranca Villafranca 36 44 49 47
15 MapelloBonate MapelloBonat 36 36 48 47
16 Caravaggio Caravaggio 36 37 42 41
17 Folgore Caratese Folgore 36 34 40 37
18 AC Castellana Castellana 36 36 61 30
19 AC Montichiari Montichiari 36 26 97 5

  USO DE MEMORIA  
5,786,816 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1578
Total Execution Time  0.1592
  CADENA URL  
/historico/Polisportiva-Ciliverghe
  GET DATOS  
$_GET['/historico/Polisportiva-Ciliverghe']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0035  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Polisportiva-Ciliverghe' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0076  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Polisportiva-Ciliverghe' ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=24956 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=24956 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=24956 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=24956 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=24956 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=24956 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=24956 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=24956 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=24956 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=24956 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=24956 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=24956 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=24956 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=24956 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=24956 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0031  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 51159
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=24956 AND type_rel = 2
0.0038  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '24956' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0035  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '24956' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0053  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '24956' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0031  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 51159 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0042  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=24956 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0027  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (51159,51105) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0047  SELECT count(id) as num_players from rel_players WHERE league_id = 51159 AND teamId = 24956
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 51105 AND teamId = 24956
0.0051  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2020` 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 = 51159 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '24956' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '24956' and rp.type = 4
0.0025  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '24956' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0044  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 51159 WHERE rp.league_id = 51159 AND rp.teamId = 24956 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 51159 WHERE rp.league_id = 51159 AND rp.teamId = 24956 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 51159 WHERE rp.league_id = 51159 AND rp.teamId = 24956 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 24956 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  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 `tables2020` 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 = 51159 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 44799 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 39596 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 33450 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 15650 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 4815 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC