4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CF Sierra Nevada-Cenes
TEMPORADA 2022/2023
3ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 CD Huetor Tajar Huetor Tajar 29 102 47 66
2 CF Alhendín Balompié B Alhendín 29 105 47 65
3 Español Albolote Español 29 84 41 63
4 Huétor Vega CD Huétor Vega 29 102 51 57
5 Ogijares 89 Ogijares 89 29 86 53 55
6 Club de Futbol Motril Club Futbol 29 67 42 49
7 Zaidin Zaidin 29 74 60 45
8 Maracena B Maracena B 30 61 55 44
9 Otura CF Otura CF 29 84 70 41
10 CF Sierra Nevada-Cenes Sierra 30 83 96 37
11 Arenas de Armilla B Arenas 30 68 78 35
12 Reino De Granada B Reino 30 64 66 34
13 CD UD Illora Illora 29 74 87 33
14 Celtic CF Celtic CF 30 58 99 28
15 CD Cijuela 2008 Cijuela 2008 30 21 105 18
16 U.D. Alfacar U.D. Alfacar 29 38 174 7
TEMPORADA 2021/2022
3ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 C.D. Churriana de la Vega C.D. 29 101 41 66
2 CD Vandalia de Peligros Vandalia 30 89 57 60
3 Atlético La Zubia A Atlético 30 81 42 58
4 Cubillas de Albolote Cubillas 30 76 48 55
5 Otura CF Otura CF 30 82 55 49
6 U.D. Alfacar U.D. Alfacar 30 58 48 49
7 Reino De Granada B Reino 30 71 57 46
8 UD Maracena C Maracena 30 67 63 42
9 CD UD Illora Illora 29 66 70 40
10 Club de Fútbol Estudiantes Club Fútbol 30 72 85 39
11 CF Sierra Nevada-Cenes Sierra 30 85 91 38
12 Fuente Vaqueros Fuente 30 60 74 36
13 Puerto De Motril CF Puerto 29 49 98 30
14 Sporting Vegas del Genil Sporting 30 53 86 27
15 Atletico Salobreña Atletico 30 50 83 27
16 Zaidin Zaidin 29 40 102 16
TEMPORADA 2019/2020
3ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 CF Sierra Nevada-Cenes Sierra 24 59 33 56
2 Huétor Vega CD Huétor Vega 24 68 44 55
3 Zaidin Zaidin 24 63 23 48
4 Fuente Vaqueros Fuente 24 52 37 47
5 CD Ciudad de Granada FF Abo Ciudad 24 61 29 45
6 UD Maracena C Maracena 22 61 42 42
7 At. Padul At. Padul 24 57 50 37
8 C.D. Albolote Soccer Alda A C.D. 24 49 42 37
9 CD Huescar CD Huescar 24 49 48 37
10 Montefrio CF Montefrio 24 48 41 34
11 Granada Origen Granada 24 51 46 34
12 At. La Zubia Zubia 23 33 34 31
13 Ogijares 89 CF Ogijares 24 36 49 29
14 Puerto De Motril CF Puerto 24 40 55 25
15 Gabia Atlético CF Gabia 24 42 58 17
16 Otura CF Otura CF 23 34 63 14
17 Estrellas Parque Nueva Gran Estrellas 24 41 90 11
18 Celtic CF Celtic CF 24 19 79 4

  USO DE MEMORIA  
4,826,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.0770
Total Execution Time  0.0781
  CADENA URL  
/historico/Cf-Sierra-Nevada-Cenes-Juvenil
  GET DATOS  
$_GET['/historico/Cf-Sierra-Nevada-Cenes-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
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 = 'Cf-Sierra-Nevada-Cenes-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.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 = 'Cf-Sierra-Nevada-Cenes-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=127988 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=127988 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=127988 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=127988 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 69713
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=127988 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=753 AND type_rel = 3
0.0024  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 = '127988' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 69713 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=127988 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 (69713) 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.0021  SELECT count(id) as num_players from rel_players_base WHERE league_id = 69713 AND teamId = 127988
0.0019  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2023` 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 = 69713 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '127988' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
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 = '127988' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 = 127988 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0035  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 = 69713 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.0028  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 = 65919 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 `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 = 53859 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC