4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1980/1981
Equipo PJ GF GC Puntos
1 Darmstadt 98 Darmstadt 38 85 42 55
2 Kickers Offenbach FC Kickers 38 87 42 50
3 Stuttgarter Kickers Stuttgarter 38 81 40 48
4 Hessen Kassel Hessen 38 59 35 48
5 Ulm Ulm 38 59 39 47
6 Waldhof Mannheim Waldhof 38 65 43 45
7 SC Freiburg SC Freiburg 38 57 50 41
8 Eintracht Trier Eintracht 38 56 52 41
9 Bayreuth SpVgg Bayreuth 38 60 53 39
10 Freiburger FC Freiburger 38 76 75 39
11 FC 08 Homburg Homburg 38 66 69 38
12 Wormatia Worms Wormatia 38 60 70 37
13 VfR Bürstadt Bürstadt 38 54 66 37
14 Greuther Fürth Greuther 38 54 54 35
15 FSV Frankfurt Frankfurt 38 51 76 32
16 ESV Ingolstadt Ingolstadt 38 62 92 31
17 1. FC Saarbrücken Saarbrücken 38 43 61 28
18 FC Augsburg FC Augsburg 38 55 88 24
19 Borussia Neunkirchen Borussia 38 44 85 23
20 VfB Eppingen Eppingen 38 44 86 22
Ver
TEMPORADA 1979/1980
Equipo PJ GF GC Puntos
1 Nürnberg Nürnberg 40 88 38 61
2 Karlsruher SC Karlsruher 40 104 52 59
3 Stuttgarter Kickers Stuttgarter 40 94 54 52
4 Darmstadt 98 Darmstadt 40 81 42 48
5 1. FC Saarbrücken Saarbrücken 40 69 56 47
6 SC Freiburg SC Freiburg 40 68 54 46
7 Greuther Fürth Greuther 40 56 51 44
8 Kickers Offenbach FC Kickers 40 78 64 43
9 Freiburger FC Freiburger 40 78 83 43
10 Wormatia Worms Wormatia 40 67 73 38
11 Waldhof Mannheim Waldhof 40 57 69 38
12 FC 08 Homburg Homburg 40 58 62 37
13 Bayreuth SpVgg Bayreuth 40 77 82 37
14 VfR Bürstadt Bürstadt 40 57 68 37
15 Eintracht Trier Eintracht 40 60 57 36
16 Ulm Ulm 40 51 57 36
17 ESV Ingolstadt Ingolstadt 40 57 89 34
18 FSV Frankfurt Frankfurt 40 63 97 32
19 MTV Ingolstadt Ingolstadt 40 58 81 29
20 Rochling Volklingen Rochling 40 49 101 22
21 Würzburger FV Würzburger 40 42 82 21
Ver
TEMPORADA 1978/1979
Equipo PJ GF GC Puntos
1 1860 München 1860 38 75 38 53
2 Bayreuth SpVgg Bayreuth 38 86 53 52
3 Wormatia Worms Wormatia 38 66 33 50
4 Greuther Fürth Greuther 38 66 45 49
5 Karlsruher SC Karlsruher 38 77 50 47
6 Kickers Offenbach FC Kickers 38 86 62 43
7 FC 08 Homburg Homburg 38 65 47 43
8 1. FC Saarbrücken Saarbrücken 38 70 58 41
9 Stuttgarter Kickers Stuttgarter 38 68 59 41
10 Eintracht Trier Eintracht 38 58 57 36
11 MTV Ingolstadt Ingolstadt 38 62 82 35
12 FSV Frankfurt Frankfurt 38 59 66 34
13 Freiburger FC Freiburger 38 58 75 33
14 Würzburger FV Würzburger 38 40 62 33
15 SC Freiburg SC Freiburg 38 51 75 32
16 Waldhof Mannheim Waldhof 38 46 56 31
17 FC Hanau 93 FC Hanau 93 38 72 98 29
18 FC Augsburg FC Augsburg 38 55 89 28
19 KSV Baunatal Baunatal 38 49 67 26
20 Borussia Neunkirchen Borussia 38 47 84 24
Ver
TEMPORADA 1977/1978
Equipo PJ GF GC Puntos
1 Darmstadt 98 Darmstadt 38 90 43 58
2 Nürnberg Nürnberg 38 75 46 53
3 FC 08 Homburg Homburg 38 65 45 49
4 Bayreuth SpVgg Bayreuth 38 79 50 48
5 Kickers Offenbach FC Kickers 38 88 54 46
6 Greuther Fürth Greuther 38 73 42 46
7 Karlsruher SC Karlsruher 38 76 54 45
8 Waldhof Mannheim Waldhof 38 76 50 42
9 Wormatia Worms Wormatia 38 63 56 42
10 Stuttgarter Kickers Stuttgarter 38 63 71 40
11 Würzburger FV Würzburger 38 52 53 38
12 Eintracht Trier Eintracht 38 58 64 35
13 Freiburger FC Freiburger 38 58 71 35
14 FC Augsburg FC Augsburg 38 57 54 34
15 FSV Frankfurt Frankfurt 38 54 62 34
16 KSV Baunatal Baunatal 38 55 80 34
17 Bayern Hof Bayern Hof 38 45 62 33
18 VfR Bürstadt Bürstadt 38 48 68 25
19 Würzburger Kickers Würzburger 38 38 93 17
20 FK Pirmasens Pirmasens 38 25 120 6
Ver
TEMPORADA 1976/1977
Equipo PJ GF GC Puntos
1 Stuttgart Stuttgart 38 100 36 57
2 1860 München 1860 38 78 29 56
3 Kickers Offenbach FC Kickers 38 86 52 53
4 FC 08 Homburg Homburg 38 84 56 49
5 Nürnberg Nürnberg 38 77 51 49
6 Darmstadt 98 Darmstadt 38 68 48 46
7 FSV Frankfurt Frankfurt 38 65 58 40
8 Greuther Fürth Greuther 38 55 51 40
9 FC Augsburg FC Augsburg 38 72 73 40
10 Stuttgarter Kickers Stuttgarter 38 59 53 39
11 Waldhof Mannheim Waldhof 38 70 57 37
12 Bayern Hof Bayern Hof 38 61 53 37
13 Würzburger FV Würzburger 38 49 81 37
14 Bayreuth SpVgg Bayreuth 38 60 64 34
15 KSV Baunatal Baunatal 38 64 82 33
16 Rochling Volklingen Rochling 38 47 71 32
17 Eintracht Trier Eintracht 38 46 68 28
18 FK Pirmasens Pirmasens 38 43 85 19
19 Jahn Regensburg Jahn 38 42 87 19
20 BSV Schwenningen Schwenningen 38 31 102 15
Ver
TEMPORADA 1975/1976
Equipo PJ GF GC Puntos
1 1. FC Saarbrücken Saarbrücken 38 66 28 57
2 Nürnberg Nürnberg 38 78 42 54
3 FC 08 Homburg Homburg 38 72 41 51
4 1860 München 1860 38 78 55 47
5 Bayreuth SpVgg Bayreuth 38 71 55 47
6 Rochling Volklingen Rochling 38 72 65 45
7 Darmstadt 98 Darmstadt 38 76 64 43
8 Waldhof Mannheim Waldhof 38 64 55 42
9 Bayern Hof Bayern Hof 38 60 56 41
10 Greuther Fürth Greuther 38 64 52 37
11 Stuttgart Stuttgart 38 67 60 36
12 Mainz 05 Mainz 05 38 81 92 36
13 FSV Frankfurt Frankfurt 38 49 63 35
14 FK Pirmasens Pirmasens 38 66 78 33
15 FC Augsburg FC Augsburg 38 57 56 32
16 Stuttgarter Kickers Stuttgarter 38 57 70 32
17 Jahn Regensburg Jahn 38 48 74 30
18 Schweinfurt Schweinfurt 38 50 72 26
19 Eintracht Bad Kreuznach Eintracht 38 49 83 23
20 Reutlingen Reutlingen 38 35 99 13
Ver
TEMPORADA 1974/1975
Equipo PJ GF GC Puntos
1 Karlsruher SC Karlsruher 38 76 50 50
2 FK Pirmasens Pirmasens 38 75 62 48
3 Schweinfurt Schweinfurt 38 65 59 48
4 Bayern Hof Bayern Hof 38 65 46 46
5 1860 München 1860 38 64 45 45
6 Nürnberg Nürnberg 38 70 52 42
7 1. FC Saarbrücken Saarbrücken 38 72 52 41
8 Waldhof Mannheim Waldhof 38 52 42 40
9 Bayreuth SpVgg Bayreuth 38 53 50 40
10 Darmstadt 98 Darmstadt 38 68 62 39
11 Mainz 05 Mainz 05 38 63 60 38
12 FC Augsburg FC Augsburg 38 61 63 37
13 Rochling Volklingen Rochling 38 56 54 34
14 FC 08 Homburg Homburg 38 71 74 34
15 Greuther Fürth Greuther 38 40 48 34
16 Stuttgarter Kickers Stuttgarter 38 52 61 33
17 VfR Heilbronn Heilbronn 38 51 78 30
18 Borussia Neunkirchen Borussia 38 49 73 28
19 Wormatia Worms Wormatia 38 36 66 27
20 VfR Mannheim Mannheim 38 43 85 26

  USO DE MEMORIA  
6,320,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1472
Total Execution Time  0.1492
  CADENA URL  
/bundesliga_21981/grupo1/historico
  GET DATOS  
$_GET['/bundesliga_21981/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0018  SELECT type FROM routes WHERE alias = 'bundesliga_21981'
0.0042  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 = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1981 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=93 AND type_rel = 3
0.0027  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 93 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1307337,1306185,1305334,1303172,1302528) ORDER BY n.cover_points DESC, update_date DESC
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=93 ORDER BY order_id ASC
0.0021  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 = 9889 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 93 AND group_code = 1 and tables = 1 AND year <= 1981 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0033  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 `tables1981` 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 = 9889 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables1980` 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 = 9903 AND t.round = 42 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 `tables1979` 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 = 9912 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 `tables1978` 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 = 9920 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 `tables1977` 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 = 9925 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 `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 = 9927 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 `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 = 9930 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-06 01:38:36' 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-06 01:38:36' 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-06 01:38:36' 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-06 01:38:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  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 = 1981 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0228  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 events1981 e ON e.player_id = p.id AND e.league_id = 9889 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9889 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.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 events1981 e ON e.player_id = p.id AND e.league_id = 9889 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9889 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0089  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 events1981 e ON e.player_id = p.id AND e.league_id = 9889 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9889 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0048  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1981` 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 = 9889 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC