4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del At. Chpr. Alcobendas Sub 12
TEMPORADA 2023/2024
SUPERLIGA MADRID ALEVÍN
Equipo PJ GF GC Puntos
1 Atlético Sub 12 Atlético 25 113 6 73
2 Real Madrid Sub 12 Real Madrid 25 81 12 66
3 Rayo Vallecano Sub 12 Rayo 25 75 21 61
4 Getafe Sub 12 Getafe 25 58 22 53
5 Unión Adarve Sub 12 Unión 25 41 40 41
6 R. Ciudad Alcobendas Sub 12 Ciudad 25 39 58 34
7 Fuenlabrada Sub 12 Fuenlabrada 25 33 34 33
8 Atletico Madrileño Sub 12 Atletico 25 42 53 33
9 Móstoles URJC Sub 12 Móstoles 25 38 47 29
10 At. Chpr. Alcobendas Sub 12 Chpr. 25 27 59 29
11 Leganés Sub 12 Leganés 25 37 48 28
12 Aravaca Sub 12 Aravaca 25 31 44 25
13 Trival Valderas Sub 12 Trival 25 20 64 21
14 Alcorcón Sub 12 Alcorcón 25 18 52 18
15 Nuevo Boadilla Sub 12 Nuevo 25 22 70 13
16 EFMO Boadilla Sub 12 EFMO 25 19 64 10
TEMPORADA 2022/2023
SUPERLIGA MADRID ALEVÍN
Equipo PJ GF GC Puntos
1 Real Madrid Sub 12 Real Madrid 30 161 15 88
2 Atlético Sub 12 Atlético 30 125 15 78
3 Leganés Sub 12 Leganés 30 69 28 65
4 Rayo Vallecano Sub 12 Rayo 30 79 35 63
5 Getafe Sub 12 Getafe 30 68 25 63
6 Unión Adarve Sub 12 Unión 30 39 43 44
7 R. Ciudad Alcobendas Sub 12 Ciudad 30 29 46 39
8 Trival Valderas Sub 12 Trival 30 45 58 36
9 EFMO Boadilla Sub 12 EFMO 30 39 60 36
10 Móstoles URJC Sub 12 Móstoles 30 40 73 31
11 At. Chpr. Alcobendas Sub 12 Chpr. 30 33 67 29
12 Nuevo Boadilla Sub 12 Nuevo 30 41 88 28
13 Colegio Miramadrid Sub 12 Colegio 30 26 51 25
14 Canillas Canillas 30 24 83 21
15 Rayo Majadahonda Rayo 30 30 96 18
16 Seseña Seseña 30 19 84 11
TEMPORADA 2021/2022
1ª MADRID ALEVÍN F11 GRUPO 3
Equipo PJ GF GC Puntos
1 Alcobendas C.F. Alcobendas 25 138 12 69
2 At. Chopera Sub 12 Chopera 26 141 21 68
3 Rayo Ciudad Alcobendas C Rayo Ciudad 25 149 22 62
4 Aldovea Aldovea 26 105 24 60
5 Union Europa Sanse Union Europa 25 66 48 46
6 Castellana Nueva Castellana 25 52 38 39
7 Carranza A Carranza A 24 58 51 38
8 Academia Alcobendas Academia 26 50 84 28
9 Sporting Seis de Diciembre Sporting 25 49 74 22
10 Asociación Atletico Concili Asociación 26 58 109 22
11 Liceo Europeo Liceo 26 29 108 20
12 C.D.B Base C.D.B Base 26 45 84 19
13 San Sebastian Reyes C Sebastian 26 29 99 19
14 E Las Tablas Valverde Tablas 25 14 209 0
TEMPORADA 2020/2021
1ª AUTO. MADRID ALEVÍN F7 GRUPO 2
Equipo PJ GF GC Puntos
1 Atlético Madrileño A Atlético 17 59 19 42
2 Real Madrid C Real Madrid 17 53 18 38
3 San Sebastian Reyes A Sebastian 17 46 20 36
4 San Fernando A Fernando 17 38 14 34
5 R. Ciudad Alcobendas Sub 12 Ciudad 17 38 18 33
6 SAD Fundacion Rayo Vallecan Fundacion 17 40 23 30
7 Colegio Miramadrid Colegio 17 29 19 30
8 At. Chpr. Alcobendas Sub 12 Chpr. 17 35 21 29
9 Complutense Alcala A Complutense 17 26 23 26
10 Siete Picos Colmenar A Siete Picos 17 24 23 26
11 Getafe C Getafe C 17 26 25 24
12 Sanse A Sanse A 17 23 25 23
13 Fundacion RSD Alcala A Fundacion 17 31 28 19
14 AD Torrejon CF A Torrejon 17 23 34 17
15 Club Atletico de Madrid D Club 17 18 41 10
16 San Agustin de Guadalix A Agustin 17 20 61 10
17 Chamartin Vergara Alcobenda Chamartin 17 16 46 6
18 Escfut El Olivo de Coslada Escfut Olivo 17 10 97 4
TEMPORADA 2018/2019
1ª MADRID ALEVÍN GRUPO 9
Equipo PJ GF GC Puntos
1 Club de Futbol Isidoro San Club Futbol 23 171 26 64
2 Club Fuentelarreyna B Club 24 205 30 58
3 Chamartin Vergara A Chamartin 24 127 48 50
4 Altamira Altamira 23 135 63 50
5 Asociación Atletico Concili Asociación 23 119 51 45
6 Oña Sanchinarro B Oña 23 118 74 39
7 Olimpic de Las Tablas B Olimpic 23 84 70 35
8 Enjoy Football Enjoy 23 79 135 26
9 Asociacion Codec de Madrid Asociacion 23 77 121 24
10 Club San Agustin Club Agustin 24 68 145 17
11 At. Chpr. Alcobendas Sub 12 Chpr. 24 33 107 16
12 Colegio Brains Colegio 23 50 182 12
13 EF Femenino Alcobendas Femenino 22 10 224 5
TEMPORADA 2017/2018
1ª MADRID ALEVÍN GRUPO 9
Equipo PJ GF GC Puntos
1 Club Fuentelarreyna C Club 24 129 32 64
2 Club de Futbol Isidoro San Club Futbol 24 187 42 59
3 Oña Sanchinarro A Oña 23 124 54 56
4 Asociación Atletico Concili Asociación 24 122 60 54
5 Chamartin Vergara Alcobenda Chamartin 23 93 67 43
6 Olimpic de Las Tablas Olimpic 23 98 87 38
7 Oña Sanchinarro B Oña 23 83 76 35
8 Altamira Altamira 23 89 76 33
9 Serracines Serracines 23 71 88 23
10 At. Chpr. Alcobendas Sub 12 Chpr. 24 40 136 13
11 Colegio Brains B Colegio 24 48 96 12
12 At. Chopera Sub 12 Chopera 22 29 122 8
13 Colegio Brains A Colegio 24 24 201 4
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
PREFERENTE MADRID ALEVÍN F11 GRUPO 2
Equipo PJ GF GC Puntos
1 At. Chpr. Alcobendas Sub 12 Chpr. 26 96 9 73
2 R. Ciudad Alcobendas Sub 12 Ciudad 26 92 23 63
3 San Agustin de Guadalix A Agustin 26 98 28 61
4 Sanse A Sanse A 26 70 32 56
5 San Sebastian Reyes A Sebastian 26 62 31 51
6 Paracuellos A Paracuellos 26 70 57 39
7 Atletico Madrileño D Atletico 26 48 56 34
8 Tres Cantos A Tres Cantos 26 44 49 29
9 Alcala C Alcala C 26 37 54 29
10 Avance B Avance B 26 38 46 28
11 Recreativo Soto del Real Recreativo 26 40 54 26
12 Fuente El Saz A Fuente 26 27 76 17
13 Aldovea Aldovea 26 41 130 16
14 Alalpardo A Alalpardo A 26 7 125 1
TEMPORADA 2014/2015
PREFERENTE MADRID ALEVÍN F11 GRUPO 2
Equipo PJ GF GC Puntos
1 Siete Picos Colmenar A Siete Picos 26 109 25 68
2 Deportivo Av Santa Ana A Deportivo 26 104 28 64
3 Sanse A Sanse A 26 54 29 48
4 San Sebastian Reyes A Sebastian 26 59 54 44
5 Club San Agustin A Club Agustin 25 74 48 43
6 Atletico Madrileño D Atletico 26 55 42 43
7 Fundación Recuerdo Fundación 26 73 56 42
8 At. Chpr. Alcobendas Sub 12 Chpr. 26 42 54 40
9 Rayo Ciudad Alcobendas B Rayo Ciudad 26 46 54 34
10 Union Adarve B Union Adarve 25 34 43 28
11 Tetuan Tetuan 26 29 57 26
12 Las Rozas C Las Rozas C 26 26 75 19
13 Alcobendas Levitt B Alcobendas 26 14 76 9
14 Palestra A Palestra A 26 17 95 7

  USO DE MEMORIA  
5,583,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5043
Total Execution Time  0.5055
  CADENA URL  
/historico/Atletico-Chopera-Alcobendas-04-A-Alevin
  GET DATOS  
$_GET['/historico/Atletico-Chopera-Alcobendas-04-A-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0152  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 = 'Atletico-Chopera-Alcobendas-04-A-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.0128  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=40374 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=40374 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0267  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 = 74222
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=40374 AND type_rel = 2
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2724 AND type_rel = 3
0.0135  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 = '40374' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0134  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 = '40374' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  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 = 74222 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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=40374 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (74222) 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.0127  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74222 AND teamId = 40374
0.0129  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 = 74222 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '40374' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128  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 = '40374' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0132  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 = 40374 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0131  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 = 74222 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.0131  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 = 70510 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.0130  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 = 64881 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.0132  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 = 65091 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.0133  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 = 61365 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.0129  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 = 61491 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.0130  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 = 45482 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 46916 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 41675 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 42210 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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.0132  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 = 18000 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 6527 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 74222 ORDER BY nameShow LIMIT 100