4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del El Real de Manzanares
TEMPORADA 2021/2022
2ª MADRID ALEVÍN F7 GRUPO 6
Equipo PJ GF GC Puntos
1 Vellon Venturada Vellon 21 167 53 58
2 San Agustin de Guadalix A Agustin 22 180 56 56
3 Miraflores de La Sierra Miraflores 22 107 44 51
4 Colmenar Viejo D Colmenar 21 82 70 36
5 Escuela Municipal La Cabrer Escuela 22 87 83 32
6 Molar Sport Molar Sport 21 67 68 29
7 Colmenar Viejo E Colmenar 21 85 87 27
8 Colmenar Viejo Colmenar 22 76 114 24
9 Colmenar Viejo C Colmenar 22 47 95 19
10 El Real de Manzanares Real 21 47 104 18
11 Molareño Molareño 22 33 96 18
12 San Agustin de Guadalix B Agustin 21 37 145 5
TEMPORADA 2019/2020
2ª MADRID ALEVÍN F11 GRUPO 3
Equipo PJ GF GC Puntos
1 CF Collado Villalba Collado 19 107 21 52
2 Rayo C. Alcobendas Sub 12 Rayo 19 66 22 46
3 Atletico Villalba C Atletico 19 95 19 44
4 La Moraleja La Moraleja 19 62 30 43
5 San Agustin de Guadalix C Agustin 19 43 29 35
6 Futbol Tres Cantos Futbol Tres 19 38 22 32
7 Union Deportiva San Agustin Union 19 44 44 30
8 El Real de Manzanares Real 19 37 48 26
9 Recreativo Soto del Real Recreativo 19 28 59 18
10 CDE Academia De Futbol Alco Academia 19 31 65 17
11 AD Colmenar Viejo Colmenar 19 25 63 17
12 EF Siete Picos Colmenar Siete Picos 19 13 42 12
13 Union Deportiva Tres Cantos Union 19 25 63 10
14 Atletico Chopera Alcobendas Atletico 19 13 100 0
TEMPORADA 2016/2017
1ª MADRID ALEVÍN GRUPO 4
Equipo PJ GF GC Puntos
1 FB 3 Cantos A Cantos 16 150 13 48
2 3 Cantos B 3 Cantos B 16 74 35 38
3 Futbol Tres Cantos C Futbol Tres 16 59 46 30
4 Merced A Merced A 16 84 32 28
5 Tres Cantos UD B Tres Cantos 16 46 90 21
6 Merced B Merced B 16 28 60 18
7 Futbol Tres Cantos Futbol Tres 16 43 52 17
8 El Real de Manzanares Real 16 24 90 6
9 Union Deportiva Tres Cantos Union 16 22 112 1
TEMPORADA 2015/2016
2ª MADRID ALEVÍN F11 GRUPO 1
Equipo PJ GF GC Puntos
1 CF Pozuelo C Pozuelo 26 125 12 75
2 Electrocor Electrocor 26 113 16 67
3 El Real de Manzanares Real 26 102 29 63
4 Galapagar B Galapagar B 26 81 32 59
5 Deporte Y Punto Deporte 26 63 51 42
6 Union Collado Villalba B Union 26 70 44 39
7 Rayo Ciudad Alcobendas E Rayo Ciudad 26 46 47 34
8 Atletico Villalba B Atletico 26 47 52 33
9 Nuevo Boadilla F Nuevo 26 35 50 33
10 Torrelodones B Torrelodones 26 43 78 29
11 Boadilla E Boadilla E 26 24 76 21
12 Villanueva del Pardillo C Villanueva 26 33 83 17
13 Futbol Tres Cantos D Futbol Tres 26 17 110 13
14 Udsan Sebastian Reyes E Udsan 26 20 139 1
TEMPORADA 2014/2015
1ª MADRID ALEVÍN F11 GRUPO 1
Equipo PJ GF GC Puntos
1 Recreativo Soto del Real A Recreativo 24 76 18 63
2 Rayo B Rayo B 24 56 25 51
3 Union Collado Villalba A Union 24 56 28 51
4 CF Pozuelo B Pozuelo 24 44 20 48
5 Nuevo Boadilla C Nuevo 24 58 45 36
6 Colmenar Viejo A Colmenar 24 38 35 33
7 Alpedrete A Alpedrete A 24 36 42 32
8 Efmo Boadilla C Efmo 24 33 47 27
9 Rayo Colmenar Viejo A Rayo 24 23 42 25
10 Siete Picos Colmenar C Siete Picos 24 36 61 24
11 Villanueva del Pardillo Dim Villanueva 24 27 60 21
12 Las Rozas U.C.J.C. D Rozas 24 40 68 19
13 El Real de Manzanares Real 24 26 58 10

  USO DE MEMORIA  
5,084,104 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5951
Total Execution Time  0.5964
  CADENA URL  
/historico/Ad-El-Real-De-Manzanares-Alevin
  GET DATOS  
$_GET['/historico/Ad-El-Real-De-Manzanares-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
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-El-Real-De-Manzanares-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.0157  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-El-Real-De-Manzanares-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.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=40592 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=40592 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=40592 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=40592 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=40592 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=40592 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=40592 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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 = 64869
0.0150  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 = 65978
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=40592 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=985 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 = '40592' ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '40592' 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 = '40592' 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 = 65978 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 64869 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153  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=40592 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (65978,64869) 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 = 64869 AND teamId = 40592
0.0145  SELECT count(id) as num_players from rel_players_base WHERE league_id = 65978 AND teamId = 40592
0.0146  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 = 64869 AND t.round = 22 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 = '40592' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0147  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 = '40592' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  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 = 40592 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0147  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 = 64869 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 65978 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 54814 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.0155  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 = 36338 AND t.round = 18 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 = 18023 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 `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 = 6538 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 = 64869 ORDER BY nameShow LIMIT 100