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

Estadísticas

ENTRA
Tim Matthijs14
Mamadou Diop9
P. Buysens6
Ivica Jarakovic5
Mamar Mamouni5
Tjörven De Brul4
Ali Lukunku4
Steven Ribus4
M. Geldof4
Benjamin Maréchal2
E. Kurtulus2
Hamad Ndikumana2
Sandy Martens2
L. Buysens2
Madjid Adjaoud1
W. Vrancken1
M. Oussalah1
Matthieu Verschuere1
D. De Beule1
E. Mehmedovic1
Björn De Coninck1
Y. Håkonsen1
David Van Hoyweghen1
Steve Cooreman1

  USO DE MEMORIA  
5,421,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0467
Total Execution Time  0.0479
  CADENA URL  
/estadisticas/Kaa-Gent/2005
  GET DATOS  
$_GET['/estadisticas/Kaa-Gent/2005']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (4)  
0.0062  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 = '1431' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 events2005 e ON e.player_id = p.id AND e.league_id = 357 WHERE rp.league_id = 357 AND rp.teamId = 1431 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036  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 events2005 e ON e.player_id = p.id AND e.league_id = 357 WHERE rp.league_id = 357 AND rp.teamId = 1431 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 events2005 e ON e.player_id = p.id AND e.league_id = 357 WHERE rp.league_id = 357 AND rp.teamId = 1431 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30