4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Stoke City - Ipswich Town
Jornada 26
FINALIZADO
31
20
1345 Pts. Elo
36%
19º

1934 Pts. Elo
63%
2º

0-0
Lunes, 01 Enero 2024, 16:00

Eventos del partido

Tarjetas

J. ThompsonT. Amarilla
J. Thompson
minuto 7'
minuto 33'S. MorsyT. Amarilla S. Morsy
Lewis BakerT. Amarilla
Lewis Baker
minuto 51'
J. Thompson2a Amarilla y Roja
J. Thompson
minuto 67'
minuto 89'Harry ClarkeT. Amarilla Harry Clarke

Cambios

minuto 63'O. HutchinsonEntra en el partido O. Hutchinson
minuto 63'K. JacksonSale del partido K. Jackson
Ben WilmotEntra en el partido
Ben Wilmot
minuto 74'
André VidigalSale del partido
André Vidigal
minuto 74'
minuto 76'M. HarnessEntra en el partido M. Harness
minuto 76'C. ChaplinSale del partido C. Chaplin
minuto 77'Massimo LuongoSale del partido Massimo Luongo
minuto 77'Jack TaylorEntra en el partido Jack Taylor
Ryan MmaeeSale del partido
Ryan Mmaee
minuto 80'
D. GayleEntra en el partido
D. Gayle
minuto 80'
D. JohnsonEntra en el partido
D. Johnson
minuto 80'
Joon-Ho BaeSale del partido
Joon-Ho Bae
minuto 80'
minuto 87'F. LadapoEntra en el partido F. Ladapo
minuto 87'Axel TuanzebeSale del partido Axel Tuanzebe

Otros

minuto 62'K. JacksonLesionado K. Jackson

Alineaciones

Stoke City

Stoke City

4-3-3
Alineación Inicial
Suplentes
Ipswich Town

Ipswich Town

4-5-1
Alineación Inicial
Suplentes

Estadísticas del partido

Stoke City Stoke City Ipswich Town Ipswich Town
36%
Posesión del balón
 63%
0
Goles
 0
4
Tiros a puerta
 2
2
Tiros fuera
 8
8
Total tiros
 13
2
Paradas del portero
 4
8
Saques de esquina
 5
2
Fueras de juego
 2
0
Tarjetas Rojas
 0
0
Lesiones
 1
3
Sustituciones
 3
7
Faltas
 14


  USO DE MEMORIA  
6,848,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.6845
Total Execution Time  0.6855
  CADENA URL  
/partido/Stoke-City/Ipswich-Town-Fc/2006?section=legal
  GET DATOS  
$_GET['/partido/Stoke-City/Ipswich-Town-Fc/2006']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0108  SELECT data1 FROM stats2024 t WHERE league_id = 72033 AND teamId = 6582245 and type = 33
0.0109  SELECT data1 FROM stats2024 t WHERE league_id = 72033 AND teamId = 6582233 and type = 33
0.0113  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '27920' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0108  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 27920 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0107  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 27920 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0114  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72033 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='27920' AND `active` = 1 AND year = 2024
0.0467  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='72033' AND relp.team_id=6582245 WHERE relp.in_squad=1 and mp.`match_id` = '27920' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0233  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='72033' AND relp.team_id=6582233 WHERE relp.in_squad=1 and mp.`match_id` = '27920' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=27920 AND extraId = 72033 AND type_rel = 4
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25 AND type_rel = 3
0.0163  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 25 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0108  SELECT /*53 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 (1317792,1317193,1317198,1317017,1316655) ORDER BY n.cover_points DESC, update_date DESC
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 27920 AND league_id = 72033 AND year = 2024