4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Newcastle - Aston Villa
Jornada 1
FINALIZADO
40
40
2985 Pts. Elo
52%
1º

2644 Pts. Elo
47%
18º

5-1
Sábado, 12 Agosto 2023, 18:30
Sandro Tonali 6'
1 - 0
1 - 1
 11' M. Diaby
Alexander Isak 16'
2 - 1
Alexander Isak 58'
3 - 1
Callum Wilson 77'
4 - 1
Harvey Barnes 91'
5 - 1

Newcastle

4-3-3
Alineación Inicial
Suplentes

Aston Villa

4-5-1
Alineación Inicial
Suplentes

Eventos del partido

Goles

Gol de
Sandro Tonali
minuto 6'
minuto 11'Gol de M. Diaby
Gol de
Alexander Isak
minuto 16'
Gol de
Alexander Isak
minuto 58'
Gol de
Callum Wilson
minuto 77'
Gol de
Harvey Barnes
minuto 91'

Tarjetas

minuto 6'T. Amarilla Douglas Luiz
minuto 32'T. Amarilla Lucas Digne
minuto 48'T. Amarilla Matty Cash
T. Amarilla
Anthony Gordon
minuto 53'
minuto 54'T. Amarilla Emiliano Martínez
T. Amarilla
Sven Botman
minuto 54'
T. Amarilla
B. Guimarães
minuto 67'
T. Amarilla
Sandro Tonali
minuto 92'

Cambios

minuto 31'Sale del partido T. Mings
minuto 31'Entra en el partido Pau Torres
minuto 46'Entra en el partido Y. Tielemans
minuto 46'Sale del partido Leon Bailey
minuto 64'Sale del partido J. Mcginn
minuto 64'Entra en el partido Diego Carlos
Entra en el partido
Harvey Barnes
minuto 68'
Entra en el partido
Callum Wilson
minuto 68'
Sale del partido
Anthony Gordon
minuto 68'
Sale del partido
Alexander Isak
minuto 68'
Entra en el partido
S. Longstaff
minuto 85'
Sale del partido
B. Guimarães
minuto 85'
Sale del partido
M. Almirón
minuto 86'
Entra en el partido
Jacob Murphy
minuto 86'
minuto 87'Entra en el partido P. Coutinho
minuto 87'Sale del partido M. Diaby
minuto 87'Sale del partido Matty Cash
minuto 87'Entra en el partido Jaden Philogene
Sale del partido
Sandro Tonali
minuto 92'
Entra en el partido
E. Anderson
minuto 92'

Otros

Asistencia
Anthony Gordon
minuto 6'
minuto 11'Asistencia Ollie Watkins
Asistencia
Sven Botman
minuto 16'
minuto 30'Lesionado T. Mings
Asistencia
Harvey Barnes
minuto 77'
Asistencia
Jacob Murphy
minuto 91'

Estadísticas del partido

Newcastle Newcastle Aston Villa Aston Villa
52%
Posesión del balón
 47%
5
Goles
 1
13
Tiros a puerta
 6
2
Tiros fuera
 7
17
Total tiros
 16
5
Paradas del portero
 7
6
Saques de esquina
 5
2
Fueras de juego
 0
0
Tarjetas Rojas
 0
4
Asistencias
 1
0
Lesiones
 1
3
Sustituciones
 3
12
Faltas
 17
0 Comentarios

No hay comentarios


Partido televisado en...
Canal Medio Idioma País
DAZN TV Castellano
Star+ TV Latino
Star+ TV Latino
Star+ TV Latino
Star+ TV Latino

  USO DE MEMORIA  
7,130,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.3383
Total Execution Time  0.3392
  CADENA URL  
/partido/Newcastle-United-Fc/Aston-Villa-Fc
  GET DATOS  
$_GET['/partido/Newcastle-United-Fc/Aston-Villa-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 71849 AND teamId = 6578401 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 71849 AND teamId = 6578402 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 = '12623' 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 = 12623 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 12623 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0042  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 71849 AND t.round = 35 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='12623' AND `active` = 1 AND year = 2024
0.0122  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` = '12623' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0098  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=6578402 WHERE relp.in_squad=1 and mp.`match_id` = '12623' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 12623 AND league_id = 71849 AND year = 2024