4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Rayo Majadahonda Sub 14
TEMPORADA 2023/2024
DIVISIÓN HONOR MADRID INFANTIL
Equipo PJ GF GC Puntos
TEMPORADA 2022/2023
DIVISIÓN HONOR MADRID INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 14 B Real Madrid 29 114 33 73
2 Rayo Alcobendas Sub 14 Rayo 29 98 19 70
3 Colegio Miramadrid Sub 14 Colegio 29 77 13 70
4 Atlético Sub 14 B Atlético 29 78 38 64
5 Atlético Alcobendas Sub 14 Atlético 29 95 35 62
6 Rayo Majadahonda Sub 14 Rayo 29 58 31 57
7 Union Adarve Sub 14 Union Adarve 29 74 61 45
8 Complutense Alcalá Sub 14 Complutense 29 59 50 45
9 Aravaca FC Sub 14 Aravaca 29 74 66 38
10 Canillas Sub 14 Canillas 29 41 53 34
11 Sporting Hortaleza Sub 14 Sporting 29 55 81 32
12 Club Poligono H San Blas A Club 29 41 85 23
13 Juventud Sanse A Juventud 29 37 86 22
14 CF Pozuelo A Pozuelo 29 25 86 14
15 Coslada A Coslada A 29 28 127 11
16 CD San Fernando Fernando 29 26 116 5
TEMPORADA 2021/2022
DIVISIÓN HONOR MADRID INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 14 B Real Madrid 30 92 23 76
2 Atlético Sub 14 B Atlético 30 87 28 67
3 Chamartín Alcobendas Sub 14 Chamartín 30 85 35 63
4 Periso CF Sub 14 Periso 30 74 30 62
5 Rayo Alcobendas Sub 14 Rayo 29 56 31 56
6 Union Adarve Sub 14 Union Adarve 30 58 34 54
7 Complutense Alcalá Sub 14 Complutense 30 60 49 51
8 Aravaca FC Sub 14 Aravaca 30 63 43 49
9 Canillas Sub 14 Canillas 30 49 47 46
10 Coslada A Coslada A 30 47 45 39
11 CD San Fernando Fernando 30 48 58 36
12 Rayo Majadahonda Sub 14 Rayo 29 44 50 33
13 Atletico Madrileño B Atletico 30 41 104 23
14 Getafe Sub 14 C Getafe 30 23 73 15
15 Torrejon B Torrejon B 30 24 83 12
16 Escuela Futbol Concepcion A Escuela 30 22 140 1
TEMPORADA 2020/2021
1ª AUTO. MADRID INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Canillas Sub 14 Canillas 15 65 18 38
2 Rayo Majadahonda Sub 14 Rayo 15 43 5 38
3 Nuevo Boadilla Sub 14 Nuevo 15 38 17 32
4 Chamartín Alcobendas Sub 14 Chamartín 15 47 24 31
5 EFMO Boadilla Sub 14 EFMO 15 26 19 30
6 Galapagar Sub 14 Galapagar 15 33 15 29
7 Futbol Tres Cantos A Futbol Tres 15 25 19 29
8 Union Zona Norte A Union Zona. 15 35 20 27
9 Colmenar Viejo A Colmenar 15 26 23 22
10 San Sebastian Reyes A Sebastian 15 34 27 20
11 CF Pozuelo A Pozuelo 15 35 33 15
12 Sporting Hortaleza B Sporting 15 19 30 13
13 Ciudad del Futbol B Ciudad 15 16 39 9
14 Recreativo Soto del Real Recreativo 15 16 43 8
15 Alpedrete A Alpedrete A 15 14 80 5
16 Atletico Villalaba A Atletico 15 11 71 3
TEMPORADA 2019/2020
1ª AUTO. MADRID INFANTIL GRUPO 4
Equipo PJ GF GC Puntos
1 Ciudad del Futbol A Ciudad 19 54 4 52
2 Escuela Futbol de Brunete Escuela 19 58 16 45
3 Getafe Sub 14 C Getafe 19 47 13 39
4 Club Atletico de Madrid D Club 19 44 26 38
5 Mostoles Urjc C Mostoles 19 37 24 37
6 EFMO Boadilla Sub 14 EFMO 19 40 24 30
7 Rayo Majadahonda Sub 14 Rayo 19 27 18 30
8 Nuevo Boadilla Sub 14 Nuevo 19 32 26 28
9 EMF Aluche Sub 14 Aluche 19 22 27 23
10 CF Pozuelo A Pozuelo 19 30 42 20
11 Villaviciosa de Odon A Villaviciosa 19 21 46 12
12 Navalcarnero A Navalcarnero 19 15 41 11
13 Fundacion Rayo Vallecano B Fundacion 19 14 47 9
14 Los Yebenes-San Bruno A Yebenes-San 19 12 99 2
TEMPORADA 2018/2019
1ª AUTO. MADRID INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Sporting Hortaleza Sub 14 Sporting 26 74 16 63
2 Aravaca FC Sub 14 Aravaca 26 53 26 53
3 Rayo Majadahonda Sub 14 Rayo 26 58 24 52
4 Ciudad del Futbol A Ciudad 26 54 26 52
5 Nuevo Boadilla Sub 14 Nuevo 26 71 34 48
6 Union Zona Norte A Union Zona. 26 41 25 47
7 EFMO Boadilla Sub 14 EFMO 26 34 18 43
8 Colmenar Viejo A Colmenar 26 52 45 37
9 Deportivo Av Santa Ana A Deportivo 26 34 58 31
10 Galapagar Sub 14 Galapagar 26 21 42 23
11 Celtic Castilla A Celtic 26 34 58 22
12 Santa Barbara Getafe E Santa 26 27 65 20
13 Siete Picos Colmenar A Siete Picos 26 31 85 14
14 Fundacion A Fundacion A 26 32 94 9
TEMPORADA 2017/2018
1ª AUTO. MADRID INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 CF Pozuelo A Pozuelo 26 94 34 64
2 Escuela Futbol de Brunete Escuela 26 81 22 59
3 Deportivo Av Santa Ana A Deportivo 26 74 30 55
4 Rayo Majadahonda Sub 14 Rayo 26 86 37 54
5 Aravaca FC Sub 14 Aravaca 26 50 33 45
6 Galapagar Sub 14 Galapagar 26 51 35 45
7 Ciudad del Futbol A Ciudad 26 38 29 38
8 EFMO Boadilla Sub 14 EFMO 26 51 45 35
9 Union Zona Norte A Union Zona. 26 50 44 33
10 Siete Picos Colmenar A Siete Picos 26 41 55 33
11 Fund Recuerdo A Fund 26 32 51 23
12 Union Adarve B Union Adarve 26 35 60 21
13 Collado Villalba A Collado 26 21 66 11
14 Recreativo Soto del Real Recreativo 26 3 166 2
TEMPORADA 2016/2017
DIVISIÓN HONOR MADRID INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 14 Real Madrid 26 115 11 74
2 Atlético Sub 14 Atlético 26 113 11 70
3 Alcobendas-Levitt A Alcobendas-L 26 44 32 46
4 Getafe Sub 14 B Getafe 26 46 28 44
5 RSD Alcalá Sub 14 Alcalá 26 53 41 41
6 Las Rozas CF A Rozas 26 36 28 40
7 Union Adarve Sub 14 Union Adarve 26 36 37 37
8 Union San Fernando A Union 26 45 62 31
9 Rayo Alcobendas Sub 14 Rayo 26 28 45 30
10 Sporting Hortaleza Sub 14 Sporting 26 34 54 29
11 EFMO Boadilla Sub 14 EFMO 26 18 63 28
12 Rayo Majadahonda Sub 14 Rayo 26 22 65 20
13 Union Zona Norte A Union Zona. 26 18 57 17
14 Club Fundacion Rayo Valleca Club 26 13 87 5
TEMPORADA 2015/2016
DIVISIÓN HONOR MADRID INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 14 Real Madrid 26 133 15 73
2 Atlético Sub 14 Atlético 26 151 6 71
3 Rayo Vallecano Sub 14 B Rayo 26 100 30 63
4 Alcobendas-Levitt A Alcobendas-L 26 69 39 49
5 Getafe Sub 14 B Getafe 26 62 43 44
6 RSD Alcalá Sub 14 Alcalá 26 60 48 42
7 Union Adarve Sub 14 Union Adarve 26 52 40 41
8 Rayo Alcobendas Sub 14 Rayo 26 41 34 36
9 Las Rozas CF A Rozas 26 38 61 28
10 Rayo Majadahonda Sub 14 Rayo 26 40 75 24
11 Canillas Sub 14 Canillas 26 35 75 23
12 Atletico Madrileño A Atletico 26 23 62 14
13 San Sebastian Reyes A Sebastian 26 20 118 12
14 Naya A Naya A 26 8 186 1
TEMPORADA 2014/2015
DIVISIÓN HONOR MADRID INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Club Atletico de Madrid G Club 26 168 9 76
2 Real Madrid A Real Madrid 25 148 8 70
3 Alcobendas-Levitt A Alcobendas-L 26 55 42 54
4 Getafe B Getafe B 26 42 26 45
5 Alcalá A Alcalá A 26 34 42 38
6 Atletico Madrileño A Atletico 25 42 41 35
7 Canillas Sub 14 Canillas 25 40 56 32
8 Rayo Majadahonda Sub 14 Rayo 26 47 48 31
9 Unión Adarve A Unión 26 41 51 31
10 Las Rozas A Las Rozas A 26 32 71 31
11 San Fernando A Fernando 26 24 64 25
12 Aravaca FC Sub 14 Aravaca 25 39 62 23
13 Deportivo Santa Ana A Deportivo 26 15 74 20
14 Alameda de Osuna A Alameda 26 10 143 1

  USO DE MEMORIA  
5,567,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  2.6517
Total Execution Time  2.6537
  CADENA URL  
/historico/Rayo-Majadahonda-A-Infantil
  GET DATOS  
$_GET['/historico/Rayo-Majadahonda-A-Infantil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.2390  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 = 'Rayo-Majadahonda-A-Infantil' 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=23139 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=23139 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=23139 AND type_rel = 2
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=738 AND type_rel = 3
0.1029  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 738 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.1012  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 (1096475,969181,930948,914706,879368) ORDER BY n.cover_points DESC, update_date DESC
0.0851  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 = '23139' ORDER BY l.year DESC,cat.coefficient DESC
0.0765  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 = '23139' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.1150  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 = '23139' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0850  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 = 74221 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.1058  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=23139 AND l.year in (2023,2024,2025) 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 (74221) 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.0640  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74221 AND teamId = 23139
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 = 74221 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.3378  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 = '23139' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '23139' and rp.type = 4
0.0242  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 = '23139' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0347  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 = 23139 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,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 = 74221 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.1228  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 = 70508 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1779  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 = 65066 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.0934  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 = 61300 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0423  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 = 52290 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.0967  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 = 46393 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1181  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 = 40779 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1923  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 = 34385 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.2173  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 = 17540 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1661  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 = 4677 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC