4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Chamartín Alcobendas Sub 14
TEMPORADA 2023/2024
SUPERLIGA MADRID INFANTIL
Equipo PJ GF GC Puntos
1 Atlético Sub 14 Atlético 24 79 13 67
2 Real Madrid Sub 14 Real Madrid 25 93 18 63
3 Getafe Sub 14 Getafe 25 78 31 54
4 Rayo Alcobendas Sub 14 Rayo 26 63 25 54
5 CD Móstoles Sub 14 Móstoles 26 51 32 45
6 Leganés Sub 14 Leganés 25 38 24 44
7 Colegio Miramadrid Sub 14 Colegio 26 49 37 43
8 Rayo Vallecano Sub 14 Rayo 26 44 40 36
9 Parla Escuela Sub 14 Parla 25 31 47 36
10 Periso CF Sub 14 Periso 25 31 31 33
11 Fuenlabrada Sub 14 Fuenlabrada 26 44 51 29
12 AD Torrejon Sub 14 Torrejon 25 28 44 27
13 Unión Carrascal Sub 14 Unión 25 24 60 19
14 RSD Alcalá Sub 14 Alcalá 26 20 92 14
15 Atlético Madrileño Sub 14 Atlético 26 22 85 13
16 Chamartín Alcobendas Sub 14 Chamartín 25 10 75 6
TEMPORADA 2022/2023
SUPERLIGA MADRID INFANTIL
Equipo PJ GF GC Puntos
1 Real Madrid Sub 14 Real Madrid 30 139 10 85
2 Atlético Sub 14 Atlético 30 127 23 79
3 Leganés Sub 14 Leganés 30 70 18 78
4 Rayo Vallecano Sub 14 Rayo 30 65 35 53
5 Atlético Madrileño Sub 14 Atlético 30 70 63 52
6 Getafe Sub 14 Getafe 30 56 54 49
7 AD Torrejon Sub 14 Torrejon 30 49 66 46
8 Periso Club de Futbol Periso Club 30 78 58 45
9 Fuenlabrada Sub 14 Fuenlabrada 30 53 49 37
10 Parla Escuela Sub 14 Parla 30 37 52 36
11 Chamartín Alcobendas Sub 14 Chamartín 30 43 74 34
12 RSD Alcalá Sub 14 Alcalá 30 43 99 31
13 Las Rozas A Las Rozas A 30 36 58 25
14 Nuevo Boadilla Sub 14 Nuevo 30 35 60 23
15 Football Dreams Sub 14 Football 30 24 111 8
16 ED. Moratalaz Sub 14 Moratalaz 30 25 120 8
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
2ª MADRID INFANTIL GRUPO 20
Equipo PJ GF GC Puntos
1 Club San Jose del Parque B Club Jose P. 12 52 7 32
2 Union El Parque Union Parque 12 44 13 30
3 Olimpico Las Rosas Olimpico 12 39 14 29
4 Chamartín Alcobendas Sub 14 Chamartín 12 35 15 24
5 AD San Pascual-Montpellier Pascual-Mont 12 29 24 20
6 Arroyofresno C Arroyofresno 12 26 23 19
7 Escuela de Futbol Concepcio Escuela 12 35 36 18
8 Escuela Deportiva Almudena Escuela 12 35 40 15
9 Aula CF B Aula CF B 12 26 43 10
10 Dosa C Dosa C 12 23 56 9
11 AD Esperanza D Esperanza 12 17 34 7
12 Dep Inter España Inter 12 18 50 7
13 Cr Guindalera Guindalera 12 16 40 6
TEMPORADA 2019/2020
1ª AUTO. MADRID INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Juventud Sanse A Juventud 19 67 19 52
2 Deportivo Av Santa Ana A Deportivo 19 52 25 43
3 UD San Sebastian Reyes Sebastian 19 60 25 40
4 Atletico Villalaba A Atletico 19 35 17 37
5 Canillas Sub 14 Canillas 19 34 23 37
6 FEPE Getafe III A FEPE Getafe 19 46 20 35
7 Cabra Futbol Base Cabra Futbol 19 33 22 35
8 Union Zona Norte A Union Zona. 19 24 29 22
9 CD Galapagar F Galapagar 19 30 39 16
10 Alpedrete A Alpedrete A 19 33 52 16
11 Chamartín Alcobendas Sub 14 Chamartín 19 26 62 14
12 Colmenar Viejo Colmenar 19 18 46 11
13 Club San Agustin A Club Agustin 19 22 59 9
14 Recreativo Soto del Real Recreativo 19 20 62 7
TEMPORADA 2018/2019
1ª AUTO. MADRID INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Atlético Alcobendas Sub 14 Atlético 26 84 25 68
2 Coslada A Coslada A 26 66 19 61
3 Futbol Tres Cantos A Futbol Tres 26 75 20 59
4 San Blas A San Blas A 26 64 31 56
5 Juventud Sanse A Juventud 26 74 37 51
6 Club Atletico de Madrid D Club 26 54 42 37
7 Espartales Sur A Espartales 26 48 34 36
8 San Sebastian Reyes A Sebastian 26 36 34 35
9 Chamartín Alcobendas Sub 14 Chamartín 26 40 45 32
10 CD Dosa Sub 14 Dosa 26 42 65 28
11 Colegio Alameda de Osuna A Colegio 26 33 51 22
12 RSD Alcala B Alcala 26 27 60 18
13 Avance A Avance A 26 29 51 15
14 Alcobendas-Levitt A Alcobendas-L 26 10 168 0
TEMPORADA 2017/2018
DIVISIÓN HONOR MADRID INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Real Madrid Sub 14 Real Madrid 26 163 3 78
2 Rayo Vallecano Sub 14 Rayo 26 108 22 64
3 Getafe Sub 14 B Getafe 26 59 32 49
4 RSD Alcalá Sub 14 Alcalá 26 63 44 41
5 ED. Moratalaz Sub 14 Moratalaz 26 36 38 40
6 Atlético Madrileño Sub 14 Atlético 26 42 42 38
7 Union San Fernando A Union 26 66 57 34
8 Atlético Sub 14 B Atlético 26 48 57 32
9 Rayo Alcobendas Sub 14 Rayo 26 34 52 32
10 Complutense Alcalá Sub 14 Complutense 26 27 53 31
11 Alcobendas-Levitt A Alcobendas-L 26 36 52 27
12 Sporting Hortaleza Sub 14 Sporting 26 34 59 25
13 Chamartín Alcobendas Sub 14 Chamartín 26 31 107 18
14 Ciudad de Getafe Sport Club Ciudad 26 17 146 3

  USO DE MEMORIA  
5,305,704 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0853
Total Execution Time  0.0866
  CADENA URL  
/historico/Cd-Chamartin-Vergara-Alcobendas-C-Infantil
  GET DATOS  
$_GET['/historico/Cd-Chamartin-Vergara-Alcobendas-C-Infantil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0026  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 = 'Cd-Chamartin-Vergara-Alcobendas-C-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=104683 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=104683 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 74220
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=104683 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2585 AND type_rel = 3
0.0021  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 = '104683' ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '104683' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
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 = '104683' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 74220 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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=104683 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 (74220) 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 = 74220 AND teamId = 104683
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 = 74220 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 = '104683' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
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 = '104683' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 104683 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 = 74220 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 = 68938 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.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 `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.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 `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.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 `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 = 61441 AND t.round = 13 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 = 52287 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.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 `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 = 46394 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 = 40475 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 `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 = 40771 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC