4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CF Pozuelo A
TEMPORADA 2021/2022
PREFERENTE MADRID ALEVÍN F11 GRUPO 1
Equipo PJ GF GC Puntos
1 CF Pozuelo A Pozuelo 22 70 16 54
2 Nuevo Boadilla C Nuevo 22 58 30 47
3 Alberto Cogorro Alberto 20 63 16 41
4 Las Rozas CF B Rozas 22 34 25 39
5 Efmo Boadilla B Efmo 22 51 44 38
6 El Real de Manzanares Real 21 45 28 36
7 Galapagar Galapagar 22 42 49 32
8 E Football Dreams Experienc Football 22 61 71 31
9 Aravaca B Aravaca B 22 39 75 24
10 Torrelodones A Torrelodones 22 29 53 17
11 CDE FPA Las Rozas B Rozas 21 20 59 7
12 Gimnastica Colmenarejo Gimnastica 22 29 75 5
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ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 12 B Real Madrid 26 196 5 78
2 Ciudad del Futbol Ciudad 26 72 33 67
3 Atlético Sub 12 Atlético 26 105 19 64
4 Unión Adarve Sub 12 Unión 26 53 21 55
5 Union Zona Norte Sub 12 Union Zona. 26 38 49 38
6 Atletico Villalba A Atletico 26 44 45 35
7 Las Rozas A Las Rozas A 26 31 62 34
8 Canillas Canillas 26 40 61 32
9 San Roque A San Roque A 26 35 68 31
10 Aravaca A Aravaca A 26 28 49 30
11 Deportivo Av Santa Ana A Deportivo 26 28 67 21
12 Sporting Hortaleza A Sporting 26 31 89 14
13 CF Pozuelo A Pozuelo 26 18 93 13
14 Getafe D Getafe D 26 14 72 11
TEMPORADA 2017/2018
PREFERENTE MADRID ALEVÍN F11 GRUPO 1
Equipo PJ GF GC Puntos
1 Las Rozas A Las Rozas A 26 78 13 69
2 Atletico Villalba A Atletico 26 67 21 60
3 Tres Cantos A Tres Cantos 26 62 34 51
4 EFMO Boadilla Sub 12 EFMO 26 55 30 45
5 Nuevo Boadilla B Nuevo 26 44 41 38
6 Siete Picos Colmenar A Siete Picos 26 42 44 38
7 Villanueva de La Cañada A Villanueva 26 41 41 36
8 Galapagar A Galapagar A 26 57 67 32
9 Colmenar Viejo A Colmenar 26 41 45 30
10 San Fernando Escolapio Fernando 26 36 43 30
11 Alberto Cogorro A Alberto 26 31 52 25
12 Recreativo Soto del Real A Recreativo 26 37 59 25
13 CF Pozuelo A Pozuelo 26 22 61 14
14 Club Las Encinas de Boadill Club Encinas 26 36 98 10
TEMPORADA 2016/2017
PREFERENTE MADRID ALEVÍN F11 GRUPO 1
Equipo PJ GF GC Puntos
1 Ciudad del Futbol Ciudad 24 102 8 65
2 Aravaca A Aravaca A 24 90 22 60
3 Atletico Villalba A Atletico 24 76 23 60
4 CF Pozuelo A Pozuelo 24 71 27 45
5 Villanueva de La Cañada A Villanueva 24 59 44 39
6 Union Adarve B Union Adarve 24 50 63 33
7 Galapagar A Galapagar A 24 44 45 31
8 Barrio Pilar A Barrio Pilar 24 39 54 28
9 Las Rozas B Las Rozas B 24 25 52 21
10 Alberto Cogorro A Alberto 24 43 90 21
11 Union Zona Norte B Union Zona. 24 33 63 20
12 Torrelodones A Torrelodones 24 26 89 17
13 Alpedrete A Alpedrete A 24 15 93 2
TEMPORADA 2014/2015
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Sub 12 Atlético 26 81 4 72
2 Real Madrid Sub 12 B Real Madrid 26 109 9 71
3 Rayo Vallecano B Rayo 26 76 21 58
4 Atletico Madrileño A Atletico 26 40 38 45
5 Unión Adarve Sub 12 Unión 26 52 37 43
6 Alcobendas Levitt A Alcobendas 26 24 36 32
7 Las Rozas A Las Rozas A 26 27 45 32
8 Nuevo Boadilla Sub 12 Nuevo 26 39 71 29
9 Aravaca A Aravaca A 26 29 46 25
10 Union Zona Norte Sub 12 Union Zona. 26 26 41 24
11 CF Pozuelo A Pozuelo 26 30 54 24
12 R. Ciudad Alcobendas Sub 12 Ciudad 26 20 47 24
13 San Agustin de Guadalix A Agustin 26 28 71 17
14 EFMO Boadilla Sub 12 EFMO 26 24 85 16

  USO DE MEMORIA  
5,383,184 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4348
Total Execution Time  0.4361
  CADENA URL  
/historico/Cf-Pozuelo-De-Alarcon-A-Alevin
  GET DATOS  
$_GET['/historico/Cf-Pozuelo-De-Alarcon-A-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0256  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 = 64869
0.0133  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 = 64891
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=40487 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=985 AND type_rel = 3
0.0127  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 = '40487' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 64869 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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 = 64891 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=40487 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (64891,64869) 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.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64869 AND teamId = 40487
0.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64891 AND teamId = 40487
0.0126  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 = 64869 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0130  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 = '40487' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '40487' and rp.type = 4
0.0127  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 = '40487' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0129  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 = 40487 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0131  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 = 64891 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.0136  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 = 64869 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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.0131  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.0130  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 = 45481 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 41674 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 34518 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 6528 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 64869 ORDER BY nameShow LIMIT 100