4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Virtus Casarano
TEMPORADA 2023/2024
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Team Altamura Team 32 49 20 71
2 Martina Franca Martina 32 48 20 64
3 Nardò Nardò 32 46 23 59
4 Fidelis Andria Fidelis 32 55 29 58
5 Virtus Casarano Virtus 32 42 29 52
6 Matera Matera 32 42 34 51
7 Palmese Palmese 32 45 47 44
8 Gelbison Gelbison 32 38 33 42
9 Paganese Paganese 32 36 40 42
10 Gravina Gravina 32 47 42 39
11 Rotonda Rotonda 32 34 34 39
12 SS Manfredonia Calcio Manfredonia 32 28 36 39
13 Angri Angri 32 33 51 35
14 Città di Fasano Città 32 32 53 35
15 Gallipoli Gallipoli 32 25 47 31
16 Barletta Barletta 32 28 41 30
17 USD Bitonto USD Bitonto 32 19 42 27
18 Santa Maria Cilento Santa Maria 32 22 48 25
TEMPORADA 2022/2023
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Brindisi Brindisi 34 59 27 69
2 Cavese 1919 Cavese 1919 34 66 35 69
3 Nardò Nardò 34 51 26 65
4 Barletta Barletta 34 42 29 64
5 Virtus Casarano Virtus 34 46 32 57
6 Team Altamura Team 34 51 37 56
7 Matera Matera 34 53 46 50
8 Martina Franca Martina 34 40 43 45
9 Città di Fasano Città 34 43 43 44
10 USD Bitonto USD Bitonto 34 45 51 43
11 Afragolese Afragolese 34 41 45 39
12 Gladiator Gladiator 34 42 55 37
13 Nocerina Nocerina 34 40 51 36
14 Gravina Gravina 34 29 41 36
15 Molfetta Calcio Molfetta 34 40 50 32
16 FC Francavilla 1931 Francavilla 34 38 51 30
17 Lavello Lavello 34 31 68 26
18 Puteolana Puteolana 34 32 59 19
TEMPORADA 2021/2022
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Audace Cerignola Audace 38 83 27 88
2 FC Francavilla 1931 Francavilla 38 62 44 71
3 USD Bitonto USD Bitonto 38 56 40 65
4 Città di Fasano Città 38 63 50 62
5 Nocerina Nocerina 38 55 48 58
6 Gravina Gravina 38 51 49 56
7 Casertana Casertana 38 56 52 55
8 Sorrento Sorrento 38 41 50 52
9 Nola 1925 Nola 1925 38 50 58 51
10 Brindisi Brindisi 38 42 55 49
11 Molfetta Calcio Molfetta 38 48 45 48
12 Team Altamura Team 38 48 45 47
13 Mariglianese Mariglianese 38 43 46 47
14 Virtus Casarano Virtus 38 37 49 47
15 Lavello Lavello 38 49 56 45
16 Nardò Nardò 38 59 67 45
17 Rotonda Rotonda 38 39 46 42
18 ASD San Giorgio Giorgio 38 30 44 41
19 Bisceglie Bisceglie 38 32 47 39
20 Virtus Matino Virtus 38 36 62 30
TEMPORADA 2020/2021
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Taranto Taranto 34 50 23 69
2 Picerno Picerno 34 58 34 68
3 Fidelis Andria Fidelis 34 40 18 61
4 USD Bitonto USD Bitonto 34 51 42 55
5 Virtus Casarano Virtus 34 49 39 55
6 Lavello Lavello 34 55 40 54
7 Audace Cerignola Audace 34 62 39 52
8 Nardò Nardò 34 45 39 49
9 Team Altamura Team 34 49 42 47
10 Molfetta Calcio Molfetta 34 54 60 42
11 Sorrento Sorrento 34 41 54 41
12 Gravina Gravina 34 33 40 35
13 Città di Fasano Città 34 38 50 35
14 Brindisi Brindisi 34 27 45 35
15 FC Francavilla 1931 Francavilla 34 34 48 34
16 Real Agro Aversa Real Agro A. 34 40 57 34
17 Portici Portici 34 50 73 34
18 Puteolana Puteolana 34 23 56 26
TEMPORADA 2019/2020
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 USD Bitonto USD Bitonto 26 45 10 55
2 Calcio Foggia Calcio 26 33 16 54
3 Sorrento Sorrento 26 38 21 50
4 Audace Cerignola Audace 26 45 27 49
5 Virtus Casarano Virtus 26 34 28 42
6 Taranto Taranto 26 32 21 40
7 Città di Fasano Città 26 35 31 35
8 Gravina Gravina 26 36 32 34
9 Gelbison Gelbison 26 20 22 34
10 Gladiator Gladiator 26 25 27 33
11 Team Altamura Team 26 31 29 32
12 Brindisi Brindisi 26 23 35 31
13 Fidelis Andria Fidelis 26 31 41 29
14 Grumentum Grumentum 26 27 39 27
15 Nocerina Nocerina 26 30 45 27
16 Francavilla Calcio Francavilla 26 24 35 25
17 Nardò Nardò 26 24 35 25
18 Agropoli Agropoli 26 14 53 14
TEMPORADA 2011/2012
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Martina Franca Martina 34 61 23 72
2 Sarnese Sarnese 34 69 29 71
3 Ischia Ischia 34 65 38 66
4 Casertana Casertana 34 64 34 65
5 Brindisi Brindisi 34 58 42 59
6 Turris Neapolis Turris 34 63 41 57
7 Francavilla Calcio Francavilla 34 48 39 56
8 Campania Campania 34 31 26 52
9 Virtus Casarano Virtus 34 40 31 45
10 Nardò Nardò 34 30 43 43
11 Fortis Trani Fortis Trani 34 46 51 41
12 Internapoli Calcio Internapoli 34 31 46 37
13 Irsinese Irsinese 34 40 51 36
14 Grottaglie Grottaglie 34 35 52 35
15 Real Nocera Real Nocera 34 32 56 27
16 Viribus Unitis Viribus 34 29 61 27
17 Angelo Cristofaro Angelo 34 30 61 23
18 Gaeta Gaeta 34 23 71 23
TEMPORADA 2010/2011
SERIE D GRUPO 7
Equipo PJ GF GC Puntos
1 Arzanese Arzanese 34 60 28 71
2 Pomigliano Pomigliano 34 47 24 69
3 Gaeta Gaeta 34 50 18 67
4 Nardò Nardò 34 48 28 62
5 Virtus Casarano Virtus 34 46 30 56
6 Virtus Francavilla Virtus 34 43 38 47
7 Ischia Ischia 34 37 35 44
8 Capriatese Capriatese 34 33 35 44
9 Irsinese Irsinese 34 33 38 44
10 Atletico Boville Atletico 34 31 36 44
11 Fortis Trani Fortis Trani 34 34 42 44
12 Sant Antonio Abate Sant Antonio 34 37 43 42
13 Grottaglie Grottaglie 34 26 41 42
14 Battipagliese Battipaglies 34 36 36 39
15 Pisticci Pisticci 34 41 37 38
16 Angri Angri 34 42 59 36
17 Francavilla Calcio Francavilla 34 27 58 28
18 Ostuni Sport Ostuni Sport 34 19 64 16
TEMPORADA 2009/2010
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Turris Neapolis Turris 68 119 90 117
2 Francavilla Calcio Francavilla 68 80 85 82
3 ASD Pianura ASD Pianura 34 62 33 69
4 Virtus Casarano Virtus 34 56 28 65
5 Forza e Coraggio Forza 34 61 45 62
6 Sant Antonio Abate Sant Antonio 34 53 38 57
7 Pomigliano Pomigliano 34 41 36 55
8 Casertana Casertana 34 38 32 52
9 Matera Matera 34 43 44 46
10 Grottaglie Grottaglie 34 47 44 44
11 Ostuni Sport Ostuni Sport 34 38 51 41
12 Angri Angri 34 37 53 40
13 ASD Omnia Bitonto Omnia 35 36 50 36
14 Bacoli Sibilla Bacoli 34 36 51 33
15 Ischia Ischia 34 27 47 32
16 Pisticci Pisticci 35 28 49 32
17 Città di Fasano Città 34 23 49 23

  USO DE MEMORIA  
6,142,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1139
Total Execution Time  0.1151
  CADENA URL  
/historico/Virtus-Casarano
  GET DATOS  
$_GET['/historico/Virtus-Casarano']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0032  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-Casarano' 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=6952 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=6952 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=6952 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6952 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 = '6952' 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 = '6952' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '6952' 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=6952 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 (73986,73559,71632) 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.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 73986 AND teamId = 6952
0.0035  SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 6952
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 71632 AND teamId = 6952
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 = '6952' 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 = '6952' 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 = '6952' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0048  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 = 73986 WHERE rp.league_id = 73986 AND rp.teamId = 6952 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.0040  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 = 73986 WHERE rp.league_id = 73986 AND rp.teamId = 6952 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 = 73986 WHERE rp.league_id = 73986 AND rp.teamId = 6952 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 = 6952 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0042  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 = 73986 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.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 `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 = 64282 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.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 `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 = 58833 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.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 `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 = 51163 AND t.round = 26 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 `tables2012` 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 = 1698 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 `tables2011` 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 = 24702 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0052  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 `tables2010` 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 = 24716 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC