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

Emmen

Entrenador: Alfons Arts

Temporada 2023/2024

Estadísticas

ASISTENCIAS
D. Ubbink7
Ben Scholte4
J. Konings4
P. Parzyszek4
R. Mendes3
Patrick Brouwer3
B. Van Hoeven2
Jeff Hardeveld2
M. Te Wierik2
J. Vlak2
Maarten Pouwels1
Julius Dirksen1
M. Kieftenbeld1
A. El Messaoudi1
L. Bernadou1
J. Smeets1
Chardi Landu1
ENTRA
Patrick Brouwer21
R. Mendes21
Ben Scholte15
J. Konings11
Dennis Vos11
J. Smeets9
M. Kieftenbeld9
Maarten Pouwels8
P. Parzyszek7
Lorenzo Burnet6
L. Bernadou6
A. El Messaoudi5
B. Van Hoeven5
Jeff Hardeveld4
Julius Dirksen4
M. Heylen4
D. Ubbink4
Chardi Landu3
Robin Schouten3
M. Te Wierik2
F. Hammouti2
V. Besuijen1
George Younan1
Dj Buffonge1
Jasper Huijzer1
SALE
D. Ubbink18
J. Konings13
L. Bernadou12
P. Parzyszek11
A. El Messaoudi10
J. Smeets9
Ben Scholte9
V. Besuijen9
Robin Schouten8
R. Mendes7
J. Vlak7
Jeff Hardeveld6
M. Kieftenbeld6
Chardi Landu5
Lorenzo Burnet5
Julius Dirksen4
Dennis Vos4
M. Heylen3
Patrick Brouwer3
B. Van Hoeven2
Maarten Pouwels1
M. Te Wierik1

  USO DE MEMORIA  
5,316,000 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0510
Total Execution Time  0.0522
  CADENA URL  
/estadisticas/Emmen
  GET DATOS  
$_GET['/estadisticas/Emmen']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (5)  
0.0041  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 = '2925' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72062 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0057  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 = 72062 WHERE rp.league_id = 72062 AND rp.teamId = 2925 AND (e.action = 22) 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 = 72062 WHERE rp.league_id = 72062 AND rp.teamId = 2925 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038  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 = 72062 WHERE rp.league_id = 72062 AND rp.teamId = 2925 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30