4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1975/1976
Equipo PJ GF GC Puntos
1 Tennis Borussia Tennis 38 86 43 54
2 B. Dortmund B. Dortmund 38 93 37 52
3 Preußen Münster Preußen 38 65 42 49
4 Fortuna Köln Fortuna 38 74 49 45
5 Wuppertaler SV Wuppertaler 38 76 53 45
6 VfL Osnabrück Osnabrück 38 61 47 45
7 Schwarz-Weiss Essen Schwarz-Weis 38 63 52 44
8 Wattenscheid 09 Wattenscheid 38 71 58 43
9 Arminia Bielefeld Arminia 38 49 46 42
10 Westfalia Herne Westfalia 38 60 57 40
11 I. SC Göttingen Göttingen 38 63 54 37
12 Alemannia Aachen Alemannia 38 45 53 36
13 Union Solingen Union 38 45 56 36
14 FC St Pauli FC St Pauli 38 70 82 34
15 B. Leverkusen Leverkusen 38 46 61 32
16 Wacker 04 Berlin Wacker 38 51 82 31
17 1. FC Mülheim Mülheim 38 54 76 30
18 SpVgg Erkenschwick SpVgg 38 45 69 29
19 DJK Gütersloh Gütersloh 38 52 70 28
20 Spandauer SV Spandauer 38 33 115 8
Ver
TEMPORADA 1974/1975
Equipo PJ GF GC Puntos
1 Hannover 96 Hannover 96 38 93 39 54
2 KFC Uerdingen 05 Uerdingen 38 66 38 51
3 FC St Pauli FC St Pauli 38 77 48 50
4 Arminia Bielefeld Arminia 38 68 47 50
5 Fortuna Köln Fortuna 38 69 43 46
6 B. Dortmund B. Dortmund 38 65 44 46
7 Wattenscheid 09 Wattenscheid 38 72 53 46
8 VfL Osnabrück Osnabrück 38 81 62 42
9 Preußen Münster Preußen 38 73 63 42
10 I. SC Göttingen Göttingen 38 60 66 39
11 1. FC Mülheim Mülheim 38 47 64 36
12 Schwarz-Weiss Essen Schwarz-Weis 38 55 69 34
13 Wacker 04 Berlin Wacker 38 54 68 33
14 DJK Gütersloh Gütersloh 38 57 63 32
15 Alemannia Aachen Alemannia 38 57 71 30
16 SpVgg Erkenschwick SpVgg 38 49 70 29
17 Olympia Wilhelmshaven Olympia 38 54 81 27
18 Rot-Weiß Oberhausen Rot-Weiß 38 38 66 27
19 Wolfsburg Wolfsburg 38 61 89 26
20 Barmbek-Uhlenhorst Barmbek-Uhle 38 34 86 20

  USO DE MEMORIA  
5,467,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.1042
Total Execution Time  0.1076
  CADENA URL  
/bundesliga_21976/grupo2/historico
  GET DATOS  
$_GET['/bundesliga_21976/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0017  SELECT type FROM routes WHERE alias = 'bundesliga_21976'
0.0074  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bundesliga_2' AND (l.group_code = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1976 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=93 ORDER BY order_id ASC
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 = 9928 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 93 AND group_code = 2 and tables = 1 AND year <= 1976 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `tables1976` 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 = 9928 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables1975` 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 = 9929 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-05 11:36:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 11:36:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 11:36:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-05 11:36:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bundesliga_2' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1976 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0155  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 events1976 e ON e.player_id = p.id AND e.league_id = 9928 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9928 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.0122  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 events1976 e ON e.player_id = p.id AND e.league_id = 9928 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9928 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0072  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 events1976 e ON e.player_id = p.id AND e.league_id = 9928 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9928 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0050  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1976` 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 = 9928 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC