4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Nerva CF
TEMPORADA 2023/2024
3ª ANDALUZA HUELVA
Equipo PJ GF GC Puntos
1 Villablanca C.D. Villablanca 25 65 23 58
2 Cartaya B Cartaya B 25 85 37 58
3 Aracena Club de Futbol Aracena Club 25 69 29 48
4 CD Rubias CD Rubias 25 62 25 45
5 Atlético Tharsis Atlético 25 50 47 42
6 C.D. Zarza C.D. Zarza 25 64 52 41
7 Matalascañas Matalascaña 24 58 38 40
8 Rociana CD B Rociana 25 40 35 39
9 Santa Bárbara 2014 Santa 25 39 50 32
10 Nerva CF Nerva CF 24 39 49 31
11 Trigueros Balompie B Trigueros 25 36 77 17
12 Santa Cruz Riaumbria Santa Cruz. 25 32 98 9
13 Florida 2023 Florida 2023 14 19 38 8
14 Sagrada Familia Mes de Mayo Sagrada 24 20 80 7
TEMPORADA 2022/2023
3ª ANDALUZA HUELVA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Castillejos Castillejos 26 91 22 69
2 CD Cerreño CD Cerreño 26 68 34 56
3 Gibraleón CF Gibraleón 26 58 21 52
4 Herrerías Herrerías 26 58 34 52
5 Cartaya B Cartaya B 26 79 44 48
6 Aracena Club de Futbol Aracena Club 26 56 34 47
7 Villablanca C.D. Villablanca 26 77 52 46
8 Rociana CD B Rociana 26 47 43 39
9 Nerva CF Nerva CF 26 55 75 34
10 Santa Bárbara 2014 Santa 26 44 39 29
11 Matalascañas Matalascaña 26 40 66 23
12 Rosal CF Rosal CF 26 27 75 14
13 Sagrada Familia Mes de Mayo Sagrada 26 32 83 9
14 Zalamea Zalamea 26 18 128 5
TEMPORADA 2021/2022
3ª ANDALUZA HUELVA
Equipo PJ GF GC Puntos
1 Atl. Cortegana Atl. 31 79 40 70
2 C.D. Zarza C.D. Zarza 32 81 32 69
3 CD Huelva Descubridora Huelva 32 97 52 67
4 Recr. Paterna Recr. 31 74 41 65
5 CD Hinojos CD Hinojos 32 81 54 59
6 Rosal CF Rosal CF 32 62 41 58
7 C.D. Alosno C.D. Alosno 32 65 46 58
8 Mazagon CF Mazagon CF 32 71 53 56
9 Herrerías Herrerías 31 60 48 52
10 Aracena Club de Futbol Aracena Club 31 40 54 37
11 Sagrada Familia Mes de Mayo Sagrada 32 39 60 34
12 CD Castillejos Castillejos 32 43 52 31
13 Nerva CF Nerva CF 32 50 70 30
14 Santa Bárbara 2014 Santa 32 34 74 22
15 Villablanca C.D. Villablanca 32 35 96 19
16 Senegal Recreativo LD Senegal 28 32 78 15
17 Aroche B Aroche B 32 26 78 14
TEMPORADA 2019/2020
2ª ANDALUZA HUELVA GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Tharsis Atlético 19 39 20 38
2 Atlético Cruceño Atlético 19 41 22 36
3 Repilado CD Repilado CD 19 34 27 34
4 C.D. Zarza C.D. Zarza 20 32 20 34
5 Atl. Cortegana Atl. 19 29 20 32
6 Trigueros Trigueros 19 30 30 29
7 Rosal CF Rosal CF 20 32 36 29
8 Herrerías Herrerías 20 26 26 28
9 CD Rubias CD Rubias 20 25 30 26
10 Beas CF Beas CF 20 33 51 23
11 Santa Olalla Santa Olalla 19 25 35 16
12 Nerva CF Nerva CF 19 25 34 14
13 S. Bartolome Bartolome 19 16 36 11
TEMPORADA 2018/2019
2ª ANDALUZA HUELVA GRUPO 1
Equipo PJ GF GC Puntos
1 Atl.Calañas Atl.Calañas 20 37 15 39
2 Nerva CF Nerva CF 19 29 25 35
3 Atlético Tharsis Atlético 19 42 26 34
4 Rosal CF Rosal CF 19 37 22 34
5 C.D. Zarza C.D. Zarza 19 29 18 33
6 Riotinto Balompié Riotinto 19 34 18 31
7 Herrerías Herrerías 20 31 27 26
8 C.D. Alosno C.D. Alosno 19 27 38 22
9 Campillo Cf Campillo Cf 20 25 49 17
10 Cd Encinasola 2007 Encinasola 13 12 32 10
11 Aroche B Aroche B 19 13 46 9
12 Futbol Base Valverde Futbol Base 0 0 0 0
TEMPORADA 2017/2018
2ª ANDALUZA HUELVA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Rubias CD Rubias 23 50 29 49
2 Zalamea Zalamea 22 56 12 47
3 UD Aracena UD Aracena 23 46 23 41
4 C.D. Zarza C.D. Zarza 23 43 26 38
5 C.D. Alosno C.D. Alosno 22 38 31 35
6 Atl.Calañas Atl.Calañas 21 25 25 32
7 Beas CF Beas CF 21 32 20 30
8 Nerva CF Nerva CF 23 32 39 26
9 Futbol Base Valverde Futbol Base 20 21 33 25
10 Cd Encinasola 2007 Encinasola 22 26 40 22
11 Campillo Cf Campillo Cf 23 27 50 18
12 Repilado CD Repilado CD 23 31 47 14
13 Deportivo Campofrio Deportivo 8 3 55 0
TEMPORADA 2016/2017
2ª ANDALUZA HUELVA GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Cruceño Atlético 24 41 21 51
2 Riotinto Balompié Riotinto 23 63 33 45
3 Zalamea Zalamea 24 55 29 45
4 Beas CF Beas CF 24 48 26 44
5 Nerva CF Nerva CF 22 43 29 37
6 Atl.Calañas Atl.Calañas 23 36 24 36
7 C.D. Zarza C.D. Zarza 22 30 33 33
8 CD Rubias CD Rubias 22 35 51 27
9 Cd Encinasola 2007 Encinasola 24 38 44 25
10 C.D. Alosno C.D. Alosno 24 27 48 25
11 Futbol Base Valverde Futbol Base 23 19 42 20
12 Campillo Cf Campillo Cf 23 20 45 20
13 Repilado CD Repilado CD 22 37 67 14
TEMPORADA 2015/2016
3ª ANDALUZA HUELVA GRUPO 2
Equipo PJ GF GC Puntos
1 Aroche CF Aroche CF 26 60 15 57
2 Zalamea Zalamea 26 58 19 55
3 Rosal CF Rosal CF 26 69 24 55
4 C.D. Zarza C.D. Zarza 26 40 29 48
5 Atlético Cruceño Atlético 26 43 19 48
6 C.D. Alosno C.D. Alosno 26 46 27 47
7 Olímpica Valverdeña Sub 19 Olímpica 25 45 57 32
8 Riotinto Balompié Riotinto 26 37 42 32
9 Beas CF Beas CF 26 28 32 31
10 Campillo Cf Campillo Cf 26 39 60 24
11 Atl.Calañas Atl.Calañas 26 20 44 23
12 Nerva CF Nerva CF 26 29 51 22
13 Repilado CD Repilado CD 25 20 61 15
14 Villablanca C.D. Villablanca 26 25 79 12
TEMPORADA 2014/2015
2ª ANDALUZA HUELVA
Equipo PJ GF GC Puntos
1 Isla Cristina Isla 32 68 27 69
2 AD Cartaya AD Cartaya 32 57 24 66
3 CD Iliplense Iliplense 32 59 39 59
4 Pinzón CD Pinzón CD 32 55 37 59
5 Atlético Tharsis Atlético 32 59 42 57
6 CD San Juan CD San Juan 32 57 39 55
7 Almonte Balompié Almonte 32 69 58 54
8 CD Bonares CD Bonares 32 55 44 54
9 Punta Umbria Punta Umbria 33 54 49 54
10 CD Cerreño CD Cerreño 33 53 57 44
11 Atl. Cortegana Atl. 32 54 56 42
12 Moguer CD Moguer CD 32 64 62 41
13 Ayamonte Ayamonte 32 42 47 40
14 UD Punta del Caiman Punta Caiman 32 67 66 39
15 Zalamea Zalamea 33 41 53 33
16 Camping La Bota Camping Bota 32 31 48 29
17 Repilado CD Repilado CD 33 34 86 24
18 Nerva CF Nerva CF 32 33 78 20
19 Aljaraque CD Aljaraque 32 34 74 19
TEMPORADA 2012/2013
3ª ANDALUZA HUELVA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Cerreño CD Cerreño 24 57 28 50
2 Valverde C.F. Valverde 24 43 23 50
3 Repilado CD Repilado CD 24 57 37 46
4 C.D. Zarza C.D. Zarza 24 39 25 46
5 Cd Encinasola 2007 Encinasola 24 56 33 43
6 Beas CF Beas CF 24 37 27 41
7 Atl.Calañas Atl.Calañas 24 23 26 30
8 C.D. Rubias C.D. Rubias 24 28 43 29
9 Riotinto Balompié Riotinto 24 37 41 26
10 UD Aracena UD Aracena 24 30 38 26
11 Nerva CF Nerva CF 24 26 50 23
12 C.D. Higueras F.C. C.D. 24 19 36 17
13 Aroche CF Aroche CF 24 23 68 12

  USO DE MEMORIA  
5,735,616 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.4556
Total Execution Time  0.4572
  CADENA URL  
/historico/Nerva-C-F
  GET DATOS  
$_GET['/historico/Nerva-C-F']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0133  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 = 'Nerva-C-F' 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.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=11385 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=11385 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0254  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 = 73747
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11385 AND type_rel = 2
0.0136  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=303 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 303 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (31135,28580,28572,28307) ORDER BY n.cover_points DESC, update_date DESC
0.0128  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 = '11385' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 73747 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=11385 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (73747,67320) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 73747 AND teamId = 11385
0.0124  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 11385
0.0130  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 = 11385 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73747 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.0144  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 = 69267 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.0148  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 = 64464 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.0164  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 = 51364 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 45003 AND t.round = 22 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 = 39687 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 34656 AND t.round = 26 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 `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 = 16906 AND t.round = 26 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 `tables2015` 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 = 4107 AND t.round = 34 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 `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 = 2210 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 73747 ORDER BY nameShow LIMIT 100