4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Virtus Ciserano Bergamo
TEMPORADA 2023/2024
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 Caldiero Terme Caldiero 36 48 28 71
2 Piacenza Piacenza 36 64 31 70
3 Desenzano Calvina Desenzano 36 47 25 68
4 Pro Palazzolo Palazzolo 36 44 24 67
5 Varesina Varesina 36 69 46 64
6 Arconatese Arconatese 36 53 37 64
7 Calcio Brusaporto Calcio 36 51 49 53
8 Casatese Casatese 36 52 49 51
9 Villa Valle Villa Valle 36 45 38 50
10 Folgore Caratese Folgore 36 44 44 50
11 FC Clivense SM Clivense 36 36 42 50
12 Virtus Ciserano Bergamo Virtus 36 46 52 45
13 Club Milano Club Milano 36 40 43 43
14 Caravaggio Caravaggio 36 42 49 43
15 Real Calepina Real 36 35 44 41
16 Castellanzese Castellanzes 36 32 46 38
17 AC Legnano AC Legnano 36 28 48 36
18 Crema Crema 36 23 48 30
19 Tritium Tritium 36 24 52 28
20 US Ponte San Pietro Ponte Pietro 36 29 57 24
TEMPORADA 2022/2023
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 Lumezzane Lumezzane 34 67 20 77
2 Alcione Alcione 34 67 31 71
3 Casatese Casatese 34 38 26 59
4 Arconatese Arconatese 34 54 37 57
5 Desenzano Calvina Desenzano 34 47 41 53
6 Franciacorta Franciacorta 34 44 43 50
7 US Ponte San Pietro Ponte Pietro 34 47 38 49
8 Virtus Ciserano Bergamo Virtus 34 42 40 48
9 Calcio Brusaporto Calcio 34 43 38 47
10 Varesina Varesina 34 47 50 46
11 Villa Valle Villa Valle 34 40 47 41
12 Real Calepina Real 34 30 33 39
13 Folgore Caratese Folgore 34 37 46 39
14 Seregno Seregno 34 42 56 38
15 US Breno US Breno 34 35 50 37
16 Città di Varese Città 34 30 46 33
17 Sona Calcio Sona Calcio 34 28 56 27
18 Caronnese Caronnese 34 24 64 15
TEMPORADA 2021/2022
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 Sangiuliano City Nova Sangiuliano 38 81 39 82
2 AC Legnano AC Legnano 38 49 44 66
3 Casatese Casatese 38 70 44 64
4 Calcio Brusaporto Calcio 38 62 49 64
5 Folgore Caratese Folgore 38 57 46 63
6 Desenzano Calvina Desenzano 38 65 49 63
7 US Breno US Breno 38 56 43 58
8 Virtus Ciserano Bergamo Virtus 38 66 56 58
9 Arconatese Arconatese 38 62 58 57
10 Franciacorta Franciacorta 38 73 80 52
11 Crema Crema 38 44 52 46
12 Castellanzese Castellanzes 38 50 55 46
13 Sona Calcio Sona Calcio 38 43 56 45
14 US Ponte San Pietro Ponte Pietro 38 54 56 44
15 Real Calepina Real 38 38 39 44
16 Villa Valle Villa Valle 38 49 56 39
17 Caravaggio Caravaggio 38 41 62 37
18 Vis Nova Giussano Nova 38 56 77 35
19 Olginatese Olginatese 38 43 60 35
20 AC Leon AC Leon 38 50 88 33
TEMPORADA 2020/2021
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 Seregno Seregno 34 54 36 69
2 Fanfulla Fanfulla 34 60 36 64
3 Casatese Casatese 34 53 41 55
4 Nibionnoggiono Nibionnoggio 34 48 38 55
5 Crema Crema 34 62 51 53
6 Desenzano Calvina Desenzano 34 49 52 52
7 US Breno US Breno 34 44 35 49
8 Calcio Brusaporto Calcio 34 52 53 49
9 Franciacorta Franciacorta 34 47 37 48
10 Sona Calcio Sona Calcio 34 49 52 46
11 Real Calepina Real 34 36 42 43
12 Virtus Ciserano Bergamo Virtus 34 41 42 42
13 US Ponte San Pietro Ponte Pietro 34 37 41 41
14 Vis Nova Giussano Nova 34 43 62 39
15 Villa Valle Villa Valle 34 51 60 38
16 Caravaggio Caravaggio 34 48 61 38
17 Tritium Tritium 34 41 52 35
18 Scanzorosciate Scanzoroscia 34 28 52 26

  USO DE MEMORIA  
5,513,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1039
Total Execution Time  0.1053
  CADENA URL  
/historico/Ssd-Virtus-Ciserano-Bergamo
  GET DATOS  
$_GET['/historico/Ssd-Virtus-Ciserano-Bergamo']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0030  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 = 'Ssd-Virtus-Ciserano-Bergamo' 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.0018  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=121937 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=121937 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=121937 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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 = 73980
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=121937 AND type_rel = 2
0.0023  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 = '121937' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '121937' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '121937' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0028  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=121937 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73980,73559) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 73980 AND teamId = 121937
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 121937
0.0021  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 = '121937' 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 = '121937' and rp.type = 4
0.0021  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 = '121937' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0064  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 events2024 e ON e.player_id = p.id AND e.league_id = 73980 WHERE rp.league_id = 73980 AND rp.teamId = 121937 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.0054  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 events2024 e ON e.player_id = p.id AND e.league_id = 73980 WHERE rp.league_id = 73980 AND rp.teamId = 121937 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 events2024 e ON e.player_id = p.id AND e.league_id = 73980 WHERE rp.league_id = 73980 AND rp.teamId = 121937 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 121937 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0028  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 `tables2024` 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 = 73980 AND t.round = 37 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 `tables2022` 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 = 64276 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 `tables2021` 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 = 58827 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC