4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Köln II
TEMPORADA 2023/2024
REGIONALLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Alemannia Aachen Alemannia 30 57 28 69
2 Wuppertaler SV Wuppertaler 30 64 41 55
3 Fortuna Köln Fortuna 31 57 34 55
4 FC Bocholt FC Bocholt 30 42 26 55
5 Schalke 04 II Schalke 31 60 44 49
6 Wiedenbrück Wiedenbrück 30 42 39 46
7 Düren Düren 30 52 42 44
8 Rödinghausen Rödinghause 30 41 38 44
9 Rot-Weiß Oberhausen Rot-Weiß 30 47 31 43
10 Köln II Köln II 30 45 43 43
11 Fortuna Düsseldorf II Fortuna 29 44 39 41
12 Gutersloh Gutersloh 31 38 55 38
13 Paderborn 07 II Paderborn 30 48 48 35
14 B. Mönchengladbach II Mönchenglad 30 46 55 32
15 Lippstadt 08 Lippstadt 30 38 59 30
16 Velbert Velbert 31 34 67 28
17 Wegberg-Beeck Wegberg-Beec 31 40 70 25
18 Rot Weiss Ahlen Weiss Ahlen 30 32 68 24
TEMPORADA 2022/2023
REGIONALLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 Preußen Münster Preußen 34 89 39 79
2 Wuppertaler SV Wuppertaler 34 77 47 66
3 B. Mönchengladbach II Mönchenglad 34 73 47 66
4 Rödinghausen Rödinghause 34 59 35 58
5 Kaan-Marienborn Kaan-Marienb 34 59 54 55
6 Fortuna Köln Fortuna 34 48 43 54
7 Rot-Weiß Oberhausen Rot-Weiß 34 61 51 53
8 Alemannia Aachen Alemannia 34 50 43 53
9 Schalke 04 II Schalke 34 65 53 49
10 Düren Düren 34 51 56 48
11 Lippstadt 08 Lippstadt 34 51 56 46
12 Wiedenbrück Wiedenbrück 34 50 47 41
13 Fortuna Düsseldorf II Fortuna 34 50 64 39
14 Köln II Köln II 34 45 62 38
15 FC Bocholt FC Bocholt 34 49 70 36
16 Rot Weiss Ahlen Weiss Ahlen 34 53 82 29
17 Wattenscheid 09 Wattenscheid 34 45 90 27
18 SV Straelen SV Straelen 34 31 67 17
TEMPORADA 2021/2022
REGIONALLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 Rot-Weiss Essen Rot-Weiss 38 84 32 87
2 Preußen Münster Preußen 38 73 24 87
3 Wuppertaler SV Wuppertaler 38 68 28 78
4 Rot-Weiß Oberhausen Rot-Weiß 38 68 35 75
5 Fortuna Köln Fortuna 38 62 31 74
6 Rödinghausen Rödinghause 38 45 35 64
7 Köln II Köln II 38 70 49 62
8 Wiedenbrück Wiedenbrück 38 48 37 55
9 Schalke 04 II Schalke 38 58 65 47
10 Rot Weiss Ahlen Weiss Ahlen 38 50 67 47
11 Fortuna Düsseldorf II Fortuna 38 59 62 46
12 Alemannia Aachen Alemannia 38 43 51 44
13 B. Mönchengladbach II Mönchenglad 38 42 51 43
14 Lippstadt 08 Lippstadt 38 54 65 43
15 SV Straelen SV Straelen 38 42 64 43
16 Bonner SC Bonner SC 38 44 63 39
17 Wegberg-Beeck Wegberg-Beec 38 31 64 31
18 Sportfreunde Lotte Sportfreunde 38 36 63 30
19 KFC Uerdingen 05 Uerdingen 38 39 96 27
20 Homberg Homberg 38 30 64 26
TEMPORADA 2020/2021
REGIONALLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 B. Dortmund II Dortmund 40 94 31 93
2 Rot-Weiss Essen Rot-Weiss 40 90 28 90
3 Preußen Münster Preußen 40 70 39 78
4 Fortuna Köln Fortuna 40 66 48 66
5 Köln II Köln II 40 66 55 61
6 Rödinghausen Rödinghause 40 52 39 59
7 Rot-Weiß Oberhausen Rot-Weiß 40 61 50 59
8 Schalke 04 II Schalke 40 59 56 57
9 Fortuna Düsseldorf II Fortuna 40 67 53 56
10 Wiedenbrück Wiedenbrück 40 55 50 56
11 B. Mönchengladbach II Mönchenglad 40 49 55 55
12 Wuppertaler SV Wuppertaler 40 57 62 54
13 SV Straelen SV Straelen 40 45 61 47
14 Alemannia Aachen Alemannia 40 35 48 45
15 Sportfreunde Lotte Sportfreunde 40 47 72 44
16 Lippstadt 08 Lippstadt 40 37 63 40
17 Wegberg-Beeck Wegberg-Beec 40 36 62 39
18 Rot Weiss Ahlen Weiss Ahlen 40 50 69 38
19 Bonner SC Bonner SC 40 39 66 38
20 Homberg Homberg 40 40 75 35
21 Bergisch Gladbach Bergisch 40 36 69 33
TEMPORADA 2019/2020
REGIONALLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 Rödinghausen Rödinghause 27 68 21 64
2 Rot-Weiss Essen Rot-Weiss 25 45 25 54
3 Verl Verl 23 51 16 53
4 Rot-Weiß Oberhausen Rot-Weiß 23 42 21 46
5 Alemannia Aachen Alemannia 25 43 35 38
6 Köln II Köln II 24 41 31 36
7 B. Mönchengladbach II Mönchenglad 25 49 47 36
8 B. Dortmund II Dortmund 25 43 39 34
9 Sportfreunde Lotte Sportfreunde 23 37 34 34
10 Schalke 04 II Schalke 25 31 27 31
11 Fortuna Düsseldorf II Fortuna 25 36 43 30
12 Fortuna Köln Fortuna 23 20 27 30
13 Bonner SC Bonner SC 25 28 43 25
14 Wuppertaler SV Wuppertaler 23 29 48 23
15 TuS Haltern TuS Haltern 24 28 51 23
16 Lippstadt 08 Lippstadt 22 21 43 19
17 Bergisch Gladbach Bergisch 24 18 53 18
18 Homberg Homberg 26 22 52 17
19 Wattenscheid 09 Wattenscheid 13 20 16 16
TEMPORADA 2018/2019
REGIONALLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 Viktoria Köln Viktoria 34 62 30 67
2 Rot-Weiß Oberhausen Rot-Weiß 34 58 41 64
3 Rödinghausen Rödinghause 34 58 29 63
4 B. Mönchengladbach II Mönchenglad 34 47 38 57
5 B. Dortmund II Dortmund 34 62 36 56
6 Alemannia Aachen Alemannia 34 48 39 49
7 Verl Verl 34 51 46 46
8 Rot-Weiss Essen Rot-Weiss 34 42 40 46
9 Köln II Köln II 34 54 46 45
10 Wuppertaler SV Wuppertaler 34 45 49 44
11 Wattenscheid 09 Wattenscheid 34 44 44 43
12 Fortuna Düsseldorf II Fortuna 34 47 62 42
13 Lippstadt 08 Lippstadt 34 36 48 41
14 Bonner SC Bonner SC 34 42 51 40
15 Kaan-Marienborn Kaan-Marienb 34 50 54 39
16 SV Straelen SV Straelen 34 36 62 39
17 Wiedenbrück Wiedenbrück 34 42 52 38
18 Herkenrath Herkenrath 34 34 91 15
TEMPORADA 2017/2018
REGIONALLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 KFC Uerdingen 05 Uerdingen 34 68 24 76
2 Viktoria Köln Viktoria 34 85 36 72
3 Wuppertaler SV Wuppertaler 34 61 47 56
4 B. Dortmund II Dortmund 34 55 46 55
5 Rödinghausen Rödinghause 34 76 63 53
6 Alemannia Aachen Alemannia 34 59 47 53
7 Wiedenbrück Wiedenbrück 34 55 48 52
8 Verl Verl 34 47 33 50
9 Rot-Weiß Oberhausen Rot-Weiß 34 50 41 50
10 Rot-Weiss Essen Rot-Weiss 34 55 43 49
11 Wattenscheid 09 Wattenscheid 34 58 52 45
12 B. Mönchengladbach II Mönchenglad 34 49 49 43
13 Bonner SC Bonner SC 34 47 62 38
14 Köln II Köln II 34 49 62 37
15 Fortuna Düsseldorf II Fortuna 34 42 59 36
16 Wegberg-Beeck Wegberg-Beec 34 37 78 28
17 Erndtebrück Erndtebrück 34 28 67 26
18 Westfalia Rhynern Westfalia 34 29 93 19
TEMPORADA 2016/2017
REGIONALLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Viktoria Köln Viktoria 34 91 42 72
2 B. Dortmund II Dortmund 34 54 25 63
3 B. Mönchengladbach II Mönchenglad 34 71 42 62
4 Rot-Weiß Oberhausen Rot-Weiß 34 69 50 59
5 Alemannia Aachen Alemannia 34 51 39 59
6 Rot-Weiss Essen Rot-Weiss 34 48 35 55
7 Köln II Köln II 34 59 54 51
8 Wattenscheid 09 Wattenscheid 34 51 44 50
9 Bonner SC Bonner SC 34 60 61 48
10 Rödinghausen Rödinghause 34 55 57 48
11 Wuppertaler SV Wuppertaler 34 47 47 42
12 Fortuna Düsseldorf II Fortuna 34 44 51 41
13 Verl Verl 34 37 49 40
14 Wiedenbrück Wiedenbrück 34 43 52 39
15 Rot Weiss Ahlen Weiss Ahlen 34 43 66 32
16 Schalke 04 II Schalke 34 32 48 30
17 Sprockhövel Sprockhövel 34 31 73 24
18 Siegen Sportfreunde Siegen 34 31 82 21
TEMPORADA 2015/2016
REGIONALLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 Sportfreunde Lotte Sportfreunde 36 67 23 83
2 B. Mönchengladbach II Mönchenglad 36 80 46 68
3 Viktoria Köln Viktoria 36 66 36 63
4 B. Dortmund II Dortmund 36 57 36 60
5 Rot-Weiß Oberhausen Rot-Weiß 36 58 44 59
6 Fortuna Düsseldorf II Fortuna 36 63 51 59
7 Alemannia Aachen Alemannia 36 52 43 56
8 Wattenscheid 09 Wattenscheid 36 61 52 55
9 Schalke 04 II Schalke 36 44 44 51
10 Verl Verl 36 43 46 51
11 Wiedenbrück Wiedenbrück 36 50 45 50
12 Rot-Weiss Essen Rot-Weiss 36 48 49 48
13 Rot Weiss Ahlen Weiss Ahlen 36 56 60 46
14 Rödinghausen Rödinghause 36 43 42 43
15 Köln II Köln II 36 44 51 41
16 Velbert Velbert 36 38 65 36
17 Erndtebrück Erndtebrück 36 42 68 32
18 Kray Kray 36 36 81 18
19 Wegberg-Beeck Wegberg-Beec 36 30 96 16
TEMPORADA 2014/2015
REGIONALLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 B. Mönchengladbach II Mönchenglad 34 77 43 69
2 Alemannia Aachen Alemannia 34 56 20 68
3 Viktoria Köln Viktoria 34 70 29 66
4 Rot-Weiß Oberhausen Rot-Weiß 34 54 37 57
5 Sportfreunde Lotte Sportfreunde 34 56 33 56
6 Rot-Weiss Essen Rot-Weiss 34 58 38 56
7 Verl Verl 34 53 32 54
8 Rödinghausen Rödinghause 34 48 44 49
9 Fortuna Düsseldorf II Fortuna 34 39 52 49
10 Köln II Köln II 34 38 47 42
11 Schalke 04 II Schalke 34 38 41 41
12 Wiedenbrück Wiedenbrück 34 39 54 40
13 Wattenscheid 09 Wattenscheid 34 42 58 39
14 Kray Kray 34 39 61 39
15 KFC Uerdingen 05 Uerdingen 34 34 63 34
16 VfL Bochum II Bochum 34 46 58 30
17 Siegen Sportfreunde Siegen 34 33 56 30
18 Hennef 05 Hennef 05 34 26 80 18
TEMPORADA 2013/2014
REGIONALLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Fortuna Köln Fortuna 36 73 36 76
2 Sportfreunde Lotte Sportfreunde 36 57 26 69
3 Rot-Weiß Oberhausen Rot-Weiß 36 51 34 69
4 Viktoria Köln Viktoria 36 62 39 65
5 Siegen Sportfreunde Siegen 36 57 34 64
6 Schalke 04 II Schalke 36 52 37 58
7 B. Mönchengladbach II Mönchenglad 36 55 42 55
8 B. Leverkusen II Leverkusen 36 68 51 52
9 Rot-Weiss Essen Rot-Weiss 36 54 48 52
10 Fortuna Düsseldorf II Fortuna 36 53 48 50
11 Verl Verl 36 41 45 50
12 Köln II Köln II 36 45 47 49
13 Alemannia Aachen Alemannia 36 42 46 49
14 VfL Bochum II Bochum 36 34 53 33
15 Wattenscheid 09 Wattenscheid 36 40 67 33
16 Wiedenbrück Wiedenbrück 36 46 76 30
17 KFC Uerdingen 05 Uerdingen 36 32 69 30
18 Lippstadt 08 Lippstadt 36 38 64 24
19 Velbert Velbert 36 34 72 21
TEMPORADA 2012/2013
REGIONALLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Sportfreunde Lotte Sportfreunde 38 70 27 86
2 Fortuna Köln Fortuna 38 69 33 79
3 Schalke 04 II Schalke 38 61 40 68
4 Rot-Weiss Essen Rot-Weiss 38 63 50 66
5 Siegen Sportfreunde Siegen 38 58 43 64
6 Viktoria Köln Viktoria 38 75 66 61
7 B. Mönchengladbach II Mönchenglad 38 56 50 57
8 Rot-Weiß Oberhausen Rot-Weiß 38 54 56 53
9 Wiedenbrück Wiedenbrück 38 56 56 51
10 Verl Verl 38 68 56 50
11 B. Leverkusen II Leverkusen 38 48 51 50
12 Fortuna Düsseldorf II Fortuna 38 43 48 47
13 Velbert Velbert 38 43 57 47
14 VfL Bochum II Bochum 38 47 42 46
15 Wuppertaler SV Wuppertaler 38 52 55 46
16 Köln II Köln II 38 60 61 42
17 Hüls Hüls 38 48 71 42
18 Bergisch Gladbach Bergisch 38 47 74 39
19 MSV Duisburg II Duisburg 38 33 68 34
20 Kray Kray 38 33 80 32
TEMPORADA 2011/2012
REGIONALLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 B. Dortmund II Dortmund 36 84 39 77
2 Sportfreunde Lotte Sportfreunde 36 64 31 76
3 B. Mönchengladbach II Mönchenglad 36 67 45 69
4 Eintracht Trier Eintracht 36 57 34 64
5 Wuppertaler SV Wuppertaler 36 68 49 57
6 Köln II Köln II 36 59 48 56
7 Fortuna Köln Fortuna 36 54 56 53
8 Rot-Weiss Essen Rot-Weiss 36 52 57 52
9 Kaiserslautern II Kaiserslaute 36 56 55 51
10 Verl Verl 36 39 48 46
11 Schalke 04 II Schalke 36 55 63 45
12 Mainz 05 II Mainz 05 II 36 49 47 43
13 SV Elversberg Elversberg 36 39 60 42
14 VfL Bochum II Bochum 36 42 64 41
15 Wiedenbrück Wiedenbrück 36 44 52 40
16 Idar-Oberstein Idar-Oberste 36 38 62 39
17 TuS Koblenz TuS Koblenz 36 32 51 31
18 B. Leverkusen II Leverkusen 36 34 57 31
19 Fortuna Düsseldorf II Fortuna 36 39 54 29
TEMPORADA 2010/2011
REGIONALLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Preußen Münster Preußen 34 56 24 72
2 Eintracht Trier Eintracht 34 58 34 62
3 Sportfreunde Lotte Sportfreunde 34 43 29 62
4 Kaiserslautern II Kaiserslaute 34 53 36 59
5 B. Mönchengladbach II Mönchenglad 34 53 41 59
6 B. Dortmund II Dortmund 34 56 47 52
7 Köln II Köln II 34 61 43 51
8 Wuppertaler SV Wuppertaler 34 52 59 50
9 Verl Verl 34 40 34 48
10 Wiedenbrück Wiedenbrück 34 50 55 46
11 Schalke 04 II Schalke 34 34 45 44
12 SV Elversberg Elversberg 34 39 44 43
13 Mainz 05 II Mainz 05 II 34 48 51 41
14 VfL Bochum II Bochum 34 49 64 34
15 B. Leverkusen II Leverkusen 34 43 58 33
16 Fortuna Düsseldorf II Fortuna 34 41 55 31
17 FC 08 Homburg Homburg 34 29 49 30
18 Arminia Bielefeld II Arminia 34 30 67 21
TEMPORADA 2009/2010
REGIONALLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 1. FC Saarbrücken Saarbrücken 34 53 33 69
2 Sportfreunde Lotte Sportfreunde 34 48 31 61
3 VfL Bochum II Bochum 34 50 32 57
4 Köln II Köln II 34 50 37 55
5 Rot-Weiss Essen Rot-Weiss 34 44 32 52
6 Preußen Münster Preußen 34 47 37 51
7 SV Elversberg Elversberg 34 41 34 50
8 Kaiserslautern II Kaiserslaute 34 43 37 49
9 Verl Verl 34 41 41 47
10 Bonner SC Bonner SC 34 48 45 43
11 Fortuna Düsseldorf II Fortuna 34 35 51 41
12 Schalke 04 II Schalke 34 42 43 40
13 B. Leverkusen II Leverkusen 34 38 45 40
14 Waldhof Mannheim Waldhof 34 36 43 40
15 Mainz 05 II Mainz 05 II 34 37 45 40
16 B. Mönchengladbach II Mönchenglad 34 37 53 40
17 Wormatia Worms Wormatia 34 35 58 30
18 Eintracht Trier Eintracht 34 33 61 29
TEMPORADA 2008/2009
REGIONALLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 B. Dortmund II Dortmund 34 86 49 68
2 Kaiserslautern II Kaiserslaute 34 59 42 65
3 Köln II Köln II 34 53 34 60
4 Preußen Münster Preußen 34 51 36 53
5 Mainz 05 II Mainz 05 II 34 58 45 52
6 B. Mönchengladbach II Mönchenglad 34 50 49 51
7 Rot-Weiss Essen Rot-Weiss 34 61 41 49
8 Verl Verl 34 45 42 49
9 B. Leverkusen II Leverkusen 34 53 56 49
10 Sportfreunde Lotte Sportfreunde 34 53 57 49
11 SV Elversberg Elversberg 34 39 37 46
12 Oggersheim Oggersheim 34 43 58 42
13 Eintracht Trier Eintracht 34 37 51 41
14 VfL Bochum II Bochum 34 51 59 40
15 Schalke 04 II Schalke 34 41 54 39
16 Wormatia Worms Wormatia 34 39 55 33
17 Cloppenburg Cloppenburg 34 51 76 28
18 Kleve Kleve 34 44 73 27
TEMPORADA 2007/2008
OBERLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 B. Mönchengladbach II Mönchenglad 34 86 47 68
2 B. Leverkusen II Leverkusen 34 62 31 66
3 Köln II Köln II 34 62 29 65
4 Kleve Kleve 34 53 40 55
5 Schwarz-Weiss Essen Schwarz-Weis 34 43 48 51
6 Velbert Velbert 34 47 54 51
7 MSV Duisburg II Duisburg 34 74 62 49
8 Germania Windeck Germania 34 42 34 49
9 Alemannia Aachen II Alemannia 34 45 46 48
10 Bonner SC Bonner SC 34 48 45 46
11 Fortuna Düsseldorf II Fortuna 34 49 53 46
12 Wuppertaler SV II Wuppertaler 34 51 55 45
13 KFC Uerdingen 05 Uerdingen 34 55 67 43
14 Turu 1880 Dusseldorf Turu 1880 D. 34 37 42 42
15 Homberg Homberg 34 49 62 39
16 Speldorf Speldorf 34 42 69 30
17 Bergisch Gladbach Bergisch 34 45 74 28
18 SV Straelen SV Straelen 34 40 72 24
TEMPORADA 2006/2007
OBERLIGA GRUPO 6
Equipo PJ GF GC Puntos
1 Rot-Weiß Oberhausen Rot-Weiß 34 50 25 69
2 Alemannia Aachen II Alemannia 34 56 39 61
3 Velbert Velbert 34 60 48 56
4 Bonner SC Bonner SC 34 48 41 53
5 MSV Duisburg II Duisburg 34 61 58 53
6 Schwarz-Weiss Essen Schwarz-Weis 34 54 38 52
7 Kleve Kleve 34 44 45 50
8 Köln II Köln II 34 62 50 49
9 Wuppertaler SV II Wuppertaler 34 40 35 49
10 KFC Uerdingen 05 Uerdingen 34 45 45 48
11 Turu 1880 Dusseldorf Turu 1880 D. 34 44 38 47
12 Bergisch Gladbach Bergisch 34 42 46 45
13 SV Straelen SV Straelen 34 51 46 42
14 Speldorf Speldorf 34 40 47 42
15 Homberg Homberg 34 42 53 41
16 FC Bocholt FC Bocholt 34 43 53 40
17 Union Solingen Union 34 31 78 25
18 Düren Düren 34 38 66 24
TEMPORADA 2005/2006
REGIONALLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Rot-Weiss Essen Rot-Weiss 36 67 34 76
2 FC Carl Zeiss Jena Carl Zeiss. 36 58 32 72
3 VfB Lübeck VfB Lübeck 36 60 36 69
4 Holstein Kiel Holstein 36 64 42 66
5 FC St Pauli FC St Pauli 36 53 38 61
6 Fortuna Düsseldorf Fortuna 36 61 49 60
7 Hertha BSC II Hertha 36 54 44 55
8 BSV Kickers Emden Kickers 36 52 44 52
9 Wuppertaler SV Wuppertaler 36 42 42 51
10 VfL Osnabrück Osnabrück 36 56 58 49
11 B. Leverkusen II Leverkusen 36 56 64 44
12 Werder Bremen II Werder 36 46 47 43
13 Hamburger SV II Hamburger 36 45 48 43
14 Rot-Weiss Erfurt Rot-Weiss 36 40 48 42
15 Preußen Münster Preußen 36 37 49 42
16 Wattenscheid 09 Wattenscheid 36 50 65 39
17 Rot-Weiß Oberhausen Rot-Weiß 36 30 53 39
18 Köln II Köln II 36 39 74 26
19 Chemnitzer Chemnitzer 36 35 78 21
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,032,184 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1915
Total Execution Time  0.1927
  CADENA URL  
/historico/Koln-Ii
  GET DATOS  
$_GET['/historico/Koln-Ii']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
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 = 'Koln-Ii' 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=5675 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=5675 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=5675 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5675 AND type_rel = 2
0.0036  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 = '5675' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '5675' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 72582 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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=5675 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (72582,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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72582 AND teamId = 5675
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 5675
0.0023  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 = '5675' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5675' and rp.type = 4
0.0024  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 = '5675' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0059  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 = 72582 WHERE rp.league_id = 72582 AND rp.teamId = 5675 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.0057  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 = 72582 WHERE rp.league_id = 72582 AND rp.teamId = 5675 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0045  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 = 72582 WHERE rp.league_id = 72582 AND rp.teamId = 5675 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 = 5675 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0048  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 = 72582 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.0034  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 = 68048 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.0032  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 = 63325 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.0032  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 = 57407 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 50106 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 43944 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 38889 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 33767 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0050  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 = 15532 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 3906 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 = 2506 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046  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 = 2007 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0049  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 = 1331 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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 = 16430 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 16433 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 16436 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 19869 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 = 19880 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 16447 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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
0.0024  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72582 ORDER BY nameShow LIMIT 100