4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Urawa Reds

Urawa Reds

Entrenador: Per-Mathias Högmo

Información
  • Nombre del equipo Urawa Reds
  • Nombre completo Urawa Red Diamonds
  • Nombre corto URA
  • País Japón
  • Ciudad Saitama
  • Entrenador Per-Mathias Högmo
  • URL del equipo en RF testing.resultados-futbol.com/Urawa-Reds
Otros Datos
  • Año de Fundación 1950
Internet

Información sobre el estadio

  • Nombre del estadio Saitama Stadium 2002
  • Capacidad 64525
  • Dirección 500 Nakanoda, Midori-ku
  • Teléfono +81-48-812-1001
  • Fax +81-48-812-1212
  • Año de construcción 2001
Saitama Stadium 2002

Partidos del Urawa Reds

Ir al LIVESCORE
27 Jun 15  Finalizado Urawa Reds
5 - 2
Albirex Niigata 3
20 Jun 15  Finalizado Vissel Kobe
1 - 1
Urawa RedsTarjeta Roja 5
07 Jun 15  Finalizado Urawa Reds
1 - 0
Shimizu S-Pulse 4
03 Jun 15  Finalizado Kashiwa Reysol
3 - 3
Urawa Reds 10
30 May 15  Finalizado Tarjeta RojaSagan Tosu
1 - 6
Urawa RedsTarjeta Roja 0
23 May 15  Finalizado Urawa Reds
2 - 1
Kashima Antlers 4
16 May 15  Finalizado Urawa Reds
4 - 1
FC Tokyo 0
10 May 15  Finalizado Vegalta Sendai
4 - 4
Urawa Reds 4
02 May 15  Finalizado Urawa Reds
1 - 0
Gamba Osaka 14
29 Abr 15  Finalizado Ventforet Kofu
0 - 2
Urawa Reds 45
25 Abr 15  Finalizado Urawa Reds
2 - 1
Nagoya Grampus 2
18 Abr 15  Finalizado Urawa Reds
2 - 1
Yokohama F. Marinos 0
12 Abr 15  Finalizado Kawasaki Frontale
1 - 1
Urawa Reds 0
04 Abr 15  Finalizado Urawa Reds
1 - 0
Matsumoto Yamaga 1
22 Mar 15  Finalizado Sanfrecce Hiroshima
0 - 0
Urawa Reds 0
14 Mar 15  Finalizado Urawa Reds
1 - 0
Montedio Yamagata 2
07 Mar 15  Finalizado Shonan Bellmare
1 - 3
Urawa Reds 7
28 Nov 15  Finalizado Urawa Reds
1 - 3
Gamba Osaka 3
22 Nov 15  Finalizado Urawa Reds
5 - 2
Vissel Kobe 0
07 Nov 15  Finalizado Urawa Reds
1 - 1
Kawasaki Frontale 0
24 Oct 15  Finalizado FC Tokyo
3 - 4
Urawa Reds 7
17 Oct 15  Finalizado Gamba Osaka
2 - 1
Urawa Reds 7
03 Oct 15  Finalizado Urawa Reds
1 - 1
Sagan Tosu 2
26 Sep 15  Finalizado Kashima Antlers
1 - 2
Urawa Reds 0
19 Sep 15  Finalizado Shimizu S-Pulse
1 - 4
Urawa Reds 0
11 Sep 15  Finalizado Urawa Reds
1 - 0
Kashiwa Reysol 76
29 Ago 15  Finalizado Yokohama F. Marinos
4 - 0
Urawa Reds 2
22 Ago 15  Finalizado Urawa Reds
3 - 1
Vegalta Sendai 0
16 Ago 15  Finalizado Urawa Reds
1 - 0
Shonan Bellmare 2
12 Ago 15  Finalizado Albirex Niigata
1 - 2
Urawa Reds 0
29 Jul 15  Finalizado Urawa Reds
1 - 1
Ventforet Kofu 4
25 Jul 15  Finalizado Nagoya Grampus
2 - 1
Urawa RedsTarjeta Roja 0
19 Jul 15  Finalizado Urawa Reds
1 - 2
Sanfrecce Hiroshima 1
15 Jul 15  Finalizado Montedio Yamagata
0 - 0
Urawa RedsTarjeta Roja 2
11 Jul 15  Finalizado Matsumoto Yamaga
1 - 2
Urawa Reds 4
01 Ene 16  Finalizado Urawa Reds
1 - 2
Gamba Osaka 50
29 Dic 15  Finalizado Urawa Reds
1 - 0
Kashiwa Reysol 4
26 Dic 15  Finalizado Tarjeta RojaVissel Kobe
0 - 3
Urawa Reds 2
05 May 15  Finalizado Brisbane Roar
1 - 2
Urawa Reds 26
21 Abr 15  Finalizado Urawa Reds
1 - 2
Suwon Bluewings 5
08 Abr 15  Finalizado Urawa Reds
1 - 1
Beijing GuoanTarjeta Roja 7
17 Mar 15  Finalizado Beijing Guoan
2 - 0
Urawa Reds 29
04 Mar 15  Finalizado Tarjeta RojaUrawa Reds
0 - 1
Brisbane Roar 9
25 Feb 15  Finalizado Suwon Bluewings
2 - 1
Urawa Reds 12

Plantilla del Urawa Reds Temporada 2014/2015

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
15 35 jp 186 80 - - -
1 37 jp 183 81 - - -
Defensa
41 si 188 75 - - -
4 42 jp 180 75 2 - 3
2 40 jp 181 75 - - -
17 41 jp 184 82 - - -
46 38 jp 178 75 1 - 2
5 36 jp 182 77 1 - 1
36 31 jp 175 71 - - -
24 29 jp 167 61 4 - -
3 36 jp 172 71 1 1 6
33 37 jp 181 72 - - -
Centrocampista
13 42 jp 177 67 - - -
16 34 jp 179 73 - - 1
14 44 jp 171 67 - - -
7 37 jp 169 64 6 - 1
22 42 jp 177 77 2 - -
8 36 jp 176 73 1 - -
19 35 jp 170 68 8 - 2
Delantero
11 39 jp 173 64 - - -
30 37 jp 175 67 7 - 1
20 38 jp 182 73 1 - 1
31 32 jp 171 62 - - -
21 40 si 183 81 5 - 1

Noticias del Urawa Reds

Ver últimas noticias

Viejos conocidos lucharán por alcanzar la final de la Champions Asiática

El Al Hilal saudí recibe al Persépolis iraní, mientras que el Urawa Red Diamonds japonés visita al Shanghái SIPG chino. Unos viejos conocidos que vuelven a verse las caras en las semifinales de la Champions Asiática

Un penalti muy protestado aparta a Chapecoense de la Suruga Bank

Urawa Red Diamonds deja la copa en casa después de un partido muy igualado definido en una acción desde los once metros en los últimos instantes del partido.

El gol 'a lo Messi' en Japón: ¡se fue de todos!

Sekine fue el autor de uno de los goles de la temporada en el campeonato japonés que le dio la victoria al Urawa Reds ante el Sanfrecce Hiroshima.

Chapecoense se enfrentará a Urawa Red Diamonds el 15 de agosto

El Chapecoense de Brasil enfrentará al japonés Urawa Red Diamonds, de la J. League de la Confederación Asiática de Fútbol, el 15 de agosto próximo por la Copa Suruga, anunció la Conmebol.

La hermandad entre aficionados japoneses y chinos gracias al fútbol

Los rencores nacionalistas y el dolor del pasado se olvidan en las canchas de fútbol. Así de claro lo tiene un grupo de aficionados del equipo chino Shanghái Shenhua que desde hace años mantiene una peculiar hermandad con los japoneses del Urawa Reds, ajena a la tensión entre ambos países.




  USO DE MEMORIA  
6,395,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0025
Controller Execution Time ( Home / Category )  0.8027
Total Execution Time  0.8052
  CADENA URL  
/Urawa-Reds/2015
  GET DATOS  
$_GET['/Urawa-Reds/2015']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0294  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 = 10155
0.0151  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 = 10156
0.0151  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 = 19893
0.0151  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 = 16191
0.0150  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 = 20167
0.0155  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 = 9166
0.0150  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 = 9129
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4522 AND type_rel = 2
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4522 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148  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 (193131,206487,252900,276224,300299) ORDER BY n.cover_points DESC, update_date DESC
0.0169  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 = '4522' 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 = 9166 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 16191 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  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 = 20167 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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 = 10155 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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 = 10156 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  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 = 9129 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  (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 calendars2015 as c ON c.league_id = l.id WHERE (c.datateam1 = 4522 or c.datateam2 = 4522) AND l.year = 2015 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0154  (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 calendars2015 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 = 4522 or c.datateam2 = 4522) AND l.year = 2015 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0152  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2015 as c ON c.league_id = l.id INNER JOIN events2015 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 = 4522 or c.datateam2 = 4522) AND l.year = 2015)
0.0154  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=4522 AND l.year in (2014,2015,2016) 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 (37309,34661,33462,20451,20266,9129,3569) 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.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 3569 AND teamId = 4522
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 37309 AND teamId = 4522
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 20266 AND teamId = 4522
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 33462 AND teamId = 4522
0.0156  SELECT count(id) as num_players from rel_players WHERE league_id = 34661 AND teamId = 4522
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 20451 AND teamId = 4522
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 9129 AND teamId = 4522
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2015` 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 = 10155 AND t.round = 17 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0156  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 events2015 e ON e.player_id = p.id AND e.league_id = 10155 WHERE rp.league_id = 10155 AND rp.teamId = 4522 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.0162  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 events2015 e ON e.player_id = p.id AND e.league_id = 10155 WHERE rp.league_id = 10155 AND rp.teamId = 4522 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 events2015 e ON e.player_id = p.id AND e.league_id = 10155 WHERE rp.league_id = 10155 AND rp.teamId = 4522 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 4522 AND rp.league_id = 10155 AND l.year= 2015 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0152  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=157105 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0145  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=157105
0.0151  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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=157105 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.0153  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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=157105 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=157105 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0169   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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=157105 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0176  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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=157105 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0156  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 = 10155 ORDER BY nameShow LIMIT 100