4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Algarrobo
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
TEMPORADA 2018/2019
3ª ANDALUZA MÁLAGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Ronda UD Ronda UD 29 60 29 65
2 Benagalbon CD Benagalbon 30 62 41 56
3 El Palo FC Sub 19 Palo 29 60 33 54
4 Campanillas Campanillas 29 66 41 50
5 Torrox CD Torrox CD 30 52 49 43
6 Roma Luz Sub 19 Roma 29 48 45 43
7 Archidona Archidona 30 44 39 42
8 Club Deportivo Trabuco Club 29 54 59 41
9 Futbol Base Torreño Futbol Base 29 34 36 36
10 Guadalmar A Guadalmar A 29 53 61 35
11 Vélez C.F. Vélez C.F. 30 48 59 35
12 Futbol Romeral CD Futbol 30 48 54 34
13 Cartama CD Cartama CD 30 41 54 33
14 Malaka CF Sub 19 Malaka 29 36 66 29
15 Atlético Juval B Atlético 29 41 58 27
16 Algarrobo Algarrobo 21 32 55 17
TEMPORADA 2017/2018
3ª ANDALUZA MÁLAGA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Atlético Benamiel Atlético 30 125 36 79
2 Mijas Las Lagunas Sub 19 Mijas 30 70 25 65
3 Vázquez Cultural Sub 19 B Vázquez 30 74 54 56
4 Antequera CF B Antequera 30 89 46 54
5 Cala Mijas CD Cala Mijas 29 53 42 51
6 Atletico Estacion Atletico 30 68 58 49
7 Juventud de Torremolinos Juventud 30 73 68 48
8 Campillos CD Campillos 30 67 40 44
9 Alhaurin de la Torre CF B Alhaurin 30 66 50 44
10 Algarrobo Algarrobo 30 76 61 38
11 CD Churriana Churriana 30 55 64 31
12 Costa Unida Costa Unida 29 63 73 31
13 Puerto de la Torre Puerto Torre 30 48 65 30
14 Mijas CD Mijas CD 30 46 94 29
15 Pablo Picaso Pablo Picaso 30 40 103 19
16 Los Prados Los Prados 30 17 151 5
TEMPORADA 2016/2017
4ª ANDALUZA MÁLAGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Algarrobo Algarrobo 28 88 38 67
2 Casabermeja CD Casabermeja 28 115 45 64
3 CD Trabuco CD Trabuco 27 102 43 61
4 Sierra de Yeguas Sierra 28 92 34 61
5 Villanueva del Rosario Villanueva 28 104 43 53
6 Benamocarra Benamocarra 28 92 77 48
7 Cañete Unión Deportivo Cañete 28 78 60 42
8 Benagalbon CD Benagalbon 28 86 79 41
9 Nerja CD Nerja CD 28 69 69 41
10 Torremoya Torremoya 28 75 72 33
11 Torre del Mar Torre 28 68 81 33
12 Mollina CD Mollina CD 27 54 71 27
13 Torreño FB Torreño FB 28 47 114 19
14 Borge CD Borge CD 27 34 143 9
15 Recreativo El Morche Recreativo 27 22 157 1
TEMPORADA 2015/2016
4ª ANDALUZA MÁLAGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Velez FC Velez FC 26 115 33 62
2 Humilladero Humilladero 26 90 36 56
3 CD Trabuco CD Trabuco 26 83 40 55
4 Benamocarra Benamocarra 25 100 41 53
5 Sierra de Yeguas Sierra 26 63 36 51
6 Algarrobo Algarrobo 26 85 42 50
7 Benagalbon CD Benagalbon 26 76 62 42
8 Villanueva del Rosario Villanueva 26 69 71 34
9 Mollina CD Mollina CD 26 58 81 29
10 Torremoya Torremoya 26 57 85 24
11 Borge CD Borge CD 26 33 96 18
12 Torre del Mar Torre 26 38 100 17
13 Amigos del Deporte Colmenar Amigos 25 37 91 14
14 Periana CD Periana CD 26 37 127 13
15 Torreño FB Torreño FB 0 0 0 0
16 Villanueva de la Concepcion Villanueva 0 0 0 0
TEMPORADA 2014/2015
4ª ANDALUZA MÁLAGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Torrox CD Torrox CD 24 104 28 64
2 Alameda CF Alameda CF 24 99 19 62
3 Velez FC Velez FC 24 94 51 52
4 Sierra de Yeguas Sierra 24 66 44 46
5 Torremoya Torremoya 24 59 35 44
6 Benamocarra Benamocarra 24 78 70 37
7 Algarrobo Algarrobo 24 41 56 30
8 Humilladero Humilladero 24 45 82 24
9 Rincon CD Rincon CD 24 55 82 22
10 La Cala CD La Cala CD 23 42 63 20
11 Casabermeja CD Casabermeja 24 40 83 18
12 Francisco Castejon EF B Francisco 24 28 95 13
13 Competa CF Competa CF 23 32 75 12
14 Torreño FB Torreño FB 0 0 0 0

  USO DE MEMORIA  
5,545,136 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.4577
Total Execution Time  0.4590
  CADENA URL  
/historico/Algarrobo-Juvenil
  GET DATOS  
$_GET['/historico/Algarrobo-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0169  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 = 'Algarrobo-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.0130  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=25160 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=25160 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0261  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 = 74201
0.0130  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25160 AND type_rel = 2
0.0139  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 = '25160' ORDER BY l.year DESC,cat.coefficient DESC
0.0140  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 = '25160' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0140  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 = '25160' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0137  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 = 74201 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0138  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=25160 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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.0127  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74201 AND teamId = 25160
0.0126  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '25160' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '25160' and rp.type = 4
0.0127  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 = '25160' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128  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 = 25160 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.0133  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.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
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 `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 = 45801 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 39983 AND t.round = 30 ORDER BY team.conference 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 `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 = 35552 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 17054 AND t.round = 30 ORDER BY team.conference 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 `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 = 4857 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 74201 ORDER BY nameShow LIMIT 100