4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hinojosa
TEMPORADA 2021/2022
3ª ANDALUZA CÓRDOBA JUVENIL
Equipo PJ GF GC Puntos
1 CD Futbol Juanin Y Diego B Futbol 25 74 29 61
2 CD Colonia de Fuente Palmer Colonia 26 68 47 49
3 Apademar Apademar 26 61 40 48
4 Don Bosco CF B Bosco 26 63 41 46
5 RUD La Carlota Carlota 26 69 58 45
6 C.D. Stadium C.D. Stadium 25 61 43 43
7 Salerm Puente Genil Sub 19 Salerm 26 58 58 36
8 Villa del Rio Servicio Depo Villa 26 53 55 31
9 Ciudad Jardin CD Ciudad 26 40 53 31
10 Atco. Villanueva F.B. Atco. 25 41 54 27
11 Montalbeño Montalbeño 25 28 36 26
12 Hinojosa Hinojosa 25 40 62 24
13 Bujalance Bujalance 26 37 61 19
14 CD Posadas CF Posadas 24 38 88 19
15 CD Pozoblanco B Pozoblanco 0 0 0 0
16 Parque Cruz Conde CF Parque Cruz 1 0 6 0
TEMPORADA 2020/2021
3ª ANDALUZA CÓRDOBA JUVENIL
Equipo PJ GF GC Puntos
1 Palomera-Naranjo CDCultural Palomera-Nar 24 67 22 56
2 CD Priego CF Priego 24 47 17 53
3 Villa del Rio Servicio Depo Villa 24 48 36 51
4 CD Posadas CF Posadas 24 62 35 46
5 Salerm Puente Genil Sub 19 Salerm 24 49 26 45
6 Ciudad Jardin CD Ciudad 24 46 35 37
7 C.D. Stadium C.D. Stadium 24 66 53 31
8 Parque Cruz Conde CF Parque Cruz 24 39 48 27
9 C.D. Deportivo Cordoba C.F. C.D. 24 40 58 27
10 CD Futbol Juanin Y Diego B Futbol 24 35 53 24
11 Hinojosa Hinojosa 23 29 45 21
12 Fundacion Lucena B Fundacion 23 28 70 11
13 CD El Higuerón Higuerón 24 25 83 5
14 Almodóvar del Río C.F. Almodóvar 0 0 0 0
TEMPORADA 2019/2020
4ª ANDALUZA CÓRDOBA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Hinojosa Hinojosa 21 68 16 52
2 Peñarroya Pueblonuevo Peñarroya 21 50 25 46
3 CD Deportivo Cordoba CF C Deportivo 21 44 45 33
4 Palomera-Naranjo Palomera-Nar 21 44 32 32
5 C.D. Alcázar B C.D. 21 41 43 29
6 C.D. Atletico Espeleño C.D. 21 31 30 28
7 El Viso C.D. A.D. Viso C.D. A. 21 46 50 27
8 Ud Salvador Allende Salvador 21 34 37 26
9 Figueroa CD B Figueroa 21 28 49 25
10 Apademar B Apademar B 21 31 46 20
11 Balona Balompie Balona 21 20 31 18
12 CD Alcolea Los Angeles UD Alcolea 21 35 68 18
TEMPORADA 2018/2019
4ª ANDALUZA CÓRDOBA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 CD Pozoblanco Sub 19 Pozoblanco 22 66 27 57
2 Parque Cruz Conde CF Parque Cruz 22 73 27 53
3 CD Futbol Juanin Y Diego B Futbol 22 89 21 52
4 C.D. Atletico Espeleño C.D. 22 65 24 43
5 Apademar B Apademar B 22 65 32 38
6 C.D. Alcázar B C.D. 21 51 41 32
7 Hinojosa Hinojosa 21 43 43 24
8 Figueroa CD B Figueroa 22 43 52 24
9 El Viso C.D. A.D. Viso C.D. A. 21 50 60 24
10 Palomera-Naranjo Palomera-Nar 22 57 63 19
11 La Ribera del Guadalquivir Ribera 22 11 117 7
12 Domcor Domcor 21 14 120 6
TEMPORADA 2017/2018
4ª ANDALUZA CÓRDOBA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 CD Futbol Juanin Y Diego Futbol 23 117 26 56
2 Ciudad Jardin CD Ciudad 22 77 30 56
3 CD AD Miralbaida Miralbaida 22 81 36 52
4 Hinojosa Hinojosa 24 59 21 47
5 Los Califas Balompie Califas 21 60 37 38
6 Parque Cruz Conde CF Parque Cruz 22 47 44 34
7 Apademar B Apademar B 23 52 58 32
8 Palomera-Naranjo Palomera-Nar 23 39 68 23
9 Figueroa CD B Figueroa 23 35 64 21
10 C.D. Atletico Espeleño C.D. 22 26 76 12
11 UD Sur UD Sur 15 22 42 8
12 Belmezano Belmezano 19 16 73 8
13 UD Las Palmeras Palmeras 5 15 15 6
14 El Naranjo El Naranjo 12 10 66 3
TEMPORADA 2016/2017
4ª ANDALUZA CÓRDOBA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Don Bosco CF B Bosco 26 73 36 54
2 Villarrubia Villarrubia 25 82 40 53
3 La Ribera del Guadalquivir Ribera 25 82 49 49
4 CD Posadas CF Posadas 25 71 43 48
5 Apademar B Apademar B 26 63 55 47
6 El Viso C.D. A.D. Viso C.D. A. 26 75 62 46
7 El Naranjo El Naranjo 25 47 51 39
8 Villaviciosa CF Villaviciosa 25 72 62 38
9 Hinojosa Hinojosa 26 50 51 37
10 Ciudad Jardin CD Ciudad 26 50 74 28
11 Palma del Rio Palma 20 26 33 22
12 Ud Salvador Allende Salvador 25 39 62 19
13 CD Alcolea Los Angeles UD Alcolea 26 23 75 14
14 Almodovar del Rio Almodovar 26 27 87 7
15 CD AD Miralbaida Miralbaida 0 0 0 0
16 UD Las Palmeras Palmeras 0 0 0 0
TEMPORADA 2015/2016
4ª ANDALUZA CÓRDOBA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Belalcazar UD Belalcazar 15 48 11 41
2 El Viso C.D. A.D. Viso C.D. A. 16 43 20 38
3 Los Califas Balompie Califas 15 50 23 31
4 Cerro Muriano Cerro 16 48 33 29
5 Ud Salvador Allende Salvador 15 51 31 27
6 Hinojosa Hinojosa 16 41 33 26
7 Villaviciosa CF Villaviciosa 15 26 27 21
8 Figueroa CD B Figueroa 15 34 36 17
9 Villarrubia Villarrubia 15 32 45 15
10 CD Alcolea Los Angeles UD Alcolea 14 21 51 5
11 Alcazar CD Alcazar CD 15 19 64 5
12 Fuente Obejuna Fuente 15 20 59 3
13 Belmezano Belmezano 0 0 0 0
TEMPORADA 2014/2015
4ª ANDALUZA CÓRDOBA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Villanueva del Duque Villanueva 20 72 29 52
2 La Ribera del Guadalquivir Ribera 20 75 28 48
3 CD El Higuerón Higuerón 20 63 29 48
4 Fray Albino Fray Albino 20 39 43 31
5 Hinojosa Hinojosa 20 59 58 30
6 Cerro Muriano Cerro 20 46 51 26
7 El Viso C.D. A.D. Viso C.D. A. 20 45 66 25
8 CD Alcolea Los Angeles UD Alcolea 20 52 71 22
9 Villarrubia Villarrubia 20 54 61 19
10 Alcazar CD Alcazar CD 20 29 65 9
11 Belmezano Belmezano 20 26 59 8
12 Fuente Obejuna Fuente 0 0 0 0

  USO DE MEMORIA  
5,345,696 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1189
Total Execution Time  0.1201
  CADENA URL  
/historico/Hinojosa-Juvenil
  GET DATOS  
$_GET['/historico/Hinojosa-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0025  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 = 'Hinojosa-Juvenil' 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.0028  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 = 'Hinojosa-Juvenil' 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.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=25250 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=25250 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=25250 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=25250 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=25250 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=25250 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=25250 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=25250 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=25250 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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 = 65918
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25250 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=754 AND type_rel = 3
0.0021  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 = '25250' ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '25250' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '25250' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = '25250' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 65918 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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=25250 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (65918) 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.0022  SELECT count(id) as num_players from rel_players_base WHERE league_id = 65918 AND teamId = 25250
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 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 = 65918 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0030  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 = '25250' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0023  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '25250' and rp.type = 4
0.0029  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 = '25250' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0043  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 = 25250 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0037  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_base` 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 = 65918 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.0038  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_base` 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 = 59760 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.0045  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_base` 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 = 52246 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.0045  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_base` 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 = 45827 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0050  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_base` 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 = 40051 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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_base` 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 = 34212 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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_base` 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 = 17068 AND t.round = 18 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 `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 = 4865 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC