4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del C.D. Zarza
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
2ª ANDALUZA HUELVA
Equipo PJ GF GC Puntos
1 Ol. Valverdeña Valverdeña 28 79 36 65
2 Los Rosales AD Rosales 28 56 30 54
3 Huelva Colombina Huelva 28 70 41 50
4 Trigueros Trigueros 28 66 39 46
5 Atl. Cortegana Atl. 28 50 42 46
6 PMD Aljaraque Aljaraque 28 31 38 43
7 Hinojos Hinojos 28 57 56 41
8 C.D. Alosno C.D. Alosno 28 54 52 39
9 Recr. Paterna Recr. 28 48 52 37
10 Bollullos B Bollullos B 28 30 48 34
11 Deportivo Campofrio Deportivo 28 41 56 32
12 CD Estrella CD Estrella 28 39 64 30
13 Mazagon CF Mazagon CF 28 42 63 28
14 Atlético Tharsis Atlético 28 34 60 20
15 C.D. Zarza C.D. Zarza 28 28 48 19
16 CD Iliplense Iliplense 0 0 0 0
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
3ª ANDALUZA HUELVA GRUPO 1
Equipo PJ GF GC Puntos
1 Cd Encinasola 2007 Encinasola 22 39 24 45
2 UD Aracena UD Aracena 22 45 29 42
3 C.D. Zarza C.D. Zarza 22 44 26 39
4 Olímpica Valverdeña Sub 19 Olímpica 22 40 26 39
5 Aroche CF Aroche CF 22 32 23 39
6 Rosal CF Rosal CF 22 40 24 37
7 C.D. Alosno C.D. Alosno 22 34 34 32
8 Riotinto Balompié Riotinto 22 35 42 23
9 Atlético Cruceño Atlético 22 27 33 22
10 Campillo Cf Campillo Cf 22 33 46 22
11 Atl.Calañas Atl.Calañas 22 17 41 13
12 Las Colonias C.D. Colonias 22 17 55 10
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,690,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4811
Total Execution Time  0.4824
  CADENA URL  
/historico/C-D-Zarza
  GET DATOS  
$_GET['/historico/C-D-Zarza']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0117  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 = 'C-D-Zarza' 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.0105  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=11387 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=11387 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0217  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.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11387 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=303 AND type_rel = 3
0.0107  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.0110  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.0109  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 = '11387' ORDER BY l.year DESC,cat.coefficient DESC
0.0109  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 = '11387' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0109  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 = '11387' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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.0111  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=11387 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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,68924) 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.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 68924 AND teamId = 11387
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 73747 AND teamId = 11387
0.0110  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0107  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 = '11387' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '11387' and rp.type = 4
0.0107  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 = '11387' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0107  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 = 73747 WHERE rp.league_id = 73747 AND rp.teamId = 11387 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.0107  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 = 73747 WHERE rp.league_id = 73747 AND rp.teamId = 11387 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0109  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 = 73747 WHERE rp.league_id = 73747 AND rp.teamId = 11387 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0113  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 = 11387 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0111  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.0113  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 = 68924 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.0111  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.0108  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.0108  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.0109  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.0109  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.0110  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.0109  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 = 4120 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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.0107  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