4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1969/1970
Equipo PJ GF GC Puntos
1 Kickers Offenbach FC Kickers 38 93 47 86
2 Karlsruher SC Karlsruher 38 87 37 81
3 Nürnberg Nürnberg 38 64 29 81
4 Bayern Hof Bayern Hof 38 65 40 66
5 Schweinfurt Schweinfurt 38 78 59 60
6 Hessen Kassel Hessen 38 54 50 55
7 Freiburger FC Freiburger 38 63 48 54
8 Greuther Fürth Greuther 38 49 50 52
9 Villingen Villingen 38 61 58 51
10 Jahn Regensburg Jahn 38 61 59 47
11 Reutlingen Reutlingen 38 51 56 47
12 Stuttgarter Kickers Stuttgarter 38 61 57 46
13 Opel Rüsselsheim Opel 38 50 50 45
14 VfR Mannheim Mannheim 38 48 61 45
15 VfR Heilbronn Heilbronn 38 50 57 44
16 Darmstadt 98 Darmstadt 38 50 89 42
17 Ingolstadt 04 Ingolstadt 38 55 77 40
18 Bayreuth SpVgg Bayreuth 38 58 80 39
19 FSV Frankfurt Frankfurt 38 34 79 34
20 Waldhof Mannheim Waldhof 38 50 99 33
Ver
TEMPORADA 1968/1969
Equipo PJ GF GC Puntos
1 FC Hertha 03 Zehlendorf Hertha 30 84 32 74
2 Tasmania Berlin Tasmania 30 75 26 71
3 Tennis Borussia Tennis 30 96 38 65
4 Wacker 04 Berlin Wacker 30 93 31 62
5 Spandauer SV Spandauer 30 73 42 61
6 Neukölln Neukölln 30 72 60 49
7 Kickers 1900 Kickers 1900 30 57 54 39
8 Rapide Wedding Rapide 30 52 49 38
9 Berliner SV 1892 Berliner 30 58 63 36
10 Staaken Staaken 30 44 61 33
11 SV Blau Weiss Berlin Blau Weiss. 30 41 55 30
12 Meteor Berlin Meteor 30 53 88 29
13 BFC Sudring BFC Sudring 30 38 62 28
14 Alemannia 90 Alemannia 30 33 75 21
15 Nord Berlin Nord Berlin 30 50 107 20
16 Reinickendorfer Füchse Reinickendor 30 26 102 13
Ver
TEMPORADA 1967/1968
Equipo PJ GF GC Puntos
1 Rot-Weiß Oberhausen Rot-Weiß 34 77 32 74
2 Rot-Weiss Essen Rot-Weiss 34 73 35 74
3 B. Leverkusen Leverkusen 34 70 32 74
4 Arminia Bielefeld Arminia 34 77 44 65
5 VfL Bochum VfL Bochum 34 65 32 60
6 Schwarz-Weiss Essen Schwarz-Weis 34 56 46 47
7 Fortuna Düsseldorf Fortuna 34 65 49 46
8 Lüner Lüner 34 46 65 46
9 Viktoria Köln Viktoria 34 48 51 43
10 Marl Hüls Marl Hüls 34 49 56 43
11 Neusss Neusss 34 51 61 43
12 Hamborn Hamborn 34 60 61 42
13 Eintracht Gelsenkirchen Eintracht 34 43 56 40
14 Preußen Münster Preußen 34 45 50 39
15 Wuppertaler SV Wuppertaler 34 31 51 38
16 Fortuna Köln Fortuna 34 45 81 30
17 Westfalia Herne Westfalia 34 27 74 25
18 VfB Bottrop VfB Bottrop 34 20 72 17
Ver
TEMPORADA 1966/1967
Equipo PJ GF GC Puntos
1 Hertha BSC Hertha BSC 30 114 25 85
2 Tennis Borussia Tennis 30 101 30 72
3 Spandauer SV Spandauer 30 61 42 59
4 Tasmania Berlin Tasmania 30 53 31 55
5 FC Hertha 03 Zehlendorf Hertha 30 56 41 55
6 Wacker 04 Berlin Wacker 30 63 46 50
7 Rapide Wedding Rapide 30 42 58 36
8 Hermsdorf Hermsdorf 30 52 81 35
9 Berliner SV 1892 Berliner 30 37 49 33
10 Neukölln Neukölln 30 42 65 32
11 Reinickendorfer Füchse Reinickendor 30 39 57 29
12 Blau-Weiß 1890 Berlin Blau-Weiß 30 32 55 29
13 BFC Sudring BFC Sudring 30 44 59 28
14 Kickers 1900 Kickers 1900 30 49 79 28
15 Staaken Staaken 30 36 53 26
16 Lichterfelder Lichterfelde 30 42 92 16
Ver
TEMPORADA 1965/1966
Equipo PJ GF GC Puntos
1 Schweinfurt Schweinfurt 34 74 39 71
2 Kickers Offenbach FC Kickers 34 78 48 68
3 Waldhof Mannheim Waldhof 34 78 60 57
4 Greuther Fürth Greuther 34 70 52 54
5 Stuttgarter Kickers Stuttgarter 34 65 52 51
6 Hessen Kassel Hessen 34 70 62 49
7 Pforzheim Pforzheim 34 48 46 49
8 Reutlingen Reutlingen 34 60 50 48
9 Opel Rüsselsheim Opel 34 58 61 47
10 Darmstadt 98 Darmstadt 34 54 71 47
11 Bayern Hof Bayern Hof 34 71 63 46
12 TSV Schwaben Augsburg Schwaben 34 66 62 46
13 FSV Frankfurt Frankfurt 34 61 76 46
14 VfR Mannheim Mannheim 34 55 60 43
15 ESV Ingolstadt Ingolstadt 34 63 75 41
16 Freiburger FC Freiburger 34 55 59 40
17 Weiden Weiden 34 51 64 37
18 CfR Pforzheim Pforzheim 34 45 122 15
Ver
TEMPORADA 1964/1965
Equipo PJ GF GC Puntos
1 Bayern München Bayern 36 146 32 79
2 Reutlingen Reutlingen 36 87 45 75
3 Kickers Offenbach FC Kickers 36 91 63 67
4 Waldhof Mannheim Waldhof 36 74 50 65
5 Hessen Kassel Hessen 36 74 52 57
6 VfR Mannheim Mannheim 36 66 53 55
7 Greuther Fürth Greuther 36 72 62 55
8 Stuttgarter Kickers Stuttgarter 36 69 59 55
9 Bayern Hof Bayern Hof 36 65 58 52
10 FSV Frankfurt Frankfurt 36 52 59 51
11 Ingolstadt 04 Ingolstadt 36 55 65 47
12 Schweinfurt Schweinfurt 36 49 55 46
13 Freiburger FC Freiburger 36 60 68 46
14 Pforzheim Pforzheim 36 47 61 46
15 Darmstadt 98 Darmstadt 36 49 66 44
16 TSV Schwaben Augsburg Schwaben 36 61 73 41
17 Wacker München Wacker 36 54 86 37
18 Ulm Ulm 36 53 90 33
19 FC Emmendingen Emmendingen 36 31 158 5
Ver
TEMPORADA 1963/1964
Equipo PJ GF GC Puntos
1 Alemannia Aachen Alemannia 38 105 37 86
2 Fortuna Düsseldorf Fortuna 38 85 50 72
3 Wuppertaler SV Wuppertaler 38 66 36 71
4 Marl Hüls Marl Hüls 38 56 41 68
5 Viktoria Köln Viktoria 38 77 53 64
6 Westfalia Herne Westfalia 38 69 63 59
7 B. Mönchengladbach Mönchenglad 38 71 47 58
8 Rot-Weiß Oberhausen Rot-Weiß 38 68 58 58
9 Duisburger Duisburger 38 54 55 52
10 Arminia Bielefeld Arminia 38 65 74 52
11 Rot-Weiss Essen Rot-Weiss 38 70 64 51
12 B. Leverkusen Leverkusen 38 62 62 48
13 Schwarz-Weiss Essen Schwarz-Weis 38 60 71 47
14 Hamborn Hamborn 38 49 71 46
15 SpVgg Herten SpVgg Herten 38 55 79 43
16 STV Horst Emscher Horst 38 56 75 42
17 VfB Bottrop VfB Bottrop 38 53 68 41
18 Siegen Sportfreunde Siegen 38 69 85 38
19 Eintracht Duisburg 1848 Eintracht 38 47 88 31
20 Lüner Lüner 38 41 101 23

  USO DE MEMORIA  
6,003,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0982
Total Execution Time  0.1002
  CADENA URL  
/bundesliga_41970/grupo2/historico
  GET DATOS  
$_GET['/bundesliga_41970/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0018  SELECT type FROM routes WHERE alias = 'bundesliga_41970'
0.0043  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 = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1970 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=178 ORDER BY order_id ASC
0.0024  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 178 GROUP BY l.categoryId
0.0025  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=178 GROUP BY l.year ORDER BY l.year DESC
0.0022  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 = 22833 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 178 AND group_code = 2 and tables = 1 AND year <= 1970 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0027  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 = 22833 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 `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 = 22839 AND t.round = 30 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 `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 = 22878 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 22855 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 22865 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 22897 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 22889 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-10 00:30:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-10 00:30:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-10 00:30:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-10 00:30:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026  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 = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1970 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0027  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 events1970 e ON e.player_id = p.id AND e.league_id = 22833 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 22833 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.0022  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 events1970 e ON e.player_id = p.id AND e.league_id = 22833 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 22833 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0023  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 events1970 e ON e.player_id = p.id AND e.league_id = 22833 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 22833 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0099  SELECT *,(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 = 22833 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC