4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD EF José Santacruz
TEMPORADA 2023/2024
4ª ANDALUZA MÁLAGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 CD EF José Santacruz José 25 150 20 72
2 Faro de Torrox Asociación Faro Torrox 25 106 34 66
3 Vélez B Vélez B 27 88 46 57
4 CD Nerja CD Nerja 27 89 48 52
5 CD Rincón A Rincón 27 71 34 48
6 Futbol Base Torreño Futbol Base 27 64 49 44
7 La Cala CD La Cala CD 26 81 48 43
8 Benamocarra Benamocarra 26 76 62 41
9 Algarrobo Algarrobo 26 60 47 39
10 CD Torremoya Torremoya 27 53 56 34
11 Benagalbon CD Benagalbon 26 65 71 29
12 Francisco Castejon EF B Francisco 25 34 87 19
13 Atl. Bezmiliana Atl. 26 37 93 16
14 Veleño La Cantera Veleño 26 23 111 7
15 Periana CD Periana CD 26 20 162 7
16 AD Almayate AD Almayate 8 9 58 0
TEMPORADA 2022/2023
4ª ANDALUZA MÁLAGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 CD Nerja CD Nerja 24 98 36 57
2 CD EF José Santacruz José 24 91 43 52
3 Faro de Torrox Asociación Faro Torrox 24 80 37 51
4 Benagalbon CD Benagalbon 24 60 55 43
5 AD Almayate AD Almayate 24 63 41 42
6 La Cala CD La Cala CD 24 50 42 39
7 UD Villanueva Rosario Villanueva 24 52 53 34
8 Francisco Castejon EF B Francisco 24 55 53 33
9 CD Rincón A Rincón 24 52 68 32
10 Algarrobo Algarrobo 24 39 48 28
11 Futbol Base Torreño Futbol Base 24 48 65 27
12 Vélez B Vélez B 24 25 96 4
13 CD Torremoya Torremoya 24 29 105 3
TEMPORADA 2021/2022
4ª ANDALUZA MÁLAGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Unión Deportiva Alameda Unión 28 101 39 69
2 La Cala A La Cala A 27 83 28 60
3 UD Villanueva Rosario Villanueva 28 98 45 60
4 Benagalbon CD Benagalbon 28 75 43 52
5 CD EF José Santacruz José 28 76 48 51
6 Francisco Castejon EF B Francisco 27 72 51 50
7 CD Rincón A Rincón 28 83 72 46
8 CD Nerja CD Nerja 27 57 54 42
9 Faro de Torrox Asociación Faro Torrox 28 71 64 37
10 Algarrobo Algarrobo 28 64 81 29
11 Vélez B Vélez B 27 37 75 26
12 CD Torremoya Torremoya 28 41 61 24
13 AD Almayate AD Almayate 28 54 104 22
14 Competa CF Competa CF 28 41 110 19
15 Futbol Base Torreño Futbol Base 28 24 102 8
TEMPORADA 2020/2021
4ª ANDALUZA MÁLAGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Casabermeja CD Casabermeja 19 56 10 46
2 CD Nerja CD Nerja 20 59 40 38
3 Torre del Mar Torre 20 60 33 37
4 Almachar Rvo. Almachar 20 64 47 36
5 La Cala A La Cala A 19 41 27 36
6 Francisco Castejon EF B Francisco 19 52 36 32
7 Amigos Del Deporte Colmenar Amigos 19 25 41 23
8 Los Prados UD B Prados 19 32 38 22
9 Algarrobo Algarrobo 20 24 51 16
10 AD Almayate AD Almayate 19 20 47 10
11 CD Torremoya Torremoya 20 18 81 2
12 CD EF José Santacruz José 0 0 0 0
13 UD Benamocarra Benamocarra 0 0 0 0

  USO DE MEMORIA  
4,850,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.3050
Total Execution Time  0.3062
  CADENA URL  
/historico/Cd-Ef-Jose-Santacruz
  GET DATOS  
$_GET['/historico/Cd-Ef-Jose-Santacruz']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0133  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 = 'Cd-Ef-Jose-Santacruz' 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.0125  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=140174 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=140174 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=140174 AND type_rel = 2
0.0127  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 = '140174' ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '140174' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0126  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 = '140174' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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=140174 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (74201) 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.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74201 AND teamId = 140174
0.0126  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 = '140174' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  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 = '140174' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 140174 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 = 74201 AND t.round = 32 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 69851 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.0131  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 = 66016 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.0128  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 = 60429 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