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

Jong AZ

Entrenador: Lee-Roy Echteld

Temporada 2023/2024

Estadísticas

ASISTENCIAS
Ricuenio Kewal7
Mexx Meerdink6
Dave Kwakman4
Kees Smit4
Finn Stam3
Zangelo Daal3
Enoch Mastoras3
Jayden Addai3
Ernest Poku2
Wouter Goes2
K. Goudmijn1
Nick Koster1
Tom Kerssens1
Jurre Van Aken1
Gonçalo Esteves1
Lewis Schouten1
ENTRA
Tom Kerssens16
Nick Koster15
Damienus Reverson14
Sem Dekkers11
Enoch Mastoras11
Jurre Van Aken11
Loek Postma10
Jorn Berkhout9
M. Engel9
Ricuenio Kewal7
Jayen Gerold6
Job Kalisvaart6
Zangelo Daal5
Kees Smit4
Jeremiah Esajas3
Jayden Addai2
Julian Oerip1
Gonçalo Esteves1
Van Den Ban1
Iman Griffith1
Kasper Boogaard1
D. Van Der Klaauw1
SALE
Ricuenio Kewal16
Kees Smit13
Jayden Addai11
Gonçalo Esteves11
Lewis Schouten9
Ernest Poku8
Jurre Van Aken7
Zangelo Daal7
Mexx Meerdink6
Maxim Dekker6
Jorn Berkhout5
Wouter Goes5
Nick Koster5
Dave Kwakman5
Loek Postma4
Sem Dekkers4
Damienus Reverson3
Denso Kasius3
M. Engel2
Nick Twisk2
L. Zeefuik2
Jeremiah Esajas2
Enoch Mastoras2
Iman Griffith1
K. Goudmijn1
Job Kalisvaart1
Finn Stam1
Jayen Gerold1
M. Van Brederode1
Tom Kerssens1

  USO DE MEMORIA  
4,956,792 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0497
Total Execution Time  0.0509
  CADENA URL  
/estadisticas/az-alkmaar-sub23
  GET DATOS  
$_GET['/estadisticas/az-alkmaar-sub23']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0028  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'az-alkmaar-sub23' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=61516 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=61516 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=61516 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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 = '61516' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0032  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 = 61516 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 = 61516 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 61516 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30