4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Virtus Bolzano

Virtus Bolzano

Entrenador: Alfredo Sebastiani

Temporada 2023/2024
TEMPORADA 2023/2024
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Clodiense Clodiense 32 46 16 76
2 Dolomiti Bellunesi Dolomiti 32 54 24 62
3 Treviso Treviso 32 49 34 57
4 Bassano Virtus Bassano 32 33 26 53
5 AC Este AC Este 32 41 31 48
6 Adriese Adriese 32 49 36 47
7 Campodarsego Campodarsego 32 38 25 47
8 Mestre Mestre 32 31 34 46
9 Montecchio Maggiore Montecchio 32 45 40 45
10 Calcio Portogruaro-Summaga Calcio 32 43 42 45
11 Montebelluna Montebelluna 32 32 37 42
12 Chions Chions 32 38 45 40
13 Luparense Luparense 32 36 39 36
14 US Breno US Breno 32 35 47 34
15 Atletico Castegnato Atletico 32 36 51 33
16 Cjarlins Muzane Cjarlins 32 27 34 32
17 Virtus Bolzano Virtus 32 22 51 20
18 Mori Santo Stefano Mori Santo. 32 22 65 15
TEMPORADA 2022/2023
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Legnago Salus Legnago 34 48 26 60
2 Clodiense Clodiense 34 46 31 58
3 Adriese Adriese 34 54 38 56
4 Campodarsego Campodarsego 34 50 40 54
5 Luparense Luparense 34 49 34 53
6 Virtus Bolzano Virtus 34 53 43 53
7 AC Este AC Este 34 47 39 50
8 Cjarlins Muzane Cjarlins 34 38 36 48
9 Caldiero Terme Caldiero 34 42 41 48
10 Cartigliano Cartigliano 34 47 50 46
11 Mestre Mestre 34 46 42 43
12 Dolomiti Bellunesi Dolomiti 34 42 47 43
13 Montecchio Maggiore Montecchio 34 50 55 39
14 ASD Torviscosa Torviscosa 34 31 46 36
15 Calcio Portogruaro-Summaga Calcio 34 36 56 35
16 Villafranca Villafranca 34 35 46 34
17 Montebelluna Montebelluna 34 35 61 31
18 Levico Levico 34 23 41 29
TEMPORADA 2020/2021
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Trento Trento 38 65 35 81
2 Arzignano Valchiampo Arzignano 38 52 34 67
3 Manzanese Manzanese 38 64 44 66
4 Clodiense Clodiense 38 51 41 62
5 Caldiero Terme Caldiero 38 56 36 61
6 Mestre Mestre 38 58 49 60
7 Delta Porto Tolle Delta Porto 38 51 38 58
8 Luparense Luparense 38 52 48 54
9 Belluno Belluno 38 43 45 53
10 Cjarlins Muzane Cjarlins 38 60 60 52
11 Cartigliano Cartigliano 38 42 45 52
12 Union San Giorgio Sedico Union 38 48 48 49
13 Adriese Adriese 38 55 64 49
14 Ambrosiana Ambrosiana 38 57 64 47
15 AC Este AC Este 38 45 53 43
16 Campodarsego Campodarsego 38 41 48 40
17 Union Feltre Union Feltre 38 41 59 39
18 Virtus Bolzano Virtus 38 46 52 38
19 Montebelluna Montebelluna 38 41 67 38
20 Chions Chions 38 30 68 21
TEMPORADA 2019/2020
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 Pro Sesto Pro Sesto 27 46 29 56
2 AC Legnano AC Legnano 27 39 25 50
3 Scanzorosciate Scanzoroscia 27 32 21 46
4 Arconatese Arconatese 27 42 36 44
5 Folgore Caratese Folgore 27 31 24 43
6 Nibionnoggiono Nibionnoggio 27 38 25 42
7 Tritium Tritium 27 39 32 42
8 Sondrio Sondrio 27 31 29 41
9 Seregno Seregno 27 32 25 39
10 Calcio Brusaporto Calcio 27 27 24 39
11 Virtus Bergamo Virtus 27 34 35 35
12 Castellanzese Castellanzes 27 39 41 35
13 Virtus Bolzano Virtus 27 35 34 34
14 US Ponte San Pietro Ponte Pietro 27 29 31 33
15 Caravaggio Caravaggio 27 41 43 32
16 Villa Valle Villa Valle 27 33 43 29
17 Levico Levico 27 32 43 27
18 Bustese Milano City FC Bustese 27 21 35 23
19 Dro Calcio Dro Calcio 27 17 37 17
20 Inveruno Inveruno 27 31 57 17
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

  USO DE MEMORIA  
5,648,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.5093
Total Execution Time  0.5108
  CADENA URL  
/historico/Virtus-Bolzano
  GET DATOS  
$_GET['/historico/Virtus-Bolzano']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0139  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 = 'Virtus-Bolzano' 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.0126  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=89868 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=89868 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=89868 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=89868 AND type_rel = 2
0.0143  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 = '89868' ORDER BY l.year DESC,cat.coefficient DESC
0.0133  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 = '89868' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '89868' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = 73981 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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=89868 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 (73981,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.0136  SELECT count(id) as num_players from rel_players WHERE league_id = 73981 AND teamId = 89868
0.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 89868
0.0252  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 = 73981 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0135  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 = '89868' 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 = '89868' and rp.type = 4
0.0140  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 = '89868' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0265  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 = 73981 WHERE rp.league_id = 73981 AND rp.teamId = 89868 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.0161  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 = 73981 WHERE rp.league_id = 73981 AND rp.teamId = 89868 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 = 73981 WHERE rp.league_id = 73981 AND rp.teamId = 89868 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 89868 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73981 AND t.round = 33 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 `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 = 68749 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.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 `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 = 58828 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.0167  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 = 51157 AND t.round = 27 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 `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.0126  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73981 ORDER BY nameShow LIMIT 100