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 testing.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
01 Jun 80  Finalizado Algeciras CF
0 - 0
Real Valladolid 0
25 May 80  Finalizado Real Valladolid
0 - 2
Palencia 0
18 May 80  Finalizado Real Valladolid
1 - 0
Racing 0
11 May 80  Finalizado Real Oviedo
2 - 2
Real Valladolid 0
04 May 80  Finalizado Real Valladolid
2 - 2
Elche 0
27 Abr 80  Finalizado Cádiz
0 - 1
Real Valladolid 0
20 Abr 80  Finalizado Real Valladolid
1 - 0
OsasunaTarjeta Roja 0
13 Abr 80  Finalizado RM Castilla
1 - 2
Real ValladolidTarjeta Roja 0
06 Abr 80  Finalizado Real Valladolid
1 - 0
RC Deportivo 0
30 Mar 80  Finalizado Tarjeta RojaTarjeta RojaGimnàstic Tarragona
0 - 2
Real Valladolid 0
23 Mar 80  Finalizado Real Valladolid
2 - 1
Recreativo 0
16 Mar 80  Finalizado CE Sabadell
2 - 1
Real Valladolid 0
09 Mar 80  Finalizado Real Valladolid
0 - 2
Getafe Deportivo 0
02 Mar 80  Finalizado Levante
1 - 0
Real Valladolid 0
24 Feb 80  Finalizado Real Valladolid
4 - 0
Real Murcia 0
17 Feb 80  Finalizado CD Castellón
3 - 0
Real ValladolidTarjeta Roja 0
10 Feb 80  Finalizado Real Valladolid
1 - 1
Deportivo Alavés 0
03 Feb 80  Finalizado Celta
1 - 2
Real Valladolid 0
27 Ene 80  Finalizado Real Valladolid
3 - 2
Granada 0
20 Ene 80  Finalizado Real Valladolid
2 - 0
Algeciras CF 0
13 Ene 80  Finalizado Palencia
1 - 1
Real Valladolid 0
06 Ene 80  Finalizado Racing
1 - 1
Real Valladolid 0
30 Dic 79  Finalizado Real Valladolid
1 - 1
Real Oviedo 0
16 Dic 79  Finalizado Elche
1 - 0
Real ValladolidTarjeta RojaTarjeta Roja 0
02 Dic 79  Finalizado Real Valladolid
1 - 0
Cádiz 0
25 Nov 79  Finalizado Osasuna
4 - 2
Real Valladolid 0
18 Nov 79  Finalizado Real Valladolid
1 - 3
RM Castilla 0
11 Nov 79  Finalizado RC Deportivo
2 - 1
Real Valladolid 0
04 Nov 79  Finalizado Real Valladolid
5 - 1
Gimnàstic Tarragona 0
28 Oct 79  Finalizado Tarjeta RojaRecreativo
0 - 1
Real Valladolid 0
21 Oct 79  Finalizado Real Valladolid
2 - 0
CE Sabadell 0
14 Oct 79  Finalizado Getafe Deportivo
1 - 1
Real Valladolid 0
07 Oct 79  Finalizado Real Valladolid
1 - 1
Levante 0
30 Sep 79  Finalizado Real Murcia
0 - 0
Real Valladolid 0
23 Sep 79  Finalizado Real Valladolid
1 - 1
CD Castellón 0
16 Sep 79  Finalizado Deportivo Alavés
0 - 5
Real Valladolid 0
09 Sep 79  Finalizado Tarjeta RojaReal Valladolid
2 - 0
CeltaTarjeta RojaTarjeta RojaTarjeta Roja 0
02 Sep 79  Finalizado Granada
3 - 0
Real ValladolidTarjeta Roja 0
01 May 80  Finalizado Atlético
2 - 1
Real Valladolid 0
02 Abr 80  Finalizado Real Valladolid
1 - 1
Atlético 0
12 Mar 80  Finalizado Deportivo Alavés
2 - 1
Real Valladolid 0
27 Feb 80  Finalizado Real Valladolid
1 - 0
Deportivo Alavés 0
06 Feb 80  Finalizado Real Valladolid
2 - 1
CE Sabadell 0
30 Ene 80  Finalizado CE Sabadell
1 - 1
Real Valladolid 0
16 Ene 80  Finalizado CD Badajoz
1 - 6
Real Valladolid 0
09 Ene 80  Finalizado Real Valladolid
1 - 0
CD Badajoz 0
08 Dic 79  Finalizado Real Valladolid
3 - 1
RCD Carabanchel 0
28 Nov 79  Finalizado RCD Carabanchel
1 - 0
Real Valladolid 0
31 Oct 79  Finalizado Burgos CF B
1 - 1
Real Valladolid 0
12 Sep 79  Finalizado Real Valladolid
7 - 2
Burgos CF B 0

Plantilla del Real Valladolid Temporada 1979/1980

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
71 rs - - - - 2
74 es 178 76 - - 5
Defensa
67 es - - - 1 4
66 es 181 76 1 - 2
77 py - - - 1 3
66 es - - - 1 6
64 es 173 70 - - 6
70 es - - - - 6
71 es - - 2 1 3
Centrocampista
64 es - - 1 - -
65 es - - - - -
63 es 185 82 12 - 1
63 es 180 70 11 - 2
72 es - - - 1 1
63 es - - - - -
64 es 176 73 - - -
71 es - - 8 - 3
Delantero
67 es - - 3 - 2
67 es - - 3 - 1
62 es - - - - -
71 es - - - - 1
67 es - - 5 1 1
71 es 173 70 7 - 4
70 rs - - - - 1

Noticias del Real Valladolid

Ver últimas noticias

El Valladolid sabe esperar y da el golpe a tiempo

El Valladolid se llevó los tres puntos con una cómoda victoria por 0-3 ante el Amorebieta. Una victoria que no se encaminó hasta la segunda mitad y cuando los de Pezzolano ya estaban con un jugador más sobre el terreno de juego.

Efectivo, pero polémico

El Real Valladolid venció al Eldense por la mínima (1-0) en la jornada 35 de Segunda División. Monchu marcó el gol con el que el Pucela iguala los puntos del ascenso directo, pero la polémica marcó el encuentro por los tantos anulados a Timor y Mario Soberón.

Vinicius declaró por los insultos racistas que recibió en Valladolid

Vinicius declaró este jueves por los insultos que recibió en el José Zorrilla el 30 de diciembre de 2022. Ese día, algunos hinchas del Valladolid le dedicaron cánticos racistas. Cinco personas están siendo investigadas.

Nadie está contento

Ni Valladolid ni Levante fueron capaces de romper la igualada en un partido muy pobre de ambos conjuntos (0-0). Los pucelanos se mantienen en puesto de 'play off', mientras que los 'granotas' pierden terreno por entrar en las posiciones de privilegio.

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.




  USO DE MEMORIA  
6,196,704 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0038
Controller Execution Time ( Home / Category )  0.2897
Total Execution Time  0.2935
  CADENA URL  
/Valladolid/1980
  GET DATOS  
$_GET['/Valladolid/1980']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0018  SELECT type FROM routes WHERE alias = 'valladolid'
0.0066  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 = 'Valladolid' AND l.year = 1980 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=2654 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=2654 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=2654 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0066  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 = '2654' AND l.year = 1980 ORDER BY l.year DESC,cat.coefficient DESC
0.0052  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.0031  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 = 21960 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 5476 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106  (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 calendars1980 as c ON c.league_id = l.id WHERE (c.datateam1 = 2654 or c.datateam2 = 2654) AND l.year = 1980 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0118  (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 calendars1980 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 l.year = 1980 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0312  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1980 as c ON c.league_id = l.id INNER JOIN events1980 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 l.year = 1980)
0.0072  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 (1979,1980,1981) 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 (21961,5476,5406) 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.0034  SELECT count(id) as num_players from rel_players WHERE league_id = 5406 AND teamId = 2654
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 5476 AND teamId = 2654
0.0054  SELECT count(id) as num_players from rel_players WHERE league_id = 21961 AND teamId = 2654
0.0028  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1980` 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 = 5476 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0088  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 events1980 e ON e.player_id = p.id AND e.league_id = 5476 WHERE rp.league_id = 5476 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.0078  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 events1980 e ON e.player_id = p.id AND e.league_id = 5476 WHERE rp.league_id = 5476 AND rp.teamId = 2654 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0057  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 events1980 e ON e.player_id = p.id AND e.league_id = 5476 WHERE rp.league_id = 5476 AND rp.teamId = 2654 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0044  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 = 5476 AND l.year= 1980 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0065  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=95565 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0020  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=95565
0.0036  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 events1980 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=95565 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.0116  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 events1980 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=95565 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0039  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 events1980 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=95565 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0025   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 events1980 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=95565 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0028  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 events1980 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=95565 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0107  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 = 5476 ORDER BY nameShow LIMIT 100