4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Hispania
TEMPORADA 2023/2024
PRIMERA ANDALUZA GRUPO 6
Equipo PJ GF GC Puntos
1 CD Villacarrillo Villacarrill 30 81 28 70
2 Begíjar CF Begíjar CF 30 56 32 60
3 Carolinense Carolinense 30 55 23 59
4 Navas CD Navas CD 30 61 45 57
5 Atlético Jaén Atlético 30 65 35 55
6 Inter de Jaén CF Inter Jaén 30 52 55 44
7 UD Cazorla UD Cazorla 30 50 43 42
8 CD Hispania CD Hispania 30 41 48 41
9 UDC Torredonjimeno B Torredonjime 30 53 61 39
10 CD Villanueva Villanueva 30 43 45 38
11 Vilches Vilches 30 47 46 37
12 Baeza CF Baeza CF 30 44 48 34
13 CD Rus CD Rus 30 41 62 32
14 Atlético Mengibar Atlético 30 44 74 29
15 AD Lopera AD Lopera 30 39 73 22
16 Mancha Real B Mancha Real 30 30 84 11
TEMPORADA 2022/2023
2ª ANDALUZA JAÉN GRUPO 1
Equipo PJ GF GC Puntos
1 CD Hispania CD Hispania 20 50 24 49
2 UD La Guardia Guardia 20 54 25 46
3 Los Villares CF Villares 20 36 34 31
4 CD Jimena CD Jimena 20 36 32 31
5 Real Jaén B Real Jaén 20 30 22 28
6 Martos Unión Martos 20 32 28 26
7 Huelma CP Huelma CP 20 28 32 23
8 Veteranos Alcaudete Veteranos 20 32 33 21
9 UD Cambil UD Cambil 20 32 56 16
10 Villargordo CF Villargordo 20 37 54 15
11 Castillo de Locubin Castillo 20 27 54 15
TEMPORADA 2021/2022
2ª ANDALUZA JAÉN GRUPO 1
Equipo PJ GF GC Puntos
1 UDC Torredonjimeno B Torredonjime 24 87 19 60
2 UD La Guardia Guardia 24 58 25 55
3 CD Hispania CD Hispania 24 48 19 51
4 Atlético Jaén Atlético 24 42 21 44
5 Atlético Mengibar Atlético 24 53 33 43
6 Club At Arjonilla Club 23 37 34 39
7 AD Lopera AD Lopera 23 48 37 35
8 Villargordo CF Villargordo 24 38 39 35
9 UD Cambil UD Cambil 24 51 78 22
10 Castillo de Locubin Castillo 24 35 55 20
11 CD Utica CD Utica 23 33 60 16
12 Martos Unión Martos 23 17 75 8
13 Veteranos Alcaudete Veteranos 24 22 74 6
TEMPORADA 2018/2019
PRIMERA ANDALUZA GRUPO 7
Equipo PJ GF GC Puntos
1 CD Villanueva Villanueva 33 62 32 66
2 CD Vilches CD Vilches 34 66 46 63
3 CD Úbeda Viva Úbeda Viva 34 61 45 57
4 Arquillos CF Arquillos 34 50 41 55
5 Baeza CF Baeza CF 34 62 49 54
6 Recreativo Bailén Recreativo 33 45 39 53
7 UDC Torredonjimeno B Torredonjime 33 55 51 49
8 UD La Guardia Guardia 33 62 44 48
9 Quesada CD Quesada CD 34 62 64 48
10 Iliturgi 2016 Iliturgi 33 56 44 44
11 CD Hispania CD Hispania 33 47 40 42
12 Huelma CP Huelma CP 34 59 62 42
13 CD Arroyo del Ojanco Arroyo 34 56 77 40
14 Ibros CF Ibros CF 33 48 58 38
15 Urgavona CF Urgavona CF 31 44 61 36
16 CD Tugia CD Tugia 33 43 52 32
17 CD Santisteban Santisteban 25 24 52 20
18 Martos CD Martos CD 32 26 71 19
TEMPORADA 2017/2018
PRIMERA ANDALUZA GRUPO 7
Equipo PJ GF GC Puntos
1 Begíjar CF Begíjar CF 32 58 32 65
2 Baeza CF Baeza CF 32 68 42 62
3 CD Úbeda Viva Úbeda Viva 32 72 28 61
4 CD Hispania CD Hispania 33 59 41 56
5 UD La Guardia Guardia 32 70 41 56
6 CD Villanueva Villanueva 32 51 54 52
7 Huelma CP Huelma CP 32 57 50 51
8 Iliturgi 2016 Iliturgi 33 54 46 50
9 CD Santisteban Santisteban 32 41 51 43
10 CD Vilches CD Vilches 32 46 51 42
11 Arquillos CF Arquillos 32 50 52 40
12 CD Arroyo del Ojanco Arroyo 32 41 57 39
13 Recreativo Bailén Recreativo 33 51 57 38
14 Urgavona CF Urgavona CF 32 55 63 36
15 Quesada CD Quesada CD 32 51 73 33
16 Villargordo CF Villargordo 33 37 81 24
17 CD Castellar Ibero Castellar 32 38 65 22
18 C.D. Torredelcampo C.D. 4 1 16 0
TEMPORADA 2016/2017
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 Navas CD Navas CD 34 102 54 68
2 CD Úbeda Viva Úbeda Viva 33 69 46 61
3 UD La Guardia Guardia 34 77 52 59
4 Real Jaén B Real Jaén 34 64 47 57
5 Urgavona CF Urgavona CF 34 73 57 57
6 CD Hispania CD Hispania 34 52 44 54
7 Baeza CF Baeza CF 34 62 54 53
8 CD Arroyo del Ojanco Arroyo 34 60 48 52
9 Begíjar CF Begíjar CF 34 59 63 48
10 UD Guarroman Guarroman 34 57 50 47
11 CD Vilches CD Vilches 34 54 58 45
12 Arquillos CF Arquillos 34 45 55 45
13 Huelma CP Huelma CP 34 65 87 42
14 Villargordo CF Villargordo 34 50 62 39
15 C.D. Torredelcampo C.D. 34 50 64 38
16 CD Villanueva Villanueva 34 57 77 37
17 Carolinense Carolinense 34 52 73 36
18 Fuensanta CF Fuensanta 33 40 97 16
TEMPORADA 2015/2016
2ª ANDALUZA JAÉN
Equipo PJ GF GC Puntos
1 Linares Deportivo B Linares 30 62 32 61
2 CD Úbeda Viva Úbeda Viva 30 60 31 59
3 Urgavona CF Urgavona CF 30 60 42 58
4 UD La Guardia Guardia 30 46 41 53
5 Navas CD Navas CD 30 58 35 49
6 CD Arroyo del Ojanco Arroyo 29 42 41 46
7 Real Jaén B Real Jaén 30 61 48 45
8 Baeza CF Baeza CF 29 51 43 41
9 CD Hispania CD Hispania 30 42 44 41
10 CD Vilches CD Vilches 30 40 44 41
11 UD Cazorla UD Cazorla 30 47 60 34
12 UD Guarroman Guarroman 30 43 58 33
13 Carolinense Carolinense 30 44 55 33
14 Huelma CP Huelma CP 30 45 60 30
15 AD Lopera AD Lopera 30 32 68 26
16 Club At Arjonilla Club 30 34 65 22
TEMPORADA 2014/2015
3ª ANDALUZA JAÉN GRUPO 1
Equipo PJ GF GC Puntos
1 CD Hispania CD Hispania 24 69 20 58
2 AD Lopera AD Lopera 24 67 31 52
3 Escañolense Escañolense 24 52 22 50
4 Huelma CP Huelma CP 23 63 31 48
5 CD Alcalá Enjoy Alcalá 24 62 34 44
6 Martos CD Martos CD 24 48 37 38
7 Villargordo CF Villargordo 24 56 45 36
8 Atlético Jaén Atlético 24 54 43 35
9 Valdepeñas de Jaén CF Valdepeñas 24 34 49 32
10 Iliturgi CF Iliturgi CF 23 31 58 17
11 UD Cambil UD Cambil 24 25 71 13
12 Mancha Real AD Mancha Real 24 27 54 12
13 Mureño CF Mureño CF 24 21 114 7
14 Veteranos Alcaudete Veteranos 0 0 0 0
TEMPORADA 2011/2012
3ª ANDALUZA JAÉN GRUPO 1
Equipo PJ GF GC Puntos
1 Escañolense Sd Escañolen 22 55 19 50
2 CD Alcalá Enjoy Alcalá 22 59 28 45
3 Club At Arjonilla Club 22 56 21 44
4 At Jaen Fc At Jaen Fc 22 52 45 41
5 Atlético Mengibar Atlético 21 52 25 39
6 Ibros CF Ibros CF 22 61 28 38
7 CD Tuccitana Tuccitana 22 53 33 38
8 CD Hispania CD Hispania 22 41 39 34
9 CD Linares CF 2011 Linares 2011 21 37 24 32
10 Veteranos Alcaudete Veteranos 22 40 51 31
11 Fuensanta CF Fuensanta 22 44 38 29
12 Cd At Higuerense Cf Higuerense 22 33 47 20
13 AD Lopera AD Lopera 22 33 53 14
14 UD Cambil UD Cambil 22 25 71 11
15 Castillo de Locubin Castillo 22 26 96 11
16 Arjona Ad Arjona Ad 22 14 63 10

  USO DE MEMORIA  
5,885,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1191
Total Execution Time  0.1203
  CADENA URL  
/historico/Cd-Hispania-Torredelcampo-Senior
  GET DATOS  
$_GET['/historico/Cd-Hispania-Torredelcampo-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0036  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 = 'Cd-Hispania-Torredelcampo-Senior' 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=8621 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=8621 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 73629
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=8621 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5 AND type_rel = 3
0.0027  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 5 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0028  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 (1267671,1255959,1148089,1109642,1107691) ORDER BY n.cover_points DESC, update_date DESC
0.0029  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 = '8621' ORDER BY l.year DESC,cat.coefficient DESC
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 = '8621' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '8621' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 73629 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  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=8621 AND l.year in (2023,2024,2025) 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 (73629,71778,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.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 73629 AND teamId = 8621
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71778 AND teamId = 8621
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 8621
0.0028  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 = 73629 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '8621' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '8621' 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 = '8621' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 73629 WHERE rp.league_id = 73629 AND rp.teamId = 8621 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.0036  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 = 73629 WHERE rp.league_id = 73629 AND rp.teamId = 8621 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 73629 WHERE rp.league_id = 73629 AND rp.teamId = 8621 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 = 8621 AND l.year <= 2024 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 `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 = 73629 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.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 `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 = 69263 AND t.round = 22 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 `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 = 64175 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 = 44626 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 `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 = 39570 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 `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 = 34150 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 `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 = 16798 AND t.round = 30 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 `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 = 4114 AND t.round = 26 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 `tables2012` 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 = 1834 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC