4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Unión Zona Norte

Unión Zona Norte

Entrenador: Carlos Del Rey

Temporada 2023/2024
TEMPORADA 2023/2024
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 CF San Agustín Agustín 6 9 4 14
2 Moratalaz Moratalaz 6 9 5 12
3 Aravaca Aravaca 6 13 6 11
4 Las Rozas B Las Rozas B 6 11 6 11
5 Vicálvaro Vicálvaro 6 14 8 10
6 Sporting Hortaleza Sporting 6 15 12 10
7 CD San Fernando Fernando 6 11 8 10
8 Cala Pozuelo Cala Pozuelo 6 6 6 9
9 Unión Zona Norte Unión Zona 6 6 4 8
10 AD Torrejon CF B Torrejon 6 7 7 8
11 Coslada Coslada 6 10 11 8
12 Robledo Robledo 6 8 11 8
13 Colmenar Viejo Colmenar 6 9 8 6
14 EF Concepción A Concepción 6 7 8 6
15 CD Moraleja Futbol Moraleja 6 10 11 5
16 San Sebastián Reyes B Sebastián 6 5 9 4
17 Unión Valdebernardo Unión 6 7 20 3
18 Alameda de Osuna Alameda 6 2 15 0
TEMPORADA 2022/2023
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 CDF Tres Cantos Tres Cantos 34 72 32 69
2 Villanueva del Pardillo Villanueva 34 57 35 60
3 CF San Agustín Agustín 34 55 34 59
4 Unión Zona Norte Unión Zona 34 66 52 58
5 Moratalaz Moratalaz 34 63 58 56
6 Aravaca Aravaca 34 62 42 55
7 CD Moraleja Futbol Moraleja 34 48 54 48
8 Vicálvaro Vicálvaro 34 53 54 47
9 Las Rozas B Las Rozas B 34 39 34 46
10 EF Concepción A Concepción 34 31 45 45
11 CD Los Yébenes-San Bruno Yébenes-San 34 43 50 43
12 Colmenar Viejo Colmenar 34 37 54 41
13 AD Torrejon CF B Torrejon 34 54 62 39
14 San Sebastián Reyes B Sebastián 34 46 60 39
15 Rayo Ciudad Alcobendas Rayo Ciudad 34 47 53 38
16 CD Electrocor CF Electrocor 34 55 61 36
17 Complutense Alcala Complutense 34 37 54 34
18 Periso CF Periso CF 34 39 70 31
TEMPORADA 2021/2022
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 CD Canillas CD Canillas 34 50 33 58
2 CUC Villalba Villalba 34 56 41 57
3 San Sebastián Reyes B Sebastián 34 54 39 56
4 Villanueva del Pardillo Villanueva 34 63 41 55
5 EF Concepción A Concepción 34 48 33 55
6 Colmenar Viejo Colmenar 34 66 55 52
7 CF San Agustín Agustín 34 42 38 52
8 CD Moraleja Futbol Moraleja 34 47 41 49
9 Periso CF Periso CF 34 50 55 49
10 Aravaca Aravaca 34 55 50 48
11 Unión Zona Norte Unión Zona 34 53 48 46
12 Moratalaz B Moratalaz B 34 60 60 45
13 Alcobendas Alcobendas 34 40 52 44
14 Coslada Coslada 34 52 52 44
15 CD San Fernando Fernando 34 46 44 42
16 Sporting Hortaleza Sporting 34 36 54 38
17 DAV Santa Ana Santa 34 32 65 28
18 AD Fundación Fundación 34 39 88 17
TEMPORADA 2020/2021
1ª REGIONAL MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Unión Zona Norte Unión Zona 19 47 33 41
2 AD Fundación Fundación 19 48 33 40
3 Aravaca B Aravaca B 19 45 27 39
4 Unión Adarve B Unión 19 38 21 38
5 Celtic Castilla Celtic 19 37 26 35
6 Cala Pozuelo Cala Pozuelo 19 42 24 34
7 Cerceda CF Cerceda CF 19 38 26 31
8 CD Electrocor CF Electrocor 19 31 23 29
9 CD La Cañada Cañada 19 24 25 28
10 Villanueva del Pardillo B Villanueva 19 44 33 27
11 Torrelodones Torrelodones 19 29 25 27
12 Alcobendas B Alcobendas 19 30 30 26
13 Hoyo de Manzanares Hoyo 19 28 35 25
14 Union de Aravaca Union 19 33 38 24
15 San Lorenzo A Lorenzo 19 20 32 17
16 Siete Picos Colmenar Siete Picos 19 22 36 17
17 Chopera Alcobendas 04 Chopera 19 31 47 16
18 CD Futbol Tres Cantos B Futbol Tres 19 16 43 14
19 Club San Agustin Club Agustin 19 24 56 12
20 Galapagar B Galapagar B 19 30 44 11
TEMPORADA 2019/2020
1ª REGIONAL MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 CUC Villalba Villalba 23 47 22 56
2 Colmenar Viejo Colmenar 21 54 18 47
3 AD Fundación Fundación 23 57 45 41
4 Torrelodones Torrelodones 22 41 23 37
5 Celtic Castilla Celtic 23 47 50 35
6 Aravaca B Aravaca B 23 45 34 34
7 Siete Picos Colmenar Siete Picos 23 43 36 34
8 Villanueva del Pardillo B Villanueva 23 40 38 32
9 CD La Cañada Cañada 23 39 37 32
10 Cerceda CF Cerceda CF 21 36 31 31
11 Unión Adarve B Unión 23 35 25 29
12 Cala Pozuelo Cala Pozuelo 23 33 35 29
13 CD Electrocor CF Electrocor 23 34 51 29
14 Unión Zona Norte Unión Zona 23 28 36 27
15 Galapagar B Galapagar B 23 33 36 25
16 Union de Aravaca Union 23 37 48 24
17 Hoyo de Manzanares Hoyo 22 23 49 15
18 Club San Agustin Club Agustin 23 25 83 7
TEMPORADA 2018/2019
2ª REGIONAL MADRID GRUPO 6
Equipo PJ GF GC Puntos
1 Unión Zona Norte Unión Zona 34 110 35 82
2 Orcasitas Orcasitas 34 77 32 79
3 EF Carabanchel Carabanchel 34 86 40 73
4 Villaverde San Andres B Villaverde 34 97 49 69
5 Seccion Deportiva del Pozo Seccion 34 99 48 68
6 Alzola Alzola 34 89 45 68
7 San Viator San Viator 34 65 56 51
8 Pasillo Verde Arganzuela Pasillo 34 64 60 50
9 La Mancha La Mancha 34 64 73 46
10 Caserio Perales Caserio 34 56 64 44
11 Betis San Isidro B Betis Isidro 34 42 56 40
12 ADC San Fermín Fermín 34 48 77 38
13 Grupo Cero Grupo Cero 34 59 71 36
14 Buenavista Castilla Buenavista 34 62 91 33
15 Ciudad de Leganes Ciudad 34 55 75 32
16 EF Usera EF Usera 34 50 92 32
17 ADC Brunete B Brunete 34 45 93 24
18 CD Miraflor B Miraflor 34 27 138 9
TEMPORADA 2017/2018
3ª REGIONAL MADRID GRUPO 4
Equipo PJ GF GC Puntos
1 K-2 K-2 34 118 34 79
2 Virgen de Mirasierra Virgen 34 93 31 78
3 Unión Zona Norte Unión Zona 34 108 35 76
4 Valdeluz Valdeluz 34 103 58 71
5 CD Universitario Universitari 34 84 44 68
6 Aravaca C Aravaca C 34 84 63 60
7 Club Fuentelarreyna B Club 34 72 49 59
8 Masriver Masriver 34 88 69 57
9 Fomento Alumni CD Fomento 34 82 63 52
10 CB Ntra Sra de Lujan Ntra Lujan 34 55 60 45
11 Fundacion B Fundacion B 34 69 82 43
12 CD Colonia Moscardó C Colonia 34 55 78 34
13 Rayo del Pilar Rayo Pilar 34 54 107 32
14 CD Boca CD Boca 34 65 112 29
15 Ciringanillos Ciringanillo 34 51 84 28
16 CD Peñagrande Peñagrande 34 64 128 25
17 Union America Union 34 42 110 18
18 Santa Elena Santa Elena 34 51 131 15

  USO DE MEMORIA  
5,973,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.4659
Total Execution Time  0.4676
  CADENA URL  
/historico/Union-Zona-Norte
  GET DATOS  
$_GET['/historico/Union-Zona-Norte']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0295  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 = 73536
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=103083 AND type_rel = 2
0.0147  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 = '103083' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 73536 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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=103083 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (73536,71759) 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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 73536 AND teamId = 103083
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 71759 AND teamId = 103083
0.0148  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 = '103083' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '103083' and rp.type = 4
0.0147  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 = '103083' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0150  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 71759 WHERE rp.league_id = 71759 AND rp.teamId = 103083 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 71759 WHERE rp.league_id = 71759 AND rp.teamId = 103083 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 71759 WHERE rp.league_id = 71759 AND rp.teamId = 103083 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 103083 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0152  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` 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 = 73536 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.0155  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` 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 = 68737 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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` 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 = 63727 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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` 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 = 59965 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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` 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 = 51290 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.0150  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` 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 = 45227 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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` 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 = 39839 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC