4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Wolfsburg Sub 17 Wolfsburg 26 78 26 65
2 RB Leipzig Sub 17 Leipzig 26 60 16 61
3 Hertha BSC Sub 17 Hertha 26 76 24 59
4 Werder Bremen Sub 17 Werder 26 47 28 50
5 Hamburger SV Sub 17 Hamburger 26 51 34 48
6 FC St. Pauli Sub 17 Pauli 26 37 52 32
7 1. FC Magdeburg Sub 17 Magdeburg 26 34 47 29
8 Tennis Borussia Sub 17 Tennis 26 33 53 28
9 E. Braunschweig Sub 17 Braunschweig 26 25 45 28
10 Dynamo Dresden Sub 17 Dynamo 26 27 52 26
11 Union Berlin Sub 17 Union Berlin 26 27 34 25
12 Hannover 96 Sub 17 Hannover 26 31 55 25
13 FC Carl Zeiss Jena Sub 17 Carl Zeiss. 26 20 50 23
14 VfL Osnabrück Sub 17 Osnabrück 26 27 57 18
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 RB Leipzig Sub 17 Leipzig 26 63 19 62
2 Hannover 96 Sub 17 Hannover 26 57 22 59
3 Hamburger SV Sub 17 Hamburger 26 63 25 52
4 Wolfsburg Sub 17 Wolfsburg 26 52 18 51
5 Werder Bremen Sub 17 Werder 26 68 45 46
6 Hertha BSC Sub 17 Hertha 26 49 40 45
7 Tennis Borussia Sub 17 Tennis 26 30 30 37
8 E. Braunschweig Sub 17 Braunschweig 26 35 46 32
9 FC St. Pauli Sub 17 Pauli 26 32 44 28
10 FC Carl Zeiss Jena Sub 17 Carl Zeiss. 26 32 52 26
11 1. FC Magdeburg Sub 17 Magdeburg 26 49 60 24
12 Energie Cottbus Sub 17 Energie 26 20 34 21
13 Holstein Kiel Sub 17 Holstein 26 32 69 14
14 WTSV Concordia Sub 17 WTSV 26 16 94 9
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 RB Leipzig Sub 17 Leipzig 26 68 22 61
2 Hertha BSC Sub 17 Hertha 26 65 22 60
3 Werder Bremen Sub 17 Werder 26 66 37 54
4 Wolfsburg Sub 17 Wolfsburg 26 44 30 49
5 Hamburger SV Sub 17 Hamburger 26 43 35 41
6 FC Carl Zeiss Jena Sub 17 Carl Zeiss. 26 37 35 40
7 Energie Cottbus Sub 17 Energie 26 28 29 35
8 Hannover 96 Sub 17 Hannover 26 40 53 31
9 Holstein Kiel Sub 17 Holstein 26 43 53 28
10 E. Braunschweig Sub 17 Braunschweig 26 30 42 28
11 FC St. Pauli Sub 17 Pauli 26 25 35 23
12 Union Berlin Sub 17 Union Berlin 26 25 50 21
13 VfL Osnabrück Sub 17 Osnabrück 26 27 63 20
14 Dynamo Dresden Sub 17 Dynamo 26 19 54 16
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Hertha BSC Sub 17 Hertha 26 58 14 67
2 Werder Bremen Sub 17 Werder 26 59 30 55
3 Hannover 96 Sub 17 Hannover 26 60 30 52
4 Wolfsburg Sub 17 Wolfsburg 26 60 32 49
5 Holstein Kiel Sub 17 Holstein 26 55 44 49
6 Hamburger SV Sub 17 Hamburger 26 59 39 47
7 RB Leipzig Sub 17 Leipzig 26 42 37 41
8 Energie Cottbus Sub 17 Energie 26 38 41 38
9 VfL Osnabrück Sub 17 Osnabrück 26 49 46 34
10 FC St. Pauli Sub 17 Pauli 26 40 44 33
11 Dynamo Dresden Sub 17 Dynamo 26 30 51 23
12 Rot-Weiß Erfurt Sub 17 Rot-Weiß 26 29 64 18
13 E. Norderstedt Sub 17 Norderstedt 26 26 73 15
14 VfL Oldenburg Sub 17 Oldenburg 26 22 82 6
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Hertha BSC Sub 17 Hertha 26 71 23 61
2 Wolfsburg Sub 17 Wolfsburg 26 79 27 57
3 Hannover 96 Sub 17 Hannover 26 73 40 55
4 Werder Bremen Sub 17 Werder 26 66 37 48
5 Hamburger SV Sub 17 Hamburger 26 38 41 42
6 Dynamo Dresden Sub 17 Dynamo 26 52 50 40
7 Holstein Kiel Sub 17 Holstein 26 44 45 38
8 Energie Cottbus Sub 17 Energie 26 37 38 38
9 VfL Osnabrück Sub 17 Osnabrück 26 28 39 29
10 FC St. Pauli Sub 17 Pauli 26 26 37 26
11 RB Leipzig Sub 17 Leipzig 26 20 41 25
12 FC Carl Zeiss Jena Sub 17 Carl Zeiss. 26 34 59 24
13 Tennis Borussia Sub 17 Tennis 26 23 69 17
14 Hertha Zehlendorf Sub 17 Hertha 26 35 80 13
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Werder Bremen Sub 17 Werder 26 73 22 59
2 Hertha BSC Sub 17 Hertha 26 67 29 56
3 VfL Osnabrück Sub 17 Osnabrück 26 53 29 49
4 Tennis Borussia Sub 17 Tennis 26 49 33 45
5 Wolfsburg Sub 17 Wolfsburg 26 48 32 39
6 Hannover 96 Sub 17 Hannover 26 46 39 39
7 FC St. Pauli Sub 17 Pauli 26 37 33 38
8 Dynamo Dresden Sub 17 Dynamo 26 31 36 36
9 Hamburger SV Sub 17 Hamburger 26 31 47 36
10 FC Carl Zeiss Jena Sub 17 Carl Zeiss. 26 38 56 35
11 Energie Cottbus Sub 17 Energie 26 40 37 33
12 Hansa Rostock Sub 17 Hansa 26 37 41 33
13 Rot-Weiß Erfurt Sub 17 Rot-Weiß 26 22 78 10
14 WTSV Concordia Sub 17 WTSV 26 18 78 8
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Hertha BSC Sub 17 Hertha 26 70 24 59
2 Wolfsburg Sub 17 Wolfsburg 26 58 26 54
3 Werder Bremen Sub 17 Werder 26 62 39 47
4 Hansa Rostock Sub 17 Hansa 26 53 36 41
5 Hamburger SV Sub 17 Hamburger 26 40 33 41
6 Energie Cottbus Sub 17 Energie 26 39 45 39
7 Hannover 96 Sub 17 Hannover 26 46 31 38
8 VfL Osnabrück Sub 17 Osnabrück 26 39 37 35
9 Rot-Weiß Erfurt Sub 17 Rot-Weiß 26 51 50 34
10 Tennis Borussia Sub 17 Tennis 26 37 40 34
11 FC Carl Zeiss Jena Sub 17 Carl Zeiss. 26 33 44 32
12 Union Berlin Sub 17 Union Berlin 26 30 66 26
13 Holstein Kiel Sub 17 Holstein 26 38 62 24
14 SC Weyhe Sub 17 Weyhe 26 23 86 6
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Wolfsburg Sub 17 Wolfsburg 26 84 19 66
2 Werder Bremen Sub 17 Werder 26 86 53 54
3 Hertha BSC Sub 17 Hertha 26 65 38 50
4 Hansa Rostock Sub 17 Hansa 26 50 36 43
5 Tennis Borussia Sub 17 Tennis 26 52 42 42
6 Hamburger SV Sub 17 Hamburger 26 48 37 40
7 VfL Osnabrück Sub 17 Osnabrück 26 45 44 40
8 Energie Cottbus Sub 17 Energie 26 52 46 39
9 Hannover 96 Sub 17 Hannover 26 35 42 34
10 Rot-Weiß Erfurt Sub 17 Rot-Weiß 26 36 69 27
11 Holstein Kiel Sub 17 Holstein 26 34 70 25
12 FC St. Pauli Sub 17 Pauli 26 32 50 24
13 WTSV Concordia Sub 17 WTSV 26 25 67 16
14 Hertha Zehlendorf Sub 17 Hertha 26 29 60 15
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Hertha BSC Sub 17 Hertha 6 18 6 16
2 Hansa Rostock Sub 17 Hansa 5 16 5 13
3 Werder Bremen Sub 17 Werder 6 13 6 12
4 Hamburger SV Sub 17 Hamburger 5 11 5 12
5 Holstein Kiel Sub 17 Holstein 5 7 10 9
6 Wolfsburg Sub 17 Wolfsburg 5 13 8 8
7 Energie Cottbus Sub 17 Energie 5 5 4 7
8 Tennis Borussia Sub 17 Tennis 5 10 11 5
9 Hannover 96 Sub 17 Hannover 6 3 5 5
10 VfL Osnabrück Sub 17 Osnabrück 6 9 12 5
11 Rot-Weiß Erfurt Sub 17 Rot-Weiß 6 6 12 5
12 Dynamo Dresden Sub 17 Dynamo 6 5 12 4
13 SG Sachsen Leipzig Sub 17 Sachsen 6 5 17 4
14 E. Braunschweig Sub 17 Braunschweig 6 7 15 2

  USO DE MEMORIA  
5,904,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4138
Total Execution Time  0.4157
  CADENA URL  
/bundesliga_cadete2016/grupo1/historico
  GET DATOS  
$_GET['/bundesliga_cadete2016/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2021 AND type_rel = 3
0.0128  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2021 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (1241729,1237020,1178797,1135514,949672) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2021 ORDER BY order_id ASC
0.0126  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 = 44045 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2021 AND group_code = 1 and tables = 1 AND year <= 2016 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 44045 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 `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 = 44048 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 `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 = 44051 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 `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 = 44055 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 `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 = 44058 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 `tables2011` 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 = 44061 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 `tables2010` 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 = 44099 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 `tables2009` 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 = 44100 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 `tables2008` 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 = 44101 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 06:10:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 06:10:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 06:10:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 06:10:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0219  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 events2016 e ON e.player_id = p.id AND e.league_id = 44045 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44045 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.0203  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 events2016 e ON e.player_id = p.id AND e.league_id = 44045 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44045 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0138  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 events2016 e ON e.player_id = p.id AND e.league_id = 44045 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44045 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  SELECT *,(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 = 44045 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC