4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Figueroa CD
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
4ª ANDALUZA CÓRDOBA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Figueroa CD Figueroa CD 20 85 29 50
2 Las Palmeras Palmeras 21 86 35 49
3 El Viso El Viso 19 68 42 36
4 Pozoblanco Pozoblanco 20 57 45 35
5 Atletico Espeleño Atletico 20 55 47 32
6 Asociación de Futbolistas E Asociación 20 62 56 30
7 Salvador Allende Salvador 20 45 54 27
8 Fútbol Base Mellaria Fútbol Base 20 64 54 26
9 La Salle Cordoba Salle 20 31 82 14
10 Palomera Naranjo Cultural Palomera 20 32 74 11
11 Sur Atletismo Atletismo 20 26 83 6
12 CD Los Califas Balompie Califas 1 4 3 3
13 Sur Sub 16 Sur Sub 16 1 2 13 0
TEMPORADA 2020/2021
2ª ANDALUZA CÓRDOBA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Juanin Y Diego Sub 16 Juanin Diego 7 29 6 19
2 Pozoblanco Pozoblanco 8 19 5 19
3 Palma del Rio Atlético Palma 7 25 5 15
4 CD Colonia de Fuente Palmer Colonia 5 11 10 9
5 Figueroa CD Figueroa CD 7 7 13 6
6 Rud La Carlota A Carlota 8 12 27 6
7 Deportivo Córdoba CF Deportivo 8 8 20 4
8 Atlético Villanueva FB Atlético 8 10 35 2
TEMPORADA 2019/2020
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 CD Apedem A CD Apedem A 22 86 18 55
2 Don Bosco CF Sub 16 Bosco 23 66 19 54
3 Pozoblanco Pozoblanco 22 74 24 50
4 Atlético Seneca Atlético 22 85 27 49
5 Juanin Y Diego Sub 16 Juanin Diego 23 63 31 47
6 A.D. Apademar A A.D. 22 61 24 40
7 Futbol Base Egabrense Futbol Base 23 54 43 37
8 Salerm Cosmetics Puente Gen Salerm 23 52 40 33
9 Rud La Carlota A Carlota 22 45 51 31
10 C.D. Stadium C.D. Stadium 22 53 52 29
11 Villa del Rio Servicio Depo Villa 23 44 54 25
12 Figueroa CD Figueroa CD 20 33 44 19
13 Deportivo Córdoba CF Deportivo 21 52 66 19
14 Alcazar CD Alcazar CD 23 24 95 10
15 Baenense Atletico Baenense 23 16 169 3
16 La Rambla de Futbol Base Rambla 16 13 64 1
TEMPORADA 2017/2018
4ª ANDALUZA CÓRDOBA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Ciudad de Cordoba Los Abeto Ciudad 27 143 36 67
2 CD Montoreño Atletico Montoreño 28 122 47 64
3 Alcolea Los Angeles Alcolea 27 119 37 61
4 Villarrubia Villarrubia 27 96 36 58
5 Almodóvar del Río C.F. Almodóvar 27 100 39 54
6 CD El Carpio C.F. Carpio C.F. 27 103 46 54
7 Avejoe Avejoe 27 84 68 40
8 Las Palmeras Palmeras 27 85 86 40
9 Vespertina Perro Verde Horn Vespertina 15 51 35 27
10 Racing Futbol Club de Cordo Racing 27 55 69 27
11 Atletico Guadalquivir Atletico 27 83 98 25
12 Paco Pradas CD Paco Pradas 27 60 127 19
13 Figueroa CD Figueroa CD 27 38 112 17
14 Don Bosco CF C Bosco 27 35 145 12
15 La Salle Cordoba Salle 0 0 0 0
16 Deportivo Cordoba B Deportivo 27 27 220 0
TEMPORADA 2016/2017
4ª ANDALUZA CÓRDOBA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Fray Albino Fray Albino 18 58 21 42
2 Figueroa CD Figueroa CD 18 44 22 39
3 Adeval A Adeval A 18 47 27 38
4 CD Futbol Juanin Y Diego B Futbol 18 66 31 35
5 Peñarroya Pueblonuevo Peñarroya 18 81 34 28
6 Villaviciosa CF Villaviciosa 18 64 62 23
7 Alcázar C.D. B Alcázar 18 34 46 19
8 A.D. Apademar B A.D. 18 23 41 18
9 Granadal Córdoba A Granadal 18 33 57 12
10 CD Deportivo Cordoba CF Deportivo 18 10 119 3
11 Cerro Muriano Cerro 0 0 0 0
TEMPORADA 2015/2016
3ª ANDALUZA CORDOBA CADETE
Equipo PJ GF GC Puntos
1 CD Posadas CF Posadas 33 155 49 85
2 A.D. Apademar A A.D. 33 113 53 75
3 Rud La Carlota A Carlota 33 87 31 70
4 CD Colonia de Fuente Palmer Colonia 33 105 61 61
5 Villafranca C Villafranca 33 118 86 59
6 Los Califas Balompie B Califas 33 67 62 53
7 Atletico Aguilarense Atletico 33 122 124 52
8 La Rambla de Futbol Base Rambla 33 105 82 52
9 Deportivo Cordoba Deportivo 33 85 73 49
10 La Ribera del Guadalquivir Ribera 33 125 126 49
11 CD Hinojosa CD Hinojosa 33 64 59 46
12 C.D. Stadium C.D. Stadium 33 64 90 41
13 CD Castro Del Rio-Cajasol Castro 33 64 74 39
14 Salvador Allende Salvador 33 73 127 30
15 Villa del Rio Servicio Depo Villa 33 65 107 26
16 El Higueron El Higueron 33 63 143 19
17 Peñarroya Pueblonuevo Peñarroya 17 37 57 17
18 Figueroa CD Figueroa CD 33 60 168 5
TEMPORADA 2014/2015
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 Córdoba CF Sub 16 Córdoba 28 114 25 78
2 Atlético Seneca Atlético 28 89 30 68
3 Los Califas Balompie Califas 28 94 39 64
4 Salvador Allende Salvador 28 67 51 49
5 Egabrense FB Egabrense 28 61 47 44
6 Lucena Lucena 28 68 56 41
7 Montalbeño Montalbeño 28 40 48 38
8 Deportivo Córdoba CF Deportivo 28 54 43 37
9 Pozoblanco Pozoblanco 28 55 44 36
10 Palma del Rio Atlético Palma 28 46 55 36
11 Atlético Villanueva FB Atlético 28 50 76 32
12 Salerm Cosmetics Puente Gen Salerm 28 38 79 25
13 Palomera-Naranjo Palomera-Nar 28 46 99 17
14 A.D. Apademar A A.D. 28 45 98 14
15 Peñarroya Pueblonuevo Peñarroya 28 25 102 11
16 Figueroa CD Figueroa CD 0 0 0 0

  USO DE MEMORIA  
5,543,048 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1241
Total Execution Time  0.1255
  CADENA URL  
/historico/Figueroa-Cd-Cadete
  GET DATOS  
$_GET['/historico/Figueroa-Cd-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0027  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 = 'Figueroa-Cd-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.0035  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 = 'Figueroa-Cd-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.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=25260 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=25260 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=25260 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=25260 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=25260 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=25260 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=25260 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=25260 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=25260 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=25260 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=25260 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=25260 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0029  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 = 70185
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25260 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=759 AND type_rel = 3
0.0022  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 = '25260' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 70185 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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=25260 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0019  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,70162,66115) 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.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70162 AND teamId = 25260
0.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70185 AND teamId = 25260
0.0020  SELECT count(id) as num_players from rel_players_base WHERE league_id = 66115 AND teamId = 25260
0.0021  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 = '25260' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '25260' 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 = '25260' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0026  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 = 25260 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 70162 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_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.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 `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.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_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 = 66115 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.0020  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 = 59758 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 52410 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.0027  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 = 40581 AND t.round = 30 ORDER BY team.conference 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 `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 = 40635 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 34357 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 17288 AND t.round = 34 ORDER BY team.conference 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 `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 = 4866 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC