4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Futbol Base Torreño
TEMPORADA 2023/2024
4ª ANDALUZA MÁLAGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 CD EF José Santacruz José 26 153 22 75
2 Faro de Torrox Asociación Faro Torrox 26 108 37 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 Benamocarra Benamocarra 27 81 64 44
7 Futbol Base Torreño Futbol Base 27 64 49 44
8 La Cala CD La Cala CD 26 81 48 43
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 27 25 116 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
3ª ANDALUZA MÁLAGA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Vélez C.F. Vélez C.F. 7 20 5 17
2 Pto.Malagueño C.Jrdn Sub 19 Pto.Malague 9 18 10 16
3 UD Dos Hermanas SA C Hermanas 9 24 17 15
4 Benagalbon CD Benagalbon 8 14 11 14
5 Alhaurin de la Torre CF B Alhaurin 8 8 23 9
6 Cartama CD Cartama CD 8 19 27 8
7 CD Rincón Sub 19 Rincón 7 13 15 6
8 Futbol Base Torreño Futbol Base 8 12 20 5
TEMPORADA 2019/2020
3ª ANDALUZA MÁLAGA JUVENIL
Equipo PJ GF GC Puntos
1 Futbol Romeral CD Futbol 22 60 20 53
2 Malaka CF Sub 19 Malaka 22 92 38 50
3 Mortadelo Sub 19 Mortadelo 22 55 29 50
4 Archidona Archidona 22 40 33 40
5 Pto.Malagueño C.Jrdn Sub 19 Pto.Malague 22 59 40 37
6 Club Deportivo Trabuco Club 22 46 36 31
7 Vélez C.F. Vélez C.F. 22 56 52 30
8 Futbol Base Torreño Futbol Base 22 37 33 28
9 Benagalbon CD Benagalbon 22 43 48 28
10 Roma Luz Sub 19 Roma 22 33 38 26
11 Campanillas Campanillas 22 50 60 26
12 UD Dos Hermanas SA C Hermanas 22 37 40 25
13 Benalmadena CD Benalmadena 22 30 54 21
14 Alhaurin de la Torre CF B Alhaurin 22 22 47 18
15 Cartama CD Cartama CD 22 26 77 14
16 Guadalmar A Guadalmar A 22 35 76 9
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 1
Equipo PJ GF GC Puntos
1 CD Rincón A Rincón 27 97 26 71
2 UD Dos Hermanas SA B Hermanas 26 83 27 62
3 Mortadelo Sub 19 Mortadelo 26 77 36 55
4 Ronda UD Ronda UD 27 71 40 53
5 Cartama CD Cartama CD 26 84 63 50
6 Campanillas Campanillas 26 54 57 34
7 Atlético Juval B Atlético 27 56 56 33
8 Vélez C.F. Vélez C.F. 26 33 35 33
9 Torrox CD Torrox CD 27 42 66 30
10 Roma Luz Sub 19 Roma 26 36 43 29
11 Archidona Archidona 27 37 59 25
12 Malaka CF Sub 19 Malaka 26 39 76 21
13 Futbol Romeral CD Futbol 27 42 76 19
14 Futbol Base Torreño Futbol Base 25 34 83 18
15 Velez FC Velez FC 7 3 45 0

  USO DE MEMORIA  
5,239,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0794
Total Execution Time  0.0806
  CADENA URL  
/historico/Futbol-Base-Torreno-Cd-Ad-Juvenil
  GET DATOS  
$_GET['/historico/Futbol-Base-Torreno-Cd-Ad-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0030  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 = 'Futbol-Base-Torreno-Cd-Ad-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.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=90940 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=90940 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=90940 AND type_rel = 2
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=444 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 444 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (513201,332543) ORDER BY n.cover_points DESC, update_date DESC
0.0023  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 = '90940' ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '90940' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0019  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 = '90940' 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 = 74201 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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=90940 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 (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.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74201 AND teamId = 90940
0.0019  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.0019  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 = '90940' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  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 = '90940' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 90940 AND l.year <= 2024 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 `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.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 `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.0022  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 = 59781 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.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 `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 = 52186 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.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 `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.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 `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 = 39982 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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