4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Deportivo Cordoba CF
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

  USO DE MEMORIA  
4,585,696 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.6603
Total Execution Time  0.6617
  CADENA URL  
/historico/Cd-Deportivo-Cordoba-Cf-Cadete
  GET DATOS  
$_GET['/historico/Cd-Deportivo-Cordoba-Cf-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0262  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 = 59535
0.0023  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=128168 AND type_rel = 2
0.0029  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=760 AND type_rel = 3
0.1166  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 = '128168' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0827  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 = '128168' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0666  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 = 59535 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.1224  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=128168 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0096  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 (59535) 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.0046  SELECT count(id) as num_players from rel_players_base WHERE league_id = 59535 AND teamId = 128168
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 FROM `tables2021` 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 = '128168' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0221  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 = '128168' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0263  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 = 128168 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0824  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.0426  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.0220  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 59535 ORDER BY nameShow LIMIT 100