4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Real Madrid C

Real Madrid C

Entrenador: Pau Quesada

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Real Madrid C Real Madrid 33 61 16 76
2 CD Móstoles Móstoles 33 56 30 63
3 Leganés B Leganés B 33 44 32 55
4 Las Rozas Las Rozas 33 48 38 47
5 CD Colonia Moscardó Colonia 33 47 48 47
6 RSD Alcalá RSD Alcalá 33 51 47 45
7 CDF Tres Cantos Tres Cantos 33 43 47 45
8 AD Torrejón CF Torrejón 33 39 35 44
9 Alcorcón B Alcorcón B 33 32 31 42
10 Galapagar Galapagar 33 42 51 41
11 Paracuellos Antamira Paracuellos 33 39 46 40
12 CD Canillas CD Canillas 33 34 44 40
13 Trival Valderas Trival 33 32 39 39
14 AD Parla AD Parla 33 37 46 38
15 CUC Villalba Villalba 33 40 45 36
16 Rayo Vallecano B Rayo 33 41 56 36
17 Villanueva del Pardillo Villanueva 33 26 37 35
18 CF Pozuelo CF Pozuelo 33 27 51 28
TEMPORADA 2022/2023
TERCERA FEDERACIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 CD Ursaria CD Ursaria 30 62 22 68
2 Real Madrid C Real Madrid 30 73 27 67
3 Getafe B Getafe B 30 49 24 54
4 Paracuellos Antamira Paracuellos 30 48 40 48
5 CD Móstoles Móstoles 30 38 32 47
6 RSD Alcalá RSD Alcalá 30 31 28 46
7 Las Rozas Las Rozas 30 37 38 45
8 Trival Valderas Trival 30 38 44 37
9 CF Pozuelo CF Pozuelo 30 37 47 37
10 AD Torrejón CF Torrejón 30 31 42 35
11 Galapagar Galapagar 30 38 44 35
12 CUC Villalba Villalba 30 30 45 34
13 CD Canillas CD Canillas 30 34 46 34
14 Rayo Vallecano B Rayo 30 42 45 33
15 CDE Madrid 2021 Madrid 2021 30 31 52 32
16 Real Aranjuez CF Real 30 21 64 16
TEMPORADA 2021/2022
PREFERENTE MADRID GRUPO 2
Equipo PJ GF GC Puntos
1 Real Madrid C Real Madrid 34 62 31 66
2 Real Aranjuez CF Real 34 61 27 66
3 Móstoles CF Móstoles 34 60 26 66
4 Atlético de Pinto Atlético 34 61 19 66
5 CP Parla Escuela Parla 34 54 33 65
6 CD Los Yébenes-San Bruno Yébenes-San 34 51 28 62
7 CD Lugo Fuenlabrada Lugo 34 44 31 53
8 El Álamo El Álamo 34 52 45 53
9 Vicálvaro Vicálvaro 34 50 40 51
10 Ciudad Los Angeles Ciudad 34 37 44 45
11 CD Mostoles URJC B Mostoles 34 45 44 45
12 Ciudad de Getafe SC Ciudad 34 58 49 45
13 Arganda Arganda 34 36 51 42
14 Tajamar Tajamar 34 30 41 37
15 Fuenlabrada B Fuenlabrada 34 37 69 29
16 San Agustin Guadalix B Agustin 34 33 59 28
17 Inter de Valdemoro Inter 34 32 75 18
18 Sporting Hortaleza B Sporting 34 20 111 8
TEMPORADA 2020/2021
1ª REGIONAL MADRID GRUPO 4
Equipo PJ GF GC Puntos
1 CP Parla Escuela Parla 19 46 18 40
2 Real Madrid C Real Madrid 19 47 21 39
3 Aluche Aluche 19 31 14 36
4 CD La Avanzada Avanzada 19 28 19 35
5 CD Griñón CD Griñón 19 37 28 30
6 Atlético Valdeiglesias Atlético 19 30 31 30
7 Los Yébenes San Bruno B Yébenes 19 37 26 28
8 Piqueñas Piqueñas 19 36 33 28
9 Leganés C Leganés C 19 39 39 28
10 Campamento Campamento 19 27 18 27
11 Lucero-Linces Lucero-Lince 19 31 25 27
12 Atlético Navalcarnero Atlético 19 34 42 27
13 Atl. Trabenco Zarzaquemada Atl. 19 30 39 27
14 Villa del Prado Villa Prado 19 27 24 25
15 Betis San Isidro Betis Isidro 19 36 34 25
16 Atletico Cañada Atletico 19 23 30 22
17 Moraleja de Enmedio Moraleja 19 31 41 19
18 Amistad Alcorcon A Amistad 19 25 42 16
19 Sporting Bazan Sporting 19 22 46 15
20 Arroyomolinos Arroyomolino 19 12 59 8

  USO DE MEMORIA  
5,401,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.0878
Total Execution Time  0.0892
  CADENA URL  
/historico/Real-Madrid-Cf-C
  GET DATOS  
$_GET['/historico/Real-Madrid-Cf-C']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
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 = 'Real-Madrid-Cf-C' 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.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=139547 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=139547 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=139547 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=139547 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0021  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 = '139547' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '139547' AND l.year = 2024 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 = '139547' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=139547 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (72266,71489,71432) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72266 AND teamId = 139547
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 71489 AND teamId = 139547
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 139547
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 = '139547' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '139547' 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 = '139547' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0037  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72266 WHERE rp.league_id = 72266 AND rp.teamId = 139547 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72266 WHERE rp.league_id = 72266 AND rp.teamId = 139547 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72266 WHERE rp.league_id = 72266 AND rp.teamId = 139547 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 139547 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0039  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 `tables2024` 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 = 72266 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.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 `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 = 67981 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.0026  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` 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 = 63728 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.0026  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` 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 = 59968 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC