4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Hertha BSC Sub 19 Hertha 26 86 23 62
2 Werder Bremen Sub 19 Werder 26 61 36 49
3 Hansa Rostock Sub 19 Hansa 26 54 35 49
4 Energie Cottbus Sub 19 Energie 26 56 41 44
5 Hannover 96 Sub 19 Hannover 26 51 41 43
6 Rot-Weiß Erfurt Sub 19 Rot-Weiß 26 34 39 37
7 Tennis Borussia Sub 19 Tennis 26 45 53 33
8 Tasmania Berlín Sub 19 Tasmania 26 25 33 31
9 Hamburger SV Sub 19 Hamburger 26 32 38 30
10 SC Borea Dresden Sub 19 Borea 26 29 38 30
11 Wolfsburg Sub 19 Wolfsburg 26 33 46 30
12 Carl Zeiss Jena Sub 19 Carl Zeiss. 26 33 37 28
13 Holstein Kiel Sub 19 Holstein 26 42 68 26
14 St. Pauli Sub 19 Pauli 26 28 81 15
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Hannover 96 Sub 19 Hannover 26 73 29 59
2 Hertha BSC Sub 19 Hertha 26 60 29 56
3 Werder Bremen Sub 19 Werder 26 65 37 51
4 Carl Zeiss Jena Sub 19 Carl Zeiss. 26 62 35 51
5 Hansa Rostock Sub 19 Hansa 26 49 43 43
6 Wolfsburg Sub 19 Wolfsburg 26 57 35 42
7 Hamburger SV Sub 19 Hamburger 26 39 47 40
8 Tennis Borussia Sub 19 Tennis 26 62 42 38
9 St. Pauli Sub 19 Pauli 26 42 56 31
10 Tasmania Berlín Sub 19 Tasmania 26 40 56 31
11 SC Borea Dresden Sub 19 Borea 26 31 36 28
12 VfB Leipzig Sub 19 Leipzig 26 31 43 27
13 Osnabrück Sub 19 Osnabrück 26 26 59 20
14 ATSV 1860 Bremen Sub 19 ATSV 1860 B. 26 21 111 1

  USO DE MEMORIA  
5,098,064 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0026
Controller Execution Time ( Home / Category )  0.3733
Total Execution Time  0.3760
  CADENA URL  
/bundesliga_sub_192005/grupo1/historico
  GET DATOS  
$_GET['/bundesliga_sub_192005/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0128  SELECT type FROM routes WHERE alias = 'bundesliga_sub_192005'
0.0262  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bundesliga_sub_19' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2005 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1586 AND type_rel = 3
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1586 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0130  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1197781,1187339,1177490,1177454,1135000) ORDER BY n.cover_points DESC, update_date DESC
0.0128  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 = 44084 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1586 AND group_code = 1 and tables = 1 AND year <= 2005 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0128  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 `tables2005` 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 = 44084 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2004` 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 = 44085 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 06:55:45' 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=2 AND last_update > '2024-04-28 06:55:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 06:55:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 06:55:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0141  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bundesliga_sub_19' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2005 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0218  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 events2005 e ON e.player_id = p.id AND e.league_id = 44084 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44084 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.0250  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 events2005 e ON e.player_id = p.id AND e.league_id = 44084 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44084 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0200  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 events2005 e ON e.player_id = p.id AND e.league_id = 44084 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44084 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0139  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2005` 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 = 44084 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC