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
TEMPORADA 2023/2024
LIGA DANESA SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 OB Sub 17 OB Sub 17 20 78 18 55
2 Midtjylland Sub 17 Midtjylland 18 50 37 34
3 Nordsjælland Sub 17 Nordsjællan 18 41 28 34
4 Brøndby Sub 17 Brøndby 18 46 35 33
5 AGF Sub 17 AGF Sub 17 19 36 29 33
6 AaB Sub 17 AaB Sub 17 18 38 23 31
7 Silkeborg Sub 17 Silkeborg 19 31 31 27
8 København Sub 17 København 17 36 37 23
9 Lyngby Sub 17 Lyngby 17 32 40 22
10 Esbjerg Sub 17 Esbjerg 19 37 46 22
11 Randers Freja Sub 17 Randers 18 32 44 20
12 Vejle Sub 17 Vejle 19 27 41 17
13 SønderjyskE Sub 17 SønderjyskE 19 30 62 10
14 AC Horsens Sub 17 Horsens 19 23 66 5
TEMPORADA 2022/2023
LIGA DANESA SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Brøndby Sub 17 Brøndby 26 74 43 58
2 Nordsjælland Sub 17 Nordsjællan 26 73 32 55
3 OB Sub 17 OB Sub 17 26 52 34 54
4 Midtjylland Sub 17 Midtjylland 26 84 42 51
5 København Sub 17 København 26 73 39 51
6 AGF Sub 17 AGF Sub 17 26 53 48 43
7 Vejle Sub 17 Vejle 26 45 46 40
8 Silkeborg Sub 17 Silkeborg 26 63 54 37
9 Esbjerg Sub 17 Esbjerg 26 55 76 30
10 Lyngby Sub 17 Lyngby 26 29 51 30
11 Randers Freja Sub 17 Randers 26 30 55 24
12 AaB Sub 17 AaB Sub 17 26 39 48 22
13 SønderjyskE Sub 17 SønderjyskE 26 32 75 15
14 AC Horsens Sub 17 Horsens 26 23 82 6
TEMPORADA 2021/2022
LIGA DANESA SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 København Sub 17 København 26 71 22 61
2 Midtjylland Sub 17 Midtjylland 26 64 31 55
3 OB Sub 17 OB Sub 17 26 77 36 54
4 Brøndby Sub 17 Brøndby 26 93 45 52
5 Randers Freja Sub 17 Randers 26 58 41 42
6 Silkeborg Sub 17 Silkeborg 26 58 54 41
7 Nordsjælland Sub 17 Nordsjællan 26 60 51 39
8 Vejle Sub 17 Vejle 26 42 48 36
9 Lyngby Sub 17 Lyngby 26 56 61 33
10 AC Horsens Sub 17 Horsens 26 45 78 29
11 AaB Sub 17 AaB Sub 17 26 33 70 26
12 AGF Sub 17 AGF Sub 17 26 40 70 21
13 SønderjyskE Sub 17 SønderjyskE 26 50 97 21
14 Esbjerg Sub 17 Esbjerg 26 40 83 17
TEMPORADA 2020/2021
LIGA DANESA SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 København Sub 17 København 26 110 44 63
2 Nordsjælland Sub 17 Nordsjællan 26 72 36 56
3 Midtjylland Sub 17 Midtjylland 26 82 55 55
4 Brøndby Sub 17 Brøndby 26 105 53 53
5 OB Sub 17 OB Sub 17 26 71 56 45
6 SønderjyskE Sub 17 SønderjyskE 26 42 46 35
7 Randers Freja Sub 17 Randers 26 46 40 34
8 Lyngby Sub 17 Lyngby 26 52 62 34
9 Esbjerg Sub 17 Esbjerg 26 51 64 31
10 Silkeborg Sub 17 Silkeborg 26 54 83 29
11 AaB Sub 17 AaB Sub 17 26 57 82 24
12 Vejle Sub 17 Vejle 26 44 74 24
13 AGF Sub 17 AGF Sub 17 26 39 78 23
14 AC Horsens Sub 17 Horsens 26 32 84 17
TEMPORADA 2019/2020
LIGA DANESA SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 AC Horsens Sub 17 Horsens 16 60 17 45
2 B93 København Sub 17 København 15 47 30 37
3 Viborg Sub 17 Viborg 15 41 25 31
4 Hellerup IK Sub 17 Hellerup 15 33 24 27
5 HB Køge Sub 17 Køge 15 36 23 26
6 FC Helsingør Sub 17 Helsingør 14 45 29 25
7 Hvidovre IF Sub 17 Hvidovre 15 31 35 22
8 AB Gladsaxe Sub 17 Gladsaxe 16 27 28 20
9 FC Roskilde Sub 17 Roskilde 15 29 29 19
10 Hobro Idraets Klub Sub 17 Hobro 15 23 26 18
11 Næstved BK Sub 17 Næstved 15 17 48 16
12 Næsby BK Sub 17 Næsby 15 29 34 12
13 Kolding IF Sub 17 Kolding 15 21 39 10
14 Holbæk B&I Sub 17 Holbæk 15 19 39 10
15 Slagelse B&I Sub 17 Slagelse 15 17 49 9
TEMPORADA 2018/2019
LIGA DANESA SUB 17 GRUPO 2
Equipo PJ GF GC Puntos
1 HB Køge Sub 17 Køge 26 81 30 62
2 B93 København Sub 17 København 26 77 38 53
3 Viborg Sub 17 Viborg 26 81 33 52
4 Hellerup IK Sub 17 Hellerup 26 55 36 49
5 AC Horsens Sub 17 Horsens 26 66 42 45
6 AB Gladsaxe Sub 17 Gladsaxe 26 50 47 40
7 FC Helsingør Sub 17 Helsingør 26 47 63 37
8 Hvidovre IF Sub 17 Hvidovre 26 42 39 34
9 FC Roskilde Sub 17 Roskilde 26 58 59 34
10 Slagelse B&I Sub 17 Slagelse 26 57 55 33
11 Næsby BK Sub 17 Næsby 26 48 65 29
12 Næstved BK Sub 17 Næstved 26 35 66 27
13 Thisted FC Sub 17 Thisted 26 47 83 19
14 Holbæk B&I Sub 17 Holbæk 26 23 111 2
TEMPORADA 2017/2018
LIGA DANESA SUB 17 GRUPO 2
Equipo PJ GF GC Puntos
1 AC Horsens Sub 17 Horsens 26 67 33 65
2 Viborg Sub 17 Viborg 26 88 30 60
3 FC Roskilde Sub 17 Roskilde 26 90 39 54
4 AB Gladsaxe Sub 17 Gladsaxe 26 73 39 53
5 B93 København Sub 17 København 26 67 39 51
6 FC Helsingør Sub 17 Helsingør 26 70 42 42
7 Næstved BK Sub 17 Næstved 26 59 62 38
8 Hellerup IK Sub 17 Hellerup 26 48 70 31
9 Slagelse B&I Sub 17 Slagelse 26 38 57 27
10 Holbæk B&I Sub 17 Holbæk 26 47 76 27
11 Næsby BK Sub 17 Næsby 26 41 65 26
12 Nykøbing FC Sub 17 Nykøbing 26 36 84 17
13 Hvidovre IF Sub 17 Hvidovre 26 32 68 12
14 Thisted FC Sub 17 Thisted 26 39 91 12
TEMPORADA 2014/2015
LIGA DANESA SUB 17
Equipo PJ GF GC Puntos

  USO DE MEMORIA  
5,467,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0923
Total Execution Time  0.0935
  CADENA URL  
/historico/Ac-Horsens-Sub-17
  GET DATOS  
$_GET['/historico/Ac-Horsens-Sub-17']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0042  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72833
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=111304 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1602 AND type_rel = 3
0.0021  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.0020  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.0024  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.0020  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.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 72833 AND teamId = 111304
0.0021  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.0021  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.0021  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '111304' and rp.type = 4
0.0021  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.0041  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.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 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.0022  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.0023  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 111304 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 68360 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 63935 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` 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 = 57440 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 51483 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` 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 = 48668 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` 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 = 44134 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` 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 = 43725 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC