4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Moraleja Futbol
TEMPORADA 2023/2024
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Cala Pozuelo Cala Pozuelo 30 48 30 62
2 Aravaca Aravaca 30 54 23 60
3 CF San Agustín Agustín 30 55 33 57
4 Moratalaz Moratalaz 30 39 22 52
5 Las Rozas B Las Rozas B 30 47 34 50
6 Unión Zona Norte Unión Zona 30 48 35 48
7 Vicálvaro Vicálvaro 30 50 37 47
8 Colmenar Viejo Colmenar 30 47 38 46
9 Robledo Robledo 30 47 59 41
10 CD San Fernando Fernando 30 52 48 40
11 Coslada Coslada 30 37 45 38
12 AD Torrejon CF B Torrejon 30 37 42 38
13 CD Moraleja Futbol Moraleja 30 33 45 34
14 EF Concepción A Concepción 30 39 46 33
15 San Sebastián Reyes B Sebastián 30 35 40 33
16 Sporting Hortaleza Sporting 30 49 61 29
17 Alameda de Osuna Alameda 30 32 64 21
18 Unión Valdebernardo Unión 30 26 73 14
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
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Galapagar Galapagar 19 44 16 45
2 CDF Tres Cantos Tres Cantos 19 41 15 45
3 CF San Agustín Agustín 19 35 19 35
4 Alcobendas Alcobendas 19 33 23 35
5 CD Moraleja Futbol Moraleja 19 34 22 34
6 Colmenar Viejo Colmenar 19 33 30 34
7 Aravaca Aravaca 19 39 20 32
8 San Sebastián Reyes B Sebastián 19 32 30 28
9 CD Canillas CD Canillas 19 28 22 27
10 Periso CF Periso CF 19 26 22 27
11 CUC Villalba Villalba 19 23 23 27
12 EF Concepción A Concepción 19 25 24 26
13 Sporting Hortaleza Sporting 19 31 32 26
14 CD Avance CD Avance 19 22 24 24
15 Rayo Ciudad Alcobendas Rayo Ciudad 19 23 21 23
16 AD Torrejon CF B Torrejon 19 21 34 18
17 Barrio Pilar Barrio Pilar 19 18 37 12
18 CD San Roque EFF Roque 19 30 48 11
19 Dosa Dosa 19 22 53 11
20 Atletico Villalba Atletico 19 10 55 4
TEMPORADA 2019/2020
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Complutense Alcala Complutense 23 37 23 46
2 Villanueva del Pardillo Villanueva 23 32 19 42
3 CD San Roque EFF Roque 23 34 28 42
4 CD Canillas CD Canillas 23 23 18 39
5 Periso CF Periso CF 23 40 24 37
6 CF San Agustín Agustín 23 39 27 37
7 Alcobendas Alcobendas 23 25 21 34
8 CDF Tres Cantos Tres Cantos 23 32 29 34
9 Galapagar Galapagar 23 33 23 33
10 Atletico Villalba Atletico 23 35 32 33
11 CD Moraleja Futbol Moraleja 23 28 25 33
12 Aravaca Aravaca 23 28 27 29
13 Rayo Ciudad Alcobendas Rayo Ciudad 23 20 23 26
14 Sporting Hortaleza Sporting 23 23 32 26
15 AD Torrejon CF B Torrejon 23 25 38 18
16 EF Concepción A Concepción 23 22 44 17
17 Dosa Dosa 23 22 43 16
18 Barrio Pilar Barrio Pilar 23 15 37 16
TEMPORADA 2018/2019
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Moratalaz Moratalaz 34 51 27 68
2 AD Torrejón CF Torrejón 34 46 25 63
3 Galapagar Galapagar 34 53 32 61
4 EF Concepción A Concepción 34 45 30 59
5 Alcobendas Alcobendas 34 48 36 55
6 Villanueva del Pardillo Villanueva 34 54 42 54
7 CD Moraleja Futbol Moraleja 34 45 37 51
8 Aravaca Aravaca 34 54 54 51
9 Complutense Alcala Complutense 34 46 42 47
10 Coslada Coslada 34 43 43 44
11 Sporting Hortaleza Sporting 34 56 61 44
12 CD San Roque EFF Roque 34 36 47 42
13 Periso CF Periso CF 34 38 45 40
14 Torrelodones Torrelodones 34 41 45 38
15 Barrio Pilar Barrio Pilar 34 31 43 38
16 San Agustin Guadalix B Agustin 34 33 46 35
17 CUC Villalba Villalba 34 25 56 34
18 Colmenar Viejo Colmenar 34 19 53 14
TEMPORADA 2017/2018
1ª REGIONAL MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Barrio Pilar Barrio Pilar 34 54 32 67
2 CD Moraleja Futbol Moraleja 34 71 37 65
3 Atletico Villalba Atletico 34 69 33 64
4 Cala Pozuelo Cala Pozuelo 34 50 44 62
5 Hoyo de Manzanares Hoyo 33 56 44 56
6 Cerceda CF Cerceda CF 34 64 49 52
7 Rayo Ciudad Alcobendas Rayo Ciudad 34 45 36 49
8 Las Rozas B Las Rozas B 34 50 56 48
9 Unión Adarve B Unión 34 56 57 47
10 Siete Picos Colmenar Siete Picos 34 56 57 44
11 Galapagar B Galapagar B 34 36 50 41
12 Villanueva del Pardillo B Villanueva 34 51 65 40
13 Cd Recuerdo Cd Recuerdo 34 42 55 38
14 Academia de Futbol Alcobend Academia 34 39 58 38
15 AD Fundación Fundación 34 73 75 37
16 Colegio El Prado Colegio 34 42 70 33
17 AD Colmenar Viejo B Colmenar 34 40 59 32
18 CF Pozuelo B Pozuelo 33 46 63 31
TEMPORADA 2016/2017
2ª REGIONAL MADRID GRUPO 2
Equipo PJ GF GC Puntos
1 San Agustin Guadalix B Agustin 34 91 29 82
2 Barrio Pilar Barrio Pilar 34 102 28 78
3 CD Moraleja Futbol Moraleja 34 76 33 75
4 Atletico Chopera Alcobendas Atletico 34 78 54 59
5 Juventud Sanse A Juventud 33 69 46 59
6 CD La Resaca Resaca 34 69 51 58
7 Club Fuentelarreyna Club 34 80 62 56
8 Sporting Hortaleza C Sporting 34 76 71 54
9 Carranza Carranza 34 51 39 49
10 Club San Agustin Club Agustin 34 82 79 46
11 El Pardo El Pardo 33 70 59 45
12 Santa Maria Caridad Santa Maria 34 52 64 42
13 Altamira A Altamira A 34 52 106 35
14 Jarama Race Jarama Race 34 74 98 34
15 Alonso Cano Alonso Cano 34 63 92 33
16 Villa Buitrago del Lozoya Villa 33 51 104 28
17 Atletico Alcobendas Atletico 34 33 87 16
18 CD Molareño Molareño 33 29 96 12
TEMPORADA 2015/2016
3ª REGIONAL MADRID GRUPO 2
Equipo PJ GF GC Puntos
1 CD Moraleja Futbol Moraleja 29 113 20 76
2 Atletico Chopera Alcobendas Atletico 29 88 26 70
3 Miraflores de la Sierra Miraflores 30 106 29 65
4 UD Tres Cantos B Tres Cantos 29 78 34 61
5 CD Futbol Tres Cantos C Futbol Tres 29 56 28 61
6 CD Caraquiz CD Caraquiz 30 89 55 50
7 Talamanca B Talamanca B 30 54 60 41
8 Juventud Sanse B Juventud 29 60 59 40
9 Jarama Race B Jarama Race 29 64 78 36
10 Rascafria Rascafria 28 45 66 34
11 CF Valdeolmos Valdeolmos 30 53 58 34
12 La Cabrera La Cabrera 30 53 83 29
13 C.D. Pedrezuela C.D. 30 57 79 28
14 Valdeavero Valdeavero 29 42 100 21
15 Altamira B Altamira B 29 24 104 10
16 Serracines Serracines 24 32 135 6

  USO DE MEMORIA  
6,085,408 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4956
Total Execution Time  0.4968
  CADENA URL  
/historico/Cd-Moraleja-Futbol-Senior
  GET DATOS  
$_GET['/historico/Cd-Moraleja-Futbol-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0192  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-Moraleja-Futbol-Senior' 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.0151  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=66258 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=66258 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=66258 AND type_rel = 2
0.0160  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 = '66258' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0157  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 = '66258' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0158  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=66258 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) 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 = 66258
0.0146  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 = '66258' 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 = '66258' 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 = '66258' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0161  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 = 73536 WHERE rp.league_id = 73536 AND rp.teamId = 66258 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.0159  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 = 73536 WHERE rp.league_id = 73536 AND rp.teamId = 66258 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 = 73536 WHERE rp.league_id = 73536 AND rp.teamId = 66258 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 66258 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0293  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.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 `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.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 `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 = 59963 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 = 51262 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 = 44759 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 = 39194 AND t.round = 34 ORDER BY team.conference 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 `tables2017` 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 = 34110 AND t.round = 34 ORDER BY team.conference 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 `tables2016` 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 = 16854 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC