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

Sunderland

Entrenador: Mike Dodds

Temporada 2023/2024

Estadísticas

ASISTENCIAS
A. Pritchard6
D. Neil5
J. Clarke4
Abdoullah Ba4
P. Roberts2
A. Aouchiche2
Pierre Ekwah2
C. Styles1
Bradley Dack1
Trai Hume1
N. Rusyn1
Jenson Seelt1
Jewison Bennette1
Dennis Cirkin1
Niall Huggins1
Mason Burstow1
Jobe Bellingham1
ENTRA
A. Pritchard19
A. Aouchiche18
Luís Semedo18
Abdoullah Ba17
Chris Rigg12
N. Rusyn12
Lynden Gooch12
P. Roberts11
Danny Batth10
Bradley Dack10
Mason Burstow8
Eliezer Mayenda7
R. Mundle6
Jenson Seelt6
T. Pembélé5
Dennis Cirkin3
A. Alese3
Pierre Ekwah3
C. Styles2
C. Evans2
Niall Huggins2
Jobe Bellingham2
J. Clarke1
N. Triantis1
Jewison Bennette1
Trai Hume1
Leo Hjelde1
SALE
Jobe Bellingham20
Abdoullah Ba17
Pierre Ekwah15
P. Roberts13
Mason Burstow12
A. Pritchard10
N. Rusyn9
Niall Huggins9
Chris Rigg8
A. Aouchiche8
J. Clarke7
Lynden Gooch7
Bradley Dack6
R. Mundle5
Leo Hjelde4
C. Styles4
D. Neil4
Luís Semedo4
Jenson Seelt4
D. Ballard3
T. Pembélé3
A. Alese3
Trai Hume2
Danny Batth1
Eliezer Mayenda1
Dennis Cirkin1

  USO DE MEMORIA  
5,714,752 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0621
Total Execution Time  0.0641
  CADENA URL  
/estadisticas/Sunderland-Afc
  GET DATOS  
$_GET['/estadisticas/Sunderland-Afc']  
  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 = '2438' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0047  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 = 72033 WHERE rp.league_id = 72033 AND rp.teamId = 2438 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0042  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 = 72033 WHERE rp.league_id = 72033 AND rp.teamId = 2438 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0039  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 = 72033 WHERE rp.league_id = 72033 AND rp.teamId = 2438 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30