4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Moratalaz B

Moratalaz B

Entrenador: Jordi DIdac

Temporada 2023/2024
TEMPORADA 2023/2024
PREFERENTE MADRID GRUPO 2
Equipo PJ GF GC Puntos
1 Aluche Aluche 0 0 0 0
2 Arganda Arganda 0 0 0 0
3 Atlético de Pinto Atlético 0 0 0 0
4 Campamento Campamento 0 0 0 0
5 CD Fortuna CD Fortuna 0 0 0 0
6 CD Los Yébenes-San Bruno Yébenes-San 0 0 0 0
7 CD Mostoles URJC B Mostoles 0 0 0 0
8 CDE Madrid 2021 Madrid 2021 0 0 0 0
9 CP Parla Escuela Parla 0 0 0 0
10 El Álamo El Álamo 0 0 0 0
11 Moratalaz B Moratalaz B 0 0 0 0
12 Móstoles CF Móstoles 0 0 0 0
13 Racing Ciudad de Madrid Racing 0 0 0 0
14 RCD Carabanchel Carabanchel 0 0 0 0
15 Real Aranjuez CF Real 0 0 0 0
16 SAD Villaverde Villaverde 0 0 0 0
17 Sitio de Aranjuez Sitio 0 0 0 0
18 Villaviciosa Odón Villaviciosa 0 0 0 0
TEMPORADA 2022/2023
PREFERENTE MADRID GRUPO 2
Equipo PJ GF GC Puntos
1 CD Colonia Moscardó Colonia 34 53 21 69
2 AD Parla AD Parla 34 58 31 65
3 CP Parla Escuela Parla 34 69 37 63
4 CD Mostoles URJC B Mostoles 34 52 36 61
5 El Álamo El Álamo 34 53 44 55
6 Villaviciosa Odón Villaviciosa 34 59 40 53
7 RCD Carabanchel Carabanchel 34 50 46 53
8 Racing Ciudad de Madrid Racing 34 41 44 50
9 Moratalaz B Moratalaz B 34 49 38 49
10 Móstoles CF Móstoles 34 51 45 47
11 SAD Villaverde Villaverde 34 41 47 46
12 Aluche Aluche 34 41 47 44
13 Atlético de Pinto Atlético 34 46 43 44
14 CD Fortuna CD Fortuna 34 34 49 41
15 Ciudad Los Angeles Ciudad 34 32 54 31
16 Rivas Vaciamadrid Rivas 34 46 76 27
17 Ciudad de Getafe SC Ciudad 34 31 72 22
18 CD Lugo Fuenlabrada Lugo 34 29 65 17
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 2
Equipo PJ GF GC Puntos
1 CD Ursaria CD Ursaria 19 34 15 41
2 Villaviciosa Odón Villaviciosa 19 26 12 41
3 CD Colonia Moscardó Colonia 19 29 9 40
4 Fuenlabrada B Fuenlabrada 19 28 22 31
5 Ciudad de Getafe SC Ciudad 19 29 24 31
6 CD Mostoles URJC B Mostoles 19 27 22 31
7 Moratalaz B Moratalaz B 19 27 23 30
8 Coslada Coslada 19 26 19 29
9 Ciudad Los Angeles Ciudad 19 19 13 29
10 CD Lugo Fuenlabrada Lugo 19 21 18 28
11 CD Los Yébenes-San Bruno Yébenes-San 19 23 21 28
12 Arganda Arganda 19 21 21 25
13 Vicálvaro Vicálvaro 19 16 21 24
14 CD Fortuna CD Fortuna 19 20 27 23
15 Internacional de Móstoles Internaciona 19 22 28 21
16 Humanes Humanes 19 14 26 16
17 UD Ciempozuelos Ciempozuelos 19 18 28 15
18 Sitio de Aranjuez Sitio 19 18 32 15
19 Fepe Getafe III Fepe Getafe 19 14 30 12
20 EMF Villarejo Villarejo 19 16 37 11
TEMPORADA 2019/2020
1ª REGIONAL MADRID GRUPO 3
Equipo PJ GF GC Puntos
1 Moratalaz B Moratalaz B 23 45 22 47
2 Ciudad de Getafe SC Ciudad 23 43 27 46
3 CD Colmenar De Oreja Colmenar 23 43 32 44
4 Unión Valdebernardo Unión 23 52 34 43
5 Santa Maria del Pilar Santa Maria 23 44 27 42
6 Rivas Vaciamadrid Rivas 23 37 28 37
7 Nuevas Palomeras Nuevas 23 45 31 36
8 Union Deportiva Usera Union 23 33 28 35
9 Inter de Valdemoro Inter 23 29 30 30
10 Tajamar Tajamar 23 39 41 30
11 ADC Brunete ADC Brunete 23 30 41 29
12 Orcasitas Orcasitas 23 42 55 28
13 Mejoreño Mejoreño 23 28 42 27
14 EF Arganda EF Arganda 22 32 37 26
15 Emf Águilas Moratalaz Águilas 23 32 44 26
16 Villaverde Bajo Villaverde 23 25 41 18
17 Racing Villaverde Racing 23 31 44 17
18 Atletico Club de Socios Atletico 22 21 47 15
TEMPORADA 2018/2019
1ª REGIONAL MADRID GRUPO 3
Equipo PJ GF GC Puntos
1 CD Fortuna B Fortuna 34 72 30 79
2 EMF Villarejo Villarejo 34 80 34 73
3 Rivas Vaciamadrid Rivas 34 78 41 67
4 Santa Maria del Pilar Santa Maria 34 80 52 64
5 Union Deportiva Usera Union 34 59 38 60
6 Villaverde Bajo Villaverde 34 63 44 59
7 Inter de Valdemoro Inter 34 54 42 57
8 ADC Brunete ADC Brunete 34 55 60 50
9 Ciudad de Getafe SC Ciudad 34 61 45 44
10 CD Colmenar De Oreja Colmenar 34 57 63 44
11 Racing Villaverde Racing 34 60 57 42
12 Tajamar Tajamar 34 41 55 39
13 Moratalaz B Moratalaz B 34 43 54 37
14 Emf Águilas Moratalaz Águilas 34 40 54 36
15 La Meca de Rivas Meca Rivas 34 37 68 34
16 CD Villaconejos Villaconejos 34 41 64 30
17 Vallecas Vallecas 34 37 69 26
18 Colonia Moscardo B Colonia 34 28 116 9
TEMPORADA 2017/2018
1ª REGIONAL MADRID GRUPO 2
Equipo PJ GF GC Puntos
1 San Agustin Guadalix B Agustin 34 58 26 70
2 Sporting Hortaleza Sporting 34 70 50 66
3 CD Paracuellos Paracuellos 34 58 33 59
4 EDM San Blas Blas 34 50 33 56
5 UD Jarama 2016 Jarama 2016 34 58 56 51
6 Moratalaz B Moratalaz B 34 73 68 50
7 Alameda de Osuna Alameda 34 58 45 49
8 Club Juventud Elipa Club 34 47 50 46
9 CD Avance CD Avance 34 46 48 46
10 AD Esperanza Esperanza 34 62 57 45
11 CF Torrejon Ardoz Torrejon 34 47 47 44
12 EF Vicalvaro Vicalvaro 34 51 64 44
13 EM Cobeña EM Cobeña 34 31 43 42
14 Naya Naya 34 45 48 40
15 CD Canillas B Canillas 33 41 53 38
16 San Pedro Prosperidad-Cosla Pedro 34 44 67 37
17 Colegio Miramadrid Colegio 34 36 52 32
18 Villa Rosa Villa Rosa 33 29 64 18
TEMPORADA 2016/2017
1ª REGIONAL MADRID GRUPO 3
Equipo PJ GF GC Puntos
1 Sitio de Aranjuez Sitio 34 104 38 78
2 Colmenar Oreja Colmenar 34 95 26 74
3 Fepe Getafe III Fepe Getafe 34 59 51 59
4 Ciempozuelos Ciempozuelos 33 57 39 55
5 Emf Águilas Moratalaz Águilas 34 58 54 53
6 CD Villaconejos Villaconejos 34 52 53 53
7 Racing Villaverde Racing 34 60 52 51
8 Atletico Club de Socios Atletico 34 70 64 49
9 Adpi Rivas Adpi Rivas 34 49 57 47
10 AD Alhóndiga Alhóndiga 34 69 75 46
11 Rivas Vaciamadrid Rivas 34 58 60 45
12 Vallecas Vallecas 34 42 63 45
13 Moratalaz B Moratalaz B 34 75 62 43
14 ADC Brunete ADC Brunete 34 38 48 43
15 La Chimenea La Chimenea 33 56 66 40
16 Villaverde Bajo Villaverde 33 56 66 35
17 EMF Villarejo Villarejo 34 33 77 26
18 Seseña CF Seseña CF 33 40 120 15
TEMPORADA 2015/2016
1ª REGIONAL MADRID GRUPO 3
Equipo PJ GF GC Puntos
1 EF Arganda EF Arganda 34 62 40 66
2 Ciudad Los Angeles Ciudad 34 64 31 65
3 Colmenar Oreja Colmenar 34 67 35 59
4 Adpi Rivas Adpi Rivas 34 65 46 59
5 CD Villaconejos Villaconejos 34 52 44 59
6 Sitio de Aranjuez Sitio 34 61 40 58
7 Vallecas Vallecas 34 63 43 57
8 La Chimenea La Chimenea 33 49 41 51
9 Fepe Getafe III Fepe Getafe 34 48 43 50
10 Moratalaz B Moratalaz B 34 69 65 41
11 Villaverde Bajo Villaverde 34 58 71 40
12 Emf Águilas Moratalaz Águilas 34 49 72 39
13 AD Alhóndiga Alhóndiga 34 45 65 39
14 ADC Brunete ADC Brunete 34 50 57 37
15 San Martin de la Vega Martin Vega 34 46 75 37
16 Atlético De Pinto B Atlético 34 42 56 36
17 Grupo Cero Grupo Cero 33 45 65 35
18 La Meca de Rivas Meca Rivas 34 29 75 21
TEMPORADA 2014/2015
1ª REGIONAL MADRID GRUPO 2
Equipo PJ GF GC Puntos
1 Sporting Hortaleza Sporting 34 64 26 70
2 AD Esperanza Esperanza 34 62 46 66
3 EF Concepción A Concepción 34 64 42 65
4 Talamanca Talamanca 34 55 40 57
5 Moratalaz B Moratalaz B 34 72 59 52
6 CF Torrejon Ardoz Torrejon 34 47 43 51
7 CD Canillas B Canillas 34 46 47 51
8 AD Torrejon CF B Torrejon 34 54 43 49
9 Barajas Barajas 34 36 39 46
10 EDM San Blas Blas 34 39 44 45
11 CD Avance CD Avance 34 55 45 43
12 Fuente el Saz Fuente 34 42 55 43
13 Villa Rosa Villa Rosa 34 30 36 42
14 Emf Águilas Moratalaz Águilas 34 49 53 40
15 CD Paracuellos Paracuellos 34 32 44 37
16 Neumaticos Cervantes F.C. Neumaticos 34 41 57 37
17 Santa Maria del Pilar Santa Maria 34 36 79 27
18 Futbol de Torres Futbol 34 31 57 24

  USO DE MEMORIA  
6,256,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1437
Total Execution Time  0.1449
  CADENA URL  
/historico/Moratalaz-B
  GET DATOS  
$_GET['/historico/Moratalaz-B']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0040  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 = 'Moratalaz-B' 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.0020  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=18607 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=18607 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18607 AND type_rel = 2
0.0033  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 = '18607' ORDER BY l.year DESC,cat.coefficient DESC
0.0032  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 = '18607' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0032  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 = '18607' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0033  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=18607 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0023  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 (73541) 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.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 73541 AND teamId = 18607
0.0027  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 = '18607' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18607' and rp.type = 4
0.0030  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 = '18607' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0086  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 = 73541 WHERE rp.league_id = 73541 AND rp.teamId = 18607 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.0076  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 = 73541 WHERE rp.league_id = 73541 AND rp.teamId = 18607 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0062  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 = 73541 WHERE rp.league_id = 73541 AND rp.teamId = 18607 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 = 18607 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0045  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 = 73541 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.0057  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.0041  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 = 59964 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.0043  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 = 51292 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.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 `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 = 44755 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0050  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 = 39195 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0049  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 = 33999 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0053  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 = 16763 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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 = 3997 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC