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

Stoke City

Entrenador: Steven Schumacher

Información
  • Nombre del equipo Stoke City
  • Nombre completo Stoke City Football Club
  • Nombre corto STO
  • País Inglaterra
  • Ciudad Stoke-on-Trent
  • Entrenador Steven Schumacher
  • URL del equipo en RF //m.resultados-futbol.com/Stoke-City
Otros Datos
  • Año de Fundación 1868
  • Patrocinador bet365
  • Marca de Ropa Macron
  • Socios 15600
Internet

Información sobre el estadio

  • Nombre del estadio bet365 Stadium
  • Capacidad 28383
  • Dirección Stanley Matthews Way
  • Teléfono 087 16 63 20 08
  • Fax 087 16 63 20 08
  • Año de construcción 1997
  • Tamaño 105x68
bet365 Stadium

Histórico de participación

FA Cup
Premier League
Championship
EFL Cup
Partidos Amistosos
13 veces
League One
4 veces
Europa League Grupo 0
4 veces
Fase Previa Europa League Grupo 4
2 veces
(2012, 2012)
Trofeo Premier League Asia
1 vez
(2015)
Trofeo Teresa Herrera
1 vez
(1976)

Partidos del Stoke City

Ir al LIVESCORE
15 Ene 19  Finalizado Stoke City
2 - 3
Shrewsbury Town 57
05 Ene 19  Finalizado Shrewsbury Town
1 - 1
Stoke City 40
26 Sep 18  Finalizado Tarjeta RojaNottingham Forest
3 - 2
Stoke City 13
28 Ago 18  Finalizado Stoke City
2 - 0
Huddersfield Town 14
05 May 19  Finalizado Stoke City
2 - 2
Sheffield United 6
27 Abr 19  Finalizado Millwall
0 - 0
Stoke City 31
22 Abr 19  Finalizado Stoke City
2 - 2
Norwich City 67
19 Abr 19  Finalizado Middlesbrough
1 - 0
Stoke City 19
13 Abr 19  Finalizado Stoke City
2 - 2
Rotherham United 8
09 Abr 19  Finalizado Swansea City
3 - 1
Stoke CityTarjeta RojaTarjeta Roja 30
06 Abr 19  Finalizado Blackburn Rovers
0 - 1
Stoke City 3
30 Mar 19  Finalizado Stoke City
0 - 0
Sheffield Wednesday 12
16 Mar 19  Finalizado Stoke City
0 - 0
Reading 15
13 Mar 19  Finalizado Derby County
0 - 0
Stoke City 55
09 Mar 19  Finalizado Tarjeta RojaQueens Park Rangers
0 - 0
Stoke CityTarjeta Roja 17
02 Mar 19  Finalizado Stoke City
2 - 0
Nottingham Forest 2
23 Feb 19  Finalizado Stoke City
1 - 1
Aston Villa 2
16 Feb 19  Finalizado Ipswich Town
1 - 1
Stoke City 15
13 Feb 19  Finalizado Wigan Athletic
0 - 0
Stoke City 14
09 Feb 19  Finalizado Stoke City
0 - 1
West Bromwich Albion 4
02 Feb 19  Finalizado Hull City
2 - 0
Stoke City 12
26 Ene 19  Finalizado Stoke City
0 - 2
Preston North End 28
19 Ene 19  Finalizado Stoke City
2 - 1
Leeds UnitedTarjeta Roja 34
12 Ene 19  Finalizado Brentford
3 - 1
Stoke City 2
01 Ene 19  Finalizado Stoke City
0 - 2
Bristol City 17
29 Dic 18  Finalizado Bolton Wanderers
0 - 0
Stoke City 10
26 Dic 18  Finalizado Birmingham City
2 - 0
Stoke City 7
22 Dic 18  Finalizado Stoke City
1 - 0
Millwall 3
15 Dic 18  Finalizado Aston Villa
2 - 2
Stoke City 20
08 Dic 18  Finalizado Stoke City
2 - 0
Ipswich Town 4
01 Dic 18  Finalizado Reading
2 - 2
Stoke City 8
28 Nov 18  Finalizado Tarjeta RojaStoke City
2 - 1
Derby County 13
24 Nov 18  Finalizado Stoke City
2 - 2
Queens Park Rangers 4
10 Nov 18  Finalizado Nottingham Forest
0 - 0
Stoke City 14
03 Nov 18  Finalizado Stoke City
0 - 0
Middlesbrough 7
27 Oct 18  Finalizado Bristol City
0 - 1
Stoke City 10
23 Oct 18  Finalizado Sheffield United
1 - 1
Stoke City 25
20 Oct 18  Finalizado Stoke City
0 - 1
Birmingham City 6
06 Oct 18  Finalizado Norwich City
0 - 1
Stoke City 7
02 Oct 18  Finalizado Stoke City
2 - 0
Bolton Wanderers 7
29 Sep 18  Finalizado Rotherham United
2 - 2
Stoke City 8
22 Sep 18  Finalizado Stoke City
2 - 3
Blackburn Rovers 11
18 Sep 18  Finalizado Stoke City
1 - 0
Swansea City 24
15 Sep 18  Finalizado Sheffield Wednesday
2 - 2
Stoke City 2
01 Sep 18  Finalizado West Bromwich Albion
2 - 1
Stoke City 25
25 Ago 18  Finalizado Stoke City
2 - 0
Hull CityTarjeta Roja 15
22 Ago 18  Finalizado Tarjeta RojaStoke City
0 - 3
Wigan Athletic 138
18 Ago 18  Finalizado Preston North End
2 - 2
Stoke City 8
11 Ago 18  Finalizado Stoke City
1 - 1
Brentford 14
05 Ago 18  Finalizado Leeds United
3 - 1
Stoke City 50
28 Jul 18  Finalizado FC St Pauli
2 - 0
Stoke City 10
25 Jul 18  Finalizado Stoke City
0 - 0
Wolves 18
21 Jul 18  Finalizado SV Meppen
1 - 0
Stoke City 2
18 Jul 18  Finalizado VfL Bochum
2 - 0
Stoke City 23
14 Jul 18  Finalizado Walsall
0 - 3
Stoke City 0
13 Jul 18  Aplazado Union Berlin
-
Stoke City 0

Plantilla del Stoke City Temporada 2018/2019

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
32 39 au 188 90 - - -
1 31 gb 196 95 - - -
29 31 dk 199 87 - - -
Defensa
5 39 wa 183 75 1 1 7
15 32 nl 185 76 1 1 5
14 33 gb 191 90 - - 3
12 24 gb 180 73 - - -
2 32 at 181 73 - - 1
37 22 ie 193 81 - - -
17 36 gb 191 76 1 - 6
30 25 gb 176 70 1 1 5
Centrocampista
16 38 ss 185 82 - - 3
24 40 ss 183 84 1 - -
44 26 gb 171 73 - - -
4 34 wa 170 62 6 - 9
33 24 dk 185 77 - - -
8 28 ng 174 70 2 1 6
38 30 gb 173 69 - - 5
22 33 gb 178 71 3 1 2
Delantero
9 31 cd 179 70 8 - -
27 33 es 170 65 1 - -
18 36 sn 185 76 - - -
19 30 bi 180 77 3 - -
10 34 wa 186 90 3 - -
31 24 be 174 65 - - -
7 32 gb 178 66 6 - 2

Noticias del Stoke City

Ver últimas noticias

El United se fija en Begovic para sustituir a De Gea

Los 'red devils' podrían encontrar dificultades para el traspaso ante el interés que también tiene el Chelsea por el guardameta bosnio.

Sergio Molina, al Stoke City

El canterano del Real Madrid está en Inglaterra pasando las pruebas médicas.

Crouch da la bienvenida a Shaqiri en Twitter

Xherdan Shaqiri podría acabar su andadura en el Inter de Milán y fichar por el Stoke City en las próximas horas, según apunta la BBC. Un enigmático tweet de Crouch confirmaría los rumores que suenan en Inglaterra.

El Stoke City se interesa por Sergi Roberto

El Inter de Milan también sigue muy de cerca al caterano culé.

Joselu dejará la Bundesliga para ir al Stoke City, según los medios alemanes

El delantero español José Luis Sanmartín, "Joselu", está a punto de dejar las filas del Hannover para fichar por el Stoke City, de la liga inglesa, según informaciones coincidentes de los rotativos alemanes "Bild" y "Kicker".




  USO DE MEMORIA  
6,435,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1439
Total Execution Time  0.1459
  CADENA URL  
/Stoke-City/2019
  GET DATOS  
$_GET['/Stoke-City/2019']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0036  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 = '2429' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  (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 calendars2019 as c ON c.league_id = l.id WHERE (c.datateam1 = 2429 or c.datateam2 = 2429) AND l.year = 2019 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0031  (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 calendars2019 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 = 2429 or c.datateam2 = 2429) AND l.year = 2019 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0024  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2019 as c ON c.league_id = l.id INNER JOIN events2019 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 = 2429 or c.datateam2 = 2429) AND l.year = 2019)
0.0034  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=2429 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (50579,50152,49880,49506,38633) 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 = 38633 AND teamId = 2429
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 49880 AND teamId = 2429
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 50579 AND teamId = 2429
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 50152 AND teamId = 2429
0.0099  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 2429
0.0038  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 events2019 e ON e.player_id = p.id AND e.league_id = 43565 WHERE rp.league_id = 43565 AND rp.teamId = 2429 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.0032  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 events2019 e ON e.player_id = p.id AND e.league_id = 43565 WHERE rp.league_id = 43565 AND rp.teamId = 2429 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 events2019 e ON e.player_id = p.id AND e.league_id = 43565 WHERE rp.league_id = 43565 AND rp.teamId = 2429 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 2429 AND rp.league_id = 43565 AND l.year= 2019 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0023  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=6185767 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0018  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6185767
0.0026  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 events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6185767 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.0026  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 events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6185767 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0026  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 events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6185767 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 events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6185767 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 events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6185767 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC