4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Ciudad de Granada B
TEMPORADA 2021/2022
2ª ANDALUZA GRANADA CADETE
Equipo PJ GF GC Puntos
1 Atarfe Industrial Sub 16 Atarfe 30 120 43 71
2 Santa Fe Santa Fe 30 101 36 67
3 Estrellas Chana Barrio B Estrellas 30 77 40 64
4 CD Medina Lauxa Medina Lauxa 30 64 32 64
5 Español Albolote Sub 16 Español 30 64 30 62
6 Reino de Granada Reino 29 77 46 58
7 Arenas de Armilla C Arenas 30 55 55 47
8 CD Ciudad de Granada B Ciudad 29 71 73 40
9 CD Huescar CD Huescar 30 64 79 40
10 Ogijares 89 Ogijares 89 30 71 74 39
11 UD Motril UD Motril 30 66 76 38
12 Sierra Nevada Cenes Sierra 30 42 79 29
13 Ciudad de Baza Ciudad Baza 30 76 96 28
14 Atlético La Zubia Atlético 30 47 93 18
15 Guadix Atletico Guadix 28 36 112 13
16 UD Maracena B Maracena 30 49 116 11
TEMPORADA 2019/2020
2ª ANDALUZA GRANADA CADETE
Equipo PJ GF GC Puntos
1 Atarfe Industrial Sub 16 Atarfe 21 72 26 51
2 Calahonda-Carchuna Calahonda-Ca 21 45 28 49
3 Santa Fe Santa Fe 21 78 19 48
4 CD We Futbol Club B Futbol Club 21 53 22 47
5 Medina Lauxa Medina Lauxa 21 52 36 36
6 Reino de Granada Reino 21 41 44 34
7 Vandalia de Peligros Vandalia 21 33 39 30
8 Ogijares 89 A Ogijares 21 48 48 27
9 Ciudad de Baza Ciudad Baza 21 35 43 27
10 Zaidin Zaidin 21 45 49 26
11 CD Ciudad de Granada B Ciudad 21 44 39 23
12 C.D. Huetor Tajar C.D. Huetor 21 42 56 23
13 Arenas de Armilla B Arenas 21 33 48 16
14 U.D. Motril A U.D. Motril 21 25 62 16
15 Celtic Celtic 21 31 73 11
16 UD Maracena B Maracena 21 26 71 9
TEMPORADA 2018/2019
2ª ANDALUZA GRANADA CADETE
Equipo PJ GF GC Puntos
1 Arenas de Armilla Sub 16 Arenas 32 116 39 78
2 Ciudad de Baza Ciudad Baza 32 115 42 70
3 CD Ciudad de Granada B Ciudad 32 80 43 68
4 Zaidin Zaidin 32 82 39 66
5 Atarfe Industrial Sub 16 Atarfe 32 101 49 62
6 CD We Futbol Club B Futbol Club 32 84 43 62
7 C.D. Huetor Tajar C.D. Huetor 32 86 48 55
8 UD Maracena B Maracena 32 52 46 49
9 Vandalia de Peligros Vandalia 32 63 68 46
10 Santa Fe Santa Fe 32 44 56 45
11 Ogijares 89 Ogijares 89 32 61 61 43
12 Puerto de Motril Puerto 32 51 84 28
13 Motril B Motril B 32 48 102 28
14 Illora Illora 32 47 98 22
15 Albolote Soccer Alda Albolote 32 39 114 20
16 Huescar Huescar 32 39 102 19
17 Granada Origen Granada 32 46 120 13
TEMPORADA 2017/2018
2ª ANDALUZA GRANADA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Granada CF Sub 16 Granada 28 177 10 81
2 Arenas de Armilla Sub 16 Arenas 28 169 34 68
3 Huetor Vega Huetor Vega 28 120 37 67
4 UD Maracena B Maracena 28 94 63 55
5 CD Ciudad de Granada B Ciudad 28 126 66 53
6 We Futbol Club Sub 16 Futbol Club 28 79 35 51
7 Granada Origen Granada 28 87 71 41
8 Ogijares 89 Ogijares 89 28 73 50 38
9 Puerto de Motril Puerto 28 62 64 37
10 Calahonda-Carchuna Calahonda-Ca 28 78 76 36
11 Granada Base Granada Base 28 72 93 32
12 Otura CF. Otura CF. 28 36 112 20
13 Atlético La Zubia Atlético 28 56 136 16
14 Almuñecar 77 Almuñecar 28 22 193 9
15 Cullar Vega Base Cullar Vega 28 27 238 3
16 Estrellas Chana Barrio A Estrellas 0 0 0 0
TEMPORADA 2016/2017
3ª ANDALUZA GRANADA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Ogijares 89 Ogijares 89 22 124 32 60
2 CD Ciudad de Granada B Ciudad 22 108 18 55
3 Atletismo Padul Atletismo 22 114 34 54
4 Juventud Sexitana Juventud 22 76 58 41
5 Albuñol Albuñol 22 70 42 40
6 Motril B Motril B 21 60 80 26
7 Orgiva Orgiva 21 50 75 23
8 Puerto de Motril Puerto 20 38 66 23
9 Durcal Durcal 22 49 88 20
10 La Malaha La Malaha 22 47 91 16
11 Atletico de Ogijares Atletico 20 24 114 7
12 Club Baloncesto Alhendin Club 22 21 83 6
TEMPORADA 2015/2016
4ª ANDALUZA GRANADA CADETE GRUPO 3
Equipo PJ GF GC Puntos
1 Colegio Mulhacen Colegio 22 128 22 56
2 Huetor Vega Huetor Vega 22 110 54 51
3 Ogijares 89 Ogijares 89 22 63 27 45
4 CD Ciudad de Granada B Ciudad 22 84 55 41
5 Granada Noroeste Granada 22 56 44 34
6 Monachil Monachil 22 57 69 32
7 Granada Origen Granada 22 62 44 32
8 Sierra Nevada Cenes Sierra 22 50 69 30
9 Armilla Armilla 22 42 65 25
10 Atlético La Zubia Atlético 22 36 109 15
11 Zaidin Zaidin 22 51 98 15
12 Atletico de Ogijares Atletico 22 17 100 2
TEMPORADA 2014/2015
4ª ANDALUZA GRANADA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Zaidin Zaidin 23 130 24 57
2 WE FC WE FC 22 109 42 54
3 Dama de Baza BM Dama Baza 22 111 33 52
4 Comarca Los Montes Comarca 22 76 51 43
5 Sierra Nevada-Cenes A Sierra 23 58 55 40
6 Guadix B Guadix B 23 56 48 38
7 Huetor Vega Huetor Vega 22 67 60 32
8 CD Ciudad de Granada B Ciudad 23 71 67 32
9 Granada Noroeste Granada 23 81 100 26
10 La Zubia B La Zubia B 23 53 83 25
11 Iznalloz Iznalloz 22 53 76 24
12 Nazari Nazari 23 53 94 19
13 Granada Origen Granada 23 56 100 15
14 Huescar Huescar 0 0 0 0
15 Albolote Soccer Alda B Albolote 22 10 151 0

  USO DE MEMORIA  
5,310,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.6056
Total Execution Time  0.6068
  CADENA URL  
/historico/Ciudad-De-Granada-Ff-B-Cadete
  GET DATOS  
$_GET['/historico/Ciudad-De-Granada-Ff-B-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
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 = 'Ciudad-De-Granada-Ff-B-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.0205  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 = 'Ciudad-De-Granada-Ff-B-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.0145  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=25342 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=25342 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=25342 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=25342 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=25342 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=25342 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=25342 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  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=25342 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0161  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 = 66041
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25342 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=532 AND type_rel = 3
0.0148  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '25342' ORDER BY l.year DESC,cat.coefficient DESC
0.0148  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '25342' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '25342' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = '25342' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = 66041 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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=25342 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (66041) 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.0145  SELECT count(id) as num_players from rel_players_base WHERE league_id = 66041 AND teamId = 25342
0.0147  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2022` 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 = 66041 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0148  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 = '25342' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '25342' and rp.type = 4
0.0148  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 = '25342' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0153  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 = 25342 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0157  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 = 66041 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.0149  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 = 52415 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.0150  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 = 45906 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 40488 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 17372 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 4871 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 66041 ORDER BY nameShow LIMIT 100