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,556,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.3601
Total Execution Time  0.3612
  CADENA URL  
/historico/Ssd-Virtus-Ciserano-Bergamo
  GET DATOS  
$_GET['/historico/Ssd-Virtus-Ciserano-Bergamo']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=121937 AND type_rel = 2
0.0131  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.0127  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 = 73980 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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.0128  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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 73980 AND teamId = 121937
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 121937
0.0254  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0134  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.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '121937' and rp.type = 4
0.0136  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.0199  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.0186  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.0143  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.0129  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.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 `tables2023` 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 = 68748 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
0.0131  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.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 `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