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 Zaragoza
  • Nombre completo Real Zaragoza Club Deportivo SAD
  • Nombre corto ZAR
  • País España
  • Ciudad Zaragoza
  • Entrenador Víctor Fernández
  • URL del equipo en RF //m.resultados-futbol.com/Real-Zaragoza
Otros Datos
  • Año de Fundación 1932
  • Patrocinador Caravan Fragancias
  • Equipo Filial Deportivo Aragón
  • Marca de Ropa Adidas
  • Lugar de entrenamiento Ciudad Deportiva
  • Socios 21000
Internet
Información sobre el estadio
  • Nombre del estadio La Romareda
  • Capacidad 34596
  • Dirección Paseo Isabel La Católica s/n
  • Teléfono 976 56 77 77
  • Fax 976 567 777
  • Año de construcción 1957
  • Tamaño 107 x 68 metros
La Romareda
Histórico de participación
Copa del Rey
Primera División
Trofeo Ciudad de Zaragoza
Segunda División
Partidos Amistosos
15 veces
Segunda - Play Offs Ascenso
11 veces
Europa League Grupo 0
9 veces
Trofeo Ramón de Carranza
6 veces
Copa de Ferias
5 veces
Recopa de Europa
5 veces
Trofeo Colombino
5 veces
Copa de la Liga de España
4 veces
Tercera División Grupo 3
4 veces
Supercopa de España
3 veces
(2005, 2002, 1995)
Trofeo Joan Gamper
1 vez
(1970)
Regional
1 vez
(1932)
Supercopa Europa
1 vez
(1996)
Trofeo Costa del Sol
1 vez
(1984)
Trofeo Teresa Herrera
1 vez
(2005)
Partidos del Real Zaragoza Ir al LIVESCORE
02 Jun 24  en 2 meses Real Zaragoza
-
Albacete 14
26 May 24  en 1 mes Racing
-
Real Zaragoza 1
19 May 24  en 1 mes Real Zaragoza
-
Racing Ferrol 2
12 May 24  en 1 mes Real Oviedo
-
Real Zaragoza 3
05 May 24  en 1 mes Real Zaragoza
-
Burgos 1
27 Abr 24  en 29 días Leganés
16:15
Real Zaragoza 1
20 Abr 24  en 22 días Huesca
21:00
Real Zaragoza 2
14 Abr 24  en 16 días Real Zaragoza
18:30
Elche 2
06 Abr 24  en 8 días Levante
18:30
Real Zaragoza 1
31 Mar 24  en 2 días Real Zaragoza
16:15
Tenerife 21
24 Mar 24  Finalizado Mirandés
0 - 0
Real Zaragoza 402
17 Mar 24  Finalizado Real Zaragoza
0 - 1
Espanyol 181
09 Mar 24  Finalizado Real Valladolid
2 - 0
Real Zaragoza 136
03 Mar 24  Finalizado Real Zaragoza
0 - 1
SD Amorebieta 206
24 Feb 24  Finalizado Villarreal B
0 - 0
Real Zaragoza 92
16 Feb 24  Finalizado Real Zaragoza
1 - 2
FC CartagenaTarjeta Roja 999
11 Feb 24  Finalizado Eibar
1 - 0
Real Zaragoza 130
05 Feb 24  Finalizado Real Zaragoza
3 - 0
Real Sporting 530
27 Ene 24  Finalizado Alcorcón
0 - 0
Real Zaragoza 78
20 Ene 24  Finalizado Real Zaragoza
2 - 0
FC Andorra 214
15 Ene 24  Finalizado Eldense
1 - 1
Real Zaragoza 285
20 Dic 23  Finalizado Real Zaragoza
2 - 2
Levante 215
17 Dic 23  Finalizado SD Amorebieta
1 - 1
Real Zaragoza 95
08 Dic 23  Finalizado Tarjeta RojaEspanyol
1 - 1
Real Zaragoza 325
02 Dic 23  Finalizado Real Zaragoza
1 - 0
Leganés 255

Plantilla del Real Zaragoza Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
1 38 ar 186 85 - - 1
37 20 es 185 - - - -
35 24 es 188 77 - - 1
25 32 es 180 72 - - 1
36 23 es 184 - - - -
13 25 fr 186 82 - - 1
Defensa
6 21 es 181 70 2 - 5
2 28 dz 173 72 - - 1
38 22 es 181 72 - - 1
17 27 es 181 74 - - 1
18 32 es 174 71 1 - 3
40 17 es - - - - -
3 34 pt 190 88 1 - 6
31 22 es 187 - - - -
24 27 es 182 79 - 1 1
22 30 fr 172 65 - - 4
15 22 uy 186 - - - 5
Centrocampista
26 20 es 184 - - - -
14 22 es 180 72 3 - 1
5 26 es 184 67 1 - 2
41 18 es - - - - -
11 32 es 188 66 8 - 6
8 24 es 184 80 - - 6
10 27 es 178 75 - - 1
21 26 es 185 69 - - 6
Delantero
33 18 es 182 - - - 1
39 21 es 185 63 - - -
7 22 es 170 67 1 - 1
9 21 es 182 78 2 - 1
19 27 es 167 62 2 - 1
34 21 es 184 - - - -
30 19 es - - - - -
29 19 es 177 72 - - -
23 34 es 183 77 - 1 2
12 29 tr 188 78 - - 4
20 23 es 177 71 4 - 10
Noticias del Real Zaragoza
Ver últimas noticias

Bastón podría llegar a la ida contra el Zaragoza

El goleador del Real Zaragoza, Borja Bastón, se ha entrenado hoy con normalidad y podría estar disponible para ser convocado para el partido de ida de la segunda eliminatoria de la fase de ascenso a Primera que se jugará el próximo miércoles en el estadio de La Romareda contra la Unión Deportiva Las Palmas.

1-4. Un épico Zaragoza ahonda la depresión del Girona y jugará por el ascenso

Contra todo pronóstico, el Real Zaragoza ha conseguido una remontada histórica a domicilio y se ha impuesto por 1-4 al Girona, que no ha hecho valer el 0-3 en la ida, por lo que se jugará ante la UD Las Palmas el ascenso a Primera División.

0-3. El Girona, a un paso de la siguiente eliminatoria

El Girona dejó prácticamente resuelta la primera eliminatoria de la promoción de ascenso contra el Real Zaragoza en el encuentro de ida, en el que se impuso por 0-3 gracias a su gran efectividad en el remate en la primera mitad.

Araujo, Culio y Silva ponen el acento sudamericano al ascenso de Las Palmas

El ascenso a la Primera división del fútbol español conseguido hoy por la UD Las Palmas tras vencer por 2-0 al Real Zaragoza ha contado con la notable aportación de los argentinos Sergio Ezequiel Araujo y Juan Emmanuel Culio, así como del uruguayo Marcelo Andrés Silva.

2-0. El equipo canario logra el 2-0 que necesitaba y vuelve a Primera

La UD Las Palmas firmó el 2-0 que necesitaba para remontar el 3-1 adverso ante el Real Zaragoza y regresa a la máxima categoría del fútbol español 13 años después, gracias a un gol del delantero argentino Sergio Araujo en los minutos finales de un emocionante y ya histórico encuentro.



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,349,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.5693
Total Execution Time  0.5711
  CADENA URL  
/Real-Zaragoza
  GET DATOS  
$_GET['/Real-Zaragoza']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0105  SELECT type FROM routes WHERE alias = 'real-zaragoza'
0.0250  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 = 73281
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2136 AND type_rel = 2
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2136 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0108  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 (79,229,230,245,349) ORDER BY n.cover_points DESC, update_date DESC
0.0123  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 = '2136' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0109  (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 = 2136 or c.datateam2 = 2136) 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.0114  (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 = 2136 or c.datateam2 = 2136) 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 = 2136 or c.datateam2 = 2136) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0125  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=2136 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0107  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 (73281,72177,71759,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.0124  SELECT count(id) as num_players from rel_players WHERE league_id = 72177 AND teamId = 2136
0.0163  SELECT count(id) as num_players from rel_players WHERE league_id = 71759 AND teamId = 2136
0.0370  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2136
0.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 73281 AND teamId = 2136
0.0123  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 = '2136' 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 = '2136' and rp.type = 4
0.0157  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 = '2136' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0106  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '2136' and rp.type = 4
0.0130  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 = 2136 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.0141  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 = 2136 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144  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 = 2136 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 2136 AND rp.league_id = 72177 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0136  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=6584351 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0113  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6584351
0.0154  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=6584351 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.0156  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=6584351 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0144  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=6584351 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0145   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=6584351 AND (e.action = 22) 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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6584351 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC