Ver
TEMPORADA 2021/2022
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
Ver
TEMPORADA 2020/2021
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
Ver
TEMPORADA 2019/2020
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
Ver
TEMPORADA 2018/2019
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
Ver
TEMPORADA 2017/2018
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
Ver
TEMPORADA 2016/2017
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
Ver
TEMPORADA 2015/2016
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
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos

  USO DE MEMORIA  
5,699,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1435
Total Execution Time  0.1455
  CADENA URL  
/liga_danesa_sub_172022/grupo1/historico
  GET DATOS  
$_GET['/liga_danesa_sub_172022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0044  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_danesa_sub_17' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1602 AND type_rel = 3
0.0021  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1602 ORDER BY order_id ASC
0.0027  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 63935 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1602 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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.0032  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.0041  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.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 `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.0035  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.0043  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.0037  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.0041  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
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 05:59:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-19 05:59:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-19 05:59:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-19 05:59:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0360  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63935 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63935 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0117  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63935 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63935 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0027  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63935 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63935 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029  SELECT *,(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