4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Nuevo Boadilla E
TEMPORADA 2022/2023
1ª MADRID CADETE GRUPO 7
Equipo PJ GF GC Puntos
1 CD Alzola-Halcones A Alzola-Halco 26 186 17 67
2 Estudiantes Alcorcón B Estudiantes 26 132 36 64
3 Fundación CD Leganes A Fundación 26 109 24 62
4 Alcorcon C Alcorcon C 26 106 22 60
5 Trival Valderas Alcorcon C Trival 26 107 23 57
6 Nuevo Boadilla E Nuevo 26 100 41 47
7 Libertad Alcorcon B Libertad 26 69 77 35
8 FEPE Getafe III B FEPE Getafe 26 52 113 30
9 Getafe City Getafe City 26 46 83 27
10 EFMO Boadilla E EFMO 26 41 78 22
11 Brunete B Brunete B 26 30 107 15
12 Santa Barbara Getafe B Santa 26 26 135 14
13 Villaverde San Andres B Villaverde 26 26 141 12
14 Caserio Perales Caserio 26 44 177 11
TEMPORADA 2021/2022
1ª MADRID CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Galapagar B Galapagar B 24 104 20 65
2 CD Alberto Cogorro Alberto 24 119 29 60
3 Hoyo De Manzanares CDH Hoyo 24 75 39 52
4 Nuevo Boadilla E Nuevo 23 86 33 46
5 Torrelodones B Torrelodones 24 57 55 37
6 UD San Lorenzo A Lorenzo 23 48 61 32
7 Electrocor Las Rozas B Electrocor 24 29 61 28
8 ADC Castilla Castilla 24 43 48 27
9 Las Rozas CF D Rozas 24 34 54 27
10 Union Collado Villalba B Union 24 51 77 26
11 Deporte Y Punto Bcm Deporte 23 38 57 24
12 Moralzarzal A Moralzarzal 23 28 68 16
13 Villanueva del Pardillo C Villanueva 24 20 130 0
TEMPORADA 2020/2021
2ª MADRID CADETE GRUPO 7
Equipo PJ GF GC Puntos
1 Fepe Getafe III A Fepe Getafe 12 45 4 32
2 Santa Barbara Getafe B Santa 12 41 6 30
3 Ciudad de Getafe Sport Club Ciudad 12 30 14 27
4 Nuevo Boadilla E Nuevo 12 45 20 26
5 Brunete B Brunete B 12 25 16 20
6 de Valdemoro D Valdemoro 12 24 24 18
7 Juventud Canario Juventud 12 23 19 17
8 AD El Norte AD El Norte 12 30 35 16
9 Nuevo Versalles Loranca C Nuevo 12 21 39 13
10 EMF Moraleja De Enmedio B Moraleja 12 16 27 9
11 Ciudad de Pinto C Ciudad Pinto 12 19 51 6
12 Libertad Alcorcon C Libertad 12 11 42 5
13 E Amistad Alcorcon B Amistad 12 15 48 2
TEMPORADA 2019/2020
3ª MADRID CADETE GRUPO 3
Equipo PJ GF GC Puntos
1 Las Matas B Las Matas B 18 82 19 49
2 Las Rozas CF D Rozas 18 64 18 40
3 FPA Las Rozas C Rozas 13 63 10 35
4 Nuevo Boadilla E Nuevo 17 46 23 29
5 Aravaca D Aravaca D 17 51 43 28
6 EFMO Boadilla E EFMO 18 43 31 25
7 CDE Monte Tabor Monte Tabor 17 43 41 23
8 CF Pozuelo D Pozuelo 18 35 44 21
9 Prodet Pozuelo B Prodet 18 27 55 20
10 AD Calasanz Pozuelo Calasanz 13 29 23 18
11 CDE FPA Las Rozas C Rozas 5 32 5 13
12 Calasanz Pozuelo C Calasanz 5 12 12 9
13 Escuela Europea Escuela 17 24 74 8
14 Collado Villalba C Collado 17 21 94 5
15 Union de Aravaca B Union 12 11 63 4
16 CD Union De Aravaca B Union 5 5 33 0
TEMPORADA 2018/2019
3ª MADRID CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Villanueva del Pardillo C Villanueva 27 151 35 66
2 Villanueva de La Cañada B Villanueva 27 99 30 63
3 Las Rozas CF B Rozas 28 97 35 61
4 K 2 B K 2 B 27 100 42 58
5 Nuevo Boadilla E Nuevo 27 71 46 54
6 Puerta de Madrid B Puerta 28 63 54 49
7 Collado Villalba C Collado 27 100 45 47
8 Prodet Pozuelo B Prodet 28 56 64 37
9 Vallmont Vallmont 28 56 70 36
10 San Agustin Los Negrales B Agustin 28 67 76 35
11 Independiente de Aravaca Independient 27 51 64 30
12 Aravaca D Aravaca D 28 45 83 26
13 Galapagar D Galapagar D 28 31 107 16
14 Nuevo Boadilla F Nuevo 28 26 131 11
15 Las Rozas Ucjc G Rozas Ucjc 22 2 133 1
TEMPORADA 2017/2018
3ª MADRID CADETE GRUPO 12
Equipo PJ GF GC Puntos
1 Getafe Atletico B Getafe 24 146 13 64
2 Nuevo Boadilla E Nuevo 24 155 32 58
3 Mostoles C Mostoles C 24 112 41 54
4 Internacional de Mostoles B Internaciona 24 108 36 50
5 Rayo Ciempozuelos C Rayo 24 75 28 47
6 Libertad Alcorcon F Libertad 24 63 26 45
7 Griñon B Griñon B 24 48 55 35
8 Villaviciosa de Odon D Villaviciosa 24 58 76 30
9 Mostoles Balompie B Mostoles 24 64 57 29
10 Inter de Valdemoro C Inter 24 46 92 21
11 Cultural Deportiva Miraflor Cultural 24 37 158 12
12 Racing Calypso Racing 24 22 160 6
13 Sergio Pachon Y Antonio Lop Sergio 24 27 187 3
14 San Pedro de Humanes Pedro 0 0 0 0
TEMPORADA 2016/2017
3ª MADRID CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Siete Picos Colmenar C Siete Picos 25 112 23 67
2 Pinosierra Pinosierra 25 93 36 61
3 Juventud Sanse B Juventud 25 93 32 59
4 King's College King's 25 79 50 53
5 Sek Ciudalcampo Ciudalcampo 25 62 46 46
6 Futbol Tres Cantos C Futbol Tres 25 64 52 39
7 Futbol Base 3 Cantos Futbol Base 25 66 65 32
8 Las Rozas Ucjc G Rozas Ucjc 25 31 56 27
9 Colmenar Viejo C Colmenar 24 44 72 24
10 Nuevo Boadilla E Nuevo 25 58 83 23
11 Galapagar D Galapagar D 25 49 96 23
12 UD Tres Cantos C Tres Cantos 25 44 79 16
13 Miraflores de La Sierra Miraflores 25 21 98 9
14 La Moraleja C Moraleja 12 18 46 7
TEMPORADA 2015/2016
3ª MADRID CADETE GRUPO 17
Equipo PJ GF GC Puntos
1 Puerta Bonita D Puerta 26 121 30 68
2 Agrupación CD Lucero Linces Agrupación 26 99 48 56
3 Sek El Castillo Ucjc Castillo 26 78 47 51
4 Campamento Campamento 26 74 60 47
5 Efmo Boadilla D Efmo 26 75 56 44
6 Fatima B Fatima B 26 90 71 41
7 Alzola A Alzola A 26 73 58 41
8 La Cañada B Cañada 26 67 65 37
9 Escuela de Futbol Carabanch Escuela 26 61 66 35
10 Vicalvaro F Vicalvaro F 26 62 67 35
11 Prodet Pozuelo B Prodet 26 65 60 29
12 Distrito Carabanchel Distrito 26 62 67 29
13 Ferilan Ferilan 25 28 105 10
14 Nuevo Boadilla E Nuevo 25 21 176 0
TEMPORADA 2014/2015
3ª MADRID CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Collado Villalba Collado 26 88 17 63
2 AD Collado Mediano Collado 26 123 25 62
3 Electrocor Las Rozas Electrocor 26 81 30 61
4 Union Collado Villalba B Union 26 80 44 58
5 Hoyo de Manzanares Hoyo 26 81 49 48
6 Atletico Villalba B Atletico 26 38 48 33
7 Atletico Leones Castilla B Atletico 25 53 64 32
8 Deporte Y Punto Deporte 26 64 88 30
9 Galapagar C Galapagar C 25 39 63 27
10 Alpedrete B Alpedrete B 26 44 77 23
11 Futbol Tres Cantos C Futbol Tres 26 35 55 21
12 Union Tres Cantos C Union Tres. 26 31 90 21
13 Nuevo Boadilla E Nuevo 26 36 78 17
14 Escuela Alcobendas B Escuela 26 48 113 17

  USO DE MEMORIA  
5,499,648 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1060
Total Execution Time  0.1081
  CADENA URL  
/historico/Cd-Nuevo-Boadilla-E-Cadete
  GET DATOS  
$_GET['/historico/Cd-Nuevo-Boadilla-E-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0024  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-Nuevo-Boadilla-E-Cadete' 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.0037  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-Nuevo-Boadilla-E-Cadete' 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.0018  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=96008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=96008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=96008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=96008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=96008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=96008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=96008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=96008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=96008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=96008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 70421
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=96008 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=735 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 = '96008' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '96008' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '96008' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 70421 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=96008 AND l.year in (2022,2023,2024) 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 (70421) 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.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70421 AND teamId = 96008
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 `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 = 70421 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '96008' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '96008' and rp.type = 4
0.0020  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 = '96008' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 96008 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 70421 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 = 64803 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 `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 = 61326 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.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 `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 = 54741 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.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 `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 = 46108 AND t.round = 30 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 = 40591 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 35874 AND t.round = 26 ORDER BY team.conference 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 `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 = 17285 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 4663 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 70421 ORDER BY nameShow LIMIT 100