4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Aston Villa

Aston Villa

Entrenador: Unai Emery

Temporada 2023/2024

Estadísticas

ASISTENCIAS
Ollie Watkins12
Leon Bailey9
M. Diaby7
Y. Tielemans6
Douglas Luiz5
J. Mcginn4
Lucas Digne3
Matty Cash2
C. Lenglet1
Cameron Archer1
Jacob Ramsey1
B. Kamara1
Morgan Rogers1
ENTRA
Jhon Durán18
N. Zaniolo15
Y. Tielemans15
Leon Bailey13
M. Diaby13
Cameron Archer9
Álex Moreno9
Jacob Ramsey8
L. Dendoncker7
Diego Carlos7
Tim Iroegbunam7
Lucas Digne6
Matty Cash5
Morgan Rogers3
Pau Torres2
B. Traoré2
C. Chambers2
P. Coutinho2
Kaine Kesler2
Robin Olsen1
O. Kellyman1
Jaden Philogene1
SALE
Leon Bailey20
M. Diaby20
Y. Tielemans10
B. Kamara9
Cameron Archer9
N. Zaniolo9
J. Mcginn9
Ollie Watkins9
Douglas Luiz8
Lucas Digne8
Matty Cash7
Álex Moreno6
Morgan Rogers4
E. Konsa4
Jacob Ramsey3
C. Lenglet3
Diego Carlos2
Jhon Durán2
Pau Torres2
P. Coutinho1
T. Mings1
Emiliano Martínez1
Tim Iroegbunam1
L. Dendoncker1

  USO DE MEMORIA  
6,284,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0546
Total Execution Time  0.0564
  CADENA URL  
/estadisticas/Aston-Villa-Fc
  GET DATOS  
$_GET['/estadisticas/Aston-Villa-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (4)  
0.0036  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 = '297' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0050  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 71849 WHERE rp.league_id = 71849 AND rp.teamId = 297 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0051  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 71849 WHERE rp.league_id = 71849 AND rp.teamId = 297 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0043  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 71849 WHERE rp.league_id = 71849 AND rp.teamId = 297 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30