4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información
  • Nombre del equipo Real Valladolid
  • Nombre completo Real Valladolid Club de Fútbol
  • Nombre corto VAD
  • País España
  • Ciudad Valladolid
  • Presidente Ronaldo
  • Entrenador Paulo Pezzolano
  • URL del equipo en RF //m.resultados-futbol.com/Valladolid
Otros Datos
  • Año de Fundación 1928
  • Patrocinador Estrella Galicia
  • Equipo Filial Valladolid B
  • Marca de Ropa Adidas
  • Lugar de entrenamiento Anexos José Zorrilla
  • Socios 20067
Internet
Información sobre el estadio
  • Nombre del estadio Municipal José Zorrilla
  • Capacidad 26512
  • Dirección Avenida del Mundial 82 s/n
  • Teléfono 983 36 03 42
  • Fax 983 37 21 64
  • Año de construcción 1982
  • Tamaño 105 x 68 metros
Municipal José Zorrilla
Histórico de participación
Copa del Rey
Primera División
Segunda División
Partidos Amistosos
15 veces
Segunda - Play Offs Ascenso
11 veces
Tercera División Grupo 2
9 veces
Copa de la Liga de España
4 veces
Europa League
2 veces
(1998, 1985)
Recopa de Europa
1 vez
(1990)
Segunda División - Play Offs Permanencia
1 vez
(1942)
Trofeo Colombino
1 vez
(1997)
Trofeo Naranja
1 vez
(1995)
Partidos del Real Valladolid Ir al LIVESCORE
02 Jun 24  en 2 meses Tenerife
-
Real Valladolid 8
26 May 24  en 1 mes Real Valladolid
-
Villarreal B 3
19 May 24  en 1 mes Alcorcón
-
Real Valladolid 3
12 May 24  en 1 mes Real Valladolid
-
Espanyol 7
05 May 24  en 1 mes Mirandés
-
Real Valladolid 3
28 Abr 24  en 1 mes Real Valladolid
18:30
Huesca 3
20 Abr 24  en 22 días SD Amorebieta
14:00
Real Valladolid 3
13 Abr 24  en 15 días Real Valladolid
18:30
Eldense 3
07 Abr 24  en 9 días FC Cartagena
21:00
Real Valladolid 4
30 Mar 24  en 1 día Real Valladolid
14:00
Levante 12
24 Mar 24  Finalizado Real Valladolid
3 - 1
EibarTarjeta Roja 416
17 Mar 24  Finalizado Racing Ferrol
2 - 0
Real ValladolidTarjeta Roja 193
09 Mar 24  Finalizado Real Valladolid
2 - 0
Real Zaragoza 136
03 Mar 24  Finalizado FC Andorra
2 - 1
Real Valladolid 215
23 Feb 24  Finalizado Real Valladolid
3 - 0
Real Oviedo 358
17 Feb 24  Finalizado Real Sporting
1 - 1
Real Valladolid 256
12 Feb 24  Finalizado Real Valladolid
0 - 0
Albacete 385
03 Feb 24  Finalizado Leganés
0 - 0
Real Valladolid 227
29 Ene 24  Finalizado Tarjeta RojaReal Valladolid
3 - 1
Racing 203
21 Ene 24  Finalizado Elche
0 - 0
Real Valladolid 299
13 Ene 24  Finalizado Burgos
1 - 0
Real Valladolid 333
21 Dic 23  Finalizado Real Valladolid
0 - 1
Racing Ferrol 406
18 Dic 23  Finalizado Villarreal B
1 - 0
Real Valladolid 658
09 Dic 23  Finalizado Real Valladolid
2 - 1
SD Amorebieta 147
02 Dic 23  Finalizado Levante
2 - 1
Real Valladolid 142

Plantilla del Real Valladolid Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
31 20 es 190 - - - -
13 27 pt 193 79 - - -
1 35 es 180 76 - - -
Defensa
34 22 es 194 - - 1 2
3 21 es 182 - - - 3
6 22 cm 184 75 1 1 4
29 18 es 177 - - - -
5 27 es 189 77 - - -
12 28 br 187 82 - - -
22 23 br 177 - 1 - 4
2 29 es 173 68 - - 3
18 34 es 176 65 1 - 8
Centrocampista
26 22 es 186 74 - - 2
23 29 ma 173 63 2 - 2
16 31 es 179 70 - - 5
28 19 es - - - - -
37 21 gh 174 - - - -
8 24 es 173 68 5 - 4
20 27 hr 188 83 2 - 4
4 24 es 184 81 4 - 4
Delantero
21 38 es 186 85 - - -
39 17 es 185 - - - -
19 27 sn 173 65 5 - 2
35 22 cm 187 75 2 - 1
10 31 es 169 64 - - 8
24 28 br 180 77 2 - 1
27 22 es 168 - - - -
7 30 sn 180 80 7 - 5
9 27 br 185 78 2 - 3
11 21 es 169 65 - - 4
38 20 es 178 67 2 - 2
17 21 hr 184 70 - - -
Noticias del Real Valladolid
Ver últimas noticias

Archivan el 'caso Oikos' tras seis años de instrucción

La Justicia ha resuelto sobreseer y archivar provisionalmente el 'caso Oikos' después de seis años de proceso y decenas de investigaciones. La jueza se apoya en una sentencia del Tribunal Supremo que data de 2023 y congela las pesquisas porque entiende que no hay pruebas suficientes para considerar probado o digno de continuidad en sus indagaciones el presunto amaño de partidos que había sobre la mesa.

Domingo grande para el José Zorrilla

El Real Valladolid derrotó por 3-1 al Eibar en un duelo directo por los puestos de 'play off' de ascenso celebrado en el Estadio José Zorrilla. El Pucela está mostrando una entereza en casa que refrenda su candidatura a Primera. Con 51 puntos, los tres que cosechó a costa de los 'armeros' aproximaron su posición a la guipuzcoana, que tan solo está blinada por una unidad de distancia. Meseguer, Sylla y Sala anotaron para los blanquivioletas. Jon Bautista lo hizo para la visita.

Una mala racha acaba con otra

El Racing de Ferrol cerró su mala racha y volvió a ganar ante un Valladolid que vuelve a perder puntos fuera de casa, donde no gana desde el 24 de noviembre.

El chico nuevo aprende rápido la lección

El Valladolid se llevó la victoria en su partido frente al Zaragoza gracias a un doblete de Amath Ndiaye (2-0). Con estos tres puntos, el conjunto de Paulo Pezzolano se mantiene en la lucha por el ascenso a Primera División.

Scheidler deja al Valladolid con la miel en los labios

El Andorra consiguió remontar en el tramo final del partido para soñar con la salvación y para dejar en la estocada a un Valladolid que sigue negado fuera de casa.



Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,155,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.5413
Total Execution Time  0.5433
  CADENA URL  
/Valladolid
  GET DATOS  
$_GET['/Valladolid']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0108  SELECT type FROM routes WHERE alias = 'valladolid'
0.0111  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2654 AND type_rel = 2
0.0259  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2654 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0109  SELECT /*35 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 (1308194,1307887,1306885,1305682,1304754) ORDER BY n.cover_points DESC, update_date DESC
0.0121  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 = '2654' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0115  (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 as c ON c.league_id = l.id WHERE (c.datateam1 = 2654 or c.datateam2 = 2654) 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.0113  (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 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 = 2654 or c.datateam2 = 2654) 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.0110  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN events2024 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players 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 = 2654 or c.datateam2 = 2654) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0122  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=2654 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0108  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 (72177,71759,71432,67669) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 67669 AND teamId = 2654
0.0114  SELECT count(id) as num_players from rel_players WHERE league_id = 72177 AND teamId = 2654
0.0119  SELECT count(id) as num_players from rel_players WHERE league_id = 71759 AND teamId = 2654
0.0249  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2654
0.0119  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 = '2654' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0107  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2654' and rp.type = 4
0.0125  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 = '2654' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0109  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '2654' and rp.type = 4
0.0210  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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 2654 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.0215  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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 2654 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0197  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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 2654 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0164  SELECT rp.team_id as teamId FROM rel_players 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 = 2654 AND rp.league_id = 72177 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0129  SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=6584350 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0111  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6584350
0.0152  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6584350 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0160  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6584350 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0143  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6584350 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0146   SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6584350 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0180  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6584350 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC