4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Real Madrid Sub 14 B
TEMPORADA 2023/2024
DIVISIÓN HONOR MADRID INFANTIL
Equipo PJ GF GC Puntos
1 Real Madrid Sub 14 B Real Madrid 25 97 16 68
2 Getafe Sub 14 C Getafe 26 82 16 63
3 Sporting Hortaleza Sub 14 Sporting 26 75 37 63
4 Rayo Majadahonda Sub 14 Rayo 26 74 32 56
5 Leganés Sub 14 Leganés 26 51 32 47
6 Atlético Sub 14 B Atlético 26 44 31 47
7 Football Dreams Sub 14 Football 26 57 37 46
8 Union Adarve Sub 14 Union Adarve 25 49 41 42
9 Atlético Alcobendas Sub 14 Atlético 26 40 48 31
10 Galapagar Sub 14 Galapagar 26 29 38 30
11 Aravaca FC Sub 14 Aravaca 26 35 63 19
12 Canillas Sub 14 Canillas 25 28 57 18
13 Complutense Alcalá Sub 14 Complutense 26 21 51 16
14 Las Rozas Sub 14 Rozas 25 14 49 15
15 CD Dosa Sub 14 Dosa 25 14 82 13
16 AD Torrejón Sub 14 Torrejón 25 11 91 6
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
DIVISIÓN HONOR MADRID INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Getafe Sub 14 Getafe 16 65 11 43
2 Atlético Sub 14 B Atlético 16 41 11 36
3 CD Móstoles Sub 14 Móstoles 16 42 15 33
4 Leganés Sub 14 Leganés 16 38 15 33
5 Atlético Madrileño Sub 14 Atlético 16 32 23 29
6 Real Madrid Sub 14 B Real Madrid 16 39 24 27
7 Parla Escuela Sub 14 Parla 16 39 20 26
8 Trival Valderas Sub 14 Trival 16 22 14 26
9 Fuenlabrada Sub 14 Fuenlabrada 16 28 18 25
10 Seseña Sub 14 Seseña 16 24 18 25
11 Rayo Vallecano Sub 14 Rayo 16 27 23 18
12 ED. Moratalaz Sub 14 Moratalaz 16 25 41 14
13 Atletico de Pinto A Atletico 16 13 27 13
14 Periso CF Sub 14 Periso 16 13 45 13
15 Unión Carrascal Sub 14 Unión 16 15 42 12
16 Alcorcón Sub 14 Alcorcón 16 22 56 9
17 Colonia Moscardo A Colonia 16 11 93 3
TEMPORADA 2019/2020
DIVISIÓN HONOR MADRID INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Rayo Vallecano Sub 14 Rayo 17 61 12 43
2 Getafe Sub 14 Getafe 18 56 22 43
3 Real Madrid Sub 14 B Real Madrid 17 50 15 41
4 Leganés Sub 14 Leganés 17 62 17 38
5 Parla Escuela A Parla 18 42 28 35
6 CD Móstoles Sub 14 Móstoles 18 48 28 32
7 Atlético Madrileño Sub 14 Atlético 17 24 25 23
8 Atlético Sub 14 B Atlético 17 35 37 23
9 Unión Carrascal Sub 14 Unión 18 25 39 17
10 Seseña Sub 14 Seseña 18 17 31 16
11 Fuenlabrada Sub 14 Fuenlabrada 18 25 47 16
12 Trival Valderas Sub 14 Trival 18 28 64 13
13 Alcorcón Sub 14 Alcorcón 17 19 40 11
14 Colonia Moscardo A Colonia 18 4 91 0
TEMPORADA 2018/2019
DIVISIÓN HONOR MADRID INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Leganés Sub 14 Leganés 26 81 24 67
2 Fuenlabrada Sub 14 Fuenlabrada 26 80 44 51
3 Real Madrid Sub 14 B Real Madrid 26 54 38 43
4 Atlético Madrileño Sub 14 Atlético 26 56 43 43
5 ED. Moratalaz Sub 14 Moratalaz 26 55 43 42
6 Unión Carrascal Sub 14 Unión 26 42 42 38
7 Atlético Sub 14 B Atlético 26 47 48 35
8 CD Móstoles Sub 14 Móstoles 26 43 56 33
9 Trival Valderas Sub 14 Trival 26 43 52 32
10 Alcorcón Sub 14 Alcorcón 26 51 63 32
11 Rayo Vallecano Sub 14 Rayo 26 32 51 32
12 Getafe Sub 14 Getafe 26 33 50 29
13 Escuela Futbol de Brunete Escuela 26 37 68 20
14 CF Pozuelo A Pozuelo 26 41 73 20
TEMPORADA 2017/2018
DIVISIÓN HONOR MADRID INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Sub 14 Atlético 25 134 12 73
2 Real Madrid Sub 14 B Real Madrid 26 96 27 68
3 CD Móstoles Sub 14 Móstoles 26 61 28 58
4 Leganés Sub 14 Leganés 26 57 51 42
5 Las Rozas CF A Rozas 26 39 37 38
6 Fuenlabrada Sub 14 Fuenlabrada 26 58 58 34
7 Getafe Sub 14 Getafe 26 43 48 31
8 Rayo Vallecano Sub 14 B Rayo 26 36 61 31
9 Union Adarve Sub 14 Union Adarve 26 29 37 29
10 Alcorcón Sub 14 Alcorcón 26 23 43 27
11 Illescas A Illescas A 26 42 69 26
12 Ciudad de Getafe Sport Club Ciudad 25 40 55 23
13 Nuevo Boadilla Sub 14 Nuevo 26 31 79 20
14 Lugo Fuenlabrada A Lugo 26 20 104 7
TEMPORADA 2016/2017
DIVISIÓN HONOR MADRID INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Rayo Vallecano Sub 14 Rayo 26 87 30 62
2 CD Móstoles Sub 14 Móstoles 26 57 23 59
3 Leganés Sub 14 Leganés 26 70 19 58
4 Atlético Sub 14 B Atlético 26 55 41 49
5 Alcorcón Sub 14 Alcorcón 26 62 34 45
6 Real Madrid Sub 14 B Real Madrid 26 56 40 45
7 Ciudad de Getafe Sport Club Ciudad 26 50 28 41
8 Fuenlabrada Sub 14 Fuenlabrada 26 34 44 33
9 Illescas A Illescas A 26 40 54 30
10 Getafe Sub 14 Getafe 26 37 55 28
11 Unión Carrascal Sub 14 Unión 26 25 44 26
12 Trival Valderas Sub 14 Trival 26 32 63 20
13 Asoc. Cultural El Bercial A Asoc. 26 25 84 12
14 Union Deportiva La Poveda A Union 26 10 81 6
TEMPORADA 2015/2016
DIVISIÓN HONOR MADRID INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 CD Móstoles Sub 14 Móstoles 26 62 23 59
2 Getafe Sub 14 Getafe 26 68 17 58
3 Leganés Sub 14 Leganés 26 70 19 57
4 Atlético Sub 14 B Atlético 26 47 33 49
5 Alcorcón Sub 14 Alcorcón 26 48 37 44
6 Real Madrid Sub 14 B Real Madrid 26 54 37 43
7 Illescas A Illescas A 26 46 40 42
8 Trival Valderas Sub 14 Trival 26 46 40 42
9 Union Deportiva La Poveda A Union 26 58 42 39
10 EFMO Boadilla Sub 14 EFMO 26 44 58 31
11 Rayo Vallecano Sub 14 Rayo 26 33 62 20
12 Los Yebenes-San Bruno A Yebenes-San 26 27 72 18
13 San Blas A San Blas A 26 27 67 14
14 Atlético Madrileño Sub 14 Atlético 26 14 97 1

  USO DE MEMORIA  
5,590,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.0825
Total Execution Time  0.0837
  CADENA URL  
/historico/Real-Madrid-Cf-B-Infantil
  GET DATOS  
$_GET['/historico/Real-Madrid-Cf-B-Infantil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0044  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 = 74221
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=71215 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 71215 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  SELECT /*35 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 (416489,603723,722551,726847,807367) ORDER BY n.cover_points DESC, update_date DESC
0.0022  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 = '71215' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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.0027  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=71215 AND l.year in (2023,2024,2025) 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 (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.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74221 AND teamId = 71215
0.0020  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 = '71215' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '71215' and rp.type = 4
0.0020  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 = '71215' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 = 71215 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.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 `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.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 `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 = 61489 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.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 `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 = 52244 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.0026  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 = 45464 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 `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 = 40770 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 34386 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 = 17541 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC