4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Union Zona Norte Sub 12
TEMPORADA 2023/2024
DIVISIÓN HONOR MADRID ALEVÍN F7
Equipo PJ GF GC Puntos
1 Real Madrid Sub 12 Real Madrid 23 221 10 69
2 Atlético Sub 12 Atlético 23 189 16 63
3 Getafe Sub 12 B Getafe 23 96 42 46
4 Rayo C. Alcobendas Sub 12 Rayo 22 85 54 46
5 EF Concepcion Sub 12 Concepcion 22 71 58 45
6 Unión Adarve Sub 12 Unión 22 67 63 39
7 Colegio Miramadrid Sub 12 Colegio 22 81 65 38
8 RSD Alcalá SAD Sub 12 Alcalá 22 60 71 26
9 At. Chopera Sub 12 Chopera 23 72 108 24
10 CDE FPA Las Rozas Sub 12 Rozas 22 40 99 20
11 Rayo Majadahonda Sub 12 Rayo 22 29 75 16
12 Villalbilla Sub 12 Villalbilla 22 44 146 13
13 Aravaca CF Sub 12 Aravaca 22 29 144 10
14 Union Zona Norte Sub 12 Union Zona. 22 37 170 1
TEMPORADA 2022/2023
DIVISIÓN HONOR MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético de Madrid B Atlético 26 202 17 76
2 Real Madrid Sub 12 B Real Madrid 26 221 16 72
3 Colegio Miramadrid B Colegio 26 88 46 55
4 Getafe Sub 12 B Getafe 26 82 58 51
5 Unión Adarve Sub 12 Unión 26 83 70 44
6 RSD Alcalá SAD Sub 12 Alcalá 26 92 106 41
7 Rayo Ciudad Alcobendas B Rayo Ciudad 26 67 89 38
8 Aravaca CF Sub 12 Aravaca 26 61 107 36
9 CDE FPA Las Rozas Sub 12 Rozas 26 41 65 29
10 Union Zona Norte Sub 12 Union Zona. 26 55 103 28
11 Atletico Madrileño B Atletico 26 61 100 25
12 ED Moratalaz B Moratalaz 26 32 115 17
13 Las Rozas CF Rozas 26 59 147 13
14 Colmenar Viejo A Colmenar 26 47 152 10
TEMPORADA 2021/2022
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Aravaca A Aravaca A 26 84 42 51
2 Union Zona Norte Sub 12 Union Zona. 26 64 34 51
3 CDE FPA Las Rozas Sub 12 Rozas 25 47 25 48
4 Villanueva del Pardillo A Villanueva 25 52 37 48
5 Rayo B Rayo B 26 58 27 46
6 RSD Alcalá SAD B Alcalá 26 58 35 46
7 Nuevo Boadilla B Nuevo 26 66 42 43
8 Getafe D Getafe D 26 53 42 43
9 Atletico Villalba A Atletico 26 41 43 35
10 Mostoles C Mostoles C 26 30 36 29
11 Club Fuentelarreyna A Club 26 36 45 28
12 Electrocor Las Rozas Electrocor 26 32 90 18
13 Union Adarve B Union Adarve 26 39 100 14
14 Eepp San Fernando Escolapio Eepp 26 33 95 8
TEMPORADA 2020/2021
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Sub 12 Atlético 17 115 4 49
2 Real Madrid Sub 12 B Real Madrid 17 105 2 49
3 Canillas Canillas 17 35 25 36
4 Sporting Hortaleza A Sporting 17 22 19 34
5 Villa Rosa A Villa Rosa 17 43 23 33
6 Unión Adarve Sub 12 Unión 17 35 26 32
7 Electrocor Las Rozas A Electrocor 17 34 23 31
8 Rayo Majadahonda Rayo 17 22 14 30
9 Aravaca A Aravaca A 17 31 35 25
10 Union Zona Norte Sub 12 Union Zona. 17 17 22 21
11 Getafe D Getafe D 17 19 28 21
12 Atletico Villalba A Atletico 17 24 45 17
13 CDE FPA Las Rozas A Rozas 17 19 55 15
14 San Roque A San Roque A 17 13 39 12
15 Torrelodones A Torrelodones 17 14 59 10
16 Club San Agustin A Club Agustin 17 11 47 9
17 Ciudad del Futbol B Ciudad 17 10 52 8
18 Gredos-San Diego Gredos-San 17 0 51 0
TEMPORADA 2019/2020
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 12 B Real Madrid 20 100 6 57
2 Atletico Montaura Atletico 20 107 8 55
3 CF Rayo Majadahonda Rayo 19 42 15 42
4 Ciudad de Baza A Ciudad Baza 19 38 30 34
5 AD Villa Rosa Villa Rosa 19 35 32 33
6 Canillas Canillas 19 38 20 32
7 Las Rozas CF-Nuicon-Asuman Rozas 19 32 46 27
8 Sporting Hortaleza A Sporting 19 38 46 26
9 AD Union Adarve Union Adarve 20 29 55 22
10 San Roque A San Roque A 19 22 55 21
11 Union Zona Norte Sub 12 Union Zona. 19 30 64 16
12 Atletico Villalba A Atletico 18 23 51 10
13 Aravaca A Aravaca A 19 13 51 7
14 Torrelodones A Torrelodones 19 7 75 5
TEMPORADA 2018/2019
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 12 B Real Madrid 26 196 5 78
2 Ciudad del Futbol Ciudad 26 72 33 67
3 Atlético Sub 12 Atlético 26 105 19 64
4 Unión Adarve Sub 12 Unión 26 53 21 55
5 Union Zona Norte Sub 12 Union Zona. 26 38 49 38
6 Atletico Villalba A Atletico 26 44 45 35
7 Las Rozas A Las Rozas A 26 31 62 34
8 Canillas Canillas 26 40 61 32
9 San Roque A San Roque A 26 35 68 31
10 Aravaca A Aravaca A 26 28 49 30
11 Deportivo Av Santa Ana A Deportivo 26 28 67 21
12 Sporting Hortaleza A Sporting 26 31 89 14
13 CF Pozuelo A Pozuelo 26 18 93 13
14 Getafe D Getafe D 26 14 72 11
TEMPORADA 2017/2018
1ª MADRID ALEVÍN GRUPO 12
Equipo PJ GF GC Puntos
1 Colegio El Prado A Colegio 22 136 25 66
2 Colegio El Prado B Colegio 22 87 55 44
3 Virgen de Mirasierra A Virgen 22 70 51 41
4 Ntra Sra Buen Consejo D Ntra Buen C. 22 79 59 38
5 Chamartin B Chamartin B 22 62 82 29
6 Deporte Dca Montecarmelo Deporte 22 62 56 28
7 Chamartin C Chamartin C 22 59 51 27
8 Fundación Recuerdo Fundación 22 64 76 27
9 Virgen de Mirasierra B Virgen 22 79 91 26
10 Club Chamartin R A Club 22 38 77 19
11 Union Zona Norte Sub 12 Union Zona. 22 73 124 19
12 Buen Consejo C Buen Consejo 22 38 100 14
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 3
Equipo PJ GF GC Puntos
1 Dosa A Dosa A 26 88 25 66
2 Union Zona Norte Sub 12 Union Zona. 26 89 26 65
3 EF Concepcion Sub 12 Concepcion 26 75 26 62
4 Club San Agustin A Club Agustin 26 66 23 53
5 Esperanza A Esperanza A 26 72 45 43
6 Colegio Alameda de Osuna A Colegio 26 56 48 43
7 Canillas B Canillas B 26 48 41 37
8 Periso Periso 26 35 62 32
9 Fundación Recuerdo Fundación 26 48 52 28
10 Union Adarve B Union Adarve 26 39 59 26
11 Atletico Madrileño E Atletico 26 36 72 24
12 San Agustin de Guadalix B Agustin 26 33 72 20
13 Oña Sanchinarro Oña 26 30 78 16
14 Chamartin Vergara B Chamartin 26 18 104 7
TEMPORADA 2014/2015
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Sub 12 Atlético 26 81 4 72
2 Real Madrid Sub 12 B Real Madrid 26 109 9 71
3 Rayo Vallecano B Rayo 26 76 21 58
4 Atletico Madrileño A Atletico 26 40 38 45
5 Unión Adarve Sub 12 Unión 26 52 37 43
6 Alcobendas Levitt A Alcobendas 26 24 36 32
7 Las Rozas A Las Rozas A 26 27 45 32
8 Nuevo Boadilla Sub 12 Nuevo 26 39 71 29
9 Aravaca A Aravaca A 26 29 46 25
10 Union Zona Norte Sub 12 Union Zona. 26 26 41 24
11 CF Pozuelo A Pozuelo 26 30 54 24
12 R. Ciudad Alcobendas Sub 12 Ciudad 26 20 47 24
13 San Agustin de Guadalix A Agustin 26 28 71 17
14 EFMO Boadilla Sub 12 EFMO 26 24 85 16

  USO DE MEMORIA  
5,655,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0980
Total Execution Time  0.0993
  CADENA URL  
/historico/Union-Zona-Norte-A-Alevin
  GET DATOS  
$_GET['/historico/Union-Zona-Norte-A-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0045  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 = 74228
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=40489 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2586 AND type_rel = 3
0.0023  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 = '40489' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '40489' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 74228 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=40489 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 (74228) 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.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74228 AND teamId = 40489
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 = 74228 AND t.round = 23 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 = '40489' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  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 = '40489' 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 = 40489 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021  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 = 74228 AND t.round = 23 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 = 70511 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.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 `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 = 64879 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 `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 = 61490 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.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 `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 = 52472 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 = 45481 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 41619 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 42213 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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.0040  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 = 18001 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 6528 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 74228 ORDER BY nameShow LIMIT 100