4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Cerreño
TEMPORADA 2023/2024
2ª ANDALUZA HUELVA
Equipo PJ GF GC Puntos
1 Ad Almonte Balompié Almonte 29 68 26 64
2 CD Cerreño CD Cerreño 29 37 33 51
3 Atl. Cortegana Atl. 29 44 27 48
4 Repilado CD Repilado CD 29 47 38 48
5 Gibraleón CF Gibraleón 29 40 31 47
6 CD Castillejos Castillejos 29 50 38 46
7 CD Canela CD Canela 29 59 39 45
8 Recr. Paterna Recr. 29 55 44 45
9 Bollullos B Bollullos B 29 50 48 40
10 PMD Aljaraque Aljaraque 29 43 35 39
11 Herrerías Herrerías 29 50 50 38
12 C.D. Alosno C.D. Alosno 30 45 70 32
13 CD Estrella CD Estrella 29 30 41 31
14 Mazagon CF Mazagon CF 29 42 63 27
15 Deportivo Campofrio Deportivo 29 35 66 21
16 Hinojos Hinojos 16 14 60 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 2019/2020
PRIMERA ANDALUZA GRUPO 5
Equipo PJ GF GC Puntos
1 Bollullos CF Bollullos 24 70 19 64
2 Ayamonte Ayamonte 24 59 20 62
3 Camping La Bota Camping Bota 24 49 15 55
4 CD Cerreño CD Cerreño 24 47 27 40
5 Ol. Valverdeña Valverdeña 24 38 40 36
6 Pinzón CD Pinzón CD 24 36 44 35
7 Punta Umbria Punta Umbria 24 36 33 34
8 Los Rosales AD Rosales 24 44 48 31
9 Atl.Calañas Atl.Calañas 24 30 35 27
10 Rociana CD Rociana CD 24 40 46 27
11 Zalamea Zalamea 24 28 32 26
12 CD Canela CD Canela 24 36 46 25
13 CD Bonares CD Bonares 24 34 40 23
14 Riotinto Balompié Riotinto 24 26 56 18
15 Almonte Balompié Almonte 24 26 52 17
16 Gibraleón Gibraleón 24 15 61 9
TEMPORADA 2018/2019
PRIMERA ANDALUZA GRUPO 4
Equipo PJ GF GC Puntos
1 Ayamonte Ayamonte 33 80 32 69
2 Aroche CF Aroche CF 33 66 34 69
3 Almonte Balompié Almonte 33 71 37 67
4 Bollullos CF Bollullos 34 64 33 64
5 CD Cerreño CD Cerreño 33 55 44 58
6 Camping La Bota Camping Bota 34 57 37 55
7 Zalamea Zalamea 34 58 46 53
8 Gibraleón Gibraleón 33 48 46 50
9 CD Canela CD Canela 34 57 63 49
10 Los Rosales AD Rosales 33 41 50 44
11 CD Bonares CD Bonares 33 37 42 42
12 Atl. Cortegana Atl. 33 42 59 38
13 Mazagon CF Mazagon CF 33 53 71 38
14 UD Punta del Caiman Punta Caiman 33 46 82 35
15 Atlético Cruceño Atlético 34 35 51 34
16 San Roque de Lepe B Roque Lepe 33 46 57 30
17 Moguer CD Moguer CD 33 35 52 28
18 CD Rubias CD Rubias 22 8 63 1
TEMPORADA 2017/2018
PRIMERA ANDALUZA GRUPO 4
Equipo PJ GF GC Puntos
1 Pinzón CD Pinzón CD 34 74 30 76
2 Ayamonte Ayamonte 34 71 36 72
3 Camping La Bota Camping Bota 34 73 36 69
4 Aroche CF Aroche CF 34 65 28 68
5 Bollullos CF Bollullos 34 61 41 59
6 UD Punta del Caiman Punta Caiman 34 54 49 58
7 Almonte Balompié Almonte 34 84 66 50
8 CD Cerreño CD Cerreño 34 58 52 45
9 Moguer CD Moguer CD 34 46 52 44
10 Gibraleón Gibraleón 34 47 59 44
11 Los Rosales AD Rosales 34 63 62 44
12 Atl. Cortegana Atl. 34 47 51 41
13 CD Bonares CD Bonares 34 48 66 37
14 Atlético Cruceño Atlético 34 38 51 34
15 Riotinto Balompié Riotinto 34 48 73 33
16 Atlético Tharsis Atlético 34 42 61 30
17 Aljaraque CD Aljaraque 34 31 73 21
18 Rosal CF Rosal CF 34 32 96 18
TEMPORADA 2016/2017
PRIMERA ANDALUZA GRUPO 7
Equipo PJ GF GC Puntos
1 Isla Cristina Isla 34 81 36 76
2 CD Cerreño CD Cerreño 34 80 48 68
3 Camping La Bota Camping Bota 34 69 34 66
4 Ayamonte Ayamonte 33 68 41 63
5 Atl. Cortegana Atl. 33 69 47 58
6 Almonte Balompié Almonte 33 87 70 53
7 Rosal CF Rosal CF 33 55 41 52
8 Bollullos B Bollullos B 34 71 69 50
9 Aroche CF Aroche CF 34 69 67 48
10 CD Bonares CD Bonares 34 73 68 46
11 UD Punta del Caiman Punta Caiman 34 77 75 45
12 Los Rosales AD Rosales 32 54 66 41
13 Moguer CD Moguer CD 34 44 58 41
14 UD Aracena UD Aracena 34 38 67 36
15 Atlético Tharsis Atlético 33 61 88 34
16 CD Canela CD Canela 34 51 62 32
17 CD Iliplense Iliplense 31 40 92 24
18 Trigueros Trigueros 34 45 103 18
TEMPORADA 2015/2016
2ª ANDALUZA HUELVA
Equipo PJ GF GC Puntos
1 Pinzón CD Pinzón CD 31 62 34 67
2 Almonte Balompié Almonte 32 72 38 59
3 Atl. Cortegana Atl. 31 69 45 56
4 Bollullos B Bollullos B 32 69 42 51
5 CD Bonares CD Bonares 32 57 42 50
6 Ayamonte Ayamonte 32 59 40 50
7 CD Cerreño CD Cerreño 32 50 50 44
8 Atlético Tharsis Atlético 32 41 45 41
9 CD Iliplense Iliplense 32 51 58 41
10 Moguer CD Moguer CD 32 51 70 40
11 Los Rosales AD Rosales 31 48 49 40
12 CD San Juan CD San Juan 32 49 49 40
13 UD Aracena UD Aracena 32 36 56 39
14 Punta Umbria Punta Umbria 31 54 55 38
15 UD Punta del Caiman Punta Caiman 32 43 60 37
16 Mazagon CF Mazagon CF 31 31 71 27
17 Cd Encinasola 2007 Encinasola 31 37 75 26
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 2013/2014
2ª ANDALUZA HUELVA
Equipo PJ GF GC Puntos
1 San Roque Roquiño Roque 34 62 25 73
2 C. Atlético Tharsis Atlético 34 80 53 66
3 Moguer CD Moguer CD 34 55 41 62
4 CD Cerreño CD Cerreño 34 66 45 58
5 CD San Juan CD San Juan 34 68 52 55
6 Isla Cristina Isla 33 67 57 54
7 Atl. Cortegana Atl. 34 58 42 52
8 AD Cartaya AD Cartaya 34 62 52 48
9 Almonte Balompié Almonte 33 52 47 47
10 Pinzón CD Pinzón CD 34 51 48 47
11 Zalamea Zalamea 34 52 50 42
12 UD Punta del Caiman Punta Caiman 33 60 62 42
13 CD Iliplense Iliplense 34 61 72 41
14 CD Bonares CD Bonares 34 44 54 38
15 Ebrosala Ebrosala 34 46 74 33
16 CD Canela CD Canela 33 45 71 30
17 Hinojos Hinojos 34 39 72 27
18 Cd Encinasola 2007 Encinasola 34 32 83 26
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,956,176 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.4050
Total Execution Time  0.4066
  CADENA URL  
/historico/C-D-Cerreno
  GET DATOS  
$_GET['/historico/C-D-Cerreno']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11379 AND type_rel = 2
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=280 AND type_rel = 3
0.0128  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 = '11379' ORDER BY l.year DESC,cat.coefficient 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 = '11379' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=11379 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 (73742,71791) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 73742 AND teamId = 11379
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 71791 AND teamId = 11379
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 = '11379' 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 = '11379' 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 = '11379' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 73742 WHERE rp.league_id = 73742 AND rp.teamId = 11379 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.0125  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 = 73742 WHERE rp.league_id = 73742 AND rp.teamId = 11379 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0125  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 = 73742 WHERE rp.league_id = 73742 AND rp.teamId = 11379 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 11379 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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 = 51258 AND t.round = 24 ORDER BY team.conference ASC,t.position 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 `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 = 44623 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 `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 = 39327 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 `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 = 34215 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 `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 = 16809 AND t.round = 34 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 `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 `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 = 2580 AND t.round = 34 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 `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