4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sportfreunde Lotte
TEMPORADA 2023/2024
OBERLIGA GRUPO 12
Equipo PJ GF GC Puntos
1 Sportfreunde Lotte Sportfreunde 30 79 28 67
2 Türkspor Dortmund Türkspor 30 72 39 62
3 ASC 09 Dortmund Dortmund 30 54 32 61
4 SpVgg Erkenschwick SpVgg 30 71 47 57
5 Gievenbeck Gievenbeck 30 53 31 52
6 SpVgg Vreden SpVgg Vreden 30 50 37 49
7 Preußen Münster II Preußen 29 55 35 47
8 Siegen Sportfreunde Siegen 30 59 41 46
9 Schermbeck Schermbeck 30 55 59 45
10 Finnentrop/Bamenohl Finnentrop/B 30 60 72 40
11 Westfalia Rhynern Westfalia 30 41 53 35
12 Ennepetal Ennepetal 30 43 62 34
13 Wattenscheid 09 Wattenscheid 30 40 60 30
14 Eintracht Rheine Eintracht 30 42 68 29
15 Victoria Clarholz Victoria 30 37 57 28
16 TuS Bovinghausen Bovinghausen 30 35 78 26
17 Sprockhövel Sprockhövel 30 41 63 22
18 Brünninghausen Brünninghau 29 36 61 22
TEMPORADA 2022/2023
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 Gutersloh Gutersloh 34 67 38 72
2 Preußen Münster II Preußen 34 82 46 65
3 Paderborn 07 II Paderborn 34 53 23 64
4 Sportfreunde Lotte Sportfreunde 34 64 43 60
5 TuS Bovinghausen Bovinghausen 34 73 59 53
6 Westfalia Rhynern Westfalia 34 52 48 52
7 ASC 09 Dortmund Dortmund 34 51 55 49
8 Victoria Clarholz Victoria 34 53 48 48
9 Finnentrop/Bamenohl Finnentrop/B 34 66 56 47
10 Eintracht Rheine Eintracht 34 52 60 46
11 SpVgg Vreden SpVgg Vreden 34 59 67 43
12 Schermbeck Schermbeck 34 43 56 39
13 Gievenbeck Gievenbeck 34 48 50 36
14 Siegen Sportfreunde Siegen 34 50 54 35
15 Sprockhövel Sprockhövel 34 48 69 35
16 Ennepetal Ennepetal 34 32 59 35
17 Erndtebrück Erndtebrück 34 47 85 34
18 Delbrücker SC Delbrücker 34 47 71 32
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
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
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 5
Equipo PJ GF GC Puntos
1 Preußen Münster Preußen 34 66 23 71
2 Schalke 04 II Schalke 34 56 31 67
3 VfL Bochum II Bochum 34 61 30 66
4 Sportfreunde Lotte Sportfreunde 34 62 35 60
5 Westfalia Herne Westfalia 34 55 34 57
6 Schermbeck Schermbeck 34 46 43 51
7 Germania Gladbeck Germania 34 49 56 50
8 Hammer SpVg Hammer SpVg 34 43 44 49
9 Delbrücker SC Delbrücker 34 47 42 48
10 Gutersloh Gutersloh 34 44 48 46
11 Arminia Bielefeld II Arminia 34 66 55 45
12 SpVgg Erkenschwick SpVgg 34 49 54 43
13 Rot Weiss Ahlen II Weiss Ahlen 34 32 43 41
14 SF Oestrich-Iserlohn Oestrich-Ise 34 52 68 37
15 Eintracht Rheine Eintracht 34 39 58 33
16 Lippstadt 08 Lippstadt 34 37 67 32
17 Wiedenbrück Wiedenbrück 34 33 63 25
18 Sprockhövel Sprockhövel 34 29 72 17
TEMPORADA 2006/2007
OBERLIGA GRUPO 9
Equipo PJ GF GC Puntos
1 Verl Verl 34 63 28 75
2 Schalke 04 II Schalke 34 67 41 62
3 Arminia Bielefeld II Arminia 34 66 40 61
4 Lippstadt 08 Lippstadt 34 55 47 61
5 Gutersloh Gutersloh 34 56 38 60
6 Preußen Münster Preußen 34 51 32 58
7 Westfalia Herne Westfalia 34 58 50 54
8 Sportfreunde Lotte Sportfreunde 34 59 54 49
9 Delbrücker SC Delbrücker 34 51 49 47
10 VfL Bochum II Bochum 34 61 49 44
11 Eintracht Rheine Eintracht 34 50 57 43
12 SpVgg Erkenschwick SpVgg 34 43 56 38
13 Iserlohn Iserlohn 34 38 63 36
14 Hammer SpVg Hammer SpVg 34 38 58 34
15 Rot Weiss Ahlen II Weiss Ahlen 34 34 52 32
16 Wattenscheid 09 Wattenscheid 34 51 72 32
17 Emsdetten 05 Emsdetten 34 49 71 31
18 Hüls Hüls 34 30 63 30
TEMPORADA 2005/2006
OBERLIGA GRUPO 8
Equipo PJ GF GC Puntos
1 B. Dortmund II Dortmund 34 79 25 79
2 Verl Verl 34 75 43 70
3 Gutersloh Gutersloh 34 71 41 59
4 Schalke 04 II Schalke 34 64 43 58
5 Sportfreunde Lotte Sportfreunde 34 49 43 56
6 VfL Bochum II Bochum 34 61 52 51
7 Hüls Hüls 34 48 53 46
8 Westfalia Herne Westfalia 34 47 51 44
9 Emsdetten 05 Emsdetten 34 44 57 43
10 Arminia Bielefeld II Arminia 34 36 38 42
11 Rot Weiss Ahlen II Weiss Ahlen 34 36 43 42
12 Delbrücker SC Delbrücker 34 35 46 41
13 Lippstadt 08 Lippstadt 34 43 65 41
14 Eintracht Rheine Eintracht 34 44 65 39
15 SpVgg Erkenschwick SpVgg 34 32 45 38
16 Siegen Sportfreunde 1899 II Siegen 34 42 63 34
17 Schermbeck Schermbeck 34 43 46 33
18 VfB Fichte Bielefeld Fichte 34 31 61 31
TEMPORADA 2004/2005
OBERLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Wattenscheid 09 Wattenscheid 34 78 34 71
2 VfL Bochum II Bochum 34 78 39 70
3 Schalke 04 II Schalke 34 64 42 60
4 Hüls Hüls 34 71 45 59
5 Verl Verl 34 55 41 59
6 Emsdetten 05 Emsdetten 34 51 55 58
7 Rot Weiss Ahlen II Weiss Ahlen 34 58 42 54
8 Sportfreunde Lotte Sportfreunde 34 54 55 50
9 Eintracht Rheine Eintracht 34 62 55 44
10 Gutersloh Gutersloh 34 47 49 44
11 VfB Fichte Bielefeld Fichte 34 57 65 43
12 SpVgg Erkenschwick SpVgg 34 37 45 42
13 Schermbeck Schermbeck 34 59 60 41
14 Siegen Sportfreunde 1899 II Siegen 34 46 59 33
15 Lippstadt 08 Lippstadt 34 44 66 31
16 Sprockhövel Sprockhövel 34 33 62 31
17 SV Vorwärts Kornharpen Vorwärts 34 45 87 31
18 SC Hassel SC Hassel 34 35 73 27

  USO DE MEMORIA  
7,998,072 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1786
Total Execution Time  0.1798
  CADENA URL  
/historico/Sportfreunde-Lotte
  GET DATOS  
$_GET['/historico/Sportfreunde-Lotte']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0028  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 = 'Sportfreunde-Lotte' 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=4339 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=4339 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=4339 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 72710
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4339 AND type_rel = 2
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4339 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0025  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 (102010,125538,174968,175030,184603) ORDER BY n.cover_points DESC, update_date DESC
0.0029  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 = '4339' ORDER BY l.year DESC,cat.coefficient DESC
0.0030  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 = '4339' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '4339' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 72710 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=4339 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 (72710,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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72710 AND teamId = 4339
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 4339
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 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 = 72710 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024  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 = '4339' 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 = '4339' and rp.type = 4
0.0023  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 = '4339' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0043  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 = 72710 WHERE rp.league_id = 72710 AND rp.teamId = 4339 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.0039  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 = 72710 WHERE rp.league_id = 72710 AND rp.teamId = 4339 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037  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 = 72710 WHERE rp.league_id = 72710 AND rp.teamId = 4339 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 4339 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 = 72710 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.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 `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 = 68216 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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 = 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.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 `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.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 `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.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 `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.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 `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.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 = 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.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 `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 = 19870 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 `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 = 19883 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 `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 = 19891 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 = 28286 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC