4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Campodarsego
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 2021/2022
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Arzignano Valchiampo Arzignano 34 74 32 73
2 Clodiense Clodiense 34 53 22 72
3 Adriese Adriese 34 61 36 66
4 Luparense Luparense 34 60 35 58
5 Campodarsego Campodarsego 34 48 37 56
6 Caldiero Terme Caldiero 34 58 50 51
7 Dolomiti Bellunesi Dolomiti 34 51 50 50
8 Montebelluna Montebelluna 34 57 52 49
9 Mestre Mestre 34 36 45 46
10 Cjarlins Muzane Cjarlins 34 51 43 45
11 Cartigliano Cartigliano 34 44 40 45
12 AC Este AC Este 34 31 42 43
13 Levico Levico 34 31 40 42
14 Ambrosiana Ambrosiana 34 45 52 40
15 Delta Porto Tolle Delta Porto 34 43 51 36
16 Spinea Spinea 34 27 58 25
17 Cattolica Cattolica 34 20 61 23
18 ACD San Martino Martino 34 29 73 20
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 3
Equipo PJ GF GC Puntos
1 Campodarsego Campodarsego 27 44 25 54
2 Legnago Salus Legnago 28 43 32 49
3 Ambrosiana Ambrosiana 28 47 31 48
4 Clodiense Clodiense 27 44 32 47
5 Mestre Mestre 27 37 28 45
6 Adriese Adriese 27 53 36 44
7 Union Feltre Union Feltre 27 38 25 44
8 Cartigliano Cartigliano 28 46 37 42
9 Cjarlins Muzane Cjarlins 28 44 47 42
10 Luparense Luparense 27 49 45 37
11 Caldiero Terme Caldiero 27 25 28 37
12 AC Este AC Este 27 37 35 36
13 Chions Chions 28 39 41 35
14 Belluno Belluno 27 33 38 34
15 Delta Porto Tolle Delta Porto 27 31 38 31
16 Montebelluna Montebelluna 27 26 35 30
17 Vigasio Vigasio 27 28 42 30
18 Tamai Tamai 27 22 45 22
19 San Luigi San Luigi 28 36 64 21
20 Villafranca Villafranca 27 25 43 17
TEMPORADA 2018/2019
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Arzignano Valchiampo Arzignano 34 63 35 70
2 Adriese Adriese 34 70 37 68
3 Union Feltre Union Feltre 34 51 28 64
4 Campodarsego Campodarsego 34 55 40 60
5 Delta Porto Tolle Delta Porto 34 48 42 49
6 Virtus Don Bosco Virtus Bosco 34 46 43 49
7 Cjarlins Muzane Cjarlins 34 63 55 46
8 Montebelluna Montebelluna 34 37 44 45
9 AC Este AC Este 34 44 47 41
10 Cartigliano Cartigliano 34 37 46 41
11 Chions Chions 34 37 42 40
12 Clodiense Clodiense 34 41 46 39
13 Belluno Belluno 34 33 37 38
14 Tamai Tamai 34 35 48 38
15 Levico Levico 34 34 47 37
16 St. Georgen St. Georgen 34 30 59 36
17 Sandonà Sandonà 34 37 40 35
18 Trento Trento 34 28 53 26
TEMPORADA 2017/2018
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Virtus Verona Virtus 34 60 33 73
2 Campodarsego Campodarsego 34 73 43 68
3 Arzignano Valchiampo Arzignano 34 75 42 67
4 Mantova Mantova 34 56 34 60
5 Adriese Adriese 34 56 31 56
6 AC Este AC Este 34 49 29 56
7 Belluno Belluno 34 62 50 51
8 Legnago Salus Legnago 34 53 47 49
9 Union Feltre Union Feltre 34 49 56 49
10 Rovigo Calcio Rovigo 34 47 50 47
11 Cjarlins Muzane Cjarlins 34 51 49 44
12 Clodiense Clodiense 34 44 60 41
13 Tamai Tamai 34 50 51 40
14 Ambrosiana Ambrosiana 34 51 64 40
15 Montebelluna Montebelluna 34 34 50 32
16 Calvi Noale Calvi Noale 34 32 67 28
17 Liventina Liventina 34 33 64 25
18 Abano Terme Abano Terme 34 25 80 16
TEMPORADA 2016/2017
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Mestre Mestre 34 73 34 80
2 Triestina Triestina 34 63 33 72
3 Campodarsego Campodarsego 34 55 42 60
4 Virtus Verona Virtus 34 42 30 53
5 Abano Terme Abano Terme 34 46 38 53
6 Belluno Belluno 34 40 36 50
7 Arzignano Valchiampo Arzignano 34 43 34 49
8 Montebelluna Montebelluna 34 46 54 44
9 AC Este AC Este 34 33 33 43
10 Union Feltre Union Feltre 34 35 37 43
11 Legnago Salus Legnago 34 46 43 41
12 Calvi Noale Calvi Noale 34 44 45 40
13 Alto Vicentino Alto 34 45 55 40
14 Tamai Tamai 34 33 45 40
15 ASD Cordenons Cordenons 34 44 56 39
16 Vigasio Vigasio 34 42 61 38
17 Vigontina Vigontina 34 42 62 25
18 Eclisse Carenipievigina Eclisse 34 29 63 23
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

  USO DE MEMORIA  
6,433,640 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1528
Total Execution Time  0.1540
  CADENA URL  
/historico/Campodarsego
  GET DATOS  
$_GET['/historico/Campodarsego']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0045  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 = 'Campodarsego' 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=66508 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=66508 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=66508 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=66508 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 = 73559
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=66508 AND type_rel = 2
0.0029  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 = '66508' ORDER BY l.year DESC,cat.coefficient DESC
0.0045  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 = '66508' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0032  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 = '66508' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0039  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=66508 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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,71632,71432) 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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 73981 AND teamId = 66508
0.0051  SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 66508
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71632 AND teamId = 66508
0.0037  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 66508
0.0034  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.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 = '66508' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '66508' 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 = '66508' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0057  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 = 66508 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.0062  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 = 66508 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0046  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 = 66508 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 = 66508 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 = 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.0073  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.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 = 64277 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.0033  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.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 `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 = 51158 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 44798 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 `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 = 39597 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 33451 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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