4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Alhaurin de la Torre CF B
TEMPORADA 2023/2024
4ª ANDALUZA MÁLAGA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Futbol Romeral A Futbol 23 120 5 64
2 Los Prados Los Prados 22 63 21 54
3 Alora CD Alora CD 23 70 38 46
4 Alhaurin de la Torre CF B Alhaurin 22 61 50 35
5 Cartama CD Cartama CD 22 44 47 34
6 Benalmadena Atletico Benalmadena 23 58 64 33
7 Puerto de la Torre Puerto Torre 23 56 64 30
8 Cortijillo Bazán Sub 19 B Cortijillo 23 48 53 29
9 Santa Rosalia Maqueda Santa 23 42 48 27
10 CD Alhaurino Alhaurino 23 35 53 25
11 CD Rincon B CD Rincon B 23 42 61 24
12 CD Ronda Futbol Base Ronda Futbol 23 27 84 18
13 La Cala B La Cala B 23 24 102 5
TEMPORADA 2022/2023
4ª ANDALUZA MÁLAGA JUVENIL GRUPO 5
Equipo PJ GF GC Puntos
1 Mijas Las Lagunas Mijas 22 89 24 56
2 Union Manilva CFCD Union 22 90 30 56
3 Fuengirola Athletic Club CD Fuengirola 22 85 34 51
4 Atlético de Marbella Atlético 22 65 36 39
5 Peña Compadres Peña 21 74 49 38
6 Vazquez Cultural C Vazquez 22 89 47 34
7 Candor CF Candor CF 22 41 64 26
8 Estepona Fútbol Base Estepona 22 37 51 23
9 Futbol Banus Futbol Banus 22 42 60 22
10 J. Torremolinos Sub 19 Torremolinos 22 42 50 21
11 Alhaurin de la Torre CF B Alhaurin 21 37 80 12
12 Union Deportiva Esteponense Union 22 8 174 0
TEMPORADA 2021/2022
3ª ANDALUZA MÁLAGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Athl. Puerta Blanca Sub 19 Athl. Puerta 28 99 28 69
2 CD Rincón Sub 19 Rincón 30 89 31 68
3 Pto.Malagueño C.Jrdn Sub 19 Pto.Malague 30 88 39 63
4 Futbol Romeral CD Futbol 30 69 45 52
5 CD Conejito de Malaga Conejito 30 59 49 52
6 Guadalmar A Guadalmar A 30 86 72 51
7 Cortijillo Bazán Sub 19 Cortijillo 29 69 48 49
8 UD Dos Hermanas SA C Hermanas 30 73 64 45
9 Club Deportivo Trabuco Club 29 55 51 43
10 Mortadelo Sub 19 Mortadelo 30 53 79 38
11 Olimpica Victoriana CF A Olimpica 29 64 71 37
12 Malaka CF Sub 19 Malaka 30 46 63 33
13 Alhaurin de la Torre CF B Alhaurin 30 55 80 30
14 Roma Luz Sub 19 Roma 30 35 73 22
15 Cartama CD Cartama CD 28 38 85 18
16 Campanillas Campanillas 29 20 120 1
TEMPORADA 2020/2021
4ª ANDALUZA MÁLAGA JUVENIL GRUPO 3
Equipo PJ GF GC Puntos
1 CD Carlinda B Carlinda 22 77 21 56
2 Cortijillo Bazan Cortijillo 22 86 22 54
3 Futbol Romeral A Futbol 21 79 25 44
4 Pizarra C.F. Pizarra C.F. 22 74 29 44
5 CD Zona Norte Málaga Zona Norte. 22 71 36 43
6 Alameda CF Alameda CF 21 77 34 39
7 Athl. Puerta Blanca Sub 19 Athl. Puerta 21 43 55 30
8 Portada Alta Atco. Sub 19 B Portada Alta 22 39 69 21
9 Benalmadena Atletico B Benalmadena 22 39 64 19
10 Alhaurin de la Torre CF B Alhaurin 22 26 76 13
11 Atlético Estación Sub 19 B Atlético 22 25 99 7
12 Olimpica Victoriana B Olimpica 21 23 129 4
13 Arriate CD AD Setenil Arriate 0 0 0 0
14 Lauro CD A Lauro CD A 0 0 0 0
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 2
Equipo PJ GF GC Puntos
1 Vázquez Cultural Sub 19 B Vázquez 30 132 25 79
2 Marbella FC B Marbella 30 78 34 62
3 Benalmadena CD Benalmadena 30 71 52 58
4 Antequera CF B Antequera 30 70 43 54
5 CD Churriana Churriana 30 59 47 51
6 Fuengirola Los Boliches Juv Fuengirola 30 95 57 47
7 Campillos CD Campillos 30 59 53 47
8 Atletico Estacion Atletico 30 81 61 46
9 Alhaurino Sub 19 Alhaurino 30 67 54 45
10 UD San Pedro B Pedro 30 62 59 43
11 Alhaurin de la Torre CF B Alhaurin 30 59 41 41
12 Almargen Union Almargen 30 73 61 40
13 Juventud de Torremolinos Juventud 30 54 61 31
14 Puerto de la Torre Puerto Torre 30 57 84 25
15 Costa Unida Costa Unida 30 42 118 16
16 Cala Mijas CD Cala Mijas 30 19 228 0
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 2
Equipo PJ GF GC Puntos
1 Futbol Romeral Futbol 22 102 26 60
2 Alhaurin de la Torre CF B Alhaurin 22 122 26 56
3 San Estanislao Estanislao 22 77 40 44
4 Olímpica Victoriana Olímpica 22 66 53 39
5 UD La Mosca Sub 19 B Mosca 21 77 38 38
6 La Cala CD La Cala CD 23 60 47 36
7 Atlético Juval B Atlético 21 51 39 35
8 Puerto de la Torre Puerto Torre 22 47 60 30
9 Rincon CD Rincon CD 22 54 46 27
10 Lauro CD Lauro CD 22 59 73 26
11 Alora CD Alora CD 20 39 59 20
12 Amigos del Deporte Colmenar Amigos 24 28 123 14
13 Rayo San Julian Rayo Julian 23 26 135 9
14 Carlinda Carlinda 3 10 7 4
15 Los Prados Los Prados 13 17 63 1
TEMPORADA 2015/2016
4ª ANDALUZA MÁLAGA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 El Palo FC Sub 19 B Palo 22 81 18 53
2 Malaka CF Sub 19 Malaka 22 79 25 51
3 Unidad Nueva Malaga Sub 19 Unidad Nueva 22 62 24 49
4 Alhaurin de la Torre CF B Alhaurin 22 67 22 44
5 Casabermeja CD Casabermeja 22 65 41 39
6 San Estanislao Estanislao 22 54 43 38
7 Atlético Juval C Atlético 22 35 59 28
8 Guadalmar Guadalmar 22 60 64 27
9 Portada Alta Portada Alta 22 34 59 22
10 Rincon CD Rincon CD 22 28 77 16
11 Almogia Atletic Almogia 22 25 75 8
12 Torre del Mar B Torre 22 26 109 7

  USO DE MEMORIA  
5,500,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1107
Total Execution Time  0.1127
  CADENA URL  
/historico/Alhaurin-De-La-Torre-Cf-Juvenil
  GET DATOS  
$_GET['/historico/Alhaurin-De-La-Torre-Cf-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0028  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 = 'Alhaurin-De-La-Torre-Cf-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.0019  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=66651 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=66651 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 74202
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=66651 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=444 AND type_rel = 3
0.0021  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.0023  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.0027  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 = '66651' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '66651' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 74202 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  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=66651 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (74202) 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 = 74202 AND teamId = 66651
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 = 74202 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0028  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 = '66651' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '66651' 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 = '66651' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0025  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 = 66651 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 = 74202 AND t.round = 25 ORDER BY team.conference ASC,t.position 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 `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 = 69852 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 `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 = 69855 AND t.round = 22 ORDER BY team.conference ASC,t.position 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 `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 = 65927 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.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 = 60431 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.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 = 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.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 `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 = 45802 AND t.round = 30 ORDER BY team.conference 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 `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.0028  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 = 35553 AND t.round = 26 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 `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 = 17055 AND t.round = 22 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 = 74202 ORDER BY nameShow LIMIT 100