Publicidad 600x120.gif
3. Liga 2018
2017/2018

3. Liga 2018

  • Magdeburg
  • Paderborn
  • Karlsruher SC
  • Wehen Wiesbaden
  • Würzburger Kickers
  • Hansa Rostock
  • SV Meppen
  • Fortuna Köln
  • Unterhaching
  • Preußen Münster
  • FC Carl Zeiss Jena
  • VfR Aalen
  • Hallescher FC
  • SG Sonnenhof Großaspach
  • Zwickau
  • Sportfreunde Lotte
  • VfL Osnabrück
  • Werder Bremen II
  • Chemnitzer
  • Rot-Weiss Erfurt

3. Liga 2018

La temporada finalizó el Sábado, 12 Mayo 2018.
 
12 May 18
13:30 Finalizado
Unterhaching Unterhaching 4-1 VfL Osnabrück VfL Osnabrück más información Jugadas destacadas ...
7' M. Nicu 1-0
31' Jim Müller 2-0
2-1 52' J. Tepe
57' Jim Müller 3-1
89' S. Hain 4-1
 
12 May 18
13:30 Finalizado
Karlsruher SC Karlsruher SC 2-3 FC Carl Zeiss Jena FC Carl Zeiss Jena más información Jugadas destacadas ...
1' M. Pourie 1-0
1-1 27' T. Thiele
1-2 41' J. Schmidt
60' M. Wanitzek 2-2
2-3 80' D. Bock
 
12 May 18
13:30 Finalizado
Wehen Wiesbaden Wehen Wiesbaden 2-0 VfR Aalen VfR Aalen más información Jugadas destacadas ...
27' S. Brandstetter 1-0
29' Robert Andrich 2-0
 
12 May 18
13:30 Finalizado
Fortuna Köln Fortuna Köln 2-4 Paderborn Paderborn más información Jugadas destacadas ...
0-1 25' Marlon Ritter
37' D. Keita-Ruel 1-1
60' H. Dahmani 2-1
2-2 63' C. Antwi-Adjej
2-3 73' Marlon Ritter
2-4 87' Marlon Ritter
 
12 May 18
13:30 Finalizado
Hallescher FC Hallescher FC 2-0 Zwickau Zwickau más información Jugadas destacadas ...
11' M. Röser 1-0
25' S. Kleineheismann 2-0
 
12 May 18
13:30 Finalizado
Chemnitzer Chemnitzer 1-1 Hansa Rostock Hansa Rostock más información Jugadas destacadas ...
0-1 4' P. Breier
90' Myroslav Slavov 1-1
 
12 May 18
13:30 Finalizado
Sportfreunde Lotte Sportfreunde Lotte 0-1 Magdeburg Magdeburg más información Jugadas destacadas 2
0-1 88' Butzen
 
12 May 18
13:30 Finalizado
SG Sonnenhof Großaspach Sonnenhof Großaspach 2-2 Preußen Münster Preußen Münster más información Jugadas destacadas ...
26' Özgür Özdemir 1-0
1-1 38' N. Rinderknecht
1-2 50' P. Hoffmann
66' P. Sohm 2-2
 
12 May 18
13:30 Finalizado
Rot-Weiss Erfurt Rot-Weiss Erfurt 1-3 Würzburger Kickers Würzburger Kickers más información Jugadas destacadas ...
4' E. Huth 1-0
1-1 22' O. Ademi
1-2 54' S. Skarlatidis
1-3 86' D. Baumann
 
12 May 18
13:30 Finalizado
Werder Bremen II Werder Bremen II 2-1 SV Meppen SV Meppen más información Jugadas destacadas ...
7' J. Eilers 1-0
1-1 47' B. Girth
74' R. Kazior 2-1
Equipos Puntos J. G. E. P. F. C. Forma
1 Magdeburg Magdeburg 85 38 27 4 7 70 32
  • VICTORIA
  • Wehen Wiesbaden 1
  • Magdeburg 2
  • VICTORIA
  • Magdeburg 2
  • Fortuna Köln 0
  • VICTORIA
  • Hallescher FC 0
  • Magdeburg 2
  • VICTORIA
  • Magdeburg 3
  • Chemnitzer 1
  • VICTORIA
  • Sportfreunde Lotte 0
  • Magdeburg 1
2 Paderborn Paderborn 83 38 25 8 5 90 33
  • VICTORIA
  • VfL Osnabrück 0
  • Paderborn 5
  • VICTORIA
  • Paderborn 3
  • Unterhaching 0
  • EMPATE
  • Karlsruher SC 0
  • Paderborn 0
  • VICTORIA
  • Paderborn 3
  • Wehen Wiesbaden 1
  • VICTORIA
  • Fortuna Köln 2
  • Paderborn 4
3 Karlsruher SC Karlsruher SC 69 38 19 12 7 49 29
  • EMPATE
  • Karlsruher SC 0
  • Hansa Rostock 0
  • VICTORIA
  • Zwickau 2
  • Karlsruher SC 4
  • EMPATE
  • Karlsruher SC 0
  • Paderborn 0
  • VICTORIA
  • VfR Aalen 0
  • Karlsruher SC 2
  • DERROTA
  • Karlsruher SC 2
  • FC Carl Zeiss Jena 3
4 Wehen Wiesbaden Wehen Wiesbaden 68 38 21 5 12 76 39
  • DERROTA
  • Wehen Wiesbaden 1
  • Magdeburg 2
  • DERROTA
  • Hansa Rostock 2
  • Wehen Wiesbaden 0
  • VICTORIA
  • Wehen Wiesbaden 3
  • Zwickau 0
  • DERROTA
  • Paderborn 3
  • Wehen Wiesbaden 1
  • VICTORIA
  • Wehen Wiesbaden 2
  • VfR Aalen 0
5 Würzburger Kickers Würzburger 61 38 17 10 11 53 46
  • VICTORIA
  • Hallescher FC 1
  • Würzburger Kickers 3
  • EMPATE
  • Würzburger Kickers 0
  • Chemnitzer 0
  • VICTORIA
  • Sportfreunde Lotte 1
  • Würzburger Kickers 3
  • EMPATE
  • Würzburger Kickers 1
  • SG Sonnenhof Großa. 1
  • VICTORIA
  • Rot-Weiss Erfurt 1
  • Würzburger Kickers 3
6 Hansa Rostock Hansa Rostock 60 38 16 12 10 48 34
  • EMPATE
  • Karlsruher SC 0
  • Hansa Rostock 0
  • VICTORIA
  • Hansa Rostock 2
  • Wehen Wiesbaden 0
  • EMPATE
  • Fortuna Köln 0
  • Hansa Rostock 0
  • VICTORIA
  • Hansa Rostock 4
  • Hallescher FC 2
  • EMPATE
  • Chemnitzer 1
  • Hansa Rostock 1
7 SV Meppen SV Meppen 58 38 15 13 10 50 47
  • VICTORIA
  • Chemnitzer 1
  • SV Meppen 2
  • VICTORIA
  • SV Meppen 2
  • Sportfreunde Lotte 1
  • VICTORIA
  • SG Sonnenhof Großa. 2
  • SV Meppen 3
  • VICTORIA
  • SV Meppen 3
  • Rot-Weiss Erfurt 0
  • DERROTA
  • Werder Bremen II 2
  • SV Meppen 1
8 Fortuna Köln Fortuna Köln 54 38 15 9 14 53 48
  • DERROTA
  • Fortuna Köln 2
  • Preußen Münster 4
  • DERROTA
  • Magdeburg 2
  • Fortuna Köln 0
  • EMPATE
  • Fortuna Köln 0
  • Hansa Rostock 0
  • DERROTA
  • Zwickau 1
  • Fortuna Köln 0
  • DERROTA
  • Fortuna Köln 2
  • Paderborn 4
9 Unterhaching Unterhaching 54 38 16 6 16 54 55
  • VICTORIA
  • Unterhaching 2
  • Zwickau 1
  • DERROTA
  • Paderborn 3
  • Unterhaching 0
  • DERROTA
  • Unterhaching 0
  • VfR Aalen 1
  • DERROTA
  • FC Carl Zeiss Jena 2
  • Unterhaching 1
  • VICTORIA
  • Unterhaching 4
  • VfL Osnabrück 1
10 Preußen Münster Preußen 52 38 14 10 14 50 49
  • VICTORIA
  • Fortuna Köln 2
  • Preußen Münster 4
  • DERROTA
  • Preußen Münster 1
  • Hallescher FC 2
  • VICTORIA
  • Chemnitzer 1
  • Preußen Münster 2
  • VICTORIA
  • Preußen Münster 3
  • Sportfreunde Lotte 0
  • EMPATE
  • SG Sonnenhof Großa. 2
  • Preußen Münster 2
11 FC Carl Zeiss Jena Carl Zeiss Jena 52 38 14 10 14 49 59
  • VICTORIA
  • FC Carl Zeiss Jena 3
  • VfR Aalen 2
  • VICTORIA
  • Werder Bremen II 2
  • FC Carl Zeiss Jena 4
  • VICTORIA
  • VfL Osnabrück 1
  • FC Carl Zeiss Jena 2
  • VICTORIA
  • FC Carl Zeiss Jena 2
  • Unterhaching 1
  • VICTORIA
  • Karlsruher SC 2
  • FC Carl Zeiss Jena 3
12 VfR Aalen VfR Aalen 50 38 13 11 14 48 57
  • DERROTA
  • FC Carl Zeiss Jena 3
  • VfR Aalen 2
  • VICTORIA
  • VfR Aalen 2
  • VfL Osnabrück 1
  • VICTORIA
  • Unterhaching 0
  • VfR Aalen 1
  • DERROTA
  • VfR Aalen 0
  • Karlsruher SC 2
  • DERROTA
  • Wehen Wiesbaden 2
  • VfR Aalen 0
13 Hallescher FC Hallescher FC 49 38 13 10 15 52 54
  • DERROTA
  • Hallescher FC 1
  • Würzburger Kickers 3
  • VICTORIA
  • Preußen Münster 1
  • Hallescher FC 2
  • DERROTA
  • Hallescher FC 0
  • Magdeburg 2
  • DERROTA
  • Hansa Rostock 4
  • Hallescher FC 2
  • VICTORIA
  • Hallescher FC 2
  • Zwickau 0
14 SG Sonnenhof Großaspach Sonnenhof 47 38 12 11 15 55 60
  • EMPATE
  • SG Sonnenhof Großa. 2
  • Werder Bremen II 2
  • VICTORIA
  • Rot-Weiss Erfurt 0
  • SG Sonnenhof Großa. 6
  • DERROTA
  • SG Sonnenhof Großa. 2
  • SV Meppen 3
  • EMPATE
  • Würzburger Kickers 1
  • SG Sonnenhof Großa. 1
  • EMPATE
  • SG Sonnenhof Großa. 2
  • Preußen Münster 2
15 Zwickau Zwickau 41 38 10 11 17 38 55
  • DERROTA
  • Unterhaching 2
  • Zwickau 1
  • DERROTA
  • Zwickau 2
  • Karlsruher SC 4
  • DERROTA
  • Wehen Wiesbaden 3
  • Zwickau 0
  • VICTORIA
  • Zwickau 1
  • Fortuna Köln 0
  • DERROTA
  • Hallescher FC 2
  • Zwickau 0
16 Sportfreunde Lotte Sportfreunde 40 38 11 7 20 43 60
  • VICTORIA
  • Sportfreunde Lotte 1
  • Rot-Weiss Erfurt 0
  • DERROTA
  • SV Meppen 2
  • Sportfreunde Lotte 1
  • DERROTA
  • Sportfreunde Lotte 1
  • Würzburger Kickers 3
  • DERROTA
  • Preußen Münster 3
  • Sportfreunde Lotte 0
  • DERROTA
  • Sportfreunde Lotte 0
  • Magdeburg 1
17 VfL Osnabrück VfL Osnabrück 37 38 8 13 17 47 67
  • DERROTA
  • VfL Osnabrück 0
  • Paderborn 5
  • DERROTA
  • VfR Aalen 2
  • VfL Osnabrück 1
  • DERROTA
  • VfL Osnabrück 1
  • FC Carl Zeiss Jena 2
  • EMPATE
  • VfL Osnabrück 1
  • Werder Bremen II 1
  • DERROTA
  • Unterhaching 4
  • VfL Osnabrück 1
18 Werder Bremen II Werder Bremen 31 38 6 13 19 39 62
  • EMPATE
  • SG Sonnenhof Großa. 2
  • Werder Bremen II 2
  • DERROTA
  • Werder Bremen II 2
  • FC Carl Zeiss Jena 4
  • VICTORIA
  • Rot-Weiss Erfurt 0
  • Werder Bremen II 3
  • EMPATE
  • VfL Osnabrück 1
  • Werder Bremen II 1
  • VICTORIA
  • Werder Bremen II 2
  • SV Meppen 1
19 Chemnitzer Chemnitzer * 22 38 8 7 23 48 74
  • DERROTA
  • Chemnitzer 1
  • SV Meppen 2
  • EMPATE
  • Würzburger Kickers 0
  • Chemnitzer 0
  • DERROTA
  • Chemnitzer 1
  • Preußen Münster 2
  • DERROTA
  • Magdeburg 3
  • Chemnitzer 1
  • EMPATE
  • Chemnitzer 1
  • Hansa Rostock 1
20 Rot-Weiss Erfurt Rot-Weiss Erfurt * 13 38 5 8 25 26 78
  • DERROTA
  • Sportfreunde Lotte 1
  • Rot-Weiss Erfurt 0
  • DERROTA
  • Rot-Weiss Erfurt 0
  • SG Sonnenhof Großa. 6
  • DERROTA
  • Rot-Weiss Erfurt 0
  • Werder Bremen II 3
  • DERROTA
  • SV Meppen 3
  • Rot-Weiss Erfurt 0
  • DERROTA
  • Rot-Weiss Erfurt 1
  • Würzburger Kickers 3
Ascenso : Magdeburg, Paderborn
Playoff Ascenso : Karlsruher SC
Descenso : Werder Bremen, Chemnitzer, Rot-Weiss Erfurt

Penalizaciones de la competición

-10 Puntos: Rot-Weiss Erfurt
-9 Puntos: Chemnitzer

INFORMACIÓN

La 3. Liga es la tercera división del fútbol en Alemania. En la jerarquía se encuentra debajo de la 2. Bundesliga y encima de la Regionalliga. Es organizada por la Federación Alemana de Fútbol (DFB).
La meta de la creación fue aumentar el nivel futbolístico de la tercera división. Los clasificados fueron los equipos que ocupaban los 8 primeros puestos de las dos divisiones de la Regionalliga y los 4 equipos descendidos de la 2. Bundesliga.


Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,637,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.0980
Total Execution Time  0.1003
  CADENA URL  
/bundesliga_32018
  GET DATOS  
$_GET['/bundesliga_32018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0018  SELECT type FROM routes WHERE alias = 'bundesliga_32018'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bundesliga_3' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
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 = 38729 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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='2018' WHERE c.parentId=94 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 06:25:31' 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-03-29 06:25:31' 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-03-29 06:25:31' 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-03-29 06:25:31' 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_3' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  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=38729 AND rel.round=38
0.0019  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 = 38729 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0018  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 = 38729 AND esl.points > 0
0.0018  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-02-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 38729 ORDER BY creation_date DESC LIMIT 0, 10
0.0024  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-02-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 38729
0.0037  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 `calendars2018` 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` = 38729 AND c.`round` = 38 ORDER BY shedule ASC LIMIT 200
0.0048  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 events2018 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2018 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 38729 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 (445834,445835,445836,445837,445838,445839,445840,445841,445842,445843) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0024  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 `events2018` e INNER JOIN calendars2018 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 = 38 AND e.real_date IS NOT NULL AND e.league_id = 38729 ORDER BY total DESC LIMIT 40
0.0051  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 `tables2018` 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 = 38729 AND t.round = 37 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` 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 = 38729 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 distinct(shedule), round FROM `calendars2018` as c WHERE c.`league_id` = 38729 AND shedule >= '2018/05/01' AND shedule < '2018/06/01' ORDER BY shedule ASC
0.0018  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-03-29 00:00:00' AND c.`shedule` < '2024-04-02 23:59:59' AND l.id = 38729 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0020  SELECT data1, data2 FROM services_tags WHERE categoryId=94
0.0020  SELECT group_code, extraName from `leagues` WHERE categoryId=94 AND year=2018