4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
West Ham - Newcastle
Jornada 8
FINALIZADO
30
30
3201 Pts. Elo
35%
7º

3362 Pts. Elo
64%
8º

2-2
Domingo, 08 Octubre 2023, 15:00
Tomáš Souček 8'
1 - 0
1 - 1
 57' Alexander Isak
1 - 2
 62' Alexander Isak
M. Kudus 89'
2 - 2

West Ham

4-5-1
Alineación Inicial
Suplentes

Newcastle

4-3-3
Alineación Inicial
Suplentes

Eventos del partido

Goles

Gol de
Tomáš Souček
minuto 8'
minuto 57'Gol de Alexander Isak
minuto 62'Gol de Alexander Isak
Gol de
M. Kudus
minuto 89'

Tarjetas

T. Amarilla
Emerson
minuto 16'
minuto 16'T. Amarilla B. Guimarães
T. Amarilla
M. Antonio
minuto 35'
minuto 67'T. Amarilla M. Almirón
T. Amarilla
L. Paquetá
minuto 70'
minuto 79'T. Amarilla S. Longstaff

Ocasiones

minuto 72'Tiro al palo Alexander Isak

Cambios

Entra en el partido
S. Benrahma
minuto 75'
Sale del partido
M. Antonio
minuto 75'
Sale del partido
Tomáš Souček
minuto 76'
Entra en el partido
M. Kudus
minuto 76'
minuto 82'Sale del partido M. Almirón
minuto 82'Entra en el partido Jacob Murphy
minuto 86'Entra en el partido Callum Wilson
minuto 86'Sale del partido Alexander Isak
minuto 93'Entra en el partido Matt Targett
minuto 93'Sale del partido E. Anderson

Otros

Asistencia
Emerson
minuto 8'
minuto 62'Asistencia K. Trippier
Asistencia
V. Coufal
minuto 89'

Estadísticas del partido

West Ham West Ham Newcastle Newcastle
35%
Posesión del balón
 64%
2
Goles
 2
3
Tiros a puerta
 3
2
Tiros fuera
 6
5
Total tiros
 10
1
Paradas del portero
 1
4
Saques de esquina
 2
2
Fueras de juego
 1
0
Tarjetas Rojas
 0
2
Asistencias
 1
0
Tiros al palo
 1
2
Sustituciones
 3
11
Faltas
 18
1 Comentarios
  • quorthon
    Hace 6 meses quorthon dice: 3-0

Partido televisado en...
Canal Medio Idioma País
DAZN TV Castellano
DAZN 2 TV Castellano
DAZN 2 Bar TV Castellano

  USO DE MEMORIA  
6,876,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Match / Index )  0.2725
Total Execution Time  0.2739
  CADENA URL  
/partido/West-Ham-United/Newcastle-United-Fc/2024
  GET DATOS  
$_GET['/partido/West-Ham-United/Newcastle-United-Fc/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0004   SELECT c.comment_id, COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`league_id` = '71849' AND c.`match_id` = '12696' AND c.comment_id IN (56669568) GROUP BY c.comment_id
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 71849 AND teamId = 6578400 and type = 33
0.0024  SELECT data1 FROM stats2024 t WHERE league_id = 71849 AND teamId = 6578401 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 = '12696' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 12696 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 12696 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0019   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '56669568' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='12696' AND `active` = 1 AND year = 2024
0.0137  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='71849' AND relp.team_id=6578400 WHERE relp.in_squad=1 and mp.`match_id` = '12696' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0134  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='71849' AND relp.team_id=6578401 WHERE relp.in_squad=1 and mp.`match_id` = '12696' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 12696 AND league_id = 71849 AND year = 2024