4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Fundacion Alcala
TEMPORADA 2022/2023
1ª AUTO. MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 19 C Real Madrid 33 122 26 91
2 Rayo CI Alcobendas Sub 19 B Rayo 33 92 43 72
3 Fundacion Alcala Fundacion 33 87 48 66
4 Yebenes-San Bruno Sub 19 Yebenes-San 33 90 58 61
5 Chopera Alcobendas Sub 19 Chopera 33 75 54 61
6 Coslada Sub 19 Coslada 33 67 45 58
7 Nuevo Boadilla Sub 19 Nuevo 33 77 43 57
8 Moratalaz Sub 19 B Moratalaz 33 69 46 57
9 Unión Adarve Sub 19 B Unión 33 60 69 50
10 Santa Ana Sub 19 Santa 33 62 67 43
11 Canillas Sub 19 Canillas 33 65 74 42
12 Rayo Mjdh. Sub 19 C Rayo Mjdh. 33 55 56 41
13 Puerta Bonita A Puerta 33 70 96 39
14 Las Rozas Sub 19 B Rozas 33 69 67 38
15 Boadilla B Boadilla B 33 49 82 29
16 San Fernando Sub 19 Fernando 33 29 118 13
17 Villanueva del Pardillo A Villanueva 33 31 105 12
18 Chamartín Vergara A Chamartín 33 46 118 11
TEMPORADA 2021/2022
1ª AUTO. MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 19 C Real Madrid 34 129 20 93
2 ED Moratalaz Sub 19 Moratalaz 34 75 38 65
3 Complutense Alcalá Sub 19 Complutense 34 72 45 62
4 Fundacion Alcala Fundacion 34 63 53 58
5 Rayo Mjdh. Sub 19 C Rayo Mjdh. 34 64 51 55
6 Rayo Vallecano Sub 19 C Rayo 34 71 59 53
7 Santa Ana Sub 19 Santa 34 61 65 51
8 Villaviciosa de Odón A Villaviciosa 34 71 77 50
9 Chopera Alcobendas Sub 19 Chopera 34 61 49 48
10 San Fernando B Fernando 34 59 56 48
11 Villanueva del Pardillo A Villanueva 34 52 59 46
12 Nuevo Boadilla Sub 19 Nuevo 34 70 72 43
13 Canillas Sub 19 Canillas 34 57 80 38
14 UD Sanse Sub 19 Sanse 34 50 81 38
15 CD Móstoles C Móstoles 34 53 72 36
16 Unión Adarve C Unión 34 38 71 31
17 Alcobendas Sub 19 Alcobendas 34 30 67 24
18 Aluche B Aluche B 34 40 101 23
TEMPORADA 2020/2021
1ª MADRID JUVENIL GRUPO 5
Equipo PJ GF GC Puntos
1 Fundacion Alcala Fundacion 16 55 22 43
2 Avance B Avance B 16 55 25 40
3 Mejoreño A Mejoreño A 16 40 25 34
4 Rivas Futbol Club C Rivas Futbol 16 46 22 33
5 Torrejon D Torrejon D 16 30 24 28
6 Ada Toledo Olivos Toledo 15 26 24 24
7 Nuevo Baztan Nuevo Baztan 16 36 32 23
8 Deportivo Ardoz Deportivo 16 42 44 22
9 Cobeña A Cobeña A 16 22 25 22
10 Meco Meco 16 22 20 21
11 Complutense Alcala C Complutense 16 35 28 20
12 Naya B Naya B 16 34 31 19
13 Espartales Sur A Espartales 16 32 39 18
14 Mun Deportes Daganz Deportes 15 34 46 15
15 Paracuellos Antamira B Paracuellos 16 25 45 10
16 Henares IV A Henares 16 15 45 8
17 La Plata Tr82 A Plata Tr82 16 14 66 2
TEMPORADA 2019/2020
2ª MADRID JUVENIL GRUPO 10
Equipo PJ GF GC Puntos
1 Fundacion Alcala Fundacion 21 165 29 61
2 AD Complutense Alcala D Complutense 21 57 31 46
3 CD Valdetorres Valdetorres 21 73 37 45
4 At. La Garena A Garena 21 48 35 42
5 CF Fuente el Saz B Fuente 21 68 38 41
6 EF Arganda EF Arganda 21 67 49 37
7 Naya C Naya C 21 50 40 36
8 CF Rayo Ensanche Rayo 21 51 32 34
9 AD Henares DIv B Henares 21 56 56 32
10 Club Ciudad Henares Club Ciudad 21 57 55 31
11 CF Alalpardo Alalpardo 21 54 51 29
12 ADA Toledo Olivos CF B Toledo 21 53 52 26
13 Escolapios Alcala Escolapios 21 42 81 11
14 Espartales Sur B Espartales 21 26 74 9
15 AD Chorrillo Dist. VIII A Chorrillo 21 29 89 6
16 CFD Futuro San Francisco Futuro 21 24 171 1
TEMPORADA 2018/2019
2ª MADRID JUVENIL GRUPO 6
Equipo PJ GF GC Puntos
1 Meco Meco 28 98 31 68
2 Espartales Sur Espartales 28 116 44 65
3 Fundacion Alcala Fundacion 28 105 49 62
4 Avance C Avance C 28 91 55 52
5 Camarma Camarma 28 89 58 51
6 Naya C Naya C 28 87 63 51
7 Academia Naf San Gabriel Academia 28 110 68 50
8 Villalbilla Villalbilla 28 67 50 41
9 Henares B Henares B 28 65 75 37
10 Ciudad Henares Ciudad 28 40 77 29
11 Escolapios Alcala Escolapios 28 55 95 23
12 Atletico La Garena A Atletico 28 44 76 22
13 Rayo Ensanche Rayo 28 52 83 21
14 Nuevo Baztan B Nuevo Baztan 28 50 129 20
15 La Plata Tr82 B Plata Tr82 28 30 146 7

  USO DE MEMORIA  
5,303,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5454
Total Execution Time  0.5466
  CADENA URL  
/historico/Fundacion-Rsd-Alcala-Juvenil
  GET DATOS  
$_GET['/historico/Fundacion-Rsd-Alcala-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0130  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 = 'Fundacion-Rsd-Alcala-Juvenil' 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.0135  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 = 'Fundacion-Rsd-Alcala-Juvenil' 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.0125  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=113678 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=113678 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=113678 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=113678 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=113678 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=113678 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=113678 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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 = 68909
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=113678 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=731 AND type_rel = 3
0.0128  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 731 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0129  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 (1067892,914706,889402,860480,829183) ORDER BY n.cover_points DESC, update_date DESC
0.0129  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 = '113678' ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '113678' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '113678' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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 = '113678' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 68909 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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=113678 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0131  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 (68909,64221) 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 = 68909 AND teamId = 113678
0.0129  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64221 AND teamId = 113678
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 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 = 68909 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '113678' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '113678' and rp.type = 4
0.0131  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 = '113678' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0133  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 = 113678 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68909 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 64221 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.0147  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 = 64789 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.0145  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 = 61247 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 54202 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.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 `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 = 45729 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC