4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Esbjerg Sub 19 Esbjerg 22 63 27 52
2 Midtjylland Sub 19 Midtjylland 22 54 26 51
3 København Sub 19 København 22 50 24 46
4 Aalborg BK Sub 19 Aalborg 22 48 41 35
5 Nordsjælland Sub 19 Nordsjællan 22 41 43 30
6 Odense Sub 19 Odense 22 29 38 30
7 Silkeborg Sub 19 Silkeborg 22 40 43 27
8 Brøndby Sub 19 Brøndby 22 42 46 27
9 Randers Freja Sub 19 Randers 22 29 41 25
10 Lyngby Sub 19 Lyngby 22 39 50 22
11 Vejle BK Sub 19 Vejle 22 28 60 15
12 AGF Sub 19 AGF Sub 19 22 34 58 12
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Midtjylland Sub 19 Midtjylland 22 57 16 56
2 Nordsjælland Sub 19 Nordsjællan 22 65 35 50
3 Aalborg BK Sub 19 Aalborg 22 50 26 44
4 Esbjerg Sub 19 Esbjerg 22 39 38 39
5 København Sub 19 København 22 38 37 29
6 Silkeborg Sub 19 Silkeborg 22 36 37 28
7 Brøndby Sub 19 Brøndby 22 27 31 26
8 Vejle BK Sub 19 Vejle 22 34 45 26
9 Odense Sub 19 Odense 22 28 45 26
10 Lyngby Sub 19 Lyngby 22 23 41 20
11 AGF Sub 19 AGF Sub 19 22 25 47 18
12 Randers Freja Sub 19 Randers 22 23 47 14
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Midtjylland Sub 19 Midtjylland 22 64 21 55
2 Nordsjælland Sub 19 Nordsjællan 22 58 32 48
3 Esbjerg Sub 19 Esbjerg 22 38 25 40
4 Randers Freja Sub 19 Randers 22 34 29 34
5 Aalborg BK Sub 19 Aalborg 22 34 34 31
6 Brøndby Sub 19 Brøndby 22 34 32 30
7 AGF Sub 19 AGF Sub 19 22 37 43 24
8 Silkeborg Sub 19 Silkeborg 22 29 35 24
9 København Sub 19 København 22 36 45 23
10 Odense Sub 19 Odense 22 36 61 21
11 Vejle BK Sub 19 Vejle 22 22 41 20
12 Lyngby Sub 19 Lyngby 22 20 44 17
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Esbjerg Sub 19 Esbjerg 24 38 30 47
2 Nordsjælland Sub 19 Nordsjællan 24 50 29 44
3 Midtjylland Sub 19 Midtjylland 24 45 35 41
4 København Sub 19 København 24 52 40 35
5 Brøndby Sub 19 Brøndby 24 39 37 35
6 Aalborg BK Sub 19 Aalborg 24 43 42 35
7 Odense Sub 19 Odense 24 48 43 33
8 AGF Sub 19 AGF Sub 19 24 35 31 33
9 Randers Freja Sub 19 Randers 24 38 44 29
10 HB Køge Sub 19 Køge 24 34 42 26
11 Lyngby Sub 19 Lyngby 24 40 51 24
12 SönderjyskE Sub 19 SönderjyskE 24 40 61 24
13 Vejle BK Sub 19 Vejle 24 34 51 21
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Nordsjælland Sub 19 Nordsjællan 23 57 22 48
2 AGF Sub 19 AGF Sub 19 23 51 27 46
3 Midtjylland Sub 19 Midtjylland 24 47 36 44
4 Esbjerg Sub 19 Esbjerg 22 33 14 43
5 Odense Sub 19 Odense 21 32 30 31
6 Brøndby Sub 19 Brøndby 21 42 37 30
7 Aalborg BK Sub 19 Aalborg 21 28 29 29
8 Lyngby Sub 19 Lyngby 22 27 39 27
9 Randers Freja Sub 19 Randers 23 29 47 26
10 København Sub 19 København 22 27 33 24
11 SönderjyskE Sub 19 SönderjyskE 22 30 49 22
12 Vejle BK Sub 19 Vejle 22 25 40 19
13 Silkeborg Sub 19 Silkeborg 22 27 52 11
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 København Sub 19 København 20 45 25 41
2 Midtjylland Sub 19 Midtjylland 20 42 24 41
3 Odense Sub 19 Odense 20 45 32 36
4 Brøndby Sub 19 Brøndby 20 34 24 32
5 Aalborg BK Sub 19 Aalborg 20 32 22 30
6 Randers Freja Sub 19 Randers 20 29 35 26
7 Lyngby Sub 19 Lyngby 20 35 40 21
8 AGF Sub 19 AGF Sub 19 20 29 37 20
9 Nordsjælland Sub 19 Nordsjællan 20 33 42 20
10 Vejle BK Sub 19 Vejle 20 30 43 20
11 Esbjerg Sub 19 Esbjerg 20 19 49 13

  USO DE MEMORIA  
5,399,064 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.6637
Total Execution Time  0.6670
  CADENA URL  
/liga_danesa_sub_192017/grupo1/historico
  GET DATOS  
$_GET['/liga_danesa_sub_192017/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0127  SELECT type FROM routes WHERE alias = 'liga_danesa_sub_192017'
0.0266  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_19' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2017 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0132  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1601 AND type_rel = 3
0.0130  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1601 ORDER BY order_id ASC
0.0135  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 = 37161 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1601 AND group_code = 1 and tables = 1 AND year <= 2017 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0144  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 = 37161 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 15802 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 9363 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 28244 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2013` 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 = 28245 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 `tables2012` 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 = 63274 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 09:27:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 09:27:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 09:27:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 09:27:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0135  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_19' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2017 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0474  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 events2017 e ON e.player_id = p.id AND e.league_id = 37161 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 37161 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.0435  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 events2017 e ON e.player_id = p.id AND e.league_id = 37161 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 37161 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0134  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 events2017 e ON e.player_id = p.id AND e.league_id = 37161 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 37161 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0145  SELECT *,(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 = 37161 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC