4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Dosa Sub 14
Información

Partidos del CD Dosa Sub 14

Ir al LIVESCORE
01 Jun 24  en 1 mes CD Dosa Sub 14
-
Galapagar Sub 14 0
25 May 24  en 27 días Atlético Alcobendas
-
CD Dosa Sub 14 0
18 May 24  en 20 días CD Dosa Sub 14
-
AD Torrejón Sub 14 0
11 May 24  en 13 días Union Adarve Sub 14
-
CD Dosa Sub 14 0
08 May 24  en 11 días CD Dosa Sub 14
20:00
Real Madrid Sub 14 B 0
20 Abr 24  Finalizado Rayo Majadahonda Sub 14
3 - 0
CD Dosa Sub 14 0
14 Abr 24  Finalizado CD Dosa Sub 14
1 - 1
Complutense Alcalá 0
06 Abr 24  Finalizado Football Dreams Sub 14
7 - 1
CD Dosa Sub 14 0
17 Mar 24  Finalizado CD Dosa Sub 14
1 - 0
Leganés Sub 14 0
09 Mar 24  Finalizado CD Dosa Sub 14
0 - 0
Las Rozas Sub 14 0
03 Mar 24  Finalizado Canillas Sub 14
0 - 1
CD Dosa Sub 14 0
25 Feb 24  Finalizado CD Dosa Sub 14
0 - 3
Atlético Sub 14 B 0
17 Feb 24  Finalizado Getafe Sub 14 C
5 - 0
CD Dosa Sub 14 0
10 Feb 24  Finalizado CD Dosa Sub 14
0 - 3
Aravaca FC Sub 14 0
03 Feb 24  Finalizado Sporting Hortaleza
5 - 0
CD Dosa Sub 14 0
28 Ene 24  Finalizado Galapagar Sub 14
3 - 0
CD Dosa Sub 14 0
20 Ene 24  Finalizado CD Dosa Sub 14
1 - 2
Atlético Alcobendas 0
13 Ene 24  Finalizado AD Torrejón Sub 14
0 - 0
CD Dosa Sub 14 0

Noticias de División Honor Madrid Infantil

Ver últimas noticias

Ancelotti, espectador de lujo del derbi de infantiles

Este sábado se enfrentaron en Valdebebas el Infantil B del Real Madrid contra sus homólogos del Atlético de Madrid. En las gradas estuvo Carlo Ancelotti, muy atento al desempeño de los que en un futuro pueden ser jugadores del primer equipo.

Así se presenta el fin de semana para la cantera del Real Madrid

El Real Madrid Castilla ya tiene virtualmente la clasificación a la fase de ascenso a Segunda División y cierra la primera fase contra el Sanse. También juegan el Juvenil B, el Cadete A y el Infantil A en un fin de semana cargado de partidos.

Así llega el fin de semana del 19 y 20 de diciembre para la cantera del Real Madrid

Estos son los partidos que disputarán este fin de semana del 19 y 20 de diciembre los equipos del Real Madrid. Destaca que Cadete, Infantil A y Alevín A jugarán derbis contra el Atlético.

Estos son los partidos del fin de semana para la cantera del Madrid

Más allá del primer equipo, la cantera del Real Madrid afronta estos 14 y 15 de noviembre un fin de semana plagado de partidos. Consulta aquí los rivales y horarios desde el Castilla hasta el Alevín B blanco.

Madrid quiere que su fútbol base juegue ¡con la mascarilla puesta!

El pánico por el coronavirus sigue provocando decisiones de todo tipo en cuanto al fútbol, como la aprobada por la Comunicad de Madrid, que ha decidido obligar a los jugadores del fútbol base a entrenar y competir... ¡con la mascarilla puesta!




  USO DE MEMORIA  
4,655,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3176
Total Execution Time  0.3195
  CADENA URL  
/Dosa-A-Infantil
  GET DATOS  
$_GET['/Dosa-A-Infantil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0146  SELECT type FROM routes WHERE alias = 'dosa-a-infantil'
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=23176 AND type_rel = 2
0.0147  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 = '23176' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 74221 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024_base as c ON c.league_id = l.id WHERE (c.datateam1 = 23176 or c.datateam2 = 23176) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0152  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024_base as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 23176 or c.datateam2 = 23176) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0149  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024_base as c ON c.league_id = l.id INNER JOIN events2024_base as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players_base rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 23176 or c.datateam2 = 23176) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0153  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=23176 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (74221) 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.0146  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74221 AND teamId = 23176
0.0150  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 = '23176' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '23176' and rp.type = 4
0.0155  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 = '23176' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0154  SELECT rp.team_id as teamId FROM rel_players_base AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 23176 AND rp.league_id = 74221 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1