4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Bundesliga 1986
1985/1986

Bundesliga 1986

  • Werder Bremen
  • Bayern München
  • B. Mönchengladbach
  • KFC Uerdingen 05
  • Stuttgart
  • Hamburger SV
  • B. Leverkusen
  • Waldhof Mannheim
  • Schalke 04
  • VfL Bochum
  • Köln
  • Nürnberg
  • B. Dortmund
  • Eintracht Frankfurt
  • Kaiserslautern
  • Fortuna Düsseldorf
  • 1. FC Saarbrücken
  • Hannover 96

Bundesliga 1986

La temporada finalizó el Sábado, 26 Abril 1986.
 
04 Abr 86
Finalizado
Werder Bremen Werder Bremen 5-0 B. Leverkusen B. Leverkusen más información Jugadas destacadas ...
23' B. Pezzey 1-0
29' Manfred Burgsmüller 2-0
56' Günter Hermann 3-0
64' Manfred Burgsmüller 4-0
88' Neubarth 5-0
 
05 Abr 86
Finalizado
Schalke 04 Schalke 04 4-2 VfL Bochum VfL Bochum más información Jugadas destacadas ...
0-1 28' Uwe Wegmann
53' Michael Skibbe 1-1
62' Mathias Schipper 2-1
75' Regenbogen 3-1
3-2 80' S. Kuntz
81' Klaus Täuber 4-2
 
05 Abr 86
Finalizado
B. Mönchengladbach B. Mönchengladbach 2-1 B. Dortmund B. Dortmund más información Jugadas destacadas ...
25' F. Mill 1-0
33' B. Krauss 2-0
2-1 50' Bernd Storck
60' E. Thorstvedt
 
05 Abr 86
Finalizado
Bayern München Bayern München 5-0 Kaiserslautern Kaiserslautern más información Jugadas destacadas ...
15' S. Lerby 1-0
22' Holger Willmer 2-0
34' S. Lerby 3-0
37' Roland Wohlfarth 4-0
57' M. Rummenigge 5-0
 
05 Abr 86
Finalizado
Hannover 96 Hannover 96 1-1 Waldhof Mannheim Waldhof Mannheim más información Jugadas destacadas ...
25' Martin Giesel 1-0
1-1 50' Günter Sebert
 
05 Abr 86
Finalizado
Hamburger SV Hamburger SV 2-1 Nürnberg Nürnberg más información Jugadas destacadas ...
2' Michael Schröder 1-0
17' Heinz Gründel 2-0
2-1 29' Fred Klaus
 
05 Abr 86
Finalizado
1. FC Saarbrücken 1. FC Saarbrücken 1-1 Fortuna Düsseldorf Fortuna Düsseldorf más información Jugadas destacadas ...
1' Stefan Jambo 1-0
1-1 58' Sven Demandt
 
05 Abr 86
Finalizado
Köln Köln 1-1 KFC Uerdingen 05 KFC Uerdingen 05 más información Jugadas destacadas ...
0-1 6' Wolfgang Funkel
7' U. Bein 1-1
 
05 Abr 86
15:30 Finalizado
Stuttgart Stuttgart 2-1 Eintracht Frankfurt Eintracht Frankfurt más información Jugadas destacadas ...
3' P. Pašić 1-0
7' Michael Nushöhr 2-0
2-1 72' K. Theiss
82' Armin Kraaz
Equipos Puntos J. G. E. P. F. C. Forma
1 Werder Bremen Werder Bremen 47 30 20 7 3 81 37
  • EMPATE
  • Werder Bremen 0
  • VfL Bochum 0
  • VICTORIA
  • Eintracht Frankfur. 0
  • Werder Bremen 2
  • VICTORIA
  • Werder Bremen 2
  • Kaiserslautern 0
  • EMPATE
  • B. Dortmund 1
  • Werder Bremen 1
  • VICTORIA
  • Werder Bremen 5
  • B. Leverkusen 0
2 Bayern München Bayern München 43 30 19 5 6 73 31
  • DERROTA
  • Bayern München 2
  • Fortuna Düsseldorf 3
  • VICTORIA
  • Waldhof Mannheim 0
  • Bayern München 4
  • VICTORIA
  • Bayern München 6
  • VfL Bochum 1
  • EMPATE
  • Eintracht Frankfur. 2
  • Bayern München 2
  • VICTORIA
  • Bayern München 5
  • Kaiserslautern 0
3 B. Mönchengladbach Mönchengladbach 41 30 15 11 4 62 39
  • EMPATE
  • B. Mönchengladbach 1
  • Waldhof Mannheim 1
  • EMPATE
  • VfL Bochum 2
  • B. Mönchengladbach 2
  • EMPATE
  • B. Mönchengladbach 1
  • Eintracht Frankfur. 1
  • EMPATE
  • Kaiserslautern 1
  • B. Mönchengladbach 1
  • VICTORIA
  • B. Mönchengladbach 2
  • B. Dortmund 1
4 KFC Uerdingen 05 Uerdingen 37 30 15 7 8 49 55
  • VICTORIA
  • 1. FC Saarbrücken 1
  • KFC Uerdingen 05 2
  • VICTORIA
  • KFC Uerdingen 05 2
  • B. Dortmund 0
  • VICTORIA
  • Hamburger SV 1
  • KFC Uerdingen 05 4
  • VICTORIA
  • KFC Uerdingen 05 2
  • B. Leverkusen 1
  • EMPATE
  • Köln 1
  • KFC Uerdingen 05 1
5 Stuttgart Stuttgart 36 30 15 6 9 60 40
  • VICTORIA
  • Stuttgart 3
  • Nürnberg 1
  • VICTORIA
  • Fortuna Düsseldorf 0
  • Stuttgart 7
  • VICTORIA
  • Stuttgart 3
  • Waldhof Mannheim 1
  • VICTORIA
  • VfL Bochum 0
  • Stuttgart 2
  • VICTORIA
  • Stuttgart 2
  • Eintracht Frankfur. 1
6 Hamburger SV Hamburger SV 35 30 15 5 10 47 30
  • VICTORIA
  • Hannover 96 0
  • Hamburger SV 2
  • VICTORIA
  • Hamburger SV 4
  • 1. FC Saarbrücken 0
  • DERROTA
  • Hamburger SV 1
  • KFC Uerdingen 05 4
  • EMPATE
  • Köln 1
  • Hamburger SV 1
  • VICTORIA
  • Hamburger SV 2
  • Nürnberg 1
7 B. Leverkusen B. Leverkusen 34 30 13 8 9 56 47
  • VICTORIA
  • B. Leverkusen 2
  • Eintracht Frankfur. 0
  • DERROTA
  • Kaiserslautern 4
  • B. Leverkusen 1
  • VICTORIA
  • B. Leverkusen 2
  • B. Dortmund 1
  • DERROTA
  • KFC Uerdingen 05 2
  • B. Leverkusen 1
  • DERROTA
  • Werder Bremen 5
  • B. Leverkusen 0
8 Waldhof Mannheim Waldhof Mannheim 30 30 10 10 10 39 38
  • EMPATE
  • B. Mönchengladbach 1
  • Waldhof Mannheim 1
  • DERROTA
  • Waldhof Mannheim 0
  • Bayern München 4
  • DERROTA
  • Stuttgart 3
  • Waldhof Mannheim 1
  • VICTORIA
  • Waldhof Mannheim 3
  • Schalke 04 0
  • EMPATE
  • Hannover 96 1
  • Waldhof Mannheim 1
9 Schalke 04 Schalke 04 28 30 11 6 13 48 49
  • VICTORIA
  • Schalke 04 3
  • Köln 0
  • DERROTA
  • Nürnberg 3
  • Schalke 04 1
  • EMPATE
  • Schalke 04 1
  • Fortuna Düsseldorf 1
  • DERROTA
  • Waldhof Mannheim 3
  • Schalke 04 0
  • VICTORIA
  • Schalke 04 4
  • VfL Bochum 2
10 VfL Bochum VfL Bochum 26 30 11 4 15 49 52
  • EMPATE
  • Werder Bremen 0
  • VfL Bochum 0
  • EMPATE
  • VfL Bochum 2
  • B. Mönchengladbach 2
  • DERROTA
  • Bayern München 6
  • VfL Bochum 1
  • DERROTA
  • VfL Bochum 0
  • Stuttgart 2
  • DERROTA
  • Schalke 04 4
  • VfL Bochum 2
11 Köln Köln 26 30 8 10 12 41 52
  • DERROTA
  • Schalke 04 3
  • Köln 0
  • VICTORIA
  • Köln 3
  • Hannover 96 0
  • VICTORIA
  • 1. FC Saarbrücken 1
  • Köln 2
  • EMPATE
  • Köln 1
  • Hamburger SV 1
  • EMPATE
  • Köln 1
  • KFC Uerdingen 05 1
12 Nürnberg Nürnberg 25 30 10 5 15 43 46
  • DERROTA
  • Stuttgart 3
  • Nürnberg 1
  • VICTORIA
  • Nürnberg 3
  • Schalke 04 1
  • VICTORIA
  • Hannover 96 0
  • Nürnberg 2
  • VICTORIA
  • Nürnberg 2
  • 1. FC Saarbrücken 0
  • DERROTA
  • Hamburger SV 2
  • Nürnberg 1
13 B. Dortmund B. Dortmund 25 30 9 7 14 44 56
  • VICTORIA
  • B. Dortmund 4
  • Kaiserslautern 2
  • DERROTA
  • KFC Uerdingen 05 2
  • B. Dortmund 0
  • DERROTA
  • B. Leverkusen 2
  • B. Dortmund 1
  • EMPATE
  • B. Dortmund 1
  • Werder Bremen 1
  • DERROTA
  • B. Mönchengladbach 2
  • B. Dortmund 1
14 Eintracht Frankfurt Eintracht 25 30 6 13 11 31 45
  • DERROTA
  • B. Leverkusen 2
  • Eintracht Frankfur. 0
  • DERROTA
  • Eintracht Frankfur. 0
  • Werder Bremen 2
  • EMPATE
  • B. Mönchengladbach 1
  • Eintracht Frankfur. 1
  • EMPATE
  • Eintracht Frankfur. 2
  • Bayern München 2
  • DERROTA
  • Stuttgart 2
  • Eintracht Frankfur. 1
15 Kaiserslautern Kaiserslautern 23 30 7 9 14 37 50
  • DERROTA
  • B. Dortmund 4
  • Kaiserslautern 2
  • VICTORIA
  • Kaiserslautern 4
  • B. Leverkusen 1
  • DERROTA
  • Werder Bremen 2
  • Kaiserslautern 0
  • EMPATE
  • Kaiserslautern 1
  • B. Mönchengladbach 1
  • DERROTA
  • Bayern München 5
  • Kaiserslautern 0
16 Fortuna Düsseldorf Fortuna 23 30 8 7 15 44 70
  • VICTORIA
  • Bayern München 2
  • Fortuna Düsseldorf 3
  • DERROTA
  • Fortuna Düsseldorf 0
  • Stuttgart 7
  • EMPATE
  • Schalke 04 1
  • Fortuna Düsseldorf 1
  • EMPATE
  • Fortuna Düsseldorf 2
  • Hannover 96 2
  • EMPATE
  • 1. FC Saarbrücken 1
  • Fortuna Düsseldorf 1
17 1. FC Saarbrücken Saarbrücken 19 30 5 9 16 36 59
  • DERROTA
  • 1. FC Saarbrücken 1
  • KFC Uerdingen 05 2
  • DERROTA
  • Hamburger SV 4
  • 1. FC Saarbrücken 0
  • DERROTA
  • 1. FC Saarbrücken 1
  • Köln 2
  • DERROTA
  • Nürnberg 2
  • 1. FC Saarbrücken 0
  • EMPATE
  • 1. FC Saarbrücken 1
  • Fortuna Düsseldorf 1
18 Hannover 96 Hannover 96 17 30 5 7 18 40 84
  • DERROTA
  • Hannover 96 0
  • Hamburger SV 2
  • DERROTA
  • Köln 3
  • Hannover 96 0
  • DERROTA
  • Hannover 96 0
  • Nürnberg 2
  • EMPATE
  • Fortuna Düsseldorf 2
  • Hannover 96 2
  • EMPATE
  • Hannover 96 1
  • Waldhof Mannheim 1
Copa de Europa : Werder Bremen
UEFA : Bayern München, Mönchengladbach, Uerdingen, Hamburger SV
Recopa : Stuttgart
Playoff Descenso : Fortuna
Descenso : Saarbrücken, Hannover 96

La Bundesliga es la competición entre los equipos de fútbol de la máxima categoría de Alemania.

En la Bundesliga el llamado clásico enfrenta al Bayern Munich contra el Werder Bremen. También existe otro clásico, entre el Schalke 04 contra el Borussia Dortmund, este es por razones geograficas. Otro clasico es el llamado clasico del sur y el norte, es el del Bayern Munich contra el Hamburgo SV.


  USO DE MEMORIA  
6,243,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.4241
Total Execution Time  0.4265
  CADENA URL  
/bundesliga1986/grupo1/jornada30
  GET DATOS  
$_GET['/bundesliga1986/grupo1/jornada30']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0125  SELECT type FROM routes WHERE alias = 'bundesliga1986'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bundesliga' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1986 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0127  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 = 5448 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='1986' WHERE c.parentId=8 GROUP BY c.id ORDER BY c.order_id ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 07:58:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-02 07:58:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-02 07:58:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-02 07:58:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bundesliga' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1986 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0126  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=5448 AND rel.round=30
0.0125  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 5448 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0125  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 5448 AND esl.points > 0
0.0124  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-04-02" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 5448 ORDER BY creation_date DESC LIMIT 0, 10
0.0129  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-04-02" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 5448
0.0136  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars1986` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 5448 AND c.`round` = 30 ORDER BY shedule ASC LIMIT 200
0.0158  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events1986 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1986 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 5448 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (948,949,950,952,953,954,955,956,951) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0126  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events1986` e INNER JOIN calendars1986 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 30 AND e.real_date IS NOT NULL AND e.league_id = 5448 ORDER BY total DESC LIMIT 40
0.0129  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events1986` e INNER JOIN calendars1986 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 5448 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0137  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 `tables1986` 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 = 5448 AND t.round = 29 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1986` 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 = 5448 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT distinct(shedule), round FROM `calendars1986` as c WHERE c.`league_id` = 5448 AND shedule >= '1986/04/01' AND shedule < '1986/05/01' ORDER BY shedule ASC
0.0124  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-05-02 00:00:00' AND c.`shedule` < '2024-05-06 23:59:59' AND l.id = 5448 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0127  SELECT data1, data2 FROM services_tags WHERE categoryId=8
0.0127  SELECT group_code, extraName from `leagues` WHERE categoryId=8 AND year=1986