4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Karlsruher SC Karlsruher 38 69 27 79
2 Arminia Bielefeld Arminia 38 59 32 76
3 VfL Osnabrück Osnabrück 38 64 35 73
4 Preußen Münster Preußen 38 63 33 72
5 Heidenheim Heidenheim 38 69 47 72
6 Chemnitzer Chemnitzer 38 56 47 55
7 Wehen Wiesbaden Wehen 38 51 51 51
8 SV Wacker Burghausen Wacker 38 45 45 51
9 Unterhaching Unterhaching 38 48 55 51
10 Hallescher FC Hallescher 38 37 50 46
11 1. FC Saarbrücken Saarbrücken 38 52 62 45
12 Hansa Rostock Hansa 38 39 52 44
13 Rot-Weiss Erfurt Rot-Weiss 38 44 58 44
14 Stuttgart II Stuttgart 38 35 42 43
15 Kickers Offenbach FC Kickers 38 41 44 42
16 B. Dortmund II Dortmund 38 39 58 41
17 Stuttgarter Kickers Stuttgarter 38 39 48 40
18 Darmstadt 98 Darmstadt 38 32 46 38
19 SV Babelsberg 03 Babelsberg 38 32 54 37
20 Alemannia Aachen Alemannia 38 40 68 26
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Sandhausen Sandhausen 38 57 42 66
2 VfR Aalen VfR Aalen 38 50 42 64
3 Jahn Regensburg Jahn 38 55 41 61
4 Heidenheim Heidenheim 38 48 36 60
5 Rot-Weiss Erfurt Rot-Weiss 38 54 41 59
6 SV Wacker Burghausen Wacker 38 55 47 57
7 VfL Osnabrück Osnabrück 38 46 35 55
8 Kickers Offenbach FC Kickers 38 49 41 55
9 Chemnitzer Chemnitzer 38 47 43 55
10 1. FC Saarbrücken Saarbrücken 38 61 51 54
11 Stuttgart II Stuttgart 38 44 47 50
12 Preußen Münster Preußen 38 40 44 50
13 Arminia Bielefeld Arminia 38 51 57 50
14 Darmstadt 98 Darmstadt 38 51 47 49
15 Unterhaching Unterhaching 38 63 59 44
16 Wehen Wiesbaden Wehen 38 40 48 44
17 SV Babelsberg 03 Babelsberg 38 44 59 44
18 FC Carl Zeiss Jena Carl Zeiss. 38 39 59 39
19 Rot-Weiß Oberhausen Rot-Weiß 38 33 47 38
20 Werder Bremen II Werder 38 29 70 22
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Eintracht Braunschweig Eintracht 38 81 22 85
2 Hansa Rostock Hansa 38 70 36 78
3 Dynamo Dresden Dynamo 38 55 37 65
4 Wehen Wiesbaden Wehen 38 55 39 64
5 Rot-Weiss Erfurt Rot-Weiss 38 63 45 61
6 1. FC Saarbrücken Saarbrücken 38 61 51 59
7 Kickers Offenbach FC Kickers 38 52 45 57
8 Jahn Regensburg Jahn 38 35 41 52
9 Heidenheim Heidenheim 38 59 58 51
10 Stuttgart II Stuttgart 38 48 48 51
11 TuS Koblenz TuS Koblenz 38 38 46 49
12 Sandhausen Sandhausen 38 43 46 46
13 SV Babelsberg 03 Babelsberg 38 39 47 46
14 Unterhaching Unterhaching 38 39 55 45
15 FC Carl Zeiss Jena Carl Zeiss. 38 43 62 44
16 Rot Weiss Ahlen Weiss Ahlen 38 45 69 42
17 VfR Aalen VfR Aalen 38 40 52 41
18 SV Wacker Burghausen Wacker 38 46 66 37
19 Werder Bremen II Werder 38 33 56 36
20 Bayern München II Bayern 38 30 54 30
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 VfL Osnabrück Osnabrück 38 55 37 69
2 Erzgebirge Aue Erzgebirge 38 57 41 68
3 Ingolstadt 04 Ingolstadt 38 72 46 64
4 Eintracht Braunschweig Eintracht 38 55 37 62
5 FC Carl Zeiss Jena Carl Zeiss. 38 54 44 60
6 Heidenheim Heidenheim 38 66 56 59
7 Kickers Offenbach FC Kickers 38 55 35 57
8 Bayern München II Bayern 38 55 65 54
9 Rot-Weiss Erfurt Rot-Weiss 38 41 41 53
10 Stuttgart II Stuttgart 38 53 50 52
11 Unterhaching Unterhaching 38 52 52 50
12 Dynamo Dresden Dynamo 38 39 46 50
13 Werder Bremen II Werder 38 49 54 47
14 Sandhausen Sandhausen 38 54 63 47
15 Wehen Wiesbaden Wehen 38 52 64 47
16 Jahn Regensburg Jahn 38 43 48 46
17 SV Wacker Burghausen Wacker 38 45 64 46
18 B. Dortmund II Dortmund 38 43 58 39
19 Holstein Kiel Holstein 38 43 61 38
20 Wuppertaler SV Wuppertaler 38 40 61 38
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Union Berlin Union Berlin 38 59 23 78
2 Fortuna Düsseldorf Fortuna 38 54 33 69
3 Paderborn Paderborn 38 68 38 68
4 Unterhaching Unterhaching 38 57 46 67
5 Bayern München II Bayern 38 54 38 59
6 BSV Kickers Emden Kickers 38 45 44 59
7 Kickers Offenbach FC Kickers 38 40 35 52
8 Sandhausen Sandhausen 38 58 52 50
9 Dynamo Dresden Dynamo 38 46 46 50
10 Rot-Weiss Erfurt Rot-Weiss 38 46 48 50
11 Stuttgart II Stuttgart 38 61 50 49
12 Erzgebirge Aue Erzgebirge 38 43 43 48
13 Eintracht Braunschweig Eintracht 38 46 51 45
14 Wuppertaler SV Wuppertaler 38 36 45 45
15 Jahn Regensburg Jahn 38 37 51 45
16 FC Carl Zeiss Jena Carl Zeiss. 38 41 59 41
17 Werder Bremen II Werder 38 49 58 40
18 SV Wacker Burghausen Wacker 38 40 65 40
19 VfR Aalen VfR Aalen 38 38 60 39
20 Stuttgarter Kickers Stuttgarter 38 38 71 29

  USO DE MEMORIA  
5,936,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0028
Controller Execution Time ( Home / Category )  0.1759
Total Execution Time  0.1787
  CADENA URL  
/bundesliga_32013/grupo1/historico
  GET DATOS  
$_GET['/bundesliga_32013/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=94 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 94 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0028  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 (1306138,1292863,1292079,1291710,1279728) ORDER BY n.cover_points DESC, update_date DESC
0.0020  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 = 2004 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 94 AND group_code = 1 and tables = 1 AND year <= 2013 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0039  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 = 2004 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 1326 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 1187 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 885 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 452 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 18:24:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 18:24:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0017  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 18:24:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0017  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 18:24:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0390  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 events2013 e ON e.player_id = p.id AND e.league_id = 2004 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2004 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.0551  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 events2013 e ON e.player_id = p.id AND e.league_id = 2004 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2004 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0045  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 events2013 e ON e.player_id = p.id AND e.league_id = 2004 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2004 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0049  SELECT *,(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 = 2004 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC