4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Città di Fasano
TEMPORADA 2023/2024
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Team Altamura Team 34 51 23 72
2 Martina Franca Martina 34 51 23 66
3 Nardò Nardò 34 53 24 65
4 Fidelis Andria Fidelis 34 58 32 61
5 Virtus Casarano Virtus 34 45 32 55
6 Matera Matera 34 45 37 53
7 Palmese Palmese 34 47 51 47
8 Paganese Paganese 34 42 43 45
9 Gelbison Gelbison 34 41 37 43
10 SS Manfredonia Calcio Manfredonia 34 30 37 43
11 Rotonda Rotonda 34 36 36 42
12 Gravina Gravina 34 49 44 41
13 Città di Fasano Città 34 38 57 41
14 Angri Angri 34 35 52 39
15 Gallipoli Gallipoli 34 27 49 33
16 Barletta Barletta 34 30 45 30
17 USD Bitonto USD Bitonto 34 22 45 30
18 Santa Maria Cilento Santa Maria 34 22 55 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 2018/2019
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Picerno Picerno 34 67 24 81
2 Audace Cerignola Audace 34 68 28 75
3 Taranto Taranto 34 65 28 71
4 USD Bitonto USD Bitonto 34 54 31 59
5 FC Savoia 1908 Savoia 1908 34 40 27 59
6 Fidelis Andria Fidelis 34 37 26 56
7 Città di Fasano Città 34 58 50 50
8 Gravina Gravina 34 48 43 48
9 Team Altamura Team 34 43 49 47
10 Sorrento Sorrento 34 47 50 43
11 FC Francavilla 1931 Francavilla 34 30 35 43
12 Nardò Nardò 34 30 39 37
13 Gelbison Gelbison 34 37 49 37
14 Sarnese Sarnese 34 32 50 36
15 Nola 1925 Nola 1925 34 36 55 36
16 Gragnano Gragnano 34 30 43 33
17 Pomigliano Pomigliano 34 17 59 19
18 Granata 1924 Granata 1924 34 21 74 14
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
TEMPORADA 2008/2009
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Brindisi Brindisi 34 61 28 70
2 ASD Pianura ASD Pianura 34 71 39 60
3 Nocerina Nocerina 33 51 40 60
4 Pomigliano Pomigliano 34 56 41 56
5 Ischia Ischia 34 43 29 55
6 Turris 1944 Turris 1944 34 40 37 54
7 Matera Matera 34 42 33 47
8 Virtus Francavilla Virtus 34 35 39 47
9 Città di Fasano Città 34 41 36 46
10 Francavilla Calcio Francavilla 33 36 33 45
11 Bacoli Sibilla Bacoli 34 43 41 45
12 Angri Angri 33 33 41 42
13 Sant Antonio Abate Sant Antonio 34 34 44 42
14 ASD Omnia Bitonto Omnia 33 33 47 37
15 Grottaglie Grottaglie 34 31 41 36
16 FC Sporting Genzano Sporting 34 27 52 32
17 Gelbison Gelbison 34 35 56 24
18 US Venafro US Venafro 34 25 60 20

  USO DE MEMORIA  
6,147,256 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1306
Total Execution Time  0.1320
  CADENA URL  
/historico/Fasano
  GET DATOS  
$_GET['/historico/Fasano']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0073  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 = 'Fasano' 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.0043  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=86851 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=86851 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=86851 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0075  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 = 73986
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=86851 AND type_rel = 2
0.0023  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 = '86851' ORDER BY l.year DESC,cat.coefficient DESC
0.0032  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 = '86851' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '86851' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0027  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 = 73559 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 73986 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=86851 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,67320) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73986 AND teamId = 86851
0.0034  SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 86851
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 86851
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 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 = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 = '86851' 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 = '86851' and rp.type = 4
0.0019  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 = '86851' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0033  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 = 86851 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.0029  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 = 86851 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2024 e ON e.player_id = p.id AND e.league_id = 73986 WHERE rp.league_id = 73986 AND rp.teamId = 86851 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 86851 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  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 = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 68754 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.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 `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.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 `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.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 `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 `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 = 44803 AND t.round = 34 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 `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
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 `tables2009` 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 = 24735 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 73986 ORDER BY nameShow LIMIT 100