4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1971/1972
Equipo PJ GF GC Puntos
1 Wuppertaler SV Wuppertaler 34 111 23 88
2 Rot-Weiss Essen Rot-Weiss 34 113 37 78
3 Fortuna Köln Fortuna 34 76 41 69
4 Alemannia Aachen Alemannia 34 51 38 56
5 Schwarz-Weiss Essen Schwarz-Weis 34 57 48 54
6 B. Leverkusen Leverkusen 34 41 49 50
7 SpVgg Erkenschwick SpVgg 34 41 52 49
8 KFC Uerdingen 05 Uerdingen 34 49 51 48
9 Arminia Gütersloh Arminia 34 48 56 43
10 Preußen Münster Preußen 34 43 57 43
11 Eintracht Gelsenkirchen Eintracht 34 50 60 42
12 Gutersloh Gutersloh 34 44 75 41
13 Wattenscheid 09 Wattenscheid 34 43 49 39
14 Westfalia Herne Westfalia 34 39 52 37
15 Lüner Lüner 34 34 50 37
16 Neusss Neusss 34 42 69 29
17 Viktoria Köln Viktoria 34 34 62 27
18 VfL Klafeld VfL Klafeld 34 24 71 19
Ver
TEMPORADA 1970/1971
Equipo PJ GF GC Puntos
1 Tasmania Berlin Tasmania 33 110 20 90
2 Wacker 04 Berlin Wacker 33 75 34 75
3 Blau-Weiß 1890 Berlin Blau-Weiß 33 95 38 74
4 Tennis Borussia Tennis 33 68 39 64
5 FC Hertha 03 Zehlendorf Hertha 33 75 63 48
6 Spandauer SV Spandauer 33 59 70 46
7 Wannsee Wannsee 33 48 84 36
8 Alemannia 90 Alemannia 33 41 61 32
9 Rapide Wedding Rapide 33 46 66 29
10 Neukölln Neukölln 33 53 78 28
11 Staaken Staaken 33 35 76 28
12 Nord Berlin Nord Berlin 33 31 107 10
Ver
TEMPORADA 1969/1970
Equipo PJ GF GC Puntos
1 VfL Osnabrück Osnabrück 32 75 38 68
2 Wolfsburg Wolfsburg 32 78 35 65
3 Holstein Kiel Holstein 32 64 37 61
4 FC St Pauli FC St Pauli 32 56 33 60
5 I. SC Göttingen Göttingen 32 65 42 59
6 TuS Bremerhaven 93 Bremerhaven 32 57 47 53
7 VfB Lübeck VfB Lübeck 32 46 41 50
8 Arminia Hannover Arminia 32 53 51 46
9 VfB Oldenburg Oldenburg 32 44 48 45
10 Barmbek-Uhlenhorst Barmbek-Uhle 32 42 45 40
11 TuS Celle TuS Celle 32 39 61 36
12 Itzehoer SV 09 Itzehoer 32 57 71 34
13 HSC Leu 06 HSC Leu 06 32 42 57 32
14 1. FC Phönix Lübeck Phönix 32 41 61 32
15 Bergedorf 85 Bergedorf 32 46 79 31
16 Olympia Wilhelmshaven Olympia 32 28 49 27
17 Concordia Hamburg Concordia 32 22 60 18
Ver
TEMPORADA 1968/1969
Equipo PJ GF GC Puntos
1 Rot-Weiß Oberhausen Rot-Weiß 34 69 24 75
2 VfL Bochum VfL Bochum 34 86 36 74
3 Rot-Weiss Essen Rot-Weiss 34 72 25 72
4 Fortuna Düsseldorf Fortuna 34 64 35 63
5 Schwarz-Weiss Essen Schwarz-Weis 34 48 43 56
6 Wuppertaler SV Wuppertaler 34 46 41 56
7 Arminia Bielefeld Arminia 34 63 47 52
8 B. Leverkusen Leverkusen 34 48 35 48
9 Neusss Neusss 34 38 52 38
10 Hamborn Hamborn 34 46 64 38
11 Lüner Lüner 34 39 47 36
12 Bonner SC Bonner SC 34 45 70 35
13 Marl Hüls Marl Hüls 34 33 58 35
14 Preußen Münster Preußen 34 40 63 34
15 Eintracht Gelsenkirchen Eintracht 34 47 65 33
16 Fortuna Köln Fortuna 34 44 69 33
17 Eintracht Duisburg 1848 Eintracht 34 30 64 28
18 Viktoria Köln Viktoria 34 33 53 26
Ver
TEMPORADA 1967/1968
Equipo PJ GF GC Puntos
1 SV Alsenborn Alsenborn 30 87 21 75
2 FK Pirmasens Pirmasens 30 57 31 59
3 TuS Koblenz TuS Koblenz 30 66 29 58
4 Mainz 05 Mainz 05 30 57 32 53
5 1. FC Saarbrücken Saarbrücken 30 55 37 46
6 SV Südwest Ludwigshafen Südwest 30 45 32 46
7 Rochling Volklingen Rochling 30 53 47 45
8 Eintracht Trier Eintracht 30 57 46 43
9 Saar Saarbrücken Saar 30 32 35 43
10 FC 08 Homburg Homburg 30 41 53 39
11 Weisenau Weisenau 30 42 60 37
12 VfR Frankenthal Frankenthal 30 35 63 34
13 Wormatia Worms Wormatia 30 34 40 33
14 Friedrichsthal Friedrichsth 30 42 60 29
15 Ludwigshafener SC Ludwigshafen 30 27 90 13
16 1. FC Mülheim Mülheim 30 22 76 11
Ver
TEMPORADA 1966/1967
Equipo PJ GF GC Puntos
1 Alemannia Aachen Alemannia 34 56 24 68
2 Schwarz-Weiss Essen Schwarz-Weis 34 51 23 66
3 VfL Bochum VfL Bochum 34 67 42 63
4 Arminia Bielefeld Arminia 34 72 39 62
5 Hamborn Hamborn 34 52 33 60
6 Rot-Weiß Oberhausen Rot-Weiß 34 67 52 53
7 Wuppertaler SV Wuppertaler 34 49 41 52
8 Neusss Neusss 34 56 50 50
9 Preußen Münster Preußen 34 53 58 48
10 B. Leverkusen Leverkusen 34 57 62 44
11 Westfalia Herne Westfalia 34 41 41 43
12 Eintracht Gelsenkirchen Eintracht 34 48 53 40
13 Viktoria Köln Viktoria 34 36 39 39
14 Marl Hüls Marl Hüls 34 38 49 33
15 Hagen Vorhalle Hagen 34 35 69 32
16 Hammer SpVg Hammer SpVg 34 45 76 30
17 Bonner SC Bonner SC 34 27 48 28
18 Eintracht Duisburg 1848 Eintracht 34 34 85 25
Ver
TEMPORADA 1965/1966
Equipo PJ GF GC Puntos
1 Hertha BSC Hertha BSC 30 136 25 87
2 Tennis Borussia Tennis 30 108 50 65
3 Spandauer SV Spandauer 30 88 53 60
4 Wacker 04 Berlin Wacker 30 77 52 52
5 FC Hertha 03 Zehlendorf Hertha 30 53 43 51
6 Staaken Staaken 30 54 47 48
7 Berliner SV 1892 Berliner 30 49 65 40
8 Neukölln Neukölln 30 51 62 39
9 BFC Sudring BFC Sudring 30 49 53 38
10 Blau-Weiß 1890 Berlin Blau-Weiß 30 50 58 35
11 Reinickendorfer Füchse Reinickendor 30 50 70 35
12 Hermsdorf Hermsdorf 30 61 75 34
13 Lichterfelder Lichterfelde 30 34 82 32
14 SC Tegel SC Tegel 30 34 76 30
15 SC Gatow SC Gatow 30 36 60 26
16 BFC Viktoria 1889 Viktoria 30 34 93 13
Ver
TEMPORADA 1964/1965
Equipo PJ GF GC Puntos
1 Tennis Borussia Tennis 26 67 23 59
2 Spandauer SV Spandauer 26 57 26 59
3 Tasmania Berlin Tasmania 26 82 29 57
4 Wacker 04 Berlin Wacker 26 47 60 31
5 BFC Sudring BFC Sudring 26 54 61 29
6 Blau-Weiß 1890 Berlin Blau-Weiß 26 27 38 28
7 Berliner SV 1892 Berliner 26 28 61 28
8 FC Hertha 03 Zehlendorf Hertha 26 33 50 24
9 BFC Viktoria 1889 Viktoria 26 48 67 24
10 Reinickendorfer Füchse Reinickendor 26 28 56 23
Ver
TEMPORADA 1963/1964
Equipo PJ GF GC Puntos
1 FC St Pauli FC St Pauli 34 87 35 72
2 Hannover 96 Hannover 96 34 78 27 71
3 Altona 93 Altona 93 34 82 46 65
4 Arminia Hannover Arminia 34 73 44 63
5 Holstein Kiel Holstein 34 72 48 61
6 VfL Osnabrück Osnabrück 34 56 52 55
7 VfB Oldenburg Oldenburg 34 63 50 54
8 Bergedorf 85 Bergedorf 34 65 65 48
9 Wolfsburg Wolfsburg 34 50 61 48
10 VfR Neumunster Neumunster 34 56 61 45
11 VfV 06 Hildesheim Hildesheim 34 40 53 38
12 VfB Lübeck VfB Lübeck 34 59 78 38
13 Victoria Hamburg Victoria 34 49 71 38
14 TuS Bremerhaven 93 Bremerhaven 34 48 48 37
15 Concordia Hamburg Concordia 34 39 62 31
16 SV Friedrichsort Friedrichsor 34 46 85 31
17 VfL Oldenburg Oldenburg 34 36 69 29
18 Barmbek-Uhlenhorst Barmbek-Uhle 34 40 84 24

  USO DE MEMORIA  
6,065,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  2.1069
Total Execution Time  2.1089
  CADENA URL  
/bundesliga_41972/grupo5/historico
  GET DATOS  
$_GET['/bundesliga_41972/grupo5/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0450  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bundesliga_4' AND (l.group_code = 5 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1972 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=5 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=178 AND type_rel = 3
0.2237  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 178 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0920  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 (1312550,1292079,1266183,1227043,1201762) ORDER BY n.cover_points DESC, update_date DESC
0.0183  SELECT id,name,alias,stepParent FROM categories WHERE parentId=178 ORDER BY order_id ASC
0.0220  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 = 22746 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0502  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 178 AND group_code = 5 and tables = 1 AND year <= 1972 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.2154  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 `tables1972` 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 = 22746 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1020  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 `tables1971` 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 = 22763 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1626  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 `tables1970` 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 = 22836 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1213  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 `tables1969` 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 = 22853 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1181  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 `tables1968` 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 = 22885 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1548  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 `tables1967` 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 = 22866 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1684  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 `tables1966` 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 = 22864 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1715  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 `tables1965` 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 = 22906 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1305  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 `tables1964` 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 = 22892 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 14:09:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0058  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 14:09:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0079  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 14:09:49' 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-04-28 14:09:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0216  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 events1972 e ON e.player_id = p.id AND e.league_id = 22746 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 22746 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.0584  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 events1972 e ON e.player_id = p.id AND e.league_id = 22746 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 22746 AND (e.action = 4 or e.action = 5) 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 events1972 e ON e.player_id = p.id AND e.league_id = 22746 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 22746 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0991  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1972` 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 = 22746 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC