4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Aravaca A
TEMPORADA 2021/2022
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Aravaca A Aravaca A 26 84 42 51
2 Union Zona Norte Sub 12 Union Zona. 26 64 34 51
3 CDE FPA Las Rozas Sub 12 Rozas 25 47 25 48
4 Villanueva del Pardillo A Villanueva 25 52 37 48
5 Rayo B Rayo B 26 58 27 46
6 RSD Alcalá SAD B Alcalá 26 58 35 46
7 Nuevo Boadilla B Nuevo 26 66 42 43
8 Getafe D Getafe D 26 53 42 43
9 Atletico Villalba A Atletico 26 41 43 35
10 Mostoles C Mostoles C 26 30 36 29
11 Club Fuentelarreyna A Club 26 36 45 28
12 Electrocor Las Rozas Electrocor 26 32 90 18
13 Union Adarve B Union Adarve 26 39 100 14
14 Eepp San Fernando Escolapio Eepp 26 33 95 8
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 2019/2020
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 12 B Real Madrid 20 100 6 57
2 Atletico Montaura Atletico 20 107 8 55
3 CF Rayo Majadahonda Rayo 19 42 15 42
4 Ciudad de Baza A Ciudad Baza 19 38 30 34
5 AD Villa Rosa Villa Rosa 19 35 32 33
6 Canillas Canillas 19 38 20 32
7 Las Rozas CF-Nuicon-Asuman Rozas 19 32 46 27
8 Sporting Hortaleza A Sporting 19 38 46 26
9 AD Union Adarve Union Adarve 20 29 55 22
10 San Roque A San Roque A 19 22 55 21
11 Union Zona Norte Sub 12 Union Zona. 19 30 64 16
12 Atletico Villalba A Atletico 18 23 51 10
13 Aravaca A Aravaca A 19 13 51 7
14 Torrelodones A Torrelodones 19 7 75 5
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
PREFERENTE MADRID ALEVÍN F11 GRUPO 1
Equipo PJ GF GC Puntos
1 Ciudad del Futbol Ciudad 24 102 8 65
2 Aravaca A Aravaca A 24 90 22 60
3 Atletico Villalba A Atletico 24 76 23 60
4 CF Pozuelo A Pozuelo 24 71 27 45
5 Villanueva de La Cañada A Villanueva 24 59 44 39
6 Union Adarve B Union Adarve 24 50 63 33
7 Galapagar A Galapagar A 24 44 45 31
8 Barrio Pilar A Barrio Pilar 24 39 54 28
9 Las Rozas B Las Rozas B 24 25 52 21
10 Alberto Cogorro A Alberto 24 43 90 21
11 Union Zona Norte B Union Zona. 24 33 63 20
12 Torrelodones A Torrelodones 24 26 89 17
13 Alpedrete A Alpedrete A 24 15 93 2
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,370,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1066
Total Execution Time  0.1078
  CADENA URL  
/historico/Aravaca-Cf-A-Alevin
  GET DATOS  
$_GET['/historico/Aravaca-Cf-A-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0023  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 = 'Aravaca-Cf-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.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 = 'Aravaca-Cf-A-Alevin' 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=40485 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=40485 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=40485 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=40485 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=40485 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=40485 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=40485 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=40485 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=40485 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 64879
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=40485 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=984 AND type_rel = 3
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 984 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (930948,914706,76448) ORDER BY n.cover_points DESC, update_date DESC
0.0024  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 = '40485' ORDER BY l.year DESC,cat.coefficient DESC
0.0028  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 = '40485' AND l.year = 2022 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 = '40485' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '40485' 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 = 64879 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=40485 AND l.year in (2021,2022,2023) 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 (64879) 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 = 64879 AND teamId = 40485
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 = '40485' 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 = '40485' and rp.type = 4
0.0022  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 = '40485' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0023  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 = 40485 AND l.year <= 2022 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 `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 = 64879 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.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 `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.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 `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 = 52472 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.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 `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.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 `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.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 = 34518 AND t.round = 26 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 `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.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 `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