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 Werder Bremen Sub 17 Werder 26 94 13 75
2 RB Leipzig Sub 17 Leipzig 26 86 23 59
3 Hamburger SV Sub 17 Hamburger 26 65 32 46
4 Wolfsburg Sub 17 Wolfsburg 26 62 39 46
5 Hertha BSC Sub 17 Hertha 26 41 31 45
6 FC St. Pauli Sub 17 Pauli 26 48 32 42
7 Holstein Kiel Sub 17 Holstein 26 55 41 40
8 1. FC Magdeburg Sub 17 Magdeburg 26 34 48 37
9 Dynamo Dresden Sub 17 Dynamo 26 43 61 32
10 Union Berlin Sub 17 Union Berlin 26 41 57 31
11 E. Braunschweig Sub 17 Braunschweig 26 31 58 22
12 Hansa Rostock Sub 17 Hansa 26 15 63 21
13 Tennis Borussia Sub 17 Tennis 26 14 53 14
14 Niendorfer TSV Sub 17 Niendorfer 26 17 95 7
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  
6,025,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.5100
Total Execution Time  0.5131
  CADENA URL  
/bundesliga_cadete2017/grupo1/historico
  GET DATOS  
$_GET['/bundesliga_cadete2017/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0115  SELECT type FROM routes WHERE alias = 'bundesliga_cadete2017'
0.0237  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bundesliga_cadete' 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.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2021 AND type_rel = 3
0.0130  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.0110  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.0107  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 = 44042 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0122  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2021 AND group_code = 1 and tables = 1 AND year <= 2017 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 `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 = 44042 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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.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 `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.0124  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.0155  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.0113  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.0111  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.0113  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.0119  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.0122  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.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 17:18:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0108  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 17:18:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 17:18:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0108  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 17:18:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0117  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bundesliga_cadete' 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.0335  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 = 44042 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44042 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.0221  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 = 44042 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44042 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0115  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 = 44042 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44042 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0118  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 = 44042 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC