4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ciudad de Baza 2017
TEMPORADA 2021/2022
2ª ANDALUZA GRANADA INFANTIL
Equipo PJ GF GC Puntos
1 Arenas de Armilla Sub 14 Arenas 30 161 22 87
2 Reino de Granada Reino 30 108 35 70
3 Ciudad de Granada Sub 14 Ciudad 30 57 40 52
4 Medina Lauxa Sub 14 Medina Lauxa 30 62 49 50
5 Motril Motril 30 84 65 47
6 Huetor Tajar Huetor Tajar 30 64 53 47
7 CD Santa Fe A Santa 30 64 57 47
8 We Sub 14 We Sub 14 30 53 46 46
9 Guadix Atletico Guadix 30 45 56 45
10 Ciudad de Baza 2017 Ciudad Baza 30 66 57 44
11 Ogijares 89 Cf Ogijares 30 63 78 41
12 Sierra Nevada Cenes Sierra 30 43 67 33
13 Español Albolote Sub 14 Español 30 44 58 31
14 Mutrayil Mutrayil 30 49 93 19
15 Atarfe Industrial Cf Atarfe 30 23 130 11
16 Zaidin Zaidin 30 25 105 9
TEMPORADA 2020/2021
2ª ANDALUZA GRANADA INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Granada Sub 14 B Granada 5 28 3 15
2 Español Albolote Sub 14 Español 6 27 10 12
3 Atarfe Industrial Cf Atarfe 4 19 4 12
4 Ciudad de Baza 2017 Ciudad Baza 6 10 13 7
5 CD Santa Fe A Santa 4 9 14 6
6 Medina Lauxa Sub 14 Medina Lauxa 6 13 13 5
7 Huetor Tajar Huetor Tajar 4 9 12 4
8 Cd Huescar Cd Huescar 6 12 30 4
9 Illora Illora 5 4 32 1
TEMPORADA 2019/2020
2ª ANDALUZA GRANADA INFANTIL
Equipo PJ GF GC Puntos
1 UD Maracena UD Maracena 21 102 8 60
2 Granada Sub 14 B Granada 21 55 26 50
3 Ciudad de Baza 2017 Ciudad Baza 21 89 45 42
4 CD Ciudad de Granada B Ciudad 21 62 45 42
5 Arenas de Armilla Cultura Y Arenas 21 58 23 41
6 Motril Motril 21 53 44 35
7 Huetor Tajar Huetor Tajar 21 45 46 34
8 Reino de Granada Reino 21 61 52 29
9 Atarfe Industrial Cf Atarfe 21 50 62 29
10 We Fútbol Club B Fútbol Club 21 49 54 27
11 Cd Huescar Cd Huescar 21 48 65 26
12 Medina Lauxa Sub 14 Medina Lauxa 21 36 56 22
13 Calahonda-Carchuna Calahonda-Ca 21 37 57 20
14 Sierra Nevada Cenes Sierra 21 28 85 10
15 Sporting Club Vegas del Gen Sporting 21 24 75 7
16 CD Santa Fe B Santa 21 28 82 6
TEMPORADA 2018/2019
2ª ANDALUZA GRANADA INFANTIL
Equipo PJ GF GC Puntos
1 CD Santa Fe A Santa 30 148 28 80
2 UD Maracena UD Maracena 30 106 34 75
3 Arenas de Armilla Cultura Y Arenas 30 121 32 69
4 We Fútbol Club B Fútbol Club 30 118 34 64
5 Granada Sub 14 B Granada 30 105 41 59
6 Calahonda-Carchuna Calahonda-Ca 30 79 46 55
7 Medina Lauxa Sub 14 Medina Lauxa 30 84 50 53
8 Atarfe Industrial Cf Atarfe 30 68 60 48
9 Cd Huescar Cd Huescar 30 65 47 46
10 Sierra Nevada Cenes Sierra 30 88 88 35
11 Zaidin Zaidin 30 74 90 34
12 Ciudad de Baza 2017 Ciudad Baza 30 48 80 28
13 Reino de Granada Reino 30 44 90 23
14 Albolote Soccer Alda Albolote 30 40 164 14
15 Almuñecar 77 Almuñecar 30 19 213 6
16 Pinos Puente Pinos Puente 30 20 130 3
17 Ogijares 89 Cf Ogijares 0 0 0 0
TEMPORADA 2017/2018
2ª ANDALUZA GRANADA INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Huetor Tajar Huetor Tajar 30 125 39 75
2 CD Santa Fe A Santa 30 123 25 68
3 Atarfe Industrial Cf Atarfe 30 105 29 67
4 Medina Lauxa Sub 14 Medina Lauxa 30 114 36 64
5 We Fútbol Club B Fútbol Club 30 76 30 61
6 Ciudad de Baza 2017 Ciudad Baza 30 89 64 55
7 UD Maracena UD Maracena 30 80 39 49
8 Cd Huescar Cd Huescar 30 78 38 49
9 Albolote Soccer Alda Albolote 30 58 74 44
10 Illora Illora 30 56 67 42
11 Vandalia de Peligros Vandalia 30 32 88 22
12 Chauchina Chauchina 30 57 172 22
13 Ciudad de Granada C Ciudad 30 35 108 19
14 Caniles Caniles 30 33 121 19
15 Arenas de Armilla Cultura Y Arenas 30 45 94 18
16 Guadix Cf Guadix Cf 30 35 117 15
TEMPORADA 2016/2017
3ª ANDALUZA GRANADA INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Ciudad de Baza 2017 Ciudad Baza 22 135 15 57
2 Celtic CF Celtic CF 22 80 36 57
3 Alfacar Alfacar 22 93 13 55
4 Caniles Caniles 22 56 46 40
5 Iznalloz Iznalloz 22 32 38 31
6 Campotejar Campotejar 22 45 64 28
7 Vandalia de Peligros Vandalia 22 45 61 27
8 Guadix Cf Guadix Cf 22 47 58 25
9 Comarca Los Montes Comarca 22 59 78 24
10 Albolote Soccer Alda A Albolote 22 62 69 22
11 Cullar Vega Base Cullar Vega 22 28 93 10
12 Club Deportivo Benalúa Club 22 25 136 4

  USO DE MEMORIA  
5,301,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.0754
Total Execution Time  0.0774
  CADENA URL  
/historico/Cd-Ciudad-De-Baza-Cp-2017-Infantil
  GET DATOS  
$_GET['/historico/Cd-Ciudad-De-Baza-Cp-2017-Infantil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=105138 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=287 AND type_rel = 3
0.0021  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 = '105138' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 66528 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=105138 AND l.year in (2021,2022,2023) 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 (66528,59764) 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.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 66528 AND teamId = 105138
0.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 59764 AND teamId = 105138
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 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 = 66528 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '105138' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0038  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '105138' 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 = '105138' 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 = 105138 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 59764 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.0021  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 = 59771 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.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 = 53041 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.0029  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 = 45195 AND t.round = 34 ORDER BY team.conference 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 `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 = 40676 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 = 35375 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC