4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Esbjerg 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 2
Equipo PJ GF GC Puntos
1 København Sub 17 København 14 38 15 33
2 Lyngby Sub 17 Lyngby 14 44 23 33
3 Randers Freja Sub 17 Randers 14 36 25 27
4 Midtjylland Sub 17 Midtjylland 14 48 31 23
5 Esbjerg Sub 17 Esbjerg 14 31 36 22
6 Nordsjælland Sub 17 Nordsjællan 13 32 19 21
7 OB Sub 17 OB Sub 17 14 29 21 20
8 AaB Sub 17 AaB Sub 17 14 29 39 15
9 Brøndby Sub 17 Brøndby 14 24 25 14
10 AGF Sub 17 AGF Sub 17 14 22 30 13
11 Vejle Sub 17 Vejle 13 16 26 12
12 Silkeborg Sub 17 Silkeborg 14 26 52 11
13 SønderjyskE Sub 17 SønderjyskE 14 20 53 5
TEMPORADA 2018/2019
LIGA DANESA SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Nordsjælland Sub 17 Nordsjællan 24 66 26 55
2 Silkeborg Sub 17 Silkeborg 24 73 34 54
3 Midtjylland Sub 17 Midtjylland 24 62 55 44
4 Vejle Sub 17 Vejle 24 36 35 38
5 Esbjerg Sub 17 Esbjerg 24 53 58 38
6 OB Sub 17 OB Sub 17 24 49 44 37
7 Brøndby Sub 17 Brøndby 24 64 49 36
8 AGF Sub 17 AGF Sub 17 24 45 59 29
9 Randers Freja Sub 17 Randers 24 40 50 27
10 Lyngby Sub 17 Lyngby 24 36 48 27
11 København Sub 17 København 24 53 52 25
12 AaB Sub 17 AaB Sub 17 24 35 56 23
13 SønderjyskE Sub 17 SønderjyskE 24 32 78 13
TEMPORADA 2017/2018
LIGA DANESA SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 AGF Sub 17 AGF Sub 17 26 65 34 59
2 København Sub 17 København 26 76 32 55
3 AaB Sub 17 AaB Sub 17 26 57 29 52
4 Nordsjælland Sub 17 Nordsjællan 26 61 49 48
5 Midtjylland Sub 17 Midtjylland 26 75 50 47
6 Vejle Sub 17 Vejle 26 53 43 42
7 OB Sub 17 OB Sub 17 26 45 38 42
8 Brøndby Sub 17 Brøndby 26 52 48 36
9 Esbjerg Sub 17 Esbjerg 26 52 70 30
10 Silkeborg Sub 17 Silkeborg 26 49 75 25
11 Lyngby Sub 17 Lyngby 26 34 57 24
12 Randers Freja Sub 17 Randers 26 39 58 21
13 Haderslev Sub 17 Haderslev 26 29 61 15
14 HB Køge Sub 17 Køge 26 28 71 15
TEMPORADA 2016/2017
LIGA DANESA SUB 17
Equipo PJ GF GC Puntos
1 AGF Sub 17 AGF Sub 17 25 66 26 57
2 Brøndby Sub 17 Brøndby 25 46 32 49
3 Nordsjælland Sub 17 Nordsjællan 26 70 49 48
4 København Sub 17 København 25 53 35 42
5 AaB Sub 17 AaB Sub 17 26 62 44 41
6 Midtjylland Sub 17 Midtjylland 25 59 52 41
7 Esbjerg Sub 17 Esbjerg 26 48 44 39
8 Vejle Sub 17 Vejle 26 47 53 33
9 OB Sub 17 OB Sub 17 26 40 49 29
10 Silkeborg Sub 17 Silkeborg 25 34 56 29
11 Randers Freja Sub 17 Randers 26 35 53 28
12 Lyngby Sub 17 Lyngby 26 47 72 23
13 HB Køge Sub 17 Køge 26 22 60 20
14 Viborg Sub 17 Viborg 25 41 45 19
TEMPORADA 2015/2016
LIGA DANESA SUB 17
Equipo PJ GF GC Puntos
1 København Sub 17 København 24 70 14 66
2 Nordsjælland Sub 17 Nordsjællan 26 67 32 50
3 Midtjylland Sub 17 Midtjylland 26 54 27 49
4 AaB Sub 17 AaB Sub 17 25 45 31 47
5 Lyngby Sub 17 Lyngby 26 48 53 40
6 HB Køge Sub 17 Køge 26 46 43 37
7 AGF Sub 17 AGF Sub 17 26 38 44 36
8 Brøndby Sub 17 Brøndby 25 33 35 33
9 Esbjerg Sub 17 Esbjerg 26 40 40 32
10 Vejle Sub 17 Vejle 26 37 62 31
11 Silkeborg Sub 17 Silkeborg 26 35 63 23
12 OB Sub 17 OB Sub 17 26 31 43 22
13 Randers Freja Sub 17 Randers 26 29 56 21
14 Haderslev Sub 17 Haderslev 26 30 60 15
TEMPORADA 2014/2015
LIGA DANESA SUB 17
Equipo PJ GF GC Puntos
TEMPORADA 2013/2014
LIGA DANESA SUB 17
Equipo PJ GF GC Puntos

  USO DE MEMORIA  
5,666,408 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1687
Total Execution Time  0.1705
  CADENA URL  
/historico/Esbjerg-Sub17
  GET DATOS  
$_GET['/historico/Esbjerg-Sub17']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0058  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 = 'Esbjerg-Sub17' 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.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=65930 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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=65930 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0064  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.0031  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65930 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1602 AND type_rel = 3
0.0028  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '65930' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '65930' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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=65930 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 72833 AND teamId = 65930
0.0023  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 = '65930' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65930' and rp.type = 4
0.0020  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 = '65930' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0056  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 = 65930 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.0049  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 = 65930 AND (e.action = 4 or e.action = 5) 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 = 72833 WHERE rp.league_id = 72833 AND rp.teamId = 65930 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 65930 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0027  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.0029  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.0028  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.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 `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.0036  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 = 51484 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 44340 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 38750 AND t.round = 26 ORDER BY team.conference 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 `tables2017` 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 = 37162 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 `tables2016` 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 = 16633 AND t.round = 18 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
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 `tables2014` 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 = 43726 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC