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 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,020,752 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5197
Total Execution Time  0.5210
  CADENA URL  
/historico/Rossoblu-Potenza/2021
  GET DATOS  
$_GET['/historico/Rossoblu-Potenza/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0139  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 = 'Rossoblu-Potenza' AND l.year = 2021 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.0125  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=66540 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=66540 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=66540 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=66540 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=66540 AND type_rel = 2
0.0141  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 = '66540' ORDER BY l.year DESC,cat.coefficient DESC
0.0132  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 = '66540' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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.0135  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 = 58762 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0141  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 (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (69410,63826,62807,58676) 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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 63826 AND teamId = 66540
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 58676 AND teamId = 66540
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 69410 AND teamId = 66540
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 66540
0.0126  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 = '66540' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '66540' and rp.type = 4
0.0127  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 = '66540' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0154  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 events2021 e ON e.player_id = p.id AND e.league_id = 58762 WHERE rp.league_id = 58762 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.0184  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 events2021 e ON e.player_id = p.id AND e.league_id = 58762 WHERE rp.league_id = 58762 AND rp.teamId = 66540 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0174  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 events2021 e ON e.player_id = p.id AND e.league_id = 58762 WHERE rp.league_id = 58762 AND rp.teamId = 66540 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0265  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.0131  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.0131  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.0129  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.0139  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.0130  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.0131  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