4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Unión Adarve Sub 12
TEMPORADA 2023/2024
SUPERLIGA MADRID ALEVÍN
Equipo PJ GF GC Puntos
1 Atlético Sub 12 Atlético 26 120 6 76
2 Real Madrid Sub 12 Real Madrid 26 87 13 69
3 Rayo Vallecano Sub 12 Rayo 26 75 21 62
4 Getafe Sub 12 Getafe 25 58 22 53
5 Unión Adarve Sub 12 Unión 26 42 46 41
6 Atletico Madrileño Sub 12 Atletico 26 44 53 36
7 R. Ciudad Alcobendas Sub 12 Ciudad 26 39 58 35
8 Fuenlabrada Sub 12 Fuenlabrada 26 33 34 34
9 At. Chpr. Alcobendas Sub 12 Chpr. 26 27 59 30
10 Móstoles URJC Sub 12 Móstoles 26 38 54 29
11 Aravaca Sub 12 Aravaca 26 35 45 28
12 Leganés Sub 12 Leganés 26 37 50 28
13 Trival Valderas Sub 12 Trival 26 21 68 21
14 Alcorcón Sub 12 Alcorcón 25 18 52 18
15 EFMO Boadilla Sub 12 EFMO 26 21 65 13
16 Nuevo Boadilla Sub 12 Nuevo 26 23 72 13
TEMPORADA 2022/2023
SUPERLIGA MADRID ALEVÍN
Equipo PJ GF GC Puntos
1 Real Madrid Sub 12 Real Madrid 30 161 15 88
2 Atlético Sub 12 Atlético 30 125 15 78
3 Leganés Sub 12 Leganés 30 69 28 65
4 Rayo Vallecano Sub 12 Rayo 30 79 35 63
5 Getafe Sub 12 Getafe 30 68 25 63
6 Unión Adarve Sub 12 Unión 30 39 43 44
7 R. Ciudad Alcobendas Sub 12 Ciudad 30 29 46 39
8 Trival Valderas Sub 12 Trival 30 45 58 36
9 EFMO Boadilla Sub 12 EFMO 30 39 60 36
10 Móstoles URJC Sub 12 Móstoles 30 40 73 31
11 At. Chpr. Alcobendas Sub 12 Chpr. 30 33 67 29
12 Nuevo Boadilla Sub 12 Nuevo 30 41 88 28
13 Colegio Miramadrid Sub 12 Colegio 30 26 51 25
14 Canillas Canillas 30 24 83 21
15 Rayo Majadahonda Rayo 30 30 96 18
16 Seseña Seseña 30 19 84 11
TEMPORADA 2021/2022
DIVISIÓN HONOR MADRID ALEVÍN F11 GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Sub 12 Atlético 30 174 9 88
2 Real Madrid Sub 12 B Real Madrid 30 172 10 83
3 R. Ciudad Alcobendas Sub 12 Ciudad 30 81 31 64
4 Getafe Sub 12 B Getafe 30 102 28 62
5 Unión Adarve Sub 12 Unión 30 57 61 53
6 At. Chpr. Alcobendas Sub 12 Chpr. 30 45 57 50
7 Fundacion Rayo Vallecano A Fundacion 30 53 62 48
8 Canillas Canillas 30 53 72 39
9 Colegio Miramadrid Colegio 30 33 53 38
10 Las Rozas A Las Rozas A 30 34 55 36
11 Atletico Madrileño Sub 12 Atletico 30 43 82 33
12 Sporting Hortaleza A Sporting 30 46 72 32
13 Villa Rosa A Villa Rosa 30 38 83 28
14 CD Leganés Sub 12 B Leganés 30 29 90 19
15 Complutense Alcala A Complutense 30 29 106 9
16 San Sebastian Reyes A Sebastian 30 27 145 7
TEMPORADA 2020/2021
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Sub 12 Atlético 17 115 4 49
2 Real Madrid Sub 12 B Real Madrid 17 105 2 49
3 Canillas Canillas 17 35 25 36
4 Sporting Hortaleza A Sporting 17 22 19 34
5 Villa Rosa A Villa Rosa 17 43 23 33
6 Unión Adarve Sub 12 Unión 17 35 26 32
7 Electrocor Las Rozas A Electrocor 17 34 23 31
8 Rayo Majadahonda Rayo 17 22 14 30
9 Aravaca A Aravaca A 17 31 35 25
10 Union Zona Norte Sub 12 Union Zona. 17 17 22 21
11 Getafe D Getafe D 17 19 28 21
12 Atletico Villalba A Atletico 17 24 45 17
13 CDE FPA Las Rozas A Rozas 17 19 55 15
14 San Roque A San Roque A 17 13 39 12
15 Torrelodones A Torrelodones 17 14 59 10
16 Club San Agustin A Club Agustin 17 11 47 9
17 Ciudad del Futbol B Ciudad 17 10 52 8
18 Gredos-San Diego Gredos-San 17 0 51 0
TEMPORADA 2018/2019
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 12 B Real Madrid 26 196 5 78
2 Ciudad del Futbol Ciudad 26 72 33 67
3 Atlético Sub 12 Atlético 26 105 19 64
4 Unión Adarve Sub 12 Unión 26 53 21 55
5 Union Zona Norte Sub 12 Union Zona. 26 38 49 38
6 Atletico Villalba A Atletico 26 44 45 35
7 Las Rozas A Las Rozas A 26 31 62 34
8 Canillas Canillas 26 40 61 32
9 San Roque A San Roque A 26 35 68 31
10 Aravaca A Aravaca A 26 28 49 30
11 Deportivo Av Santa Ana A Deportivo 26 28 67 21
12 Sporting Hortaleza A Sporting 26 31 89 14
13 CF Pozuelo A Pozuelo 26 18 93 13
14 Getafe D Getafe D 26 14 72 11
TEMPORADA 2017/2018
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Sub 12 Atlético 26 131 18 67
2 Real Madrid C Real Madrid 26 85 41 58
3 Ciudad del Futbol Ciudad 26 69 28 55
4 San Sebastian Reyes A Sebastian 26 71 33 55
5 R. Ciudad Alcobendas Sub 12 Ciudad 26 66 32 51
6 Unión Adarve Sub 12 Unión 26 71 54 41
7 Deportivo Av Santa Ana A Deportivo 26 54 55 35
8 Union Zona Norte Sub 12 Union Zona. 26 59 61 32
9 Aravaca A Aravaca A 26 26 43 26
10 Atletico Madrileño A Atletico 26 34 62 26
11 Rayo Majadahonda Rayo 26 23 52 23
12 Alcobendas Levitt A Alcobendas 26 39 75 20
13 Mostoles C Mostoles C 26 26 92 15
14 Fundacion Rayo Vallecano B Fundacion 26 14 122 4
TEMPORADA 2016/2017
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Sub 12 Atlético 25 129 15 75
2 Real Madrid Sub 12 B Real Madrid 25 162 11 69
3 Union Zona Norte Sub 12 Union Zona. 26 45 30 47
4 Deportivo Av Santa Ana A Deportivo 26 60 55 42
5 R. Ciudad Alcobendas Sub 12 Ciudad 26 39 40 39
6 Alcobendas Levitt A Alcobendas 26 41 39 36
7 Atletico Madrileño A Atletico 25 38 51 35
8 Unión Adarve Sub 12 Unión 26 35 54 32
9 Rayo Majadahonda Rayo 26 24 52 32
10 Nuevo Boadilla Sub 12 Nuevo 25 29 56 27
11 Las Rozas A Las Rozas A 26 30 59 27
12 EFMO Boadilla Sub 12 EFMO 26 31 68 27
13 Sporting Hortaleza A Sporting 25 21 81 12
14 At. Chpr. Alcobendas Sub 12 Chpr. 25 20 93 8
TEMPORADA 2015/2016
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Sub 12 Atlético 26 130 7 74
2 Real Madrid Sub 12 B Real Madrid 26 148 10 73
3 Rayo Vallecano B Rayo 26 86 21 64
4 Atletico Madrileño A Atletico 26 68 47 47
5 Unión Adarve Sub 12 Unión 26 45 43 44
6 Deportivo Av Santa Ana A Deportivo 26 57 69 41
7 Las Rozas A Las Rozas A 26 46 62 32
8 Nuevo Boadilla Sub 12 Nuevo 26 38 48 31
9 Alcobendas Levitt A Alcobendas 26 30 59 29
10 Rayo Majadahonda Rayo 26 38 56 26
11 CF Pozuelo B Pozuelo 26 38 67 25
12 Siete Picos Colmenar A Siete Picos 26 29 68 21
13 Aravaca A Aravaca A 26 24 73 13
14 Torrelodones A Torrelodones 26 7 154 2
TEMPORADA 2014/2015
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Sub 12 Atlético 26 81 4 72
2 Real Madrid Sub 12 B Real Madrid 26 109 9 71
3 Rayo Vallecano B Rayo 26 76 21 58
4 Atletico Madrileño A Atletico 26 40 38 45
5 Unión Adarve Sub 12 Unión 26 52 37 43
6 Alcobendas Levitt A Alcobendas 26 24 36 32
7 Las Rozas A Las Rozas A 26 27 45 32
8 Nuevo Boadilla Sub 12 Nuevo 26 39 71 29
9 Aravaca A Aravaca A 26 29 46 25
10 Union Zona Norte Sub 12 Union Zona. 26 26 41 24
11 CF Pozuelo A Pozuelo 26 30 54 24
12 R. Ciudad Alcobendas Sub 12 Ciudad 26 20 47 24
13 San Agustin de Guadalix A Agustin 26 28 71 17
14 EFMO Boadilla Sub 12 EFMO 26 24 85 16

  USO DE MEMORIA  
5,596,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0870
Total Execution Time  0.0883
  CADENA URL  
/historico/Ad-Union-Adarve-A-Alevin
  GET DATOS  
$_GET['/historico/Ad-Union-Adarve-A-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0027  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 = 'Ad-Union-Adarve-A-Alevin' 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=40482 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=40482 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0045  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 = 74222
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=40482 AND type_rel = 2
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2724 AND type_rel = 3
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 = '40482' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '40482' 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 = 74222 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=40482 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 (74222) 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 = 74222 AND teamId = 40482
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 = 74222 AND t.round = 26 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 = '40482' 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 = '40482' 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 = 40482 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74222 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 `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 = 70510 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.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 = 64881 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.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 `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 = 61490 AND t.round = 17 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 = 45481 AND t.round = 26 ORDER BY team.conference 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 `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 = 41619 AND t.round = 26 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 = 34513 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 = 17995 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 `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 = 6528 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 74222 ORDER BY nameShow LIMIT 100