4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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  
4,972,552 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3107
Total Execution Time  0.3127
  CADENA URL  
/liga_danesa_sub_192014/grupo1/historico
  GET DATOS  
$_GET['/liga_danesa_sub_192014/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0107  SELECT type FROM routes WHERE alias = 'liga_danesa_sub_192014'
0.0226  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 = 2014 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1601 AND type_rel = 3
0.0106  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1601 ORDER BY order_id ASC
0.0106  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1601 GROUP BY l.categoryId
0.0106  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=1601 GROUP BY l.year ORDER BY l.year DESC
0.0109  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 = 28244 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1601 AND group_code = 1 and tables = 1 AND year <= 2014 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0109  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.0110  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.0109  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.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 22:23:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 22:23:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 22:23:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 22:23:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  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 = 2014 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0109  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 events2014 e ON e.player_id = p.id AND e.league_id = 28244 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 28244 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.0136  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 events2014 e ON e.player_id = p.id AND e.league_id = 28244 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 28244 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0106  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 events2014 e ON e.player_id = p.id AND e.league_id = 28244 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 28244 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0116  SELECT *,(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