4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Nola 1925
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 8
Equipo PJ GF GC Puntos
1 Audace Cerignola Audace 38 83 27 88
2 FC Francavilla 1931 Francavilla 38 62 44 71
3 USD Bitonto USD Bitonto 38 56 40 65
4 Città di Fasano Città 38 63 50 62
5 Nocerina Nocerina 38 55 48 58
6 Gravina Gravina 38 51 49 56
7 Casertana Casertana 38 56 52 55
8 Sorrento Sorrento 38 41 50 52
9 Nola 1925 Nola 1925 38 50 58 51
10 Brindisi Brindisi 38 42 55 49
11 Molfetta Calcio Molfetta 38 48 45 48
12 Team Altamura Team 38 48 45 47
13 Mariglianese Mariglianese 38 43 46 47
14 Virtus Casarano Virtus 38 37 49 47
15 Lavello Lavello 38 49 56 45
16 Nardò Nardò 38 59 67 45
17 Rotonda Rotonda 38 39 46 42
18 ASD San Giorgio Giorgio 38 30 44 41
19 Bisceglie Bisceglie 38 32 47 39
20 Virtus Matino Virtus 38 36 62 30
TEMPORADA 2020/2021
SERIE D GRUPO 7
Equipo PJ GF GC Puntos
1 Monterosi Tuscia Monterosi 34 65 26 81
2 Latina Latina 34 60 29 65
3 FC Savoia 1908 Savoia 1908 34 39 22 57
4 Nocerina Nocerina 34 51 32 53
5 Vis Artena Vis Artena 34 51 43 53
6 Insieme Formia Insieme 34 52 39 50
7 Lanusei Lanusei 34 46 40 47
8 Muravera Muravera 34 42 40 47
9 Carbonia Carbonia 34 56 55 46
10 Latte Dolce Latte Dolce 34 45 42 44
11 Cassino Cassino 34 41 48 41
12 Gladiator Gladiator 34 37 44 40
13 Team Nuova Florida Team Nuova. 34 39 48 39
14 Arzachena Arzachena 34 39 50 36
15 Sassari Torres Sassari 34 31 48 34
16 Afragolese Afragolese 34 40 60 34
17 Nola 1925 Nola 1925 34 37 58 34
18 SSC Giugliano Giugliano 34 29 76 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 2018/2019
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Picerno Picerno 34 67 24 81
2 Audace Cerignola Audace 34 68 28 75
3 Taranto Taranto 34 65 28 71
4 USD Bitonto USD Bitonto 34 54 31 59
5 FC Savoia 1908 Savoia 1908 34 40 27 59
6 Fidelis Andria Fidelis 34 37 26 56
7 Città di Fasano Città 34 58 50 50
8 Gravina Gravina 34 48 43 48
9 Team Altamura Team 34 43 49 47
10 Sorrento Sorrento 34 47 50 43
11 FC Francavilla 1931 Francavilla 34 30 35 43
12 Nardò Nardò 34 30 39 37
13 Gelbison Gelbison 34 37 49 37
14 Sarnese Sarnese 34 32 50 36
15 Nola 1925 Nola 1925 34 36 55 36
16 Gragnano Gragnano 34 30 43 33
17 Pomigliano Pomigliano 34 17 59 19
18 Granata 1924 Granata 1924 34 21 74 14
TEMPORADA 2013/2014
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Matera Matera 32 48 22 64
2 Taranto Taranto 32 56 37 62
3 Turris Neapolis Turris 32 45 26 58
4 Monopoli Monopoli 32 48 32 57
5 Progreditur Marcianise Progreditur 32 60 34 56
6 Brindisi Brindisi 32 51 35 54
7 Francavilla Calcio Francavilla 32 48 40 49
8 Bisceglie Bisceglie 32 46 39 44
9 Gelbison Gelbison 32 36 42 42
10 San Severo San Severo 32 31 46 39
11 SS Manfredonia Calcio Manfredonia 32 36 48 38
12 Mariano Keller Mariano 32 39 54 37
13 Nola 1925 Nola 1925 32 28 41 33
14 Puteolana Puteolana 32 26 35 30
15 Real Metapontino Real 32 29 42 29
16 Gladiator Gladiator 32 23 53 27
17 Grottaglie Grottaglie 32 30 54 26
18 Nardò Nardò 0 0 0 0
TEMPORADA 2012/2013
SERIE D GRUPO 7
Equipo PJ GF GC Puntos
1 Sassari Torres Sassari 34 62 30 68
2 Sarnese Sarnese 34 48 31 60
3 Torre Neapolis Torre 34 48 37 60
4 Casertana Casertana 34 55 37 59
5 Lupa Frascati Lupa 34 57 39 56
6 Ostia Mare Ostia Mare 34 57 39 56
7 San Basilio Pa… Basilio 34 50 40 55
8 Sora Sora 34 53 41 50
9 Cynthia Cynthia 34 45 44 45
10 Arzachena Arzachena 34 47 47 42
11 AC Isola Liri Isola Liri 34 24 37 41
12 Porto Torres Porto Torres 34 34 40 39
13 Budoni Budoni 34 36 47 37
14 Anzio Anzio 34 38 54 35
15 Nola 1925 Nola 1925 34 38 55 33
16 Civitavecchia Civitavecchi 34 32 47 32
17 Selargius Selargius 34 44 66 32
18 Progetto Sant.Elia Progetto 34 34 71 23
TEMPORADA 2010/2011
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Ebolitana Ebolitana 34 63 18 83
2 Forza e Coraggio Forza 34 63 24 80
3 Casertana Casertana 34 58 26 67
4 ASD Sambiase Sambiase 34 45 31 59
5 Nissa FC ASD Nissa 34 42 27 56
6 Turris Neapolis Turris 34 66 46 54
7 ACR Messina ACR Messina 35 39 46 50
8 Valle Grecanica Valle 34 51 42 49
9 ASD HinterReggio HinterReggio 34 39 36 48
10 Sapri Calcio Sapri Calcio 34 51 47 44
11 Noto Noto 34 39 43 43
12 Cittanova Interpiana Cittanova 35 31 36 43
13 Real Nocera Real Nocera 34 39 43 42
14 Acireale Acireale 34 35 40 40
15 Modica Modica 34 30 45 38
16 Marsala Marsala 34 30 49 32
17 FC Rossanese 1909 Rossanese 34 26 51 31
18 GSD Mazara 1946 Mazara 1946 34 46 63 30
19 Nola 1925 Nola 1925 34 18 98 9

  USO DE MEMORIA  
6,245,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1066
Total Execution Time  0.1078
  CADENA URL  
/historico/Hyria-Nola
  GET DATOS  
$_GET['/historico/Hyria-Nola']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0042  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 = 68753
0.0027  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 = 71665
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10746 AND type_rel = 2
0.0023  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 = '10746' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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 = '10746' 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 = 71665 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=10746 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (71665,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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71665 AND teamId = 10746
0.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 68661 AND teamId = 10746
0.0025  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 = 68753 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '10746' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10746' and rp.type = 4
0.0021  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 = '10746' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0049  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 = 68753 WHERE rp.league_id = 68753 AND rp.teamId = 10746 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.0041  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 = 68753 WHERE rp.league_id = 68753 AND rp.teamId = 10746 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 68753 WHERE rp.league_id = 68753 AND rp.teamId = 10746 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 10746 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0025  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 = 64282 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 = 58832 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 `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.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 = 44803 AND t.round = 34 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 `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 = 24686 AND t.round = 34 ORDER BY team.conference 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 `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 = 2093 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2011` 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 = 24703 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC