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 FC St Pauli FC St Pauli 32 57 34 63
2 Holstein Kiel Holstein 31 61 37 61
3 Fortuna Düsseldorf Fortuna 32 68 37 59
4 Hamburger SV Hamburger 32 60 42 55
5 Karlsruher SC Karlsruher 32 64 46 52
6 Hannover 96 Hannover 96 31 53 39 46
7 Paderborn Paderborn 31 49 50 46
8 Greuther Fürth Greuther 32 48 49 46
9 Hertha BSC Hertha BSC 31 63 52 45
10 SV Elversberg Elversberg 31 45 55 40
11 Magdeburg Magdeburg 32 44 51 37
12 Schalke 04 Schalke 04 31 47 57 37
13 Nürnberg Nürnberg 32 39 60 37
14 Kaiserslautern Kaiserslaute 32 53 61 36
15 Eintracht Braunschweig Eintracht 32 36 48 35
16 Wehen Wiesbaden Wehen 31 35 46 32
17 Hansa Rostock Hansa 32 28 53 31
18 VfL Osnabrück Osnabrück 31 28 61 25
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
3. LIGA
Equipo PJ GF GC Puntos
1 Magdeburg Magdeburg 36 83 39 78
2 Eintracht Braunschweig Eintracht 36 61 36 64
3 Kaiserslautern Kaiserslaute 36 56 27 63
4 1860 München 1860 36 67 50 61
5 Waldhof Mannheim Waldhof 36 58 40 60
6 VfL Osnabrück Osnabrück 36 56 48 58
7 1. FC Saarbrücken Saarbrücken 36 50 44 53
8 Wehen Wiesbaden Wehen 36 49 44 51
9 B. Dortmund II Dortmund 36 51 48 49
10 Zwickau Zwickau 36 46 44 47
11 Freiburg II Freiburg II 36 34 42 47
12 SV Meppen SV Meppen 36 47 60 47
13 Viktoria Köln Viktoria 36 39 52 45
14 Hallescher FC Hallescher 36 46 48 43
15 MSV Duisburg Duisburg 36 46 71 42
16 Verl Verl 36 56 66 40
17 Viktoria Berlin Viktoria 36 44 62 37
18 Würzburger Kickers Würzburger 36 34 59 30
19 Havelse Havelse 36 28 71 23
20 Türkgücü München Türkgücü 0 0 0 0
TEMPORADA 2020/2021
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 VfL Bochum VfL Bochum 34 66 39 67
2 Greuther Fürth Greuther 34 69 44 64
3 Holstein Kiel Holstein 34 57 35 62
4 Hamburger SV Hamburger 34 71 44 58
5 Fortuna Düsseldorf Fortuna 34 55 46 56
6 Karlsruher SC Karlsruher 34 51 44 52
7 Darmstadt 98 Darmstadt 34 63 55 51
8 Heidenheim Heidenheim 34 49 49 51
9 Paderborn Paderborn 34 53 45 47
10 FC St Pauli FC St Pauli 34 51 56 47
11 Nürnberg Nürnberg 34 46 51 44
12 Erzgebirge Aue Erzgebirge 34 44 53 44
13 Hannover 96 Hannover 96 34 53 51 42
14 Jahn Regensburg Jahn 34 37 50 38
15 Sandhausen Sandhausen 34 41 60 34
16 VfL Osnabrück Osnabrück 34 35 58 33
17 Eintracht Braunschweig Eintracht 34 30 59 31
18 Würzburger Kickers Würzburger 34 37 69 25
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
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Fortuna Düsseldorf Fortuna 34 57 44 63
2 Nürnberg Nürnberg 34 61 39 60
3 Holstein Kiel Holstein 34 71 44 56
4 Arminia Bielefeld Arminia 34 51 47 48
5 Jahn Regensburg Jahn 34 53 53 48
6 VfL Bochum VfL Bochum 34 37 40 48
7 MSV Duisburg Duisburg 34 52 56 48
8 Union Berlin Union Berlin 34 54 46 47
9 Ingolstadt 04 Ingolstadt 34 47 45 45
10 Darmstadt 98 Darmstadt 34 47 45 43
11 Sandhausen Sandhausen 34 35 33 43
12 FC St Pauli FC St Pauli 34 35 48 43
13 Heidenheim Heidenheim 34 50 56 42
14 Dynamo Dresden Dynamo 34 42 52 41
15 Greuther Fürth Greuther 34 37 48 40
16 Erzgebirge Aue Erzgebirge 34 35 49 40
17 Eintracht Braunschweig Eintracht 34 37 43 39
18 Kaiserslautern Kaiserslaute 34 42 55 35
TEMPORADA 2016/2017
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Stuttgart Stuttgart 34 63 37 69
2 Hannover 96 Hannover 96 34 51 32 67
3 Eintracht Braunschweig Eintracht 34 50 36 66
4 Union Berlin Union Berlin 34 51 39 60
5 Dynamo Dresden Dynamo 34 53 46 50
6 Heidenheim Heidenheim 34 43 39 46
7 FC St Pauli FC St Pauli 34 39 35 45
8 Greuther Fürth Greuther 34 33 40 45
9 VfL Bochum VfL Bochum 34 42 47 44
10 Sandhausen Sandhausen 34 41 36 42
11 Fortuna Düsseldorf Fortuna 34 37 39 42
12 Nürnberg Nürnberg 34 46 52 42
13 Kaiserslautern Kaiserslaute 34 29 33 41
14 Erzgebirge Aue Erzgebirge 34 37 52 39
15 Arminia Bielefeld Arminia 34 50 54 37
16 1860 München 1860 34 37 47 36
17 Würzburger Kickers Würzburger 34 32 41 34
18 Karlsruher SC Karlsruher 34 27 56 25
TEMPORADA 2015/2016
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 SC Freiburg SC Freiburg 34 75 39 72
2 RB Leipzig RB Leipzig 34 54 32 67
3 Nürnberg Nürnberg 34 68 41 65
4 FC St Pauli FC St Pauli 34 45 39 53
5 VfL Bochum VfL Bochum 34 56 40 51
6 Union Berlin Union Berlin 34 56 50 49
7 Karlsruher SC Karlsruher 34 35 37 47
8 Eintracht Braunschweig Eintracht 34 44 38 46
9 Greuther Fürth Greuther 34 49 55 46
10 Kaiserslautern Kaiserslaute 34 49 47 45
11 Heidenheim Heidenheim 34 42 40 45
12 Arminia Bielefeld Arminia 34 38 39 42
13 Sandhausen Sandhausen 34 40 50 40
14 Fortuna Düsseldorf Fortuna 34 32 47 35
15 1860 München 1860 34 32 46 34
16 MSV Duisburg Duisburg 34 32 54 32
17 FSV Frankfurt Frankfurt 34 33 59 32
18 Paderborn Paderborn 34 28 55 28
TEMPORADA 2014/2015
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Ingolstadt 04 Ingolstadt 34 53 32 64
2 Darmstadt 98 Darmstadt 34 44 26 59
3 Karlsruher SC Karlsruher 34 46 26 58
4 Kaiserslautern Kaiserslaute 34 45 31 56
5 RB Leipzig RB Leipzig 34 39 31 50
6 Eintracht Braunschweig Eintracht 34 44 41 50
7 Union Berlin Union Berlin 34 46 51 47
8 Heidenheim Heidenheim 34 49 44 46
9 Nürnberg Nürnberg 34 42 47 45
10 Fortuna Düsseldorf Fortuna 34 48 52 44
11 VfL Bochum VfL Bochum 34 53 55 42
12 Sandhausen Sandhausen 34 32 37 39
13 FSV Frankfurt Frankfurt 34 41 53 39
14 Greuther Fürth Greuther 34 34 42 37
15 FC St Pauli FC St Pauli 34 40 51 37
16 1860 München 1860 34 41 51 36
17 Erzgebirge Aue Erzgebirge 34 32 47 36
18 VfR Aalen VfR Aalen 34 34 46 31
TEMPORADA 2013/2014
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 94 23 90
2 B. Dortmund B. Dortmund 34 80 38 71
3 Schalke 04 Schalke 04 34 63 43 64
4 B. Leverkusen Leverkusen 34 60 41 61
5 Wolfsburg Wolfsburg 34 63 50 60
6 B. Mönchengladbach Mönchenglad 34 59 43 55
7 Mainz 05 Mainz 05 34 52 54 53
8 FC Augsburg FC Augsburg 34 47 47 52
9 Hoffenheim Hoffenheim 34 72 70 44
10 Hannover 96 Hannover 96 34 46 59 42
11 Hertha BSC Hertha BSC 34 40 48 41
12 Werder Bremen Werder 34 42 66 39
13 Eintracht Frankfurt Eintracht 34 40 57 36
14 SC Freiburg SC Freiburg 34 43 61 36
15 Stuttgart Stuttgart 34 49 62 32
16 Hamburger SV Hamburger 34 51 75 27
17 Nürnberg Nürnberg 34 37 70 26
18 Eintracht Braunschweig Eintracht 34 29 60 25
TEMPORADA 2012/2013
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Hertha BSC Hertha BSC 34 65 28 76
2 Eintracht Braunschweig Eintracht 34 52 34 67
3 Kaiserslautern Kaiserslaute 34 55 33 58
4 FSV Frankfurt Frankfurt 34 55 45 54
5 Köln Köln 34 43 33 54
6 1860 München 1860 34 39 31 49
7 Union Berlin Union Berlin 34 50 49 49
8 Energie Cottbus Energie 34 41 36 48
9 VfR Aalen VfR Aalen 34 40 39 46
10 FC St Pauli FC St Pauli 34 44 47 43
11 MSV Duisburg Duisburg 34 37 49 43
12 Paderborn Paderborn 34 45 45 42
13 Ingolstadt 04 Ingolstadt 34 36 43 42
14 VfL Bochum VfL Bochum 34 40 52 38
15 Erzgebirge Aue Erzgebirge 34 39 46 37
16 Dynamo Dresden Dynamo 34 35 49 37
17 Sandhausen Sandhausen 34 38 66 26
18 Jahn Regensburg Jahn 34 36 65 19
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
3. LIGA
Equipo PJ GF GC Puntos
1 VfL Osnabrück Osnabrück 38 55 37 69
2 Erzgebirge Aue Erzgebirge 38 57 41 68
3 Ingolstadt 04 Ingolstadt 38 72 46 64
4 Eintracht Braunschweig Eintracht 38 55 37 62
5 FC Carl Zeiss Jena Carl Zeiss. 38 54 44 60
6 Heidenheim Heidenheim 38 66 56 59
7 Kickers Offenbach FC Kickers 38 55 35 57
8 Bayern München II Bayern 38 55 65 54
9 Rot-Weiss Erfurt Rot-Weiss 38 41 41 53
10 Stuttgart II Stuttgart 38 53 50 52
11 Unterhaching Unterhaching 38 52 52 50
12 Dynamo Dresden Dynamo 38 39 46 50
13 Werder Bremen II Werder 38 49 54 47
14 Sandhausen Sandhausen 38 54 63 47
15 Wehen Wiesbaden Wehen 38 52 64 47
16 Jahn Regensburg Jahn 38 43 48 46
17 SV Wacker Burghausen Wacker 38 45 64 46
18 B. Dortmund II Dortmund 38 43 58 39
19 Holstein Kiel Holstein 38 43 61 38
20 Wuppertaler SV Wuppertaler 38 40 61 38
TEMPORADA 2008/2009
3. LIGA
Equipo PJ GF GC Puntos
1 Union Berlin Union Berlin 38 59 23 78
2 Fortuna Düsseldorf Fortuna 38 54 33 69
3 Paderborn Paderborn 38 68 38 68
4 Unterhaching Unterhaching 38 57 46 67
5 Bayern München II Bayern 38 54 38 59
6 BSV Kickers Emden Kickers 38 45 44 59
7 Kickers Offenbach FC Kickers 38 40 35 52
8 Sandhausen Sandhausen 38 58 52 50
9 Dynamo Dresden Dynamo 38 46 46 50
10 Rot-Weiss Erfurt Rot-Weiss 38 46 48 50
11 Stuttgart II Stuttgart 38 61 50 49
12 Erzgebirge Aue Erzgebirge 38 43 43 48
13 Eintracht Braunschweig Eintracht 38 46 51 45
14 Wuppertaler SV Wuppertaler 38 36 45 45
15 Jahn Regensburg Jahn 38 37 51 45
16 FC Carl Zeiss Jena Carl Zeiss. 38 41 59 41
17 Werder Bremen II Werder 38 49 58 40
18 SV Wacker Burghausen Wacker 38 40 65 40
19 VfR Aalen VfR Aalen 38 38 60 39
20 Stuttgarter Kickers Stuttgarter 38 38 71 29
TEMPORADA 2007/2008
REGIONALLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Rot Weiss Ahlen Weiss Ahlen 36 73 41 67
2 Rot-Weiß Oberhausen Rot-Weiß 36 64 32 66
3 Fortuna Düsseldorf Fortuna 36 49 29 64
4 Union Berlin Union Berlin 36 67 49 60
5 Werder Bremen II Werder 36 52 43 59
6 Wuppertaler SV Wuppertaler 36 60 50 58
7 Rot-Weiss Erfurt Rot-Weiss 36 70 46 56
8 Dynamo Dresden Dynamo 36 45 39 55
9 BSV Kickers Emden Kickers 36 43 39 54
10 Eintracht Braunschweig Eintracht 36 55 50 53
11 Magdeburg Magdeburg 36 39 37 53
12 Rot-Weiss Essen Rot-Weiss 36 42 36 51
13 B. Dortmund II Dortmund 36 35 37 48
14 Energie Cottbus II Energie 36 31 44 44
15 SV Babelsberg 03 Babelsberg 36 33 53 34
16 VfB Lübeck VfB Lübeck 36 32 58 34
17 Hamburger SV II Hamburger 36 36 58 33
18 Verl Verl 36 31 55 32
19 Wolfsburg II Wolfsburg 36 20 81 22
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
REGIONALLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Eintracht Braunschweig Eintracht 36 59 35 70
2 Paderborn Paderborn 36 63 40 70
3 VfB Lübeck VfB Lübeck 36 62 40 69
4 VfL Osnabrück Osnabrück 36 67 44 67
5 Wuppertaler SV Wuppertaler 36 46 48 54
6 Hamburger SV II Hamburger 36 49 48 53
7 FC St Pauli FC St Pauli 36 43 39 52
8 Fortuna Düsseldorf Fortuna 36 46 42 49
9 KFC Uerdingen 05 Uerdingen 36 43 50 49
10 Holstein Kiel Holstein 36 54 46 48
11 Hertha BSC II Hertha 36 61 55 47
12 Preußen Münster Preußen 36 52 58 46
13 Köln II Köln II 36 58 65 46
14 Werder Bremen II Werder 36 48 57 42
15 Chemnitzer Chemnitzer 36 33 38 40
16 B. Dortmund II Dortmund 36 57 64 40
17 Wolfsburg II Wolfsburg 36 37 58 34
18 Bielefeld Amatuere Bielefeld 36 50 83 29
19 Union Berlin Union Berlin 36 32 50 27

  USO DE MEMORIA  
8,330,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1793
Total Execution Time  0.1805
  CADENA URL  
/historico/Eintracht-Brau-Hellip
  GET DATOS  
$_GET['/historico/Eintracht-Brau-Hellip']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0147  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 = 'Eintracht-Brau-Hellip' 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.0020  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=5116 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=5116 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=5116 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=5116 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027  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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5116 AND type_rel = 2
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5116 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024  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 (2926,2939,129841,166479,231985) ORDER BY n.cover_points DESC, update_date DESC
0.0044  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 = '5116' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0041  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 = '5116' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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.0029  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=5116 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 72037 AND teamId = 5116
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 72172 AND teamId = 5116
0.0038  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 5116
0.0022  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '5116' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5116' and rp.type = 4
0.0020  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '5116' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 5116 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.0042  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 = 5116 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036  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 = 5116 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036  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 = 5116 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  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 = 32 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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.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 `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 = 63195 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.0023  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 = 56926 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.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 `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.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 `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.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 `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 = 38638 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 `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 = 29215 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 `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 = 15098 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 3811 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 1920 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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.0023  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.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 `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 = 885 AND t.round = 38 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 `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 = 452 AND t.round = 38 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 `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 = 16437 AND t.round = 38 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.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 `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.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 `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 = 16446 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC