4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Las Rozas 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 2018/2019
1ª MADRID ALEVÍN F11 GRUPO 1
Equipo PJ GF GC Puntos
1 Las Rozas A Las Rozas A 24 65 19 58
2 Gredos-San Diego Gredos-San 24 59 20 54
3 Ciudad del Futbol B Ciudad 24 78 18 53
4 Alberto Cogorro A Alberto 24 77 32 53
5 Rayo B Rayo B 24 52 32 46
6 Colmenar Viejo C Colmenar 24 39 48 33
7 Alpedrete A Alpedrete A 24 53 46 29
8 Electrocor Electrocor 24 43 41 27
9 CDE FPA Las Rozas Sub 12 Rozas 24 38 47 27
10 Efmo Boadilla C Efmo 24 58 53 24
11 CF Pozuelo B Pozuelo 24 32 44 24
12 Nuevo Boadilla D Nuevo 24 29 55 16
13 Recreativo Soto del Real B Recreativo 24 6 174 0
TEMPORADA 2017/2018
PREFERENTE MADRID ALEVÍN F11 GRUPO 1
Equipo PJ GF GC Puntos
1 Las Rozas A Las Rozas A 26 78 13 69
2 Atletico Villalba A Atletico 26 67 21 60
3 Tres Cantos A Tres Cantos 26 62 34 51
4 EFMO Boadilla Sub 12 EFMO 26 55 30 45
5 Nuevo Boadilla B Nuevo 26 44 41 38
6 Siete Picos Colmenar A Siete Picos 26 42 44 38
7 Villanueva de La Cañada A Villanueva 26 41 41 36
8 Galapagar A Galapagar A 26 57 67 32
9 Colmenar Viejo A Colmenar 26 41 45 30
10 San Fernando Escolapio Fernando 26 36 43 30
11 Alberto Cogorro A Alberto 26 31 52 25
12 Recreativo Soto del Real A Recreativo 26 37 59 25
13 CF Pozuelo A Pozuelo 26 22 61 14
14 Club Las Encinas de Boadill Club Encinas 26 36 98 10
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,193,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0630
Total Execution Time  0.0643
  CADENA URL  
/historico/Las-Rozas-Cf-Ucjc-A-Alevin
  GET DATOS  
$_GET['/historico/Las-Rozas-Cf-Ucjc-A-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
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 = 64881
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=40484 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2505 AND type_rel = 3
0.0029  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 = '40484' 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 = '40484' 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 = 64881 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=40484 AND l.year in (2021,2022,2023) 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 (64881) 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 = 64881 AND teamId = 40484
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 = 40484 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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.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 = 47112 AND t.round = 26 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 = 41674 AND t.round = 26 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 `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.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 `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.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 `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