¿Eres mayor de edad?

SI NO

Confirma si tienes 18 años

Faldón apuestas
4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Huddersfield Town - Stoke City
Jornada 7
FINALIZADO
20
20
1081 Pts. Elo
34%
16º

1264 Pts. Elo
65%
19º

2-2
Miércoles, 20 Septiembre 2023, 20:45
Matthew Pearson 31'
1 - 0
1 - 1
 33' D. Johnson
1 - 2
 62' Ben Wilmot
J. Rudoni 68'
2 - 2

Eventos del partido

Goles

Matthew PearsonGol de
Matthew Pearson
minuto 31'
minuto 33'D. JohnsonGol de D. Johnson
minuto 62'Ben WilmotGol de Ben Wilmot
J. RudoniGol de
J. Rudoni
minuto 68'

Tarjetas

minuto 72'Wouter BurgerT. Amarilla Wouter Burger
J. RudoniT. Amarilla
J. Rudoni
minuto 77'
minuto 77'B. PearsonT. Amarilla B. Pearson
R. Edmonds-GreenT. Amarilla
R. Edmonds-Green
minuto 81'

Cambios

R. Edmonds-GreenEntra en el partido
R. Edmonds-Green
minuto 39'
D. KasumuSale del partido
D. Kasumu
minuto 39'
Sorba ThomasSale del partido
Sorba Thomas
minuto 46'
K. HarrattSale del partido
K. Harratt
minuto 46'
Josh RuffelsSale del partido
Josh Ruffels
minuto 46'
J. HeadleyEntra en el partido
J. Headley
minuto 46'
D. BurgzorgEntra en el partido
D. Burgzorg
minuto 46'
B. JacksonEntra en el partido
B. Jackson
minuto 46'
minuto 73'Sead HaksabanovicSale del partido Sead Haksabanovic
minuto 73'Joon-Ho BaeEntra en el partido Joon-Ho Bae
minuto 78'Tyrese CampbellSale del partido Tyrese Campbell
minuto 78'D. GayleEntra en el partido D. Gayle
minuto 86'Wouter BurgerSale del partido Wouter Burger
minuto 86'Wesley MoraesEntra en el partido Wesley Moraes
Josh KoromaSale del partido
Josh Koroma
minuto 89'
B. DiarraEntra en el partido
B. Diarra
minuto 89'

Otros

Sorba ThomasAsistencia
Sorba Thomas
minuto 31'
minuto 33'Wouter BurgerAsistencia Wouter Burger
D. KasumuLesionado
D. Kasumu
minuto 38'
minuto 62'Sead HaksabanovicAsistencia Sead Haksabanovic
B. JacksonAsistencia
B. Jackson
minuto 68'

Alineaciones

Huddersfield Town

Huddersfield Town

4-3-3
Alineación Inicial
Suplentes
Stoke City

Stoke City

Alineación Inicial
Suplentes

Estadísticas del partido

Huddersfield Town Huddersfield Stoke City Stoke City
34%
Posesión del balón
 65%
2
Goles
 2
6
Tiros a puerta
 3
4
Tiros fuera
 8
10
Total tiros
 18
1
Paradas del portero
 4
5
Saques de esquina
 8
2
Fueras de juego
 4
0
Tarjetas Rojas
 0
2
Asistencias
 2
1
Lesiones
 0
3
Sustituciones
 3
10
Faltas
 6


  USO DE MEMORIA  
7,563,256 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.1209
Total Execution Time  0.1219
  CADENA URL  
/partido/Huddersfield-Town-Fc/Stoke-City/1950?section=legal
  GET DATOS  
$_GET['/partido/Huddersfield-Town-Fc/Stoke-City/1950']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0036   SELECT c.*, c.stadium as real_stadium, 2025 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2025 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Huddersfield-Town-Fc' AND dt2.basealias = 'Stoke-City'
0.0025   SELECT c.*, c.stadium as real_stadium, 2026 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2026 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Huddersfield-Town-Fc' AND dt2.basealias = 'Stoke-City'
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72033 AND teamId = 6582231 and type = 33
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72033 AND teamId = 6582245 and type = 33
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '27690' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 27690 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 27690 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='27690' AND `active` = 1 AND year = 2024
0.0104  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=6582231 WHERE relp.in_squad=1 and mp.`match_id` = '27690' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0113  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` = '27690' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=27690 AND extraId = 72033 AND type_rel = 4
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 27690 AND league_id = 72033 AND year = 2024