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

Licata

Entrenador: Giuseppe Romano

TEMPORADA 2023/2024
SERIE D GRUPO 9
Equipo PJ GF GC Puntos
1 Trapani Trapani 33 89 12 89
2 Siracusa Siracusa 33 71 23 76
3 US Vibonese Calcio Vibonese 33 63 27 69
4 Reggina Reggina 32 51 24 61
5 Ragusa Ragusa 34 41 37 51
6 Cittá Di Sant'Agata Cittá 33 43 31 50
7 Real Casalnuovo Real 33 48 45 49
8 Acireale Acireale 33 35 41 49
9 Canicattì Canicattì 33 51 49 45
10 Igea Virtus Igea Virtus 33 37 39 44
11 Licata Licata 33 41 49 43
12 Akragas Akragas 33 41 49 40
13 Sancataldese Sancataldese 32 32 40 37
14 Portici Portici 33 32 54 32
15 San Luca San Luca 33 35 50 30
16 Locri 1909 Locri 1909 34 34 65 29
17 Castrovillari Castrovillar 33 28 74 17
18 Nuova Gioiese Nuova 33 15 78 9
19 Lamezia Terme Lamezia 0 0 0 0
TEMPORADA 2022/2023
SERIE D GRUPO 9
Equipo PJ GF GC Puntos
1 Catania Catania 34 74 20 88
2 Locri 1909 Locri 1909 34 56 41 57
3 Trapani Trapani 34 46 31 54
4 Lamezia Terme Lamezia 34 45 35 54
5 Cittá Di Sant'Agata Cittá 34 61 45 52
6 Licata Licata 34 43 35 52
7 Sancataldese Sancataldese 34 34 30 52
8 US Vibonese Calcio Vibonese 34 40 41 47
9 Santa Maria Cilento Santa Maria 34 45 48 45
10 Canicattì Canicattì 34 35 40 45
11 Acireale Acireale 34 31 30 41
12 Castrovillari Castrovillar 34 30 42 41
13 Real Agro Aversa Real Agro A. 34 29 31 37
14 San Luca San Luca 34 34 46 37
15 Ragusa Ragusa 34 31 47 37
16 Paternò Paternò 34 27 47 37
17 Cittanova Interpiana Cittanova 34 23 45 27
18 Mariglianese Mariglianese 34 24 54 24
TEMPORADA 2021/2022
SERIE D GRUPO 9
Equipo PJ GF GC Puntos
1 Gelbison Gelbison 36 63 23 78
2 Cavese 1919 Cavese 1919 36 58 21 77
3 Acireale Acireale 36 58 31 69
4 Lamezia Terme Lamezia 36 58 35 69
5 Cittá Di Sant'Agata Cittá 36 47 31 60
6 Paternò Paternò 36 45 41 52
7 Cittanova Interpiana Cittanova 36 48 56 52
8 Santa Maria Cilento Santa Maria 36 58 50 51
9 Licata Licata 36 57 45 50
10 Real Agro Aversa Real Agro A. 36 36 34 49
11 Portici Portici 36 42 44 44
12 Trapani Trapani 36 44 47 41
13 San Luca San Luca 36 45 52 41
14 Sancataldese Sancataldese 36 34 60 40
15 Giarre Giarre 36 33 42 39
16 Castrovillari Castrovillar 36 39 48 38
17 Rende Rende 36 35 50 36
18 Troina Troina 36 39 71 29
19 Biancavilla Biancavilla 36 25 83 13
20 FC Messina FC Messina 0 0 0 0
TEMPORADA 2020/2021
SERIE D GRUPO 9
Equipo PJ GF GC Puntos
1 ACR Messina ACR Messina 34 66 25 74
2 FC Messina FC Messina 34 59 25 72
3 Gelbison Gelbison 34 54 34 64
4 San Luca San Luca 34 46 38 58
5 Acireale Acireale 34 51 32 57
6 Dattilo Dattilo 34 52 47 52
7 Rotonda Rotonda 34 31 33 49
8 Biancavilla Biancavilla 34 44 47 47
9 Santa Maria Cilento Santa Maria 34 43 29 45
10 Licata Licata 34 36 39 43
11 Castrovillari Castrovillar 34 39 37 41
12 Paternò Paternò 34 28 35 39
13 Cittanova Cittanova 34 42 51 39
14 Cittá Di Sant'Agata Cittá 34 32 48 36
15 Troina Troina 34 27 47 36
16 Rende Rende 34 38 58 34
17 Marina di Ragusa Marina 34 38 58 33
18 Roccella Roccella 34 25 68 20
TEMPORADA 2019/2020
SERIE D GRUPO 9
Equipo PJ GF GC Puntos
1 Palermo FC Palermo FC 26 47 16 63
2 FC Savoia 1908 Savoia 1908 26 41 15 56
3 SSC Giugliano Giugliano 26 40 26 47
4 FC Messina FC Messina 26 37 20 46
5 Troina Troina 26 30 28 46
6 Acireale Acireale 26 44 32 43
7 Licata Licata 26 36 30 41
8 ACR Messina ACR Messina 26 30 29 36
9 Nola 1925 Nola 1925 26 32 31 36
10 Biancavilla Biancavilla 26 23 32 35
11 Cittanova Cittanova 26 31 37 33
12 Castrovillari Castrovillar 26 43 39 32
13 Marina di Ragusa Marina 26 22 29 28
14 Roccella Roccella 26 22 26 25
15 ASD Corigliano Corigliano 26 26 52 25
16 Marsala Marsala 26 25 38 24
17 San Tommaso San Tommaso 26 25 46 21
18 Palmese Palmese 26 21 49 12
TEMPORADA 2013/2014
SERIE D GRUPO 9
Equipo PJ GF GC Puntos
TEMPORADA 2012/2013
SERIE D GRUPO 9
Equipo PJ GF GC Puntos
1 ACR Messina ACR Messina 34 59 24 77
2 Cosenza Cosenza 34 65 41 73
3 Gelbison Gelbison 34 39 28 60
4 FC Messina FC Messina 34 55 40 58
5 US Vibonese Calcio Vibonese 34 42 31 51
6 Comprensorio Normanno Comprensorio 34 40 37 50
7 FC Savoia 1908 Savoia 1908 34 54 52 48
8 Cavese 1919 Cavese 1919 34 47 38 47
9 Noto Noto 34 46 36 46
10 Licata Licata 34 50 46 46
11 Rios Renovables Ribera Nava Rios 34 39 37 46
12 Montalto Comprensorio Montalto 34 44 38 45
13 AC Palazzolo Palazzolo 34 44 45 44
14 Agropoli Agropoli 34 35 37 44
15 Ragusa Ragusa 34 38 42 39
16 ASD Sambiase Sambiase 34 42 43 38
17 Acireale Acireale 34 21 74 15
18 Nissa FC ASD Nissa 34 12 83 8
TEMPORADA 2011/2012
SERIE D GRUPO 9
Equipo PJ GF GC Puntos
1 ASD HinterReggio HinterReggio 34 58 34 60
2 Cosenza Cosenza 34 56 35 59
3 ACR Messina ACR Messina 34 49 36 58
4 AC Palazzolo Palazzolo 34 50 30 53
5 Battipagliese Battipaglies 33 53 41 53
6 Nuvla San Felice Nuvla Felice 34 43 41 50
7 Polisportiva A… Polisportiva 34 43 45 49
8 Noto Noto 34 51 39 48
9 AC Sant Antoni… Sant 34 55 54 47
10 Licata Licata 34 50 50 47
11 Serre Alburni Serre 34 38 37 45
12 ASD Sambiase Sambiase 34 41 44 45
13 Acri Acri 33 40 42 43
14 Acireale Acireale 33 29 35 39
15 Marsala Marsala 34 34 44 38
16 Nissa FC ASD Nissa 34 30 37 36
17 Valle Grecanica Valle 33 29 46 30
18 Cittanova Interpiana Cittanova 34 20 79 20
TEMPORADA 1989/1990
SERIE B
Equipo PJ GF GC Puntos
1 Torino Torino 38 63 24 72
2 Pisa SC Pisa SC 38 51 23 67
3 Cagliari Cagliari 38 39 22 64
4 Parma Parma 38 49 30 62
5 Ancona Ancona 38 46 34 56
6 Reggina Reggina 38 32 27 55
7 Calcio Foggia Calcio 38 45 38 54
8 Pescara Pescara 38 34 39 53
9 Reggiana Reggiana 38 33 31 51
10 Padova Padova 38 26 33 49
11 Avellino Avellino 38 33 35 47
12 Brescia Brescia 38 31 34 47
13 AC Monza AC Monza 38 26 37 45
14 ACR Messina ACR Messina 38 28 44 45
15 Triestina Triestina 38 33 41 44
16 Cosenza Calcio Cosenza 38 27 40 43
17 Barletta Barletta 38 24 37 43
18 Licata Licata 38 22 38 34
19 Como Como 38 16 32 34
20 Catanzaro Catanzaro 38 16 35 28
TEMPORADA 1988/1989
SERIE B
Equipo PJ GF GC Puntos
1 Genoa Genoa 38 35 13 67
2 SSC Bari SSC Bari 38 38 21 67
3 Cosenza Calcio Cosenza 38 35 29 61
4 Udinese Udinese 38 37 24 58
5 Cremonese Cremonese 38 40 30 57
6 Reggina Reggina 38 33 31 57
7 Avellino Avellino 38 31 29 52
8 ACR Messina ACR Messina 38 46 42 51
9 Licata Licata 38 39 40 48
10 Parma Parma 38 29 31 45
11 Padova Padova 38 27 35 45
12 Brescia Brescia 38 27 29 43
13 Catanzaro Catanzaro 38 24 26 43
14 Barletta Barletta 38 40 43 43
15 Empoli Empoli 38 29 33 42
16 AC Monza AC Monza 38 31 32 41
17 Ancona Ancona 38 28 35 41
18 Sambenedettese Sambenedette 38 21 30 38
19 Taranto Taranto 38 24 40 37
20 Piacenza Piacenza 38 20 41 33

  USO DE MEMORIA  
6,322,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1651
Total Execution Time  0.1671
  CADENA URL  
/historico/Licata
  GET DATOS  
$_GET['/historico/Licata']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0033  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 = 'Licata' 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=6977 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=6977 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=6977 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6977 AND type_rel = 2
0.0041  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 = '6977' ORDER BY l.year DESC,cat.coefficient DESC
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 = '6977' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0034  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 = '6977' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 73987 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  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=6977 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 (73987,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.0042  SELECT count(id) as num_players from rel_players WHERE league_id = 73987 AND teamId = 6977
0.0088  SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 6977
0.0033  SELECT count(id) as num_players from rel_players WHERE league_id = 71632 AND teamId = 6977
0.0022  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 = '6977' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6977' 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 = '6977' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0063  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 = 73987 WHERE rp.league_id = 73987 AND rp.teamId = 6977 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.0091  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 = 73987 WHERE rp.league_id = 73987 AND rp.teamId = 6977 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0054  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 = 73987 WHERE rp.league_id = 73987 AND rp.teamId = 6977 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0039  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 = 6977 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 = 73987 AND t.round = 37 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0045  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 = 69427 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.0047  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 = 64283 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.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 `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 = 58834 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.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 `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 = 51164 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.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 `tables2014` 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 = 24687 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 `tables2013` 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 = 2092 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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 = 1699 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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 `tables1990` 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 = 30862 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0045  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 `tables1989` 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 = 30861 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC