4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atlético La Zubia A
TEMPORADA 2023/2024
2ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 Arenas de Armilla Sub 19 Arenas 27 73 20 67
2 Loja CD Loja CD 27 77 30 66
3 We FC Sub 19 27 43 35 45
4 Atarfe Industrial CF Atarfe 27 52 54 44
5 Reino de Granada Reino 28 58 54 43
6 CF Alhendín Balompié B Alhendín 27 54 46 39
7 Español Albolote Español 27 46 46 37
8 C.D. Churriana de la Vega C.D. 27 57 51 35
9 Ciudad de Granada Ciudad 27 47 47 35
10 CD Huetor Tajar Huetor Tajar 27 57 62 34
11 CD Vandalia de Peligros Vandalia 27 39 45 32
12 Guadix CF Guadix CF 28 45 65 31
13 CD Ciudad De Baza Sub 19 Ciudad Baza 27 36 67 29
14 Atlético La Zubia A Atlético 27 39 57 27
15 CD Santa Fe Sub 19 Santa 27 37 62 24
16 Ogíjares89 Ogíjares89 27 41 60 19
TEMPORADA 2022/2023
4ª ANDALUZA GRANADA JUVENIL GRUPO 4
Equipo PJ GF GC Puntos
1 Sporting Vegas del Genil Sporting 25 120 38 64
2 Regina Mundi Regina Mundi 26 91 32 59
3 Granada Origen Granada 26 85 26 59
4 Atlético La Zubia A Atlético 26 77 47 57
5 CD Estrellas Chana Barrio Estrellas 25 70 47 48
6 Rayo Eneas Rayo Eneas 25 64 45 48
7 Zaidin Zaidin 26 59 56 37
8 Reino De Granada B Reino 25 44 42 31
9 CD WE Futbol Club Futbol Club 26 40 64 30
10 Gabia Atlético CF Gabia 26 37 66 23
11 CD Huetor Vega Huetor Vega 26 47 85 19
12 Cullar Vega B Cullar Vega 26 29 75 16
13 Medina Lauxa B Medina Lauxa 26 51 119 13
14 Atarfe Industrial B Atarfe 26 36 108 12
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 2018/2019
3ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 C.D. Huetor Tajar A C.D. Huetor 34 145 39 90
2 Ciudad de Baza 2017 Ciudad Baza 33 111 53 73
3 UD Maracena C Maracena 34 97 65 62
4 Atlético La Zubia A Atlético 34 92 65 62
5 Arenas de Armilla B Arenas 34 76 53 62
6 Sporting Vegas del Genil Sporting 34 88 73 60
7 Atletico Salobreña Atletico 33 85 69 55
8 Granada Base Granada Base 34 84 82 52
9 C.D. Churriana de la Vega C.D. 34 68 66 49
10 Zaidin Zaidin 34 75 99 46
11 Gabia Atlético CF Gabia 34 76 88 41
12 Ciudad de Granada Abogados Ciudad 34 78 86 38
13 CD Huescar CD Huescar 34 74 99 37
14 Ogijares 89 Ogijares 89 34 75 77 35
15 Atarfe Industrial CF Atarfe 34 65 98 32
16 C.D. Albolote Soccer Alda A C.D. 34 59 130 26
17 Puerto de Motril Puerto 34 38 93 25
18 Medina Lauxa Medina Lauxa 34 64 115 19
TEMPORADA 2017/2018
3ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 Alhendín Balompié Sub 19 Alhendín 32 123 32 84
2 Chauchina Chauchina 32 143 51 73
3 Puerto de Motril Puerto 33 122 59 73
4 Vandalia de Peligros Vandalia 31 95 34 68
5 Calahonda-Carchuna Calahonda-Ca 31 99 53 68
6 Ciudad de Baza 2017 Ciudad Baza 32 113 48 62
7 UD Maracena C Maracena 31 99 64 61
8 Ciudad de Granada Ciudad 33 110 82 51
9 Atlético La Zubia A Atlético 31 73 70 43
10 Granada Noroeste CM Granada 31 91 114 38
11 Zaidin Zaidin 32 67 81 34
12 Medina Lauxa Medina Lauxa 31 49 106 27
13 CD Huescar CD Huescar 31 60 108 22
14 C.D. Albolote Soccer Alda A C.D. 31 45 104 22
15 C.D. Churriana de la Vega C.D. 31 52 140 20
16 U.D. Alfacar U.D. Alfacar 31 44 109 12
17 Cullar Vega Base Cullar Vega 20 17 106 1
18 Atletico Baza 2016 Atletico 4 2 43 0
TEMPORADA 2016/2017
3ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 We FC Sub 19 30 78 53 62
2 Celtic Pulianas Celtic 30 79 44 61
3 Otura Otura 30 84 41 60
4 Atletico Monachil Atletico 30 91 46 59
5 UD Maracena C Maracena 30 79 57 54
6 Arenas de Armilla Arenas 30 79 65 54
7 La Herradura 2005 Herradura 30 59 49 53
8 Vandalia de Peligros Vandalia 30 59 56 40
9 Cullar Vega Base Cullar Vega 30 59 74 39
10 U.D. Alfacar U.D. Alfacar 30 64 68 38
11 Medina Lauxa Medina Lauxa 30 58 80 37
12 Cijuela 2008 Cijuela 2008 30 68 88 34
13 Atlético La Zubia A Atlético 30 58 61 33
14 Santa Fe C Santa Fe C 30 51 57 33
15 Cp Granada 74 Granada 30 44 82 20
16 CD UD Monachil Monachil 30 41 130 10
TEMPORADA 2015/2016
4ª ANDALUZA GRANADA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 CD UD Monachil Monachil 24 113 35 57
2 We FC Sub 19 24 107 21 57
3 Atlético La Zubia A Atlético 24 105 32 54
4 CD Huescar CD Huescar 24 91 22 52
5 Granada Base Granada Base 23 71 25 41
6 Zaidin B Zaidin B 24 63 62 37
7 Dama de Baza BM Dama Baza 24 75 51 33
8 Albolote Albolote 23 52 60 30
9 Albolote Soccer Alda B Albolote 24 41 86 22
10 Numancia Numancia 23 41 106 19
11 CD Benalua CD Benalua 24 61 109 18
12 Sierra Nevada Cenes Sierra 24 45 120 17
13 C.D. Pvo Pinos Puente C.D. Pinos. 23 26 162 8
TEMPORADA 2014/2015
3ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 Maracena B Maracena B 30 110 25 80
2 Motril Motril 30 81 26 70
3 Atlético Salobreña Atlético 30 83 50 56
4 Atletismo Padul Atletismo 30 89 64 55
5 Zaidin Zaidin 30 83 52 50
6 Celtic B Celtic B 30 63 47 49
7 Vandalia de Peligros Vandalia 30 60 63 45
8 Estrellas Chana B Estrellas 30 66 77 40
9 Huetor Tajar B Huetor Tajar 30 59 70 37
10 Cp Granada 74 Granada 30 54 74 35
11 Iznalloz Iznalloz 30 39 76 34
12 Medina Lauxa Medina Lauxa 30 44 67 29
13 Barrio La Cruz Barrio Cruz 30 57 71 27
14 Atlético La Zubia A Atlético 30 39 67 25
15 Puerto de Motril Puerto 30 38 88 25
16 Parapanda 2010 Parapanda 30 42 90 23
TEMPORADA 2013/2014
2ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 Arenas de Armilla B Arenas 17 40 13 41
2 Puerto de Motril C.F Puerto 17 44 20 36
3 Celtic Pulianas Celtic 17 43 29 35
4 Estrellas Chana UD Estrellas 17 51 36 33
5 Huétor Vega CD Huétor Vega 17 40 26 33
6 Cp Granada 74 Granada 17 42 22 29
7 Ogíjares89 Ogíjares89 17 29 26 27
8 Santa Fe B Juvenil Santa 17 38 34 25
9 C.D. Baza C.D. Baza 16 35 30 24
10 C.D. Huetor Tajar A C.D. Huetor 17 35 38 22
11 Guadix Cf Guadix Cf 16 29 36 22
12 C.D. Churriana de la Vega C.D. 17 32 39 17
13 Atlético La Zubia A Atlético 17 19 49 14
14 Pinos Puente Pinos Puente 16 28 54 8
15 Atletismo Padul Atletismo 17 26 58 8
16 Maracena B Maracena B 16 22 43 7

  USO DE MEMORIA  
5,656,608 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0867
Total Execution Time  0.0880
  CADENA URL  
/historico/Atletico-La-Zubia-Juvenil
  GET DATOS  
$_GET['/historico/Atletico-La-Zubia-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0029  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 = 'Atletico-La-Zubia-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.0025  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=25115 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=25115 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25115 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=531 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 = '25115' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0029  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=25115 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (74105,69882) 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.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74105 AND teamId = 25115
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 69882 AND teamId = 25115
0.0021  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 = 25115 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024_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 = 74105 AND t.round = 29 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 `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 = 69700 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.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 `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 = 69882 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.0025  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.0030  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 = 45806 AND t.round = 34 ORDER BY team.conference 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 `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 = 39991 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 35067 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 17072 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 4855 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 `tables2014_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 = 3338 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC