4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Salvador Allende
TEMPORADA 2022/2023
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 Córdoba Cf Sub 16 Córdoba 30 114 21 82
2 Don Bosco CF Sub 16 Bosco 30 98 30 69
3 CD Los Califas Balompie Califas 30 88 40 65
4 Atlético Seneca Atlético 30 81 29 62
5 Figueroa CD Figueroa CD 30 97 59 57
6 CD Apedem A CD Apedem A 30 80 51 54
7 Lucecor FS Lucecor FS 30 103 64 53
8 Pozoblanco Pozoblanco 30 105 68 47
9 Palma del Rio Atlético Palma 30 81 64 45
10 Salerm Cosmetics Puente Gen Salerm 30 69 78 45
11 Salvador Allende Salvador 30 50 80 32
12 CD de Futbol Juanin Y Diego Futbol 30 45 68 25
13 Rud La Carlota B Carlota 30 41 142 19
14 A.D. Apademar A A.D. 30 35 101 18
15 C.D. Stadium C.D. Stadium 30 30 102 12
16 Fundacion Lucena Fundacion 30 28 148 6
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
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
3ª ANDALUZA CORDOBA CADETE
Equipo PJ GF GC Puntos
1 Menciano Atletico Menciano 21 57 27 44
2 Don Bosco CF B Bosco 20 57 25 43
3 CD Colonia de Fuente Palmer Colonia 20 78 51 43
4 Atlético Villanueva FB Atlético 21 71 40 42
5 Palma del Rio Atlético Palma 21 72 35 41
6 Palomera-Naranjo CDCultural Palomera-Nar 21 73 48 39
7 Fundacion Lucena FC A Fundacion 20 70 48 35
8 Ciudad Jardin CD Ciudad 21 58 47 30
9 Bujalance Futbol Base AD Bujalance 20 37 31 30
10 CD Posadas CF Posadas 21 69 73 30
11 Salvador Allende Salvador 20 42 43 24
12 Montemayor Atletico CD Montemayor 20 23 65 14
13 CD Deportivo Cordoba CF Deportivo 21 24 85 11
14 CD Futbol Juanin Y Diego B Futbol 21 26 79 7
15 Salerm Cosmetics Puente Gen Salerm 20 27 87 7
16 Peñarroya Pueblonuevo CF Peñarroya 0 0 0 0
TEMPORADA 2018/2019
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 CD Los Califas Balompie Califas 30 115 19 75
2 CD Deportivo Cordoba CF Deportivo 30 104 30 72
3 A.D. Apademar A A.D. 30 104 32 72
4 Juanin Y Diego Sub 16 Juanin Diego 30 107 24 69
5 Atlético Seneca Atlético 30 109 25 64
6 Don Bosco CF Sub 16 Bosco 30 91 39 62
7 CD Apedem A CD Apedem A 30 70 57 45
8 Futbol Base Egabrense Futbol Base 30 72 56 41
9 C.D. Stadium C.D. Stadium 30 79 105 39
10 Villa del Rio Servicio Depo Villa 30 56 75 33
11 Rud La Carlota A Carlota 30 67 81 32
12 Alcazar CD Alcazar CD 30 41 100 28
13 Fundacion Lucena Fundacion 30 37 89 23
14 Palma del Rio Atlético Palma 30 52 152 21
15 Atlético Villanueva FB Atlético 30 48 123 15
16 Salvador Allende Salvador 30 15 160 7
TEMPORADA 2017/2018
4ª ANDALUZA CÓRDOBA CADETE GRUPO 3
Equipo PJ GF GC Puntos
1 CD Futbol Juanin Y Diego B Futbol 30 118 25 76
2 A.D. Apademar B A.D. 30 73 27 71
3 Peñarroya Pueblonuevo Peñarroya 30 97 25 69
4 CD Hinojosa CD Hinojosa 30 93 34 66
5 Salvador Allende Salvador 30 93 44 58
6 El Viso El Viso 30 96 57 53
7 CD Deportivo Cordoba CF Deportivo 30 90 80 51
8 Pozoblanco Pozoblanco 30 81 52 48
9 Alcázar C.D. B Alcázar 30 71 49 48
10 Sur Sub 16 Sur Sub 16 30 63 94 31
11 Los Califas Balompie B Califas 30 46 98 27
12 Parque Cruz Conde Parque Cruz 30 47 72 26
13 Ciudad de Cordoba Gaspar Ga Ciudad 30 60 107 26
14 C.D. Pozoblanco B C.D. 30 46 127 20
15 Ciudad Jardin CD Ciudad 30 53 117 17
16 Racing Futbol Club de Cordo Racing 30 13 132 4
TEMPORADA 2016/2017
3ª ANDALUZA CORDOBA CADETE
Equipo PJ GF GC Puntos
1 Fundacion Lucena Fundacion 26 139 37 68
2 Atletico Baenense Atletico 26 112 46 65
3 Juanin Y Diego Sub 16 Juanin Diego 26 113 36 62
4 Alcazar CD Alcazar CD 27 99 43 57
5 Atlético Villanueva FB Atlético 26 86 48 45
6 El Higueron El Higueron 27 75 75 43
7 Salvador Allende Salvador 26 75 49 42
8 Villa del Rio Servicio Depo Villa 26 60 59 39
9 La Rambla de Futbol Base Rambla 26 71 73 37
10 C.D. Stadium C.D. Stadium 26 59 80 27
11 CD Posadas CF Posadas 26 58 87 25
12 Deportivo Cordoba Deportivo 26 38 81 17
13 Los Califas Balompie B Califas 26 25 154 6
14 Parque Cruz Conde Parque Cruz 26 19 154 3
TEMPORADA 2014/2015
4ª ANDALUZA CÓRDOBA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 CD Posadas CF Posadas 20 103 23 53
2 El Higueron El Higueron 20 91 31 46
3 CD El Carpio C.F. Carpio C.F. 20 85 34 45
4 Bujalance FB Bujalance 20 77 57 41
5 Las Palmeras Palmeras 20 81 43 36
6 Atlético Palma del Rio Atlético 20 59 70 23
7 Parque Cruz Conde Parque Cruz 20 45 64 22
8 Paco Pradas CD Paco Pradas 20 52 73 21
9 Salvador Allende Salvador 20 38 72 19
10 Los Califas Balompie Califas 20 53 99 13
11 Vespertina Perra Verde-Horn Vespertina 20 21 139 4
12 CD Montoreño Atletico Montoreño 0 0 0 0

  USO DE MEMORIA  
5,397,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5867
Total Execution Time  0.5879
  CADENA URL  
/historico/Salvador-Allende-Ud-Cadete
  GET DATOS  
$_GET['/historico/Salvador-Allende-Ud-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0137  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 = 'Salvador-Allende-Ud-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.0152  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 = 'Salvador-Allende-Ud-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=25377 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=25377 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=25377 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=25377 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=25377 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124  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=25377 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124  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=25377 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124  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=25377 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124  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=25377 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124  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=25377 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=25377 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=25377 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=25377 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0137  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 = 70162
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25377 AND type_rel = 2
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=759 AND type_rel = 3
0.0138  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 = '25377' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0135  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 = 70162 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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=25377 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0129  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 (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.0131  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70162 AND teamId = 25377
0.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 66115 AND teamId = 25377
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 = 25377 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0143  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.0142  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.0142  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.0132  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 = 52783 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.0133  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 = 53883 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.0132  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 = 45915 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 40490 AND t.round = 30 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 `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.0128  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 = 40637 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 34358 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 35352 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 4874 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC