4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Potenza Calcio
TEMPORADA 2023/2024
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 Juve Stabia Juve Stabia 38 57 24 79
2 Avellino Avellino 38 62 29 69
3 Benevento Benevento 38 45 33 66
4 Casertana Casertana 38 51 38 65
5 Taranto Taranto 38 46 31 65
6 Picerno Picerno 38 53 40 58
7 Audace Cerignola Audace 38 54 46 53
8 SSC Giugliano Giugliano 38 44 47 53
9 Crotone Crotone 38 54 47 52
10 Latina Latina 38 44 51 51
11 Calcio Foggia Calcio 38 40 44 48
12 Sorrento Sorrento 38 39 47 48
13 Catania Catania 38 39 38 45
14 ACR Messina ACR Messina 38 41 49 45
15 Turris Neapolis Turris 38 46 57 44
16 Potenza Calcio Potenza 38 38 47 43
17 Monopoli Monopoli 38 41 51 42
18 Virtus Francavilla Virtus 38 30 50 35
19 Monterosi Tuscia Monterosi 38 43 62 35
20 Brindisi Brindisi 38 28 64 25
TEMPORADA 2022/2023
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 Catanzaro Catanzaro 38 102 21 96
2 Crotone Crotone 38 57 31 80
3 Pescara Pescara 38 58 42 65
4 Calcio Foggia Calcio 38 60 44 61
5 Audace Cerignola Audace 38 48 41 60
6 Picerno Picerno 38 40 34 59
7 Monopoli Monopoli 38 46 48 54
8 Latina Latina 38 39 46 49
9 Potenza Calcio Potenza 38 49 57 48
10 Juve Stabia Juve Stabia 38 37 49 46
11 Taranto Taranto 38 26 36 46
12 SSC Giugliano Giugliano 38 51 61 46
13 Virtus Francavilla Virtus 38 47 54 45
14 Avellino Avellino 38 42 49 43
15 Turris Neapolis Turris 38 40 56 43
16 Monterosi Tuscia Monterosi 38 39 45 42
17 ACR Messina ACR Messina 38 32 47 41
18 Gelbison Gelbison 38 25 40 36
19 Viterbese Viterbese 38 35 52 33
20 Fidelis Andria Fidelis 38 29 49 33
TEMPORADA 2021/2022
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 SSC Bari SSC Bari 36 52 26 75
2 Catanzaro Catanzaro 36 57 26 67
3 Palermo FC Palermo FC 36 64 33 66
4 Avellino Avellino 36 45 26 64
5 Monopoli Monopoli 36 38 31 59
6 Virtus Francavilla Virtus 36 48 38 56
7 Calcio Foggia Calcio 36 62 51 54
8 Turris Neapolis Turris 36 52 49 52
9 Monterosi Tuscia Monterosi 36 40 38 51
10 Picerno Picerno 36 41 45 50
11 Juve Stabia Juve Stabia 36 44 36 49
12 Latina Latina 36 37 42 45
13 Città di Campobasso Città 36 51 62 44
14 ACR Messina ACR Messina 36 40 57 39
15 Taranto Taranto 36 31 40 39
16 Potenza Calcio Potenza 36 37 51 37
17 Fidelis Andria Fidelis 36 26 45 30
18 Paganese Paganese 36 36 69 26
19 US Vibonese Calcio Vibonese 36 24 60 21
20 Catania Catania 0 0 0 0
TEMPORADA 2020/2021
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 Ternana Calcio Ternana 36 95 32 90
2 Catanzaro Catanzaro 36 44 29 68
3 Avellino Avellino 36 53 33 68
4 SSC Bari SSC Bari 36 52 34 63
5 Juve Stabia Juve Stabia 36 51 39 61
6 Catania Catania 36 50 38 59
7 Palermo FC Palermo FC 36 44 40 53
8 Teramo Teramo 36 38 34 52
9 Calcio Foggia Calcio 36 36 39 51
10 Casertana Casertana 36 47 59 45
11 Monopoli Monopoli 36 43 51 41
12 Viterbese Viterbese 36 36 42 40
13 Potenza Calcio Potenza 36 38 52 39
14 Turris Neapolis Turris 36 40 56 39
15 Virtus Francavilla Virtus 36 32 44 38
16 US Vibonese Calcio Vibonese 36 34 37 36
17 Paganese Paganese 36 26 49 32
18 Bisceglie Bisceglie 36 28 51 30
19 Cavese 1919 Cavese 1919 36 27 55 23
20 Trapani Trapani 0 0 0 0
TEMPORADA 2019/2020
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 Reggina Reggina 30 54 19 69
2 SSC Bari SSC Bari 30 54 24 60
3 Monopoli Monopoli 30 40 22 57
4 Potenza Calcio Potenza 30 36 23 56
5 Ternana Calcio Ternana 30 38 29 51
6 Catania Catania 30 39 38 47
7 Catanzaro Catanzaro 30 41 36 43
8 Teramo Teramo 30 29 31 41
9 Virtus Francavilla Virtus 30 39 36 40
10 Avellino Avellino 30 34 38 40
11 US Vibonese Calcio Vibonese 30 48 37 39
12 Viterbese Viterbese 30 37 38 39
13 Cavese 1919 Cavese 1919 30 24 36 38
14 Casertana Casertana 30 37 35 38
15 Paganese Paganese 30 35 34 36
16 Picerno Picerno 30 29 38 32
17 Sicula Leonzio Sicula 30 31 46 29
18 Bisceglie Bisceglie 30 21 40 20
19 Rende Rende 30 19 50 18
20 Rieti Rieti 30 29 64 15
TEMPORADA 2018/2019
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 Juve Stabia Juve Stabia 36 63 18 77
2 Trapani Trapani 36 60 34 73
3 Catanzaro Catanzaro 36 65 32 67
4 Catania Catania 36 48 29 65
5 Potenza Calcio Potenza 36 45 32 57
6 Reggina Reggina 36 45 33 56
7 Virtus Francavilla Virtus 36 42 39 55
8 Monopoli Monopoli 36 41 31 51
9 Casertana Casertana 36 46 38 51
10 Rende Rende 36 46 45 47
11 Cavese 1919 Cavese 1919 36 49 50 47
12 Viterbese Viterbese 36 39 44 45
13 Rieti Rieti 36 33 43 43
14 US Vibonese Calcio Vibonese 36 33 37 42
15 Sicula Leonzio Sicula 36 32 42 42
16 Siracusa Siracusa 36 34 44 41
17 Bisceglie Bisceglie 36 22 41 32
18 Paganese Paganese 36 36 72 23
19 Matera Matera 36 16 91 8
TEMPORADA 2017/2018
SERIE D GRUPO 10
Equipo PJ GF GC Puntos
1 US Vibonese Calcio Vibonese 1 4 0 3
2 Gozzano Gozzano 1 2 0 3
3 Vis Pesaro Vis Pesaro 2 1 4 0
4 Pro Patria Pro Patria 1 3 1 3
5 Virtus Verona Virtus 2 1 5 0
6 Albissola Albissola 2 6 4 4
7 Rimini Rimini 2 6 5 4
8 Rieti Rieti 1 0 0 1
9 Potenza Calcio Potenza 2 0 4 1
TEMPORADA 2016/2017
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Bisceglie Bisceglie 34 67 31 74
2 Trastevere Trastevere 34 60 32 73
3 Nocerina Nocerina 34 62 31 64
4 Gravina Gravina 34 45 23 61
5 Nardò Nardò 34 49 35 60
6 Gelbison Gelbison 34 50 44 47
7 Picerno Picerno 34 42 37 47
8 Herculaneum 1924 Herculaneum 34 36 34 46
9 Potenza Calcio Potenza 34 43 44 45
10 SS Manfredonia Calcio Manfredonia 34 50 53 44
11 Francavilla Calcio Francavilla 34 34 38 43
12 Anzio Anzio 34 41 49 41
13 San Severo San Severo 34 42 45 40
14 C.S. Vultur Rionero C.S. Vultur 34 37 44 38
15 Madrepietra Daunia Madrepietra 34 43 57 37
16 Agropoli Agropoli 34 38 70 26
17 Cynthia Cynthia 34 31 59 22
18 Polisportiva Ciampino Polisportiva 34 37 81 20
TEMPORADA 2015/2016
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Virtus Francavilla Virtus 34 45 26 66
2 Taranto Taranto 34 61 34 63
3 Francavilla Calcio Francavilla 34 61 35 61
4 Nardò Nardò 34 49 26 60
5 Fondi Fondi 34 75 52 52
6 SS Manfredonia Calcio Manfredonia 34 45 49 50
7 Pomigliano Pomigliano 34 47 46 47
8 Bisceglie Bisceglie 34 42 44 47
9 Progreditur Marcianise Progreditur 34 40 38 45
10 Torrecuso Torrecuso 34 57 50 44
11 San Severo San Severo 34 58 59 44
12 AC Isola Liri Isola Liri 34 42 45 44
13 Potenza Calcio Potenza 34 43 58 44
14 Turris Neapolis Turris 34 40 50 43
15 Serpentara Bellegra Serpentara 34 44 50 41
16 Picerno Picerno 34 43 60 30
17 Aprilia Aprilia 34 37 63 28
18 Gallipoli Gallipoli 34 25 69 21

  USO DE MEMORIA  
6,131,104 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.0970
Total Execution Time  0.0985
  CADENA URL  
/historico/Rossoblu-Potenza
  GET DATOS  
$_GET['/historico/Rossoblu-Potenza']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0045  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 = 75938
0.0028  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 = 72301
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=66540 AND type_rel = 2
0.0040  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 = '66540' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 72301 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0036  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=66540 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 (75938,74153) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 75938 AND teamId = 66540
0.0036  SELECT count(id) as num_players from rel_players WHERE league_id = 74153 AND teamId = 66540
0.0019  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 = 75938 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = 75938 WHERE rp.league_id = 75938 AND rp.teamId = 66540 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.0019  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 = 75938 WHERE rp.league_id = 75938 AND rp.teamId = 66540 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0018  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 = 75938 WHERE rp.league_id = 75938 AND rp.teamId = 66540 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 66540 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 = 72301 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 `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 = 68593 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 `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 = 63826 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 = 58762 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 `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 = 51023 AND t.round = 30 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 `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 = 44233 AND t.round = 38 ORDER BY team.conference 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 `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 = 39601 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 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 = 43432 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 33456 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 `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 = 15656 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 75938 ORDER BY nameShow LIMIT 100