4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Holstein Kiel Holstein 30 60 34 61
2 FC St Pauli FC St Pauli 30 56 33 60
3 Fortuna Düsseldorf Fortuna 30 64 35 55
4 Hamburger SV Hamburger 30 55 42 49
5 Karlsruher SC Karlsruher 30 61 45 46
6 Hannover 96 Hannover 96 30 52 38 45
7 Hertha BSC Hertha BSC 30 62 51 44
8 Paderborn Paderborn 30 46 49 43
9 Greuther Fürth Greuther 30 40 43 42
10 SV Elversberg Elversberg 30 44 52 40
11 Nürnberg Nürnberg 30 38 56 37
12 Magdeburg Magdeburg 30 42 46 36
13 Schalke 04 Schalke 04 30 46 56 36
14 Eintracht Braunschweig Eintracht 30 33 41 34
15 Wehen Wiesbaden Wehen 30 32 41 32
16 Hansa Rostock Hansa 30 27 50 31
17 Kaiserslautern Kaiserslaute 30 46 59 30
18 VfL Osnabrück Osnabrück 30 27 60 24
TEMPORADA 2022/2023
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Heidenheim Heidenheim 34 67 36 67
2 Darmstadt 98 Darmstadt 34 50 33 67
3 Hamburger SV Hamburger 34 70 45 66
4 Fortuna Düsseldorf Fortuna 34 60 43 58
5 FC St Pauli FC St Pauli 34 55 39 58
6 Paderborn Paderborn 34 68 44 55
7 Karlsruher SC Karlsruher 34 56 53 46
8 Holstein Kiel Holstein 34 58 61 46
9 Kaiserslautern Kaiserslaute 34 47 48 45
10 Hannover 96 Hannover 96 34 50 55 44
11 Magdeburg Magdeburg 34 48 55 43
12 Greuther Fürth Greuther 34 47 50 41
13 Hansa Rostock Hansa 34 32 48 41
14 Nürnberg Nürnberg 34 32 49 39
15 Eintracht Braunschweig Eintracht 34 42 59 36
16 Arminia Bielefeld Arminia 34 50 62 34
17 Jahn Regensburg Jahn 34 34 58 31
18 Sandhausen Sandhausen 34 35 63 28
TEMPORADA 2021/2022
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Schalke 04 Schalke 04 34 72 44 65
2 Werder Bremen Werder 34 65 43 63
3 Hamburger SV Hamburger 34 67 35 60
4 Darmstadt 98 Darmstadt 34 71 46 60
5 FC St Pauli FC St Pauli 34 61 46 57
6 Heidenheim Heidenheim 34 43 45 52
7 Paderborn Paderborn 34 56 44 51
8 Nürnberg Nürnberg 34 49 49 51
9 Holstein Kiel Holstein 34 46 54 45
10 Fortuna Düsseldorf Fortuna 34 45 42 44
11 Hannover 96 Hannover 96 34 35 49 42
12 Karlsruher SC Karlsruher 34 54 55 41
13 Hansa Rostock Hansa 34 41 52 41
14 Sandhausen Sandhausen 34 42 54 41
15 Jahn Regensburg Jahn 34 50 51 40
16 Dynamo Dresden Dynamo 34 33 46 32
17 Erzgebirge Aue Erzgebirge 34 32 72 26
18 Ingolstadt 04 Ingolstadt 34 30 65 21
TEMPORADA 2020/2021
3. LIGA
Equipo PJ GF GC Puntos
1 Dynamo Dresden Dynamo 38 61 29 75
2 Hansa Rostock Hansa 38 52 33 71
3 Ingolstadt 04 Ingolstadt 38 56 40 71
4 1860 München 1860 38 69 35 66
5 1. FC Saarbrücken Saarbrücken 38 66 51 59
6 Wehen Wiesbaden Wehen 38 57 53 56
7 Verl Verl 38 66 55 55
8 Waldhof Mannheim Waldhof 38 50 55 52
9 Hallescher FC Hallescher 38 51 58 52
10 Zwickau Zwickau 38 46 45 51
11 Magdeburg Magdeburg 38 42 45 51
12 Viktoria Köln Viktoria 38 52 59 51
13 Türkgücü München Türkgücü 38 45 55 47
14 Kaiserslautern Kaiserslaute 38 47 52 43
15 MSV Duisburg Duisburg 38 52 67 43
16 KFC Uerdingen 05 Uerdingen 38 38 50 41
17 SV Meppen SV Meppen 38 37 61 41
18 Bayern München II Bayern 38 47 58 37
19 VfB Lübeck VfB Lübeck 38 41 57 35
20 Unterhaching Unterhaching 38 40 57 32
TEMPORADA 2019/2020
3. LIGA
Equipo PJ GF GC Puntos
1 Bayern München II Bayern 38 76 60 65
2 Würzburger Kickers Würzburger 38 71 60 64
3 Eintracht Braunschweig Eintracht 38 64 53 64
4 Ingolstadt 04 Ingolstadt 38 61 40 63
5 MSV Duisburg Duisburg 38 68 48 62
6 Hansa Rostock Hansa 38 54 43 59
7 SV Meppen SV Meppen 38 69 57 58
8 1860 München 1860 38 63 54 58
9 Waldhof Mannheim Waldhof 38 52 47 56
10 Kaiserslautern Kaiserslaute 38 59 54 55
11 Unterhaching Unterhaching 38 50 53 51
12 Viktoria Köln Viktoria 38 65 71 51
13 KFC Uerdingen 05 Uerdingen 38 40 54 48
14 Magdeburg Magdeburg 38 49 42 47
15 Hallescher FC Hallescher 38 64 66 46
16 Zwickau Zwickau 38 56 61 44
17 Chemnitzer Chemnitzer 38 54 60 44
18 Preußen Münster Preußen 38 49 62 40
19 SG Sonnenhof Großaspach Sonnenhof 38 33 67 32
20 FC Carl Zeiss Jena Carl Zeiss. 38 40 85 23
TEMPORADA 2018/2019
3. LIGA
Equipo PJ GF GC Puntos
1 VfL Osnabrück Osnabrück 38 56 31 76
2 Karlsruher SC Karlsruher 38 64 38 71
3 Wehen Wiesbaden Wehen 38 71 47 70
4 Hallescher FC Hallescher 38 47 34 66
5 Würzburger Kickers Würzburger 38 56 45 57
6 Hansa Rostock Hansa 38 47 46 55
7 Zwickau Zwickau 38 49 47 52
8 Preußen Münster Preußen 38 48 50 52
9 Kaiserslautern Kaiserslaute 38 49 51 51
10 KFC Uerdingen 05 Uerdingen 38 47 62 48
11 1860 München 1860 38 48 52 47
12 Unterhaching Unterhaching 37 53 46 47
13 SV Meppen SV Meppen 38 48 53 47
14 FC Carl Zeiss Jena Carl Zeiss. 38 48 57 46
15 SG Sonnenhof Großaspach Sonnenhof 38 38 39 45
16 Eintracht Braunschweig Eintracht 38 48 54 45
17 Energie Cottbus Energie 37 51 58 44
18 Sportfreunde Lotte Sportfreunde 38 31 46 40
19 Fortuna Köln Fortuna 38 38 64 39
20 VfR Aalen VfR Aalen 38 45 62 31
TEMPORADA 2017/2018
3. LIGA
Equipo PJ GF GC Puntos
1 Magdeburg Magdeburg 38 70 32 85
2 Paderborn Paderborn 38 90 33 83
3 Karlsruher SC Karlsruher 38 49 29 69
4 Wehen Wiesbaden Wehen 38 76 39 68
5 Würzburger Kickers Würzburger 38 53 46 61
6 Hansa Rostock Hansa 38 48 34 60
7 SV Meppen SV Meppen 38 50 47 58
8 Fortuna Köln Fortuna 38 53 48 54
9 Unterhaching Unterhaching 38 54 55 54
10 Preußen Münster Preußen 38 50 49 52
11 FC Carl Zeiss Jena Carl Zeiss. 38 49 59 52
12 VfR Aalen VfR Aalen 38 48 57 50
13 Hallescher FC Hallescher 38 52 54 49
14 SG Sonnenhof Großaspach Sonnenhof 38 55 60 47
15 Zwickau Zwickau 38 38 55 41
16 Sportfreunde Lotte Sportfreunde 38 43 60 40
17 VfL Osnabrück Osnabrück 38 47 67 37
18 Werder Bremen II Werder 38 39 62 31
19 Chemnitzer Chemnitzer 38 48 74 22
20 Rot-Weiss Erfurt Rot-Weiss 38 26 78 13
TEMPORADA 2016/2017
3. LIGA
Equipo PJ GF GC Puntos
1 MSV Duisburg Duisburg 38 52 32 68
2 Holstein Kiel Holstein 38 59 25 67
3 Jahn Regensburg Jahn 38 62 50 63
4 Magdeburg Magdeburg 38 53 36 61
5 Zwickau Zwickau 38 47 54 56
6 VfL Osnabrück Osnabrück 38 46 43 54
7 Wehen Wiesbaden Wehen 38 45 42 53
8 Chemnitzer Chemnitzer 38 54 51 52
9 Preußen Münster Preußen 38 49 43 51
10 SG Sonnenhof Großaspach Sonnenhof 38 48 48 51
11 VfR Aalen VfR Aalen 38 52 36 48
12 Sportfreunde Lotte Sportfreunde 38 46 47 48
13 Hallescher FC Hallescher 38 34 39 48
14 Rot-Weiss Erfurt Rot-Weiss 38 34 47 47
15 Hansa Rostock Hansa 38 44 46 46
16 Fortuna Köln Fortuna 38 37 59 46
17 Werder Bremen II Werder 38 32 48 45
18 Paderborn Paderborn 38 38 57 44
19 Mainz 05 II Mainz 05 II 38 41 58 40
20 FSV Frankfurt Frankfurt 38 38 50 25
TEMPORADA 2015/2016
3. LIGA
Equipo PJ GF GC Puntos
1 Dynamo Dresden Dynamo 38 75 35 78
2 Erzgebirge Aue Erzgebirge 38 42 21 70
3 Würzburger Kickers Würzburger 38 43 25 64
4 Magdeburg Magdeburg 38 49 37 56
5 VfL Osnabrück Osnabrück 38 46 41 56
6 Chemnitzer Chemnitzer 38 52 46 55
7 SG Sonnenhof Großaspach Sonnenhof 38 58 47 54
8 Rot-Weiss Erfurt Rot-Weiss 38 47 50 50
9 Preußen Münster Preußen 38 43 41 49
10 Hansa Rostock Hansa 38 42 48 49
11 Fortuna Köln Fortuna 38 56 69 49
12 Mainz 05 II Mainz 05 II 38 48 47 48
13 Hallescher FC Hallescher 38 48 48 48
14 Holstein Kiel Holstein 38 44 47 48
15 VfR Aalen VfR Aalen 38 35 40 44
16 Wehen Wiesbaden Wehen 38 35 48 43
17 Werder Bremen II Werder 38 42 56 43
18 Stuttgarter Kickers Stuttgarter 38 38 52 43
19 Energie Cottbus Energie 38 32 52 41
20 Stuttgart II Stuttgart 38 38 63 31
TEMPORADA 2014/2015
3. LIGA
Equipo PJ GF GC Puntos
1 Arminia Bielefeld Arminia 38 75 41 74
2 MSV Duisburg Duisburg 38 63 40 71
3 Holstein Kiel Holstein 38 53 30 67
4 Stuttgarter Kickers Stuttgarter 38 61 47 65
5 Chemnitzer Chemnitzer 38 44 36 59
6 Dynamo Dresden Dynamo 38 52 48 56
7 Energie Cottbus Energie 38 50 50 56
8 Preußen Münster Preußen 38 53 49 54
9 Wehen Wiesbaden Wehen 38 54 44 53
10 Hallescher FC Hallescher 38 51 53 53
11 VfL Osnabrück Osnabrück 38 49 51 52
12 Rot-Weiss Erfurt Rot-Weiss 38 47 54 51
13 Stuttgart II Stuttgart 38 48 57 47
14 Fortuna Köln Fortuna 38 38 47 46
15 SG Sonnenhof Großaspach Sonnenhof 38 39 60 46
16 Mainz 05 II Mainz 05 II 38 43 52 42
17 Hansa Rostock Hansa 38 54 68 41
18 B. Dortmund II Dortmund 38 41 51 39
19 Unterhaching Unterhaching 38 51 67 39
20 Jahn Regensburg Jahn 38 44 65 31
TEMPORADA 2013/2014
3. LIGA
Equipo PJ GF GC Puntos
1 Heidenheim Heidenheim 38 59 25 79
2 RB Leipzig RB Leipzig 38 65 34 79
3 Darmstadt 98 Darmstadt 38 58 29 72
4 Wehen Wiesbaden Wehen 38 43 44 56
5 VfL Osnabrück Osnabrück 38 50 39 55
6 Preußen Münster Preußen 38 55 50 53
7 MSV Duisburg Duisburg 38 43 43 52
8 Stuttgarter Kickers Stuttgarter 38 45 46 51
9 Hallescher FC Hallescher 38 50 55 51
10 Rot-Weiss Erfurt Rot-Weiss 38 53 49 50
11 Jahn Regensburg Jahn 38 51 51 49
12 Chemnitzer Chemnitzer 38 43 46 49
13 Hansa Rostock Hansa 38 45 55 49
14 B. Dortmund II Dortmund 38 47 55 46
15 Stuttgart II Stuttgart 38 45 54 46
16 Holstein Kiel Holstein 38 42 38 45
17 Unterhaching Unterhaching 38 50 65 43
18 SV Elversberg Elversberg 38 32 54 40
19 SV Wacker Burghausen Wacker 38 39 58 37
20 1. FC Saarbrücken Saarbrücken 38 38 63 32
TEMPORADA 2012/2013
3. LIGA
Equipo PJ GF GC Puntos
1 Karlsruher SC Karlsruher 38 69 27 79
2 Arminia Bielefeld Arminia 38 59 32 76
3 VfL Osnabrück Osnabrück 38 64 35 73
4 Preußen Münster Preußen 38 63 33 72
5 Heidenheim Heidenheim 38 69 47 72
6 Chemnitzer Chemnitzer 38 56 47 55
7 Wehen Wiesbaden Wehen 38 51 51 51
8 SV Wacker Burghausen Wacker 38 45 45 51
9 Unterhaching Unterhaching 38 48 55 51
10 Hallescher FC Hallescher 38 37 50 46
11 1. FC Saarbrücken Saarbrücken 38 52 62 45
12 Hansa Rostock Hansa 38 39 52 44
13 Rot-Weiss Erfurt Rot-Weiss 38 44 58 44
14 Stuttgart II Stuttgart 38 35 42 43
15 Kickers Offenbach FC Kickers 38 41 44 42
16 B. Dortmund II Dortmund 38 39 58 41
17 Stuttgarter Kickers Stuttgarter 38 39 48 40
18 Darmstadt 98 Darmstadt 38 32 46 38
19 SV Babelsberg 03 Babelsberg 38 32 54 37
20 Alemannia Aachen Alemannia 38 40 68 26
TEMPORADA 2011/2012
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Greuther Fürth Greuther 34 73 27 70
2 Eintracht Frankfurt Eintracht 34 76 33 68
3 Fortuna Düsseldorf Fortuna 34 64 35 62
4 FC St Pauli FC St Pauli 34 59 34 62
5 Paderborn Paderborn 34 51 42 61
6 1860 München 1860 34 63 46 57
7 Union Berlin Union Berlin 34 55 58 48
8 Eintracht Braunschweig Eintracht 34 37 35 45
9 Dynamo Dresden Dynamo 34 50 52 45
10 MSV Duisburg Duisburg 34 42 47 39
11 VfL Bochum VfL Bochum 34 41 55 37
12 Ingolstadt 04 Ingolstadt 34 43 58 37
13 FSV Frankfurt Frankfurt 34 43 59 35
14 Energie Cottbus Energie 34 30 49 35
15 Erzgebirge Aue Erzgebirge 34 31 56 35
16 Karlsruher SC Karlsruher 34 34 60 33
17 Alemannia Aachen Alemannia 34 30 47 31
18 Hansa Rostock Hansa 34 34 63 27
TEMPORADA 2010/2011
3. LIGA
Equipo PJ GF GC Puntos
1 Eintracht Braunschweig Eintracht 38 81 22 85
2 Hansa Rostock Hansa 38 70 36 78
3 Dynamo Dresden Dynamo 38 55 37 65
4 Wehen Wiesbaden Wehen 38 55 39 64
5 Rot-Weiss Erfurt Rot-Weiss 38 63 45 61
6 1. FC Saarbrücken Saarbrücken 38 61 51 59
7 Kickers Offenbach FC Kickers 38 52 45 57
8 Jahn Regensburg Jahn 38 35 41 52
9 Heidenheim Heidenheim 38 59 58 51
10 Stuttgart II Stuttgart 38 48 48 51
11 TuS Koblenz TuS Koblenz 38 38 46 49
12 Sandhausen Sandhausen 38 43 46 46
13 SV Babelsberg 03 Babelsberg 38 39 47 46
14 Unterhaching Unterhaching 38 39 55 45
15 FC Carl Zeiss Jena Carl Zeiss. 38 43 62 44
16 Rot Weiss Ahlen Weiss Ahlen 38 45 69 42
17 VfR Aalen VfR Aalen 38 40 52 41
18 SV Wacker Burghausen Wacker 38 46 66 37
19 Werder Bremen II Werder 38 33 56 36
20 Bayern München II Bayern 38 30 54 30
TEMPORADA 2009/2010
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Kaiserslautern Kaiserslaute 34 56 28 67
2 FC St Pauli FC St Pauli 34 72 37 64
3 FC Augsburg FC Augsburg 34 60 40 62
4 Fortuna Düsseldorf Fortuna 34 48 31 59
5 Arminia Bielefeld Arminia 34 48 41 53
6 Paderborn Paderborn 34 49 49 51
7 MSV Duisburg Duisburg 34 51 46 50
8 1860 München 1860 34 43 45 48
9 Energie Cottbus Energie 34 55 49 47
10 Karlsruher SC Karlsruher 34 43 45 46
11 Greuther Fürth Greuther 34 51 50 44
12 Union Berlin Union Berlin 34 42 45 44
13 Alemannia Aachen Alemannia 34 37 41 43
14 Rot-Weiß Oberhausen Rot-Weiß 34 38 52 41
15 FSV Frankfurt Frankfurt 34 29 50 38
16 Hansa Rostock Hansa 34 33 45 36
17 TuS Koblenz TuS Koblenz 34 35 60 31
18 Rot Weiss Ahlen Weiss Ahlen 34 19 55 22
TEMPORADA 2008/2009
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 SC Freiburg SC Freiburg 34 60 36 68
2 Mainz 05 Mainz 05 34 62 37 63
3 Nürnberg Nürnberg 34 51 29 60
4 Alemannia Aachen Alemannia 34 58 38 56
5 Greuther Fürth Greuther 34 60 46 56
6 MSV Duisburg Duisburg 34 56 36 55
7 Kaiserslautern Kaiserslaute 34 53 48 52
8 FC St Pauli FC St Pauli 34 52 59 48
9 Rot-Weiß Oberhausen Rot-Weiß 34 35 54 42
10 TuS Koblenz TuS Koblenz 34 47 57 41
11 Rot Weiss Ahlen Weiss Ahlen 34 38 57 41
12 FC Augsburg FC Augsburg 34 43 46 40
13 1860 München 1860 34 44 46 39
14 Hansa Rostock Hansa 34 52 53 38
15 FSV Frankfurt Frankfurt 34 34 47 38
16 VfL Osnabrück Osnabrück 34 41 60 36
17 Ingolstadt 04 Ingolstadt 34 38 54 31
18 Wehen Wiesbaden Wehen 34 28 49 27
TEMPORADA 2007/2008
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 68 21 76
2 Werder Bremen Werder 34 75 45 66
3 Schalke 04 Schalke 04 34 55 32 64
4 Hamburger SV Hamburger 34 47 26 54
5 Wolfsburg Wolfsburg 34 58 46 54
6 Stuttgart Stuttgart 34 57 57 52
7 B. Leverkusen Leverkusen 34 57 40 51
8 Hannover 96 Hannover 96 34 54 56 49
9 Eintracht Frankfurt Eintracht 34 43 50 46
10 Hertha BSC Hertha BSC 34 39 44 44
11 Karlsruher SC Karlsruher 34 38 53 43
12 VfL Bochum VfL Bochum 34 48 54 41
13 B. Dortmund B. Dortmund 34 50 62 40
14 Energie Cottbus Energie 34 35 56 36
15 Arminia Bielefeld Arminia 34 35 60 34
16 Nürnberg Nürnberg 34 35 51 31
17 Hansa Rostock Hansa 34 30 52 30
18 MSV Duisburg Duisburg 34 36 55 29
TEMPORADA 2006/2007
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Karlsruher SC Karlsruher 34 69 41 70
2 Hansa Rostock Hansa 34 49 30 62
3 MSV Duisburg Duisburg 34 66 40 60
4 SC Freiburg SC Freiburg 34 55 39 60
5 Greuther Fürth Greuther 34 53 40 54
6 Kaiserslautern Kaiserslaute 34 48 34 53
7 FC Augsburg FC Augsburg 34 43 32 52
8 1860 München 1860 34 47 49 48
9 Köln Köln 34 49 50 46
10 Erzgebirge Aue Erzgebirge 34 46 48 45
11 Paderborn Paderborn 34 32 41 42
12 TuS Koblenz TuS Koblenz 34 36 45 41
13 FC Carl Zeiss Jena Carl Zeiss. 34 40 56 38
14 Kickers Offenbach FC Kickers 34 42 59 36
15 Rot-Weiss Essen Rot-Weiss 34 34 40 35
16 Unterhaching Unterhaching 34 33 49 35
17 SV Wacker Burghausen Wacker 34 42 63 32
18 Eintracht Braunschweig Eintracht 34 20 48 23
TEMPORADA 2005/2006
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 VfL Bochum VfL Bochum 34 55 26 66
2 Alemannia Aachen Alemannia 34 61 36 65
3 Energie Cottbus Energie 34 49 33 58
4 SC Freiburg SC Freiburg 34 41 33 56
5 Greuther Fürth Greuther 34 51 42 54
6 Karlsruher SC Karlsruher 34 55 45 53
7 Erzgebirge Aue Erzgebirge 34 38 36 48
8 SV Wacker Burghausen Wacker 34 45 49 47
9 Paderborn Paderborn 34 46 40 46
10 Hansa Rostock Hansa 34 44 49 43
11 Kickers Offenbach FC Kickers 34 42 53 43
12 Eintracht Braunschweig Eintracht 34 37 48 43
13 1860 München 1860 34 41 44 42
14 Unterhaching Unterhaching 34 42 48 42
15 Dynamo Dresden Dynamo 34 39 45 41
16 1. FC Saarbrücken Saarbrücken 34 37 63 38
17 Rot Weiss Ahlen Weiss Ahlen 34 36 50 35
18 Siegen Sportfreunde Siegen 34 35 54 31
TEMPORADA 2004/2005
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 75 33 77
2 Schalke 04 Schalke 04 34 56 46 63
3 Werder Bremen Werder 34 68 37 59
4 Hertha BSC Hertha BSC 34 59 31 58
5 Stuttgart Stuttgart 34 54 40 58
6 B. Leverkusen Leverkusen 34 65 44 57
7 B. Dortmund B. Dortmund 34 47 44 55
8 Hamburger SV Hamburger 34 55 50 51
9 Wolfsburg Wolfsburg 34 49 51 48
10 Hannover 96 Hannover 96 34 34 36 45
11 Mainz 05 Mainz 05 34 50 55 43
12 Kaiserslautern Kaiserslaute 34 43 52 42
13 Arminia Bielefeld Arminia 34 37 49 40
14 Nürnberg Nürnberg 34 55 63 38
15 B. Mönchengladbach Mönchenglad 34 35 51 36
16 VfL Bochum VfL Bochum 34 47 68 35
17 Hansa Rostock Hansa 34 31 65 30
18 SC Freiburg SC Freiburg 34 30 75 18

  USO DE MEMORIA  
8,502,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1974
Total Execution Time  0.1987
  CADENA URL  
/historico/Hansa-Rostock
  GET DATOS  
$_GET['/historico/Hansa-Rostock']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0036  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Hansa-Rostock' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72037
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1292 AND type_rel = 2
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1292 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  SELECT /*35 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 (102019,109260,131529,275622,275962) ORDER BY n.cover_points DESC, update_date DESC
0.0033  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '1292' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0075  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '1292' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72037 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0040  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=1292 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (72172,72037,71432) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0033  SELECT count(id) as num_players from rel_players WHERE league_id = 72037 AND teamId = 1292
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 72172 AND teamId = 1292
0.0241  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1292
0.0058  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72037 WHERE rp.league_id = 72037 AND rp.teamId = 1292 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0040  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72037 WHERE rp.league_id = 72037 AND rp.teamId = 1292 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0046  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72037 WHERE rp.league_id = 72037 AND rp.teamId = 1292 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0043  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 1292 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024` 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 = 72037 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2023` 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 = 67802 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `tables2022` 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 = 62743 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `tables2021` 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 = 57101 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `tables2020` 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 = 49902 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `tables2019` 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 = 43698 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2017` 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 = 33314 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2016` 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 = 15102 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 `tables2015` 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 = 3885 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2014` 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 = 2446 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 `tables2013` 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 = 2004 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2012` 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 = 1325 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2011` 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 = 1187 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2010` 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 = 876 AND t.round = 34 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 `tables2009` 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 = 451 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2008` 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 = 30 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2007` 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 = 547 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2006` 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 = 548 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2005` 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 = 58 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC