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 3
2 veces
(2012, 2012)
Trofeo Premier League Asia
1 vez
(2015)
Trofeo Teresa Herrera
1 vez
(1976)

Partidos del Stoke City

Ir al LIVESCORE
21 May 17  Finalizado Southampton
0 - 1
Stoke City 40
13 May 17  Finalizado Stoke City
1 - 4
Arsenal 99
06 May 17  Finalizado AFC Bournemouth
2 - 2
Stoke City 47
29 Abr 17  Finalizado Stoke City
0 - 0
West Ham 28
22 Abr 17  Finalizado Swansea City
2 - 0
Stoke City 30
15 Abr 17  Finalizado Stoke City
3 - 1
Hull City 28
08 Abr 17  Finalizado Stoke City
1 - 2
Liverpool 174
04 Abr 17  Finalizado Burnley
1 - 0
Stoke City 38
01 Abr 17  Finalizado Leicester
2 - 0
Stoke City 109
18 Mar 17  Finalizado Tarjeta RojaStoke City
1 - 2
Chelsea 240
08 Mar 17  Finalizado Manchester City
0 - 0
Stoke City 327
04 Mar 17  Finalizado Stoke City
2 - 0
Middlesbrough 15
26 Feb 17  Finalizado Tottenham Hotspur
4 - 0
Stoke City 98
11 Feb 17  Finalizado Stoke City
1 - 0
Crystal Palace 29
04 Feb 17  Finalizado West Bromwich Albion
1 - 0
Stoke City 23
01 Feb 17  Finalizado Stoke City
1 - 1
Everton 121
21 Ene 17  Finalizado Stoke City
1 - 1
Manchester United 276
14 Ene 17  Finalizado Sunderland
1 - 3
Stoke City 54
03 Ene 17  Finalizado Stoke City
2 - 0
Watford 72
31 Dic 16  Finalizado Chelsea
4 - 2
Stoke City 230
27 Dic 16  Finalizado Liverpool
4 - 1
Stoke City 563
17 Dic 16  Finalizado Stoke City
2 - 2
LeicesterTarjeta Roja 274
14 Dic 16  Finalizado Tarjeta RojaStoke City
0 - 0
Southampton 141
10 Dic 16  Finalizado Arsenal
3 - 1
Stoke City 164
03 Dic 16  Finalizado Stoke City
2 - 0
Burnley 30
27 Nov 16  Finalizado Tarjeta RojaWatford
0 - 1
Stoke City 88
19 Nov 16  Finalizado Stoke City
0 - 1
AFC Bournemouth 52
05 Nov 16  Finalizado West Ham
1 - 1
Stoke City 116
31 Oct 16  Finalizado Stoke City
3 - 1
Swansea City 100
22 Oct 16  Finalizado Hull City
0 - 2
Stoke City 21
15 Oct 16  Finalizado Stoke City
2 - 0
Sunderland 36
02 Oct 16  Finalizado Manchester United
1 - 1
Stoke City 507
24 Sep 16  Finalizado Stoke City
1 - 1
West Bromwich Albion 50
18 Sep 16  Finalizado Crystal Palace
4 - 1
Stoke City 47
10 Sep 16  Finalizado Stoke City
0 - 4
Tottenham Hotspur 68
27 Ago 16  Finalizado Everton
1 - 0
Stoke City 59
20 Ago 16  Finalizado Stoke City
1 - 4
Manchester City 412
13 Ago 16  Finalizado Middlesbrough
1 - 1
Stoke City 87
07 Ene 17  Finalizado Stoke City
0 - 2
Wolves 64
21 Sep 16  Finalizado Stoke City
1 - 2
Hull City 8
23 Ago 16  Finalizado Stevenage
0 - 4
Stoke City 6
06 Ago 16  Finalizado Hamburger SV
1 - 0
Stoke City 2
28 Jul 16  Finalizado Orlando City
1 - 2
Stoke City 10
23 Jul 16  Finalizado Preston North End
1 - 1
Stoke City 3
16 Jul 16  Finalizado Burton Albion
3 - 0
Stoke City 2

Plantilla del Stoke City Temporada 2016/2017

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
1 31 gb 196 95 - - -
33 41 gb 193 83 - - 1
24 48 ie 185 84 - - 1
Defensa
15 32 nl 185 76 1 - 4
31 sk 193 78 - - -
3 35 nl 183 82 - - 5
20 38 us 191 92 - - 1
8 39 en 182 70 - - 1
25 au 198 79 - - -
5 32 es 180 72 1 - 2
2 38 ss 180 74 - 1 6
17 36 gb 191 76 1 - 6
72 25 gb 176 70 - - -
Centrocampista
16 38 ss 185 82 1 - 7
21 31 cd 186 77 - - 1
6 40 ie 180 79 - - 5
14 38 nl 180 78 - - -
4 34 wa 170 62 6 - 9
32 27 eg 189 75 - - 2
37 ie 173 67 - - -
22 32 ch 169 72 4 - 2
Delantero
45 26 be 185 64 - - -
19 40 ie 183 78 4 - 1
10 35 at 190 83 6 1 9
18 36 sn 185 76 1 - 3
25 43 gb 201 75 7 - 3
9 30 bi 180 77 - - 1
55 24 be 174 65 - - -
12 35 ci 182 88 2 - 1

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,265,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0035
Controller Execution Time ( Home / Category )  0.4092
Total Execution Time  0.4127
  CADENA URL  
/stoke-city/2017
  GET DATOS  
$_GET['/stoke-city/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0125  SELECT type FROM routes WHERE alias = 'stoke-city'
0.0158  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 = 'stoke-city' AND l.year = 2017 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.0125  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=2429 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=2429 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=2429 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=2429 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=2429 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2429 AND type_rel = 2
0.0141  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2429 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  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 (401,910,1269,1483,1778) ORDER BY n.cover_points DESC, update_date DESC
0.0380  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.0135  (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 calendars2017 as c ON c.league_id = l.id WHERE (c.datateam1 = 2429 or c.datateam2 = 2429) AND l.year = 2017 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0148  (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 calendars2017 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 = 2017 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0136  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2017 as c ON c.league_id = l.id INNER JOIN events2017 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 = 2017)
0.0128  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 = '2429' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2429' and rp.type = 4
0.0128  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 = '2429' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0125  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '2429' and rp.type = 4