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

Estadísticas

ASISTENCIAS
A. Trajkovic6
Rodrigo Vilela4
K. Grgic3
Luís Pedro3
M. Kilibarda2
K. De Vasconcelos1
O. Silas1
Neto1
W. Santos1
M. Březina1
ENTRA
M. Březina15
D. Ferreira15
Luís Pedro11
F. Palfi11
P. Bartunek10
L. Lukco10
K. Grgic9
M. Kilibarda8
Miguel Velosa7
Fábio Pereira5
A. Trajkovic5
Y. Rachidi4
Christian Frigerio4
Ézio Pinto4
Artur3
Marcelino3
Gito2
Matheus Dantas1
Milan Gavric1
B. Abdellaoui1
O. Silas1
J. Rodrigues1
Neto1
SALE
B. Abdellaoui20
Luís Pedro11
M. Kilibarda8
Neto8
David Nzanza7
Rodrigo Vilela6
J. Rodrigues5
A. Trajkovic5
O. Silas5
L. Lukco4
Christian Frigerio3
K. De Vasconcelos3
D. Ferreira3
F. Palfi3
Bessa2
Gito2
M. Březina2
Y. Rachidi2
Matheus Dantas1
W. Santos1
Fábio Pereira1
Miguel Velosa1
P. Bartunek1

  USO DE MEMORIA  
5,168,328 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3494
Total Execution Time  0.3514
  CADENA URL  
/estadisticas/Znojmo
  GET DATOS  
$_GET['/estadisticas/Znojmo']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5714 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1524 AND type_rel = 3
0.0130  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 = '5714' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 72398 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=5714 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (72506,72398,71432) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0137  SELECT count(id) as num_players from rel_players WHERE league_id = 72398 AND teamId = 5714
0.0138  SELECT count(id) as num_players from rel_players WHERE league_id = 72506 AND teamId = 5714
0.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 5714
0.0127  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '5714' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5714' and rp.type = 4
0.0131  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '5714' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139  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 = 72398 WHERE rp.league_id = 72398 AND rp.teamId = 5714 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0142  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 = 72398 WHERE rp.league_id = 72398 AND rp.teamId = 5714 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 72398 WHERE rp.league_id = 72398 AND rp.teamId = 5714 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139  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 = 72398 WHERE rp.league_id = 72398 AND rp.teamId = 5714 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144  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 = 72398 WHERE rp.league_id = 72398 AND rp.teamId = 5714 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139  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 = 72398 WHERE rp.league_id = 72398 AND rp.teamId = 5714 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30