4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Paternò
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 2003/2004
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Catanzaro Catanzaro 34 44 25 67
2 Crotone Crotone 34 57 33 65
3 Viterbese Viterbese 34 45 29 61
4 Acireale Acireale 34 40 26 60
5 Benevento Benevento 34 41 28 56
6 Virtus Lanciano Virtus 34 34 31 53
7 Sambenedettese Sambenedette 34 50 40 52
8 Chieti Chieti 34 39 35 48
9 Calcio Foggia Calcio 34 43 43 46
10 Teramo Teramo 34 40 41 45
11 Martina Martina 34 45 50 42
12 Real Giulianova Real 34 35 39 41
13 Sora Sora 34 27 35 41
14 Fermana Fermana 34 34 46 40
15 Vis Pesaro Vis Pesaro 34 31 48 36
16 Paternò Paternò 34 32 47 32
17 Taranto Taranto 34 31 46 30
18 L'Aquila L'Aquila 34 26 52 13
TEMPORADA 2002/2003
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Pescara Pescara 34 64 36 69
2 Avellino Avellino 34 51 25 69
3 Martina Martina 34 52 37 62
4 Teramo Teramo 34 58 40 58
5 Sambenedettese Sambenedette 34 46 26 56
6 Crotone Crotone 34 40 29 50
7 Virtus Lanciano Virtus 34 39 39 49
8 Benevento Benevento 34 27 32 44
9 Taranto Taranto 34 31 35 41
10 Chieti Chieti 34 28 32 41
11 Viterbese Viterbese 34 37 50 39
12 Sassari Torres Sassari 34 34 37 38
13 Vis Pesaro Vis Pesaro 34 29 40 36
14 Real Giulianova Real 34 29 37 35
15 Paternò Paternò 34 31 46 35
16 Sora Sora 34 36 48 34
17 L'Aquila L'Aquila 34 30 53 33
18 Fermana Fermana 34 28 48 32

  USO DE MEMORIA  
5,872,072 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1632
Total Execution Time  0.1644
  CADENA URL  
/historico/Paterno
  GET DATOS  
$_GET['/historico/Paterno']  
  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 = 'Paterno' 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.0030  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 = 'Paterno' 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=2966 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=2966 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=2966 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=2966 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=2966 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=2966 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=2966 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=2966 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=2966 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 = 69427
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 = 71633
0.0022  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 = 68661
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2966 AND type_rel = 2
0.0025  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 = '2966' ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '2966' AND l.year = 2023 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 = '2966' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = '2966' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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 = 68661 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  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 = 71633 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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 = 69427 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0037  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=2966 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0031  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 (71633,69427,68661) 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.0036  SELECT count(id) as num_players from rel_players WHERE league_id = 69427 AND teamId = 2966
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 71633 AND teamId = 2966
0.0063  SELECT count(id) as num_players from rel_players WHERE league_id = 68661 AND teamId = 2966
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0038  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 = '2966' 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 = '2966' and rp.type = 4
0.0031  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 = '2966' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0132  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 events2023 e ON e.player_id = p.id AND e.league_id = 69427 WHERE rp.league_id = 69427 AND rp.teamId = 2966 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.0096  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 events2023 e ON e.player_id = p.id AND e.league_id = 69427 WHERE rp.league_id = 69427 AND rp.teamId = 2966 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0055  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 events2023 e ON e.player_id = p.id AND e.league_id = 69427 WHERE rp.league_id = 69427 AND rp.teamId = 2966 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 = 2966 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0035  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.0034  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.0037  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.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 `tables2004` 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 = 585 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 `tables2003` 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 = 587 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC