4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del AC Horsens Sub 17

Estadísticas

ASISTENCIAS
Loris Osmani1
ENTRA
Rasmus Jensen15
Martin Jørgensen14
Oscar Tran11
Villads Gindeberg9
William Graunkær8
Oliver Nord Pallesen8
Noah Madsen8
Mathias Klint6
Alexander Pedersen4
Lucas Rasmussen3
Oliver Pold3
Emil Strandgaard3
Mads Leth2
Johan Mejer2
Lukas Weng1
O. Bjerregaard1
Rinor Rexhepi1
Kalle Rahbek1
Malthe Hesselholt1
Tobias Vester1
Magne Flemming1
Adin Cehobasic1
William Hansen1
SALE
Kalle Rahbek12
Lucas Rasmussen11
William Graunkær9
Oscar Tran9
Anton Mandrup8
Oscar Mandrup8
Lucas Mølholm6
Mathias Klint5
Malthe Hesselholt4
Loris Osmani4
Rinor Rexhepi4
Theis Bøndergaard4
Noah Madsen3
L. Kristensen3
Adin Cehobasic2
Emil Strandgaard2
Søren Albrecht2
Martin Jørgensen2
Rasmus Nybo1
Oliver Nord Pallesen1
Nikolaj Larsen1
William Hansen1
Mads Leth1
Malthe Munch1
Tobias Vester1

  USO DE MEMORIA  
4,744,856 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.3629
Total Execution Time  0.3642
  CADENA URL  
/estadisticas/Ac-Horsens-Sub-17
  GET DATOS  
$_GET['/estadisticas/Ac-Horsens-Sub-17']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=111304 AND type_rel = 2
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1602 AND type_rel = 3
0.0158  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 = '111304' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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 = 72833 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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=111304 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (72833) 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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 72833 AND teamId = 111304
0.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72833 AND t.round = 20 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '111304' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '111304' and rp.type = 4
0.0146  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 = '111304' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0156  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 = 72833 WHERE rp.league_id = 72833 AND rp.teamId = 111304 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.0157  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 = 72833 WHERE rp.league_id = 72833 AND rp.teamId = 111304 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 = 72833 WHERE rp.league_id = 72833 AND rp.teamId = 111304 AND (e.action = 3 or e.action = 4) 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 = 72833 WHERE rp.league_id = 72833 AND rp.teamId = 111304 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0168  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 = 72833 WHERE rp.league_id = 72833 AND rp.teamId = 111304 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157  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 = 72833 WHERE rp.league_id = 72833 AND rp.teamId = 111304 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30