4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Portici
TEMPORADA 2023/2024
SERIE D GRUPO 9
Equipo PJ GF GC Puntos
1 Trapani Trapani 33 91 13 91
2 Siracusa Siracusa 33 75 23 78
3 US Vibonese Calcio Vibonese 33 63 27 69
4 Reggina Reggina 33 53 24 64
5 Cittá Di Sant'Agata Cittá 33 44 31 52
6 Real Casalnuovo Real 33 49 45 51
7 Acireale Acireale 33 38 41 51
8 Ragusa Ragusa 34 41 38 50
9 Canicattì Canicattì 33 51 49 45
10 Igea Virtus Igea Virtus 33 37 39 44
11 Licata Licata 33 41 50 43
12 Akragas Akragas 33 41 53 39
13 Sancataldese Sancataldese 33 32 42 37
14 Portici Portici 33 32 54 32
15 San Luca San Luca 33 35 51 29
16 Locri 1909 Locri 1909 34 34 68 28
17 Castrovillari Castrovillar 33 29 74 17
18 Nuova Gioiese Nuova 33 16 80 8
19 Lamezia Terme Lamezia 0 0 0 0
TEMPORADA 2022/2023
SERIE D GRUPO 7
Equipo PJ GF GC Puntos
1 Sorrento Sorrento 34 53 28 70
2 Paganese Paganese 34 56 29 68
3 Casertana Casertana 34 57 40 58
4 Arzachena Arzachena 34 51 40 57
5 Lupa Roma Lupa Roma 34 44 29 50
6 Palmese Palmese 34 50 44 49
7 Cassino Cassino 34 42 45 47
8 Real Monterotondo Scalo Real 34 51 55 45
9 Sarrabus Ogliastra Sarrabus 34 51 54 43
10 Tivoli Tivoli 34 36 39 41
11 Vis Artena Vis Artena 34 24 28 41
12 Portici Portici 34 45 49 40
13 Angri Angri 34 39 51 39
14 Atletico Uri Atletico 34 45 62 39
15 Ilvamaddalena Ilvamaddalen 34 30 39 38
16 Nola 1925 Nola 1925 34 44 55 35
17 Pomezia Pomezia 34 40 58 35
18 Aprilia Aprilia 34 34 47 34
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 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 7
Equipo PJ GF GC Puntos
1 Turris Neapolis Turris 26 65 24 61
2 Ostia Mare Ostia Mare 26 46 21 57
3 Sassari Torres Sassari 26 44 25 51
4 Trastevere Trastevere 26 46 33 45
5 Latte Dolce Latte Dolce 26 40 29 45
6 Latina Latina 26 40 30 39
7 Cassino Cassino 26 27 30 39
8 Vis Artena Vis Artena 26 35 38 35
9 Muravera Muravera 26 33 32 34
10 Team Nuova Florida Team Nuova. 26 33 35 33
11 Lanusei Lanusei 26 23 25 31
12 Portici Portici 26 31 41 30
13 Aprilia Aprilia 26 25 30 29
14 Arzachena Arzachena 26 31 39 27
15 Città di Anagni Città 26 32 44 25
16 Pro Calcio Tor Sapienza Calcio 26 23 55 19
17 Ladispoli Ladispoli 26 25 42 18
18 Budoni Budoni 26 23 49 16
TEMPORADA 2018/2019
SERIE D GRUPO 9
Equipo PJ GF GC Puntos
1 SSC Bari SSC Bari 34 69 22 78
2 Turris Neapolis Turris 34 73 27 69
3 Marsala Marsala 34 44 30 53
4 Portici Portici 34 47 46 50
5 Castrovillari Castrovillar 34 40 39 49
6 Cittanova Cittanova 34 55 53 47
7 Palmese Palmese 34 34 32 47
8 Acireale Acireale 34 50 51 47
9 Nocerina Nocerina 34 35 40 47
10 Troina Troina 34 34 35 45
11 Gela Gela 34 49 50 44
12 ACR Messina ACR Messina 34 40 44 43
13 Sancataldese Sancataldese 34 52 51 42
14 FC Messina FC Messina 34 32 50 40
15 Locri 1909 Locri 1909 34 41 60 39
16 Roccella Roccella 34 32 46 38
17 Rotonda Rotonda 34 33 47 31
18 Igea Virtus Igea Virtus 34 17 54 21
TEMPORADA 2017/2018
SERIE D GRUPO 9
Equipo PJ GF GC Puntos
1 US Vibonese Calcio Vibonese 34 67 24 76
2 Troina Troina 34 59 28 76
3 Nocerina Nocerina 34 50 20 69
4 Granata 1924 Granata 1924 34 58 33 64
5 Igea Virtus Igea Virtus 34 43 25 60
6 ACR Messina ACR Messina 34 57 39 53
7 Gela Gela 34 56 46 52
8 Acireale Acireale 34 47 45 51
9 Gelbison Gelbison 34 36 42 47
10 Palmese Palmese 34 47 54 43
11 Cittanova Cittanova 34 43 46 42
12 Portici Portici 34 35 44 42
13 Sancataldese Sancataldese 34 40 41 40
14 Roccella Roccella 34 41 49 38
15 Ebolitana Ebolitana 34 32 50 30
16 AC Palazzolo Palazzolo 34 26 53 25
17 Paceco Paceco 34 30 74 21
18 Isola Capo Rizzuto Isola Capo. 34 15 69 12

  USO DE MEMORIA  
5,970,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1005
Total Execution Time  0.1025
  CADENA URL  
/historico/Portici-1906
  GET DATOS  
$_GET['/historico/Portici-1906']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
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 = 'Portici-1906' 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.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=101874 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=101874 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=101874 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=101874 AND type_rel = 2
0.0026  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 = '101874' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0028  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 = '101874' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0026  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=101874 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) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 73987 AND teamId = 101874
0.0034  SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 101874
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 = '101874' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '101874' 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 = '101874' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0045  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 = 101874 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.0042  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 = 101874 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 101874 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 = 101874 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0038  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.0031  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 = 68753 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 = 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.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 `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.0022  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 = 51162 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.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 = 44804 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 `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 = 39602 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC