4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD AD Miralbaida
TEMPORADA 2022/2023
3ª ANDALUZA CORDOBA CADETE
Equipo PJ GF GC Puntos
1 Calvario Priego CF Calvario 26 103 21 76
2 Séneca CF Sub 16 Séneca 26 78 28 65
3 La Rambla de Futbol Base Rambla 26 66 46 50
4 Palomera Naranjo Cultural Palomera 26 65 45 44
5 Don Bosco CF Sub 16 Bosco 26 65 47 44
6 Futbol Base Egabrense Futbol Base 26 57 52 43
7 Bujalance Futbol Base AD Bujalance 26 51 58 35
8 Figueroa CD Figueroa CD 26 54 57 31
9 CD AD Miralbaida Miralbaida 26 41 74 30
10 CD Posadas CF Posadas 26 53 59 28
11 Salerm Cosmetics Puente Gen Salerm 26 47 62 27
12 Montalbeño Montalbeño 26 41 65 26
13 Ciudad Jardin CD Ciudad 26 34 83 14
14 Atlético Villanueva FB Atlético 26 27 85 6
15 Alcázar Alcázar 0 0 0 0
16 Fundacion Lucena Fundacion 0 0 0 0
TEMPORADA 2021/2022
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 Juanin Y Diego Sub 16 Juanin Diego 28 86 23 67
2 Fundacion Lucena Fundacion 28 100 42 59
3 Figueroa CD Figueroa CD 28 71 36 56
4 CD Los Califas Balompie Califas 28 75 58 55
5 Atlético Seneca Atlético 28 88 37 53
6 CD Apedem A CD Apedem A 28 69 40 53
7 Don Bosco CF Sub 16 Bosco 28 45 40 47
8 A.D. Apademar A A.D. 28 61 69 39
9 Salerm Cosmetics Puente Gen Salerm 28 63 56 37
10 Pozoblanco Pozoblanco 28 59 75 32
11 C.D. Stadium C.D. Stadium 28 50 95 23
12 Salvador Allende Salvador 28 43 62 22
13 Futbol Base Egabrense Futbol Base 28 58 101 21
14 Palomera Naranjo Cultural Palomera 28 39 81 20
15 CD AD Miralbaida Miralbaida 28 27 119 11
16 Alcazar CD Alcazar CD 0 0 0 0
TEMPORADA 2020/2021
3ª ANDALUZA CORDOBA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Salvador Allende Salvador 8 21 5 20
2 Don Bosco CF B Bosco 9 26 14 19
3 Ciudad Jardin CD Ciudad 8 15 11 14
4 CD AD Miralbaida Miralbaida 7 23 8 13
5 A.D. Apademar A A.D. 10 25 30 11
6 Peñarroya Pueblonuevo CF Peñarroya 7 17 20 10
7 Villa del Rio Servicio Depo Villa 7 15 31 6
8 Bujalance Futbol Base AD Bujalance 7 9 20 2
9 CD Deportivo Cordoba CF Deportivo 5 5 17 1
TEMPORADA 2019/2020
4ª ANDALUZA CÓRDOBA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 CD AD Miralbaida Miralbaida 20 103 30 46
2 CD Colonia de Fuente Palmer Colonia 21 83 48 46
3 Alcázar C.D. B Alcázar 21 64 29 44
4 La Ribera del Guadalquivir Ribera 20 68 42 39
5 Atlético Seneca B Atlético 20 75 36 38
6 Paco Pradas CD Paco Pradas 20 59 29 37
7 Almodóvar del Río C.F. Almodóvar 21 51 49 32
8 Figueroa CD C Figueroa 20 51 47 28
9 Don Bosco CF C Bosco 20 31 63 17
10 Vespertina Perro Verde Horn Vespertina 21 51 118 17
11 Ciudad de Cordoba Los Abeto Ciudad 20 37 56 13
12 Los Califas Balompie Califas 20 29 73 13
13 Racing Futbol Club de Cordo Racing 20 24 106 4
TEMPORADA 2018/2019
4ª ANDALUZA CÓRDOBA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Montemayor Atletico Montemayor 20 73 16 56
2 El Higueron El Higueron 20 90 43 50
3 CD AD Miralbaida Miralbaida 20 82 33 45
4 CD de Futbol Juanin Y Diego Futbol 20 61 31 35
5 Almodóvar del Río C.F. Almodóvar 20 66 50 26
6 Figueroa CD C Figueroa 20 46 55 21
7 La Victoria CF Victoria 20 50 85 21
8 Paco Pradas CD Paco Pradas 20 55 73 19
9 Villarrubia Villarrubia 20 42 60 18
10 CD Colonia de Fuente Palmer Colonia 20 32 67 14
11 Rud La Carlota B Carlota 20 33 117 10
12 Atletico Guadalquivir Atletico 0 0 0 0
TEMPORADA 2015/2016
4ª ANDALUZA CÓRDOBA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 El Viso El Viso 18 94 20 47
2 CD Deportivo Cordoba CF Deportivo 18 50 26 43
3 Alcazar CD Alcazar CD 18 79 35 40
4 Fuente Obejuna Fuente 18 54 52 26
5 Villaviciosa CF Villaviciosa 18 44 43 25
6 Alcolea Los Angeles Alcolea 18 47 44 22
7 Cerro Muriano Cerro 18 35 80 19
8 Adeval Adeval 18 28 63 18
9 Fray Albino Fray Albino 18 41 54 15
10 Recreativo Belmezano Recreativo 18 17 72 7
11 Calahorra Calahorra 0 0 0 0
12 CD AD Miralbaida Miralbaida 0 0 0 0
13 Ciudad de Cordoba Los Abeto Ciudad 0 0 0 0

  USO DE MEMORIA  
5,100,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.4368
Total Execution Time  0.4384
  CADENA URL  
/historico/Miralbaida-Cd-Ad-Cadete
  GET DATOS  
$_GET['/historico/Miralbaida-Cd-Ad-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0129  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 = 'Miralbaida-Cd-Ad-Cadete' 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.0136  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 = 'Miralbaida-Cd-Ad-Cadete' 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=69376 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=69376 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=69376 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=69376 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=69376 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=69376 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=69376 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=69376 AND type_rel = 2
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=760 AND type_rel = 3
0.0135  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 = '69376' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0137  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=69376 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0136  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 (70185,66040) 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.0130  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70185 AND teamId = 69376
0.0131  SELECT count(id) as num_players from rel_players_base WHERE league_id = 66040 AND teamId = 69376
0.0131  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 = '69376' 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 = '69376' 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 = '69376' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 69376 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2023_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 = 70185 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.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 `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 = 66040 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.0139  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 = 59535 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `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 = 52782 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.0127  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 = 45943 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 `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 = 17374 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC