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 A
TEMPORADA 2021/2022
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Aravaca A Aravaca A 26 84 42 51
2 Union Zona Norte Sub 12 Union Zona. 26 64 34 51
3 CDE FPA Las Rozas Sub 12 Rozas 25 47 25 48
4 Villanueva del Pardillo A Villanueva 25 52 37 48
5 Rayo B Rayo B 26 58 27 46
6 RSD Alcalá SAD B Alcalá 26 58 35 46
7 Nuevo Boadilla B Nuevo 26 66 42 43
8 Getafe D Getafe D 26 53 42 43
9 Atletico Villalba A Atletico 26 41 43 35
10 Mostoles C Mostoles C 26 30 36 29
11 Club Fuentelarreyna A Club 26 36 45 28
12 Electrocor Las Rozas Electrocor 26 32 90 18
13 Union Adarve B Union Adarve 26 39 100 14
14 Eepp San Fernando Escolapio Eepp 26 33 95 8
TEMPORADA 2020/2021
PREFERENTE MADRID ALEVÍN F11 GRUPO 1
Equipo PJ GF GC Puntos
1 Eepp San Fernando Escolapio Eepp 14 37 15 33
2 Villanueva del Pardillo A Villanueva 14 39 12 30
3 Rayo B Rayo B 14 38 13 30
4 Union Adarve C Union Adarve 14 27 14 29
5 CF Pozuelo A Pozuelo 14 41 20 28
6 Electrocor Las Rozas A Electrocor 14 30 17 27
7 Nuevo Boadilla C Nuevo 14 22 15 25
8 Odon A Odon A 14 26 23 21
9 Galapagar A Galapagar A 14 24 20 20
10 SAD Fundacion Rayo Vallecan Fundacion 14 24 23 16
11 Mostoles D Mostoles D 14 25 30 16
12 Efmo Boadilla B Efmo 14 33 29 14
13 Club Atletico de Madrid G Club 14 21 31 14
14 Rayo Ciudad Alcobendas C Rayo Ciudad 14 15 33 9
15 Club San Agustin B Club Agustin 14 13 60 6
16 Union de Aravaca Union 14 12 72 1
TEMPORADA 2019/2020
PREFERENTE MADRID ALEVÍN F11 GRUPO 1
Equipo PJ GF GC Puntos
1 CDE FPA Las Rozas Sub 12 Rozas 19 84 9 57
2 Gredos-San Diego Gredos-San 19 56 8 52
3 Nuevo Boadilla B Nuevo 19 71 23 42
4 CF Pozuelo A Pozuelo 19 51 20 41
5 Rayo Ciudad Alcobendas C Rayo Ciudad 19 48 22 36
6 Efmo Boadilla B Efmo 19 33 25 34
7 Alcorcon B Alcorcon B 19 54 28 31
8 Villanueva del Pardillo A Villanueva 18 25 38 22
9 Mostoles D Mostoles D 19 38 45 19
10 Union Adarve C Union Adarve 19 27 47 18
11 Galapagar A Galapagar A 18 20 44 14
12 San Fernando Escolapio Fernando 19 21 58 11
13 Club San Agustin B Club Agustin 19 17 66 10
14 Union de Aravaca Union 19 9 121 1
TEMPORADA 2018/2019
1ª MADRID ALEVÍN F11 GRUPO 10
Equipo PJ GF GC Puntos
1 Libertad Alcorcon A Libertad 26 97 20 67
2 Quijorna A Quijorna A 26 98 23 65
3 Villanueva del Pardillo A Villanueva 26 89 30 64
4 Escuela Fútbol de Brunete B Escuela 26 99 28 60
5 Alcorcon B Alcorcon B 26 78 27 57
6 Estudiantes Alcorcón A Estudiantes 26 75 24 49
7 Trival Valderas Alcorcon C Trival 26 31 41 27
8 Sevilla La Nueva Sevilla 26 48 62 26
9 AD Villaviciosa De Odon B Villaviciosa 26 32 57 25
10 FS Navalcarnero A Navalcarnero 26 39 70 24
11 Villanueva de La Cañada B Villanueva 26 30 68 21
12 Deportivo Yuncos Deportivo 26 27 69 20
13 ESC de FUT de Valdemoro E Valdemoro 26 38 112 17
14 Peña Madridista 3000 Goles Peña 26 17 167 2
TEMPORADA 2017/2018
1ª MADRID ALEVÍN F11 GRUPO 10
Equipo PJ GF GC Puntos
1 A Navalcarnero A Navalcarnero 26 79 19 63
2 El Alamo A El Alamo A 26 67 27 59
3 Sevilla La Nueva Sevilla 26 66 23 58
4 Villanueva del Pardillo A Villanueva 26 71 24 56
5 Quijorna A Quijorna A 26 46 43 41
6 Trival Valderas Alcorcon C Trival 26 44 32 38
7 Escuela Fútbol de Brunete B Escuela 26 49 40 37
8 AD Alcorcón C Alcorcón 26 40 35 33
9 Estudiantes Alcorcón A Estudiantes 26 35 39 33
10 Deportivo Yuncos Deportivo 26 27 54 26
11 FS Navalcarnero A Navalcarnero 26 28 54 24
12 Villanueva de La Cañada B Villanueva 26 41 56 23
13 Municipal Arroyomolinos C Municipal 26 17 88 12
14 Libertad Alcorcon B Libertad 26 12 88 7
TEMPORADA 2016/2017
1ª MADRID ALEVÍN F11 GRUPO 1
Equipo PJ GF GC Puntos
1 Colmenar Viejo A Colmenar 26 96 12 67
2 San Fernando Escolapio Fernando 26 95 21 67
3 Villanueva del Pardillo A Villanueva 26 67 28 58
4 Union Deportiva Tres Cantos Union 26 78 47 47
5 Electrocor Electrocor 26 47 30 42
6 Las Rozas C Las Rozas C 26 40 28 41
7 Rayo B Rayo B 25 49 44 35
8 El Real A El Real A 26 42 51 35
9 Siete Picos Colmenar B Siete Picos 26 35 65 27
10 3 Cantos B 3 Cantos B 26 48 68 26
11 CF Pozuelo B Pozuelo 26 21 51 23
12 Aravaca C Aravaca C 26 31 96 22
13 Castilla Castilla 25 33 71 19
14 Union Collado Villalba A Union 26 36 106 11
TEMPORADA 2015/2016
1ª MADRID ALEVÍN F11 GRUPO 1
Equipo PJ GF GC Puntos
1 Ciudad del Futbol Ciudad 24 194 9 68
2 Alpedrete A Alpedrete A 24 138 21 61
3 La Cañada La Cañada 24 125 26 61
4 Villanueva del Pardillo A Villanueva 24 77 24 53
5 Union Collado Villalba A Union 24 130 30 52
6 CF Pozuelo B Pozuelo 24 74 45 36
7 Nuevo Boadilla D Nuevo 24 59 41 33
8 Las Rozas C Las Rozas C 24 75 57 33
9 Colmenar Viejo B Colmenar 24 46 89 26
10 Castilla Castilla 24 42 93 18
11 Union Deportiva Tres Cantos Union 24 27 140 10
12 Alberto Cogorro A Alberto 24 20 179 7
13 Siete Picos Colmenar D Siete Picos 24 10 255 0
TEMPORADA 2014/2015
PREFERENTE MADRID ALEVÍN F11 GRUPO 1
Equipo PJ GF GC Puntos
1 Rayo Majadahonda Rayo 26 79 13 65
2 Torrelodones A Torrelodones 26 50 23 55
3 Efmo Boadilla B Efmo 26 53 26 50
4 San Fernando Escolapio Fernando 26 56 30 47
5 Escuela Futbol de Brunete Escuela 26 50 35 44
6 Nuevo Boadilla B Nuevo 26 45 43 40
7 Tres Cantos A Tres Cantos 26 44 35 37
8 Atletico Villalba A Atletico 26 40 45 34
9 Galapagar A Galapagar A 26 53 43 31
10 Siete Picos Colmenar B Siete Picos 26 35 44 30
11 Las Rozas B Las Rozas B 26 38 62 30
12 Villanueva del Pardillo A Villanueva 26 28 67 24
13 Union Deportiva Tres Cantos Union 26 31 87 20
14 Castilla Castilla 26 30 79 14

  USO DE MEMORIA  
5,356,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5035
Total Execution Time  0.5047
  CADENA URL  
/historico/Fc-Villanueva-Del-Pardillo-A-Alevin
  GET DATOS  
$_GET['/historico/Fc-Villanueva-Del-Pardillo-A-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0126  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-A-Alevin' 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.0166  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-A-Alevin' 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.0111  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=74654 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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=74654 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  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=74654 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0114  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=74654 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  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=74654 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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=74654 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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=74654 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  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=74654 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  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=74654 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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 = 64879
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=74654 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=984 AND type_rel = 3
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 984 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0107  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (930948,914706,76448) ORDER BY n.cover_points DESC, update_date DESC
0.0108  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 = '74654' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = '74654' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0119  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 = 64879 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0125  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=74654 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0113  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 (64879,61382) 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.0110  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64879 AND teamId = 74654
0.0110  SELECT count(id) as num_players from rel_players_base WHERE league_id = 61382 AND teamId = 74654
0.0117  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 64879 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0112  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 = '74654' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0117  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 = '74654' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0120  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 = 74654 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0123  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 = 64879 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.0121  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 = 61382 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0122  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 = 52005 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.0123  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 = 47121 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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 = 41014 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 35750 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114  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 = 18007 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 6526 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  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 = 64879 ORDER BY nameShow LIMIT 100