4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Dro Calcio
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 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 3
Equipo PJ GF GC Puntos
1 Venezia Venezia 38 89 26 90
2 Campodarsego Campodarsego 38 56 31 79
3 AC Este AC Este 38 61 23 76
4 Belluno Belluno 38 52 38 67
5 Virtus Verona Virtus 38 67 37 63
6 Luparense Luparense 38 65 57 58
7 Tamai Tamai 38 45 43 53
8 Mestre Mestre 38 71 54 51
9 Abano Terme Abano Terme 38 50 47 49
10 Levico Levico 38 54 53 48
11 Calvi Noale Calvi Noale 38 40 43 48
12 Dro Calcio Dro Calcio 38 35 53 48
13 Union Ripa Fenadora Union Ripa. 38 50 56 45
14 Fincantieri Monfalcone Fincantieri 38 47 57 43
15 Montebelluna Montebelluna 38 50 62 43
16 Liventina Liventina 38 45 62 39
17 Triestina Triestina 38 40 57 39
18 Fontanafredda Fontanafredd 38 44 62 39
19 Giorgione Giorgione 38 42 74 38
20 Sacilese Sacilese 38 26 94 13
TEMPORADA 2014/2015
SERIE D GRUPO 10
Equipo PJ GF GC Puntos
1 Triestina Triestina 1 3 1 3
2 VF Colligiana Colligiana 1 2 0 3
3 AC Isola Liri Isola Liri 1 3 2 3
4 Battipagliese Battipaglies 1 2 1 3
5 Giorgione Giorgione 1 2 1 3
6 Romagna Centro Romagna 1 2 1 3
7 Noto Noto 1 1 0 3
8 Pomigliano Pomigliano 1 1 0 3
9 Pro Sesto Pro Sesto 1 1 0 3
10 Amiternina Amiternina 1 1 1 1
11 Castelfidardo Calcio Castelfidard 1 1 1 1
12 Palestrina Palestrina 1 2 3 0
13 Fidenza Fidenza 1 1 2 0
14 Nk Kras Asd Nk Kras Asd 1 1 2 0
15 Sorrento Sorrento 1 1 2 0
16 Arzanese Arzanese 1 0 1 0
17 Caravaggio Caravaggio 1 0 1 0
18 Tiger Brolo Tiger Brolo 1 0 1 0
19 Dro Calcio Dro Calcio 1 1 3 0
20 San Donato Tavarnelle Donato 1 0 2 0
TEMPORADA 2013/2014
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Pordenone Pordenone 34 77 20 85
2 Marano Marano 34 72 24 83
3 Sacilese Sacilese 34 55 28 66
4 Belluno Belluno 34 54 43 59
5 Luparense Luparense 34 45 51 50
6 Union Ripa Fenadora Union Ripa. 34 59 49 49
7 AC Este AC Este 34 53 43 48
8 Montebelluna Montebelluna 34 45 46 48
9 ACD Trissino Trissino 34 47 49 43
10 Triestina Triestina 34 48 45 42
11 Giorgione Giorgione 34 36 35 39
12 Tamai Tamai 34 42 56 39
13 Vittorio Falmec Vittorio 34 42 59 38
14 Fincantieri Monfalcone Fincantieri 34 37 52 34
15 AC Mezzocorona Mezzocorona 34 35 56 33
16 Dro Calcio Dro Calcio 34 34 66 31
17 Sanvitese Sanvitese 34 37 55 30
18 Fersina Perginese Fersina 34 26 67 17

  USO DE MEMORIA  
5,763,552 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1584
Total Execution Time  0.1599
  CADENA URL  
/historico/Dro-Calcio
  GET DATOS  
$_GET['/historico/Dro-Calcio']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0024  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 = 'Dro-Calcio' 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.0031  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 = 'Dro-Calcio' 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=24962 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=24962 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=24962 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=24962 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=24962 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=24962 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=24962 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=24962 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=24962 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=24962 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=24962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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 = 51157
0.0023  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 = 51105
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=24962 AND type_rel = 2
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 = '24962' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '24962' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '24962' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = '24962' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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 = 51105 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 51157 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=24962 AND l.year in (2019,2020,2021) 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 (51157,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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 51157 AND teamId = 24962
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 51105 AND teamId = 24962
0.0026  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 = 51157 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '24962' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '24962' and rp.type = 4
0.0020  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 = '24962' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 51157 WHERE rp.league_id = 51157 AND rp.teamId = 24962 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.0020  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 = 51157 WHERE rp.league_id = 51157 AND rp.teamId = 24962 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 51157 WHERE rp.league_id = 51157 AND rp.teamId = 24962 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 24962 AND l.year <= 2020 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 `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.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.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 `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 = 15651 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 = 4816 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 14783 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC