4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del La Unidad Nueva Malaga
TEMPORADA 2022/2023
3ª ANDALUZA MÁLAGA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Malaka Sub 16 Malaka 29 102 28 72
2 Carlinda Sub 16 Carlinda 29 85 43 65
3 CD Athletic Puerta Blanca Athletic 29 78 52 58
4 Antequera Antequera 30 89 41 54
5 Ronda Union Deportiva Ronda Union 29 84 62 49
6 Faro de Torrox Asociacion Faro Torrox 30 90 63 47
7 Puerto Malagueño C Puerto 30 68 54 46
8 La Unidad Nueva Malaga Unidad Nueva 30 70 79 42
9 CD Rincón CD Rincón 29 61 57 40
10 Mortadelo Sub 16 Mortadelo 29 76 69 39
11 CD Atletico Benamiel CF Atletico 29 78 62 38
12 Atletico Juval Atletico 29 59 71 31
13 Fútbol Romeral Fútbol 29 63 76 31
14 San Estanislao Sub 16 Estanislao 30 45 95 25
15 Olimpica Victoriana Sub 16 Olimpica 21 25 113 9
16 CD Conejito de Malaga Conejito 30 34 142 5
TEMPORADA 2021/2022
3ª ANDALUZA MÁLAGA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 D. Hermanas S.Andres Sub 16 Hermanas 29 95 42 73
2 Atletico Juval Atletico 29 105 38 71
3 Atletico Estacion Sub 16 Atletico 30 88 35 70
4 Antequera Antequera 30 82 49 52
5 Romeral Sub 16 Romeral 30 84 60 51
6 Puerto Malagueño C Puerto 30 66 49 48
7 La Unidad Nueva Malaga Unidad Nueva 30 49 59 45
8 Faro de Torrox Asociacion Faro Torrox 29 67 73 42
9 Rincon A Rincon A 30 70 72 41
10 Mortadelo A Mortadelo A 30 64 73 37
11 Malaka Sub 16 Malaka 30 65 74 36
12 San Estanislao Sub 16 Estanislao 30 44 67 36
13 Olimpica Victoriana Sub 16 Olimpica 29 72 85 34
14 AD Cortijillo Bazan Cortijillo 30 57 75 26
15 EF Velez Francisco Castejon Velez 30 33 74 16
16 Pizarra Atlético Pizarra 30 41 157 5
TEMPORADA 2020/2021
3ª ANDALUZA MÁLAGA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Jose Santacruz Sub 16 Jose 9 49 5 25
2 El Palo FC Sub 16 Palo 9 36 9 24
3 Atlético Juval Atlético 8 31 10 19
4 Pizarra Pizarra 10 22 22 13
5 La Unidad Nueva Malaga Unidad Nueva 9 19 34 8
6 Fútbol Romeral Fútbol 9 14 25 7
7 Zona Norte Málaga Zona Norte. 10 9 36 6
8 Roma Luz C.F. Roma C.F. 8 5 44 1
TEMPORADA 2019/2020
4ª ANDALUZA MÁLAGA CADETE GRUPO 3
Equipo PJ GF GC Puntos
1 La Unidad Nueva Malaga Unidad Nueva 21 154 23 60
2 Zona Norte Málaga Zona Norte. 21 91 16 58
3 Lauro B Lauro B 21 161 16 55
4 Unión Deportiva Alameda B Unión 21 56 40 42
5 Nerja Fund. Cueva B Nerja Fund. 21 59 31 41
6 Benalmádena Atlético B Benalmádena 21 45 40 40
7 Athletic de Coin B Athletic 21 53 35 35
8 CD San Marcos Marcos 21 53 47 25
9 Los Morales Sub Sub 16 B Morales 21 25 62 20
10 Rincon A Rincon A 21 31 75 13
11 Alhaurin de la Torre Sub 16 Alhaurin 21 28 93 13
12 EF Velez Francisco Castejon Velez 21 21 120 10
13 San Estanislao B Estanislao 21 22 115 9
14 Atletico Estacion B Atletico 21 16 102 4
TEMPORADA 2018/2019
3ª ANDALUZA MÁLAGA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 26 de Febrero Sub 16 Febrero 30 102 25 78
2 Puerto de La Torre Los Mora Puerto Torre 30 117 41 71
3 Jose Santacruz Sub 16 Jose 30 121 48 69
4 La Mosca B La Mosca B 30 116 47 64
5 Atlético Juval Atlético 30 80 62 50
6 Puerto Malagueño C Puerto 30 74 50 47
7 Fútbol Romeral Fútbol 30 62 61 41
8 Atletico Estacion Sub 16 Atletico 30 70 78 41
9 Antequera B CF Antequera 30 71 82 39
10 Mortadelo A Mortadelo A 30 67 97 39
11 El Palo FC Sub 16 Palo 30 60 76 32
12 Peña Compadres Peña 30 60 108 31
13 Mijas Las Lagunas B Mijas 30 54 81 28
14 Asociacion Faro de Torrox Asociacion 30 34 82 24
15 La Unidad Nueva Malaga Unidad Nueva 30 41 109 24
16 Alh. De La Torre Sub 16 B Alh. Torre 30 42 124 9
TEMPORADA 2017/2018
3ª ANDALUZA MÁLAGA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Puerto Malagueño C Puerto 30 116 12 85
2 Tiro Pichon Sub 16 B Tiro Pichon 30 128 50 68
3 Cortijillo Bazan Cortijillo 30 80 34 64
4 El Palo FC Sub 16 Palo 30 116 45 61
5 Atlético Juval Atlético 30 126 40 60
6 Romeral Sub 16 Romeral 30 90 41 60
7 Peña Compadres B Peña 30 92 50 52
8 Puerto de La Torre Los Mora Puerto Torre 30 87 78 49
9 Asociacion Faro de Torrox Asociacion 30 65 46 41
10 Jose Santacruz Sub 16 Jose 30 61 86 36
11 Mortadelo A Mortadelo A 30 53 74 35
12 La Unidad Nueva Malaga Unidad Nueva 30 38 76 27
13 CD Juventud De Torremolinos Juventud 30 51 105 23
14 La Mosca C La Mosca C 30 43 134 16
15 Algarrobo Algarrobo 30 44 110 14
16 La Cala A La Cala A 30 21 230 5
TEMPORADA 2016/2017
3ª ANDALUZA MÁLAGA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Roma Luz C.F. Roma C.F. 30 89 23 73
2 Mortadelo Sub 16 Mortadelo 29 114 33 67
3 Asociacion Faro de Torrox Asociacion 30 114 40 66
4 El Palo FC Sub 16 Palo 30 85 40 65
5 Puerto Malagueño C Puerto 30 82 39 55
6 Jose Santacruz Sub 16 Jose 30 96 49 53
7 Tiro Pichón B Tiro Pichón 30 76 51 47
8 Atlético Juval Atlético 30 60 59 42
9 Algarrobo Algarrobo 30 65 81 40
10 Puerto de La Torre Los Mora Puerto Torre 30 62 51 38
11 La Mosca C La Mosca C 30 66 87 32
12 La Unidad Nueva Malaga Unidad Nueva 30 65 84 28
13 Romeral Sub 16 Romeral 30 48 78 25
14 Portada Alta Atlético Portada Alta 30 59 122 24
15 Futbol Base Torreño CDAD Futbol Base 30 32 145 13
16 Malaka A Malaka A 29 31 162 9
TEMPORADA 2015/2016
2ª ANDALUZA MÁLAGA CADETE
Equipo PJ GF GC Puntos
1 Velez F. Castejón Sub 16 Velez 34 117 36 84
2 Peña Compadres Peña 34 90 47 76
3 Puerto Malagueño Sub 16 B Puerto 34 96 51 70
4 Antequera C.F. Antequera 34 104 55 62
5 Ronda Union Deportiva Ronda Union 34 62 46 58
6 CD Tiro Pichón Tiro Pichón 34 63 48 56
7 UD San Pedro Pedro 34 75 67 55
8 La Unidad Nueva Malaga Unidad Nueva 34 70 68 55
9 UD Fuengirola Los Boliches Fuengirola 34 77 57 51
10 Athletic Puerta Blanca Athletic 34 81 75 49
11 Fútbol Romeral Fútbol 34 57 55 46
12 Cortijillo Bazan Cortijillo 34 57 71 45
13 Vázquez Cultural Vázquez 34 56 85 35
14 La Mosca B La Mosca B 34 44 74 34
15 CD Rincón CD Rincón 34 56 83 33
16 Costa Unida Costa Unida 34 51 92 26
17 Malaka A Malaka A 34 37 90 24
18 Roma Luz C.F. Roma C.F. 34 34 127 8

  USO DE MEMORIA  
5,464,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1211
Total Execution Time  0.1224
  CADENA URL  
/historico/Cd-La-Unidad-Nueva-Malaga-Cadete
  GET DATOS  
$_GET['/historico/Cd-La-Unidad-Nueva-Malaga-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0025  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-La-Unidad-Nueva-Malaga-Cadete' 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.0031  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-La-Unidad-Nueva-Malaga-Cadete' 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.0020  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=68478 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=68478 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=68478 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=68478 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=68478 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=68478 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=68478 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=68478 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=68478 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=68478 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=68478 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=68478 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=68478 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=454 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 = '68478' 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 = 70183 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=68478 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (70183) 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 = 70183 AND teamId = 68478
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 FROM `tables2023` 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 = 70183 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '68478' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '68478' and rp.type = 4
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 = '68478' 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 = 68478 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 66113 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.0050  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 = 59504 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.0021  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 = 52906 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.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 `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 = 45928 AND t.round = 30 ORDER BY team.conference 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 `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 = 40486 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 40574 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 `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 = 34337 AND t.round = 34 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 `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 = 34346 AND t.round = 30 ORDER BY team.conference 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 `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 = 17266 AND t.round = 30 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 = 17268 AND t.round = 34 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 = 70183 ORDER BY nameShow LIMIT 100