4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Villa Rosa A
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
PREFERENTE MADRID ALEVÍN F11 GRUPO 4
Equipo PJ GF GC Puntos
1 Villa Rosa A Villa Rosa 26 87 23 71
2 Esperanza A Esperanza A 26 72 23 59
3 Sporting Hortaleza B Sporting 26 64 21 59
4 Canillas B Canillas B 26 49 40 46
5 Fundación Recuerdo Fundación 26 46 37 41
6 Madrid Femenino A Madrid 26 37 27 40
7 Barrio Pilar A Barrio Pilar 26 50 34 39
8 Union Adarve B Union Adarve 26 49 60 39
9 Club San Agustin A Club Agustin 26 47 37 38
10 Dosa A Dosa A 26 49 47 31
11 Celtic Castilla A Celtic 26 35 54 22
12 Fundacion A Fundacion A 26 34 62 15
13 Valdeluz A Valdeluz A 26 34 91 13
14 Club San Jose del Parque Club Jose P. 26 17 114 5
TEMPORADA 2017/2018
1ª MADRID ALEVÍN F11 GRUPO 12
Equipo PJ GF GC Puntos
1 Madrid Femenino Madrid 24 164 18 67
2 Villa Rosa A Villa Rosa 24 124 11 64
3 Vicalvaro C Vicalvaro C 24 85 30 55
4 Deportivo Santa Ana B Deportivo 24 79 38 50
5 Adae Simancas Adae 24 63 46 44
6 Esperanza B Esperanza B 24 71 65 35
7 Sporting Hortaleza B Sporting 24 58 46 32
8 Canillas C Canillas C 24 65 59 30
9 Dosa B Dosa B 24 50 100 26
10 San Blas D San Blas D 24 48 66 22
11 Julian Marias Julian 24 48 117 19
12 Alameda de Osuna B Alameda 24 24 117 7
13 Club Fundacion Rayo Valleca Club 24 15 181 4
TEMPORADA 2016/2017
PREFERENTE MADRID ALEVÍN F11 GRUPO 3
Equipo PJ GF GC Puntos
1 EF Concepcion Sub 12 Concepcion 26 134 17 69
2 San Roque A San Roque A 26 95 22 59
3 Canillas Canillas 26 89 31 58
4 Club San Agustin A Club Agustin 26 94 26 57
5 Esperanza A Esperanza A 26 79 23 57
6 Chamartin Vergara A Chamartin 26 50 35 40
7 Club Atletico de Madrid G Club 26 60 38 37
8 Colegio Alameda de Osuna A Colegio 26 59 56 34
9 Fundación Recuerdo Fundación 26 56 64 30
10 Celtic Castilla A Celtic 26 58 79 29
11 Villa Rosa A Villa Rosa 26 50 69 28
12 Atletico Madrileño D Atletico 26 38 69 19
13 Periso Periso 26 26 134 9
14 Coslada C Coslada C 26 8 233 0
TEMPORADA 2015/2016
1ª MADRID ALEVÍN F11 GRUPO 11
Equipo PJ GF GC Puntos
1 Villa Rosa A Villa Rosa 22 81 15 59
2 San Roque A San Roque A 22 78 18 51
3 Union Zona Norte D Union Zona. 22 57 24 49
4 Aravaca C Aravaca C 22 52 25 41
5 Alameda de Osuna B Alameda 22 54 40 37
6 Sporting Hortaleza B Sporting 22 42 31 36
7 Palestra Atenea C Palestra 22 53 43 36
8 Escfutbarrio Pilar B Escfutbarrio 22 31 58 20
9 Canillas C Canillas C 22 24 45 18
10 Escuela Futbol Concepcion C Escuela 22 8 57 11
11 San Jose A San Jose A 22 19 91 10
12 Fundacion B Fundacion B 22 20 72 7
TEMPORADA 2014/2015
PREFERENTE MADRID ALEVÍN F11 GRUPO 4
Equipo PJ GF GC Puntos
1 Chamartin Vergara A Chamartin 26 98 19 68
2 Alameda de Osuna A Alameda 26 102 24 68
3 Alcala C Alcala C 26 74 34 52
4 Avance B Avance B 26 53 44 48
5 Esperanza A Esperanza A 26 78 61 45
6 Colegio Alameda de Osuna A Colegio 26 49 41 38
7 Dosa A Dosa A 26 43 44 36
8 Escuela Futbol Concepcion B Escuela 26 36 52 34
9 Rayo Ciudad Alcobendas C Rayo Ciudad 26 44 66 32
10 Oña Sanchinarro Oña 26 36 46 31
11 Canillas B Canillas B 26 37 53 27
12 Villa Rosa A Villa Rosa 26 31 41 24
13 San Roque A San Roque A 26 20 103 11
14 Naya B Naya B 26 18 91 6

  USO DE MEMORIA  
5,299,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6143
Total Execution Time  0.6155
  CADENA URL  
/historico/Ad-Villa-Rosa-A-Alevin
  GET DATOS  
$_GET['/historico/Ad-Villa-Rosa-A-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0149  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-Villa-Rosa-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.0156  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-Villa-Rosa-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.0155  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=40629 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=40629 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=40629 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=40629 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=40629 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=40629 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=40629 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=40629 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=40629 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=40629 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2505 AND type_rel = 3
0.0148  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 = '40629' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '40629' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = '40629' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 64881 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151  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=40629 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (64881,61490) 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.0145  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64881 AND teamId = 40629
0.0146  SELECT count(id) as num_players from rel_players_base WHERE league_id = 61490 AND teamId = 40629
0.0145  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2022` 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '40629' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148  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 = '40629' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0148  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 = 40629 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0151  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.0149  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.0149  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 = 46784 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 41016 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 34520 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 18017 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 = 6536 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 6534 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 64881 ORDER BY nameShow LIMIT 100