4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Villanueva del Pardillo C
TEMPORADA 2022/2023
2ª MADRID CADETE GRUPO 20
Equipo PJ GF GC Puntos
1 Internacional de Madrid Internaciona 26 100 23 65
2 Villanueva del Pardillo C Villanueva 26 71 32 52
3 Villanueva de La Cañada C Villanueva 26 53 37 51
4 Sek El Castillo Ucjc Castillo 26 58 45 45
5 Nuevo Boadilla H Nuevo 26 55 35 44
6 E Aupa Mentema Boadilla B Aupa Mentema 26 48 42 41
7 Villaviciosa de Odon C Villaviciosa 26 72 54 37
8 Antavilla Villanueva del Pa Antavilla 26 73 58 37
9 Escuela Futbol de Brunete Escuela 26 59 44 36
10 Cenicientos Sotillo B Cenicientos 26 46 44 36
11 CDE Jugones CDE Jugones 26 51 66 32
12 EFMO Boadilla ''F'' EFMO 26 46 91 31
13 Vallmont de Villanueva del Vallmont 26 36 93 16
14 CF Quijorna CF Quijorna 26 1 105 0
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 9
Equipo PJ GF GC Puntos
1 CDE Andel CDE Andel 13 76 6 39
2 E Amistad Alcorcon A Amistad 13 54 16 33
3 Fundación CD Leganes B Fundación 13 39 16 28
4 Mostoles CF Mostoles CF 13 32 7 26
5 E Internacional de Mostoles Internaciona 13 37 25 26
6 Libertad Alcorcon B Libertad 13 38 26 24
7 Trival Valderas Alcorcon D Trival 13 33 24 23
8 Estudiantes Alcorcón B Estudiantes 13 28 20 15
9 Mostoles URJC B Mostoles 13 34 43 13
10 Villanueva del Pardillo C Villanueva 13 32 41 13
11 Prodet Pozuelo Liceo Soroll Prodet 13 19 42 10
12 CD Parque Verde Parque Verde 13 11 47 10
13 CDE Legasur Rayo Legasur Rayo 13 16 65 6
14 Cultural Union Leganes Cultural 13 10 81 1
TEMPORADA 2019/2020
2ª MADRID CADETE GRUPO 10
Equipo PJ GF GC Puntos
1 Nuevo Boadilla B Nuevo 19 72 27 45
2 EFMO Boadilla C EFMO 19 76 37 43
3 Cala Pozuelo B Cala Pozuelo 19 56 19 43
4 CF Pozuelo B Pozuelo 19 56 25 42
5 Libertad Alcorcon C Libertad 19 46 26 38
6 Aupa EF Mentema Boadilla Aupa Mentema 19 50 29 35
7 Alpedrete B Alpedrete B 19 50 33 34
8 Villanueva de La Cañada B Villanueva 19 31 32 27
9 Villanueva del Pardillo C Villanueva 19 42 65 19
10 Villaviciosa de Odon B Villaviciosa 19 30 44 16
11 Union de Aravaca A Union 19 30 48 10
12 Mostoles C Mostoles C 19 24 62 10
13 Prodet Pozuelo Liceo Soroll Prodet 19 33 75 10
14 Aravaca C Aravaca C 19 26 100 4
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 13
Equipo PJ GF GC Puntos
1 K 2 B K 2 B 30 221 39 83
2 Efmo Boadilla D Efmo 30 147 32 79
3 Las Rozas CF B Rozas 30 134 41 72
4 Navalcarnero C Navalcarnero 30 90 31 71
5 Nuevo Boadilla C Nuevo 30 102 44 59
6 Vallmont Vallmont 30 74 50 55
7 Villanueva de La Cañada B Villanueva 30 79 50 54
8 Villaviciosa de Odon C Villaviciosa 30 73 61 49
9 FS Navalcarnero Navalcarnero 30 52 66 31
10 Puerta de Madrid B Puerta 30 54 92 30
11 Ferilan C Ferilan C 30 78 103 29
12 Las Rozas Ucjc G Rozas Ucjc 30 61 125 24
13 Villanueva del Pardillo C Villanueva 30 41 109 24
14 Juventus Academy Mirabal Juventus 30 74 176 20
15 E Aupa Mentema Boadilla Aupa Mentema 30 32 118 8
16 Gimnastica Colmenarejo B Gimnastica 30 36 211 7
TEMPORADA 2016/2017
3ª MADRID CADETE GRUPO 12
Equipo PJ GF GC Puntos
1 Libertad Alcorcon C Libertad 24 96 24 69
2 E Castilla Alcorcon A Castilla 24 84 42 51
3 Villanueva del Pardillo C Villanueva 24 74 27 50
4 Atletico Cañada Alcorcon B Atletico 24 52 32 45
5 Navalcarnero C Navalcarnero 24 66 37 44
6 Peña Madridista 3000 Goles Peña 23 54 33 37
7 Municipal Arroyomolinos C Municipal 24 55 39 37
8 Cadalso Cadalso 23 44 53 31
9 Navas del Rey Navas 24 47 82 27
10 E Amistad Alcorcon B Amistad 24 41 77 21
11 Villaviciosa de Odon C Villaviciosa 24 26 70 18
12 Robledo Robledo 24 34 102 10
13 Estudiantes Alcorcon C Estudiantes 24 22 77 6
TEMPORADA 2015/2016
2ª MADRID CADETE GRUPO 11
Equipo PJ GF GC Puntos
1 Rayo Majadahonda C Rayo 26 84 37 64
2 Electrocor Las Rozas Electrocor 26 86 31 58
3 Union de Aravaca A Union 26 75 39 54
4 CF Pozuelo de Alarcón C Pozuelo 26 67 39 51
5 EFMO Boadilla C EFMO 26 74 34 47
6 Cala Pozuelo B Cala Pozuelo 26 55 43 41
7 Puerta de Madrid Puerta 26 64 49 38
8 Las Rozas Ucjc D Rozas Ucjc 26 45 50 37
9 Nuevo Boadilla B Nuevo 26 44 56 34
10 Eepp San Fernando Escolapio Eepp 26 50 60 32
11 Gigantes B Gigantes B 26 40 57 32
12 Aravaca D Aravaca D 26 37 64 25
13 Villanueva del Pardillo C Villanueva 26 34 71 17
14 Club Las Encinas de Boadill Club Encinas 26 20 145 0

  USO DE MEMORIA  
5,387,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1107
Total Execution Time  0.1121
  CADENA URL  
/historico/Fc-Villanueva-Del-Pardillo-C-Cadete
  GET DATOS  
$_GET['/historico/Fc-Villanueva-Del-Pardillo-C-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0022  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 = 'Fc-Villanueva-Del-Pardillo-C-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.0031  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 = 'Fc-Villanueva-Del-Pardillo-C-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=96060 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=96060 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=96060 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=96060 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=96060 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=96060 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0028  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=96060 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=96060 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=96060 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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 = 70452
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=96060 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=736 AND type_rel = 3
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 = '96060' 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 = '96060' AND l.year = 2023 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 = '96060' 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 = 70452 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=96060 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (70452,64803) 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 = 70452 AND teamId = 96060
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64803 AND teamId = 96060
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 = 70452 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 = '96060' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '96060' 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 = '96060' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0026  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 = 96060 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 70452 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.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 `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.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 `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 = 61328 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.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 `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 = 52178 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 `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.0024  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 = 40592 AND t.round = 30 ORDER BY team.conference 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 `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 = 35884 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 `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 = 17231 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC