4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hessen Kassel

Hessen Kassel

Entrenador: Alexander Kiene

Temporada 2023/2024
TEMPORADA 2023/2024
REGIONALLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 Stuttgarter Kickers Stuttgarter 31 58 29 60
2 Hoffenheim II Hoffenheim 31 61 23 58
3 Stuttgart II Stuttgart 31 72 49 56
4 Freiberg Freiberg 31 51 35 55
5 Eintracht Frankfurt II Eintracht 31 59 43 53
6 FC 08 Homburg Homburg 31 62 43 52
7 Barockstadt Barockstadt 31 46 37 48
8 Kickers Offenbach FC Kickers 31 57 41 46
9 FSV Frankfurt Frankfurt 31 42 45 42
10 Bahlinger SC Bahlinger 31 38 43 42
11 Hessen Kassel Hessen 31 43 45 41
12 Mainz 05 II Mainz 05 II 31 48 58 41
13 TSV Steinbach Haiger Steinbach 31 50 59 40
14 Astoria Walldorf Astoria 31 36 50 37
15 VfR Aalen VfR Aalen 31 36 53 33
16 TSG Balingen Balingen 31 46 72 25
17 Schott Mainz Schott Mainz 31 39 75 24
18 TuS Koblenz TuS Koblenz 31 27 71 18
TEMPORADA 2022/2023
REGIONALLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Ulm Ulm 34 59 25 72
2 TSV Steinbach Haiger Steinbach 34 80 31 71
3 Hoffenheim II Hoffenheim 34 80 38 69
4 FC 08 Homburg Homburg 34 65 44 58
5 FSV Frankfurt Frankfurt 34 57 45 57
6 TSG Balingen Balingen 34 51 44 56
7 Kickers Offenbach FC Kickers 34 48 38 55
8 Stuttgart II Stuttgart 34 53 39 52
9 Mainz 05 II Mainz 05 II 34 50 47 48
10 Bahlinger SC Bahlinger 34 53 67 46
11 Barockstadt Barockstadt 34 47 50 40
12 Astoria Walldorf Astoria 34 43 64 34
13 Hessen Kassel Hessen 34 34 51 33
14 Freiberg Freiberg 34 41 68 33
15 VfR Aalen VfR Aalen 34 38 52 32
16 Wormatia Worms Wormatia 34 37 63 29
17 RW Koblenz RW Koblenz 34 35 67 27
18 Eintracht Trier Eintracht 34 32 70 22
TEMPORADA 2021/2022
REGIONALLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 SV Elversberg Elversberg 36 79 29 80
2 Ulm Ulm 36 60 30 77
3 Kickers Offenbach FC Kickers 36 67 26 76
4 TSV Steinbach Haiger Steinbach 36 62 35 70
5 Mainz 05 II Mainz 05 II 36 63 42 69
6 FC 08 Homburg Homburg 36 43 48 52
7 Hessen Kassel Hessen 36 46 37 51
8 TSG Balingen Balingen 36 46 64 46
9 Bahlinger SC Bahlinger 36 35 44 45
10 Astoria Walldorf Astoria 36 49 61 44
11 Stuttgart II Stuttgart 36 49 52 43
12 VfR Aalen VfR Aalen 36 49 60 43
13 Hoffenheim II Hoffenheim 36 45 50 41
14 RW Koblenz RW Koblenz 36 36 44 39
15 FSV Frankfurt Frankfurt 36 40 53 39
16 SG Sonnenhof Großaspach Sonnenhof 36 42 64 39
17 Schott Mainz Schott Mainz 36 36 58 33
18 FK Pirmasens Pirmasens 36 32 59 33
19 FC Giessen FC Giessen 36 28 51 29
TEMPORADA 2020/2021
REGIONALLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Freiburg II Freiburg II 42 95 38 93
2 SV Elversberg Elversberg 42 98 43 88
3 Kickers Offenbach FC Kickers 42 80 32 87
4 Ulm Ulm 42 75 40 79
5 TSV Steinbach Haiger Steinbach 42 84 47 74
6 FSV Frankfurt Frankfurt 42 58 48 70
7 FC 08 Homburg Homburg 42 73 53 68
8 Stuttgart II Stuttgart 42 82 55 65
9 Bahlinger SC Bahlinger 42 66 75 61
10 RW Koblenz RW Koblenz 42 57 61 56
11 FC Giessen FC Giessen 42 52 51 53
12 Hessen Kassel Hessen 42 57 71 53
13 VfR Aalen VfR Aalen 42 49 60 52
14 FK Pirmasens Pirmasens 42 45 58 52
15 TSG Balingen Balingen 42 51 60 51
16 Hoffenheim II Hoffenheim 42 59 76 50
17 Mainz 05 II Mainz 05 II 42 58 73 49
18 Astoria Walldorf Astoria 42 64 79 47
19 SG Sonnenhof Großaspach Sonnenhof 42 52 75 43
20 Schott Mainz Schott Mainz 42 55 104 38
21 Bayern Alzenau Bayern 42 47 94 25
22 Eintracht Stadtallendorf Eintracht 42 40 104 17
TEMPORADA 2019/2020
OBERLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 Eintracht Stadtallendorf Eintracht 22 54 27 48
2 Hessen Kassel Hessen 22 71 26 47
3 Eddersheim Eddersheim 21 43 22 43
4 Barockstadt Barockstadt 22 55 23 42
5 VfB Ginsheim Ginsheim 21 56 41 37
6 Rot-Weiß Hadamar Rot-Weiß 22 53 38 37
7 Hessen Dreieich Hessen 23 44 38 36
8 Rot-Weiß Walldorf Rot-Weiß 23 42 42 33
9 Waldgirmes Waldgirmes 23 40 44 32
10 Viktoria Griesheim Viktoria 22 35 53 32
11 KSV Baunatal Baunatal 23 32 34 30
12 Türkgücü Friedberg Türkgücü 21 34 37 30
13 FC Hanau 93 FC Hanau 93 23 30 48 26
14 Dietkirchen Dietkirchen 22 29 44 23
15 Bad Vilbel Bad Vilbel 20 29 41 20
16 SV Steinbach 1920 Steinbach 20 21 51 16
17 Neuhof Neuhof 21 24 57 13
18 Fernwald Fernwald 23 35 61 11
TEMPORADA 2018/2019
OBERLIGA GRUPO 8
Equipo PJ GF GC Puntos
1 FC Giessen FC Giessen 35 124 26 88
2 Hessen Kassel Hessen 35 78 33 79
3 Bayern Alzenau Bayern 36 97 45 78
4 Rot-Weiß Hadamar Rot-Weiß 35 86 62 60
5 Barockstadt Barockstadt 35 75 54 58
6 KSV Baunatal Baunatal 36 59 61 57
7 VfB Ginsheim Ginsheim 36 81 82 56
8 Waldgirmes Waldgirmes 36 61 57 54
9 Eddersheim Eddersheim 35 60 67 49
10 Bad Vilbel Bad Vilbel 35 48 52 43
11 Lohfelden Lohfelden 35 52 61 41
12 Viktoria Griesheim Viktoria 35 49 79 39
13 Türkgücü Friedberg Türkgücü 36 62 86 37
14 Buchonia Flieden Buchonia 34 51 65 35
15 Hünfelder SV Hünfelder 35 35 76 33
16 Ederbergland Ederbergland 35 42 105 24
17 Neu-Isenburg Neu-Isenburg 34 43 92 21
TEMPORADA 2017/2018
REGIONALLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 1. FC Saarbrücken Saarbrücken 36 92 32 82
2 Waldhof Mannheim Waldhof 36 62 32 71
3 Kickers Offenbach FC Kickers 36 68 43 66
4 Freiburg II Freiburg II 36 50 32 66
5 SV Elversberg Elversberg 36 61 43 56
6 Hoffenheim II Hoffenheim 36 57 45 56
7 Mainz 05 II Mainz 05 II 36 52 56 51
8 TSV Steinbach Haiger Steinbach 36 53 48 50
9 Ulm Ulm 36 56 54 48
10 Stuttgart II Stuttgart 36 52 62 48
11 Astoria Walldorf Astoria 36 58 61 42
12 Eintracht Stadtallendorf Eintracht 36 46 63 42
13 Wormatia Worms Wormatia 36 49 68 42
14 FSV Frankfurt Frankfurt 36 49 66 41
15 TuS Koblenz TuS Koblenz 36 45 51 39
16 Hessen Kassel Hessen 36 53 54 38
17 Stuttgarter Kickers Stuttgarter 36 49 72 36
18 Schott Mainz Schott Mainz 36 44 76 32
19 Rochling Volklingen Rochling 36 39 77 27
TEMPORADA 2016/2017
REGIONALLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 SV Elversberg Elversberg 36 62 22 78
2 Waldhof Mannheim Waldhof 36 60 34 76
3 1. FC Saarbrücken Saarbrücken 36 61 42 69
4 Hoffenheim II Hoffenheim 36 69 40 57
5 TSV Steinbach Haiger Steinbach 36 52 39 56
6 Wormatia Worms Wormatia 36 44 37 52
7 Stuttgart II Stuttgart 36 58 55 52
8 TuS Koblenz TuS Koblenz 36 40 39 52
9 Ulm Ulm 36 48 46 51
10 Hessen Kassel Hessen 36 41 49 49
11 Astoria Walldorf Astoria 36 48 56 47
12 Kickers Offenbach FC Kickers 36 49 39 44
13 Stuttgarter Kickers Stuttgarter 36 53 51 44
14 FK Pirmasens Pirmasens 36 38 55 42
15 FC 08 Homburg Homburg 36 41 59 41
16 Kaiserslautern II Kaiserslaute 36 46 59 36
17 FC Giessen FC Giessen 36 42 68 35
18 Eintracht Trier Eintracht 36 44 58 33
19 Nottingen Nottingen 36 43 91 28
TEMPORADA 2015/2016
REGIONALLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 Waldhof Mannheim Waldhof 34 64 19 73
2 SV Elversberg Elversberg 34 69 28 72
3 Hoffenheim II Hoffenheim 34 77 39 66
4 Kickers Offenbach FC Kickers 34 67 49 64
5 Eintracht Trier Eintracht 34 62 33 63
6 FC 08 Homburg Homburg 34 59 42 59
7 1. FC Saarbrücken Saarbrücken 34 48 36 54
8 Hessen Kassel Hessen 34 42 32 53
9 Wormatia Worms Wormatia 34 54 54 48
10 Kaiserslautern II Kaiserslaute 34 47 42 43
11 Astoria Walldorf Astoria 34 46 53 42
12 TSV Steinbach Haiger Steinbach 34 36 56 42
13 FK Pirmasens Pirmasens 34 43 43 39
14 Bahlinger SC Bahlinger 34 45 58 37
15 Freiburg II Freiburg II 34 50 60 34
16 Spielberg Spielberg 34 28 70 26
17 SpVgg Neckarelz SpVgg 34 32 76 26
18 Saar Saarbrücken Saar 34 21 100 11
TEMPORADA 2014/2015
REGIONALLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Kickers Offenbach FC Kickers 34 55 22 79
2 1. FC Saarbrücken Saarbrücken 34 51 27 69
3 SV Elversberg Elversberg 34 60 28 65
4 Kaiserslautern II Kaiserslaute 34 57 28 61
5 Wormatia Worms Wormatia 34 59 44 58
6 FC 08 Homburg Homburg 34 48 31 57
7 Freiburg II Freiburg II 34 66 46 53
8 Astoria Walldorf Astoria 34 51 40 53
9 Hoffenheim II Hoffenheim 34 44 46 51
10 Hessen Kassel Hessen 34 43 35 47
11 Eintracht Trier Eintracht 34 31 33 44
12 SpVgg Neckarelz SpVgg 34 47 55 44
13 Waldhof Mannheim Waldhof 34 36 33 43
14 FK Pirmasens Pirmasens 34 40 44 42
15 Nottingen Nottingen 34 50 67 37
16 Koblenz Koblenz 34 24 58 25
17 KSV Baunatal Baunatal 34 22 82 16
18 SVN Zweibrücken Zweibrücken 34 17 82 15
TEMPORADA 2013/2014
REGIONALLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 SG Sonnenhof Großaspach Sonnenhof 34 71 37 75
2 Freiburg II Freiburg II 34 69 37 67
3 Mainz 05 II Mainz 05 II 34 63 34 67
4 Kaiserslautern II Kaiserslaute 34 66 31 63
5 Waldhof Mannheim Waldhof 34 48 40 53
6 Eintracht Trier Eintracht 34 49 37 51
7 SVN Zweibrücken Zweibrücken 34 45 39 51
8 Kickers Offenbach FC Kickers 34 39 31 50
9 SpVgg Neckarelz SpVgg 34 42 47 48
10 Hoffenheim II Hoffenheim 34 52 45 45
11 FC 08 Homburg Homburg 34 50 47 44
12 Eintracht Frankfurt II Eintracht 34 52 55 42
13 Hessen Kassel Hessen 34 41 64 40
14 Koblenz Koblenz 34 36 46 39
15 Ulm Ulm 34 39 56 32
16 Wormatia Worms Wormatia 34 36 62 30
17 KSV Baunatal Baunatal 34 33 71 25
18 Pfullendorf Pfullendorf 34 29 81 19
TEMPORADA 2012/2013
REGIONALLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Hessen Kassel Hessen 36 56 36 70
2 SV Elversberg Elversberg 36 59 44 65
3 Kaiserslautern II Kaiserslaute 36 56 38 60
4 SG Sonnenhof Großaspach Sonnenhof 36 62 36 58
5 Eintracht Trier Eintracht 36 50 44 57
6 Waldhof Mannheim Waldhof 36 48 38 55
7 Freiburg II Freiburg II 36 61 48 52
8 Koblenz Koblenz 36 46 44 52
9 Hoffenheim II Hoffenheim 36 62 45 51
10 Ulm Ulm 36 46 46 51
11 Mainz 05 II Mainz 05 II 36 55 56 49
12 Wormatia Worms Wormatia 36 49 51 44
13 Pfullendorf Pfullendorf 36 40 49 43
14 FC 08 Homburg Homburg 36 51 64 43
15 Eintracht Frankfurt II Eintracht 36 48 54 40
16 Eschborn Eschborn 36 43 56 40
17 FSV Frankfurt II Frankfurt 36 38 62 40
18 Idar-Oberstein Idar-Oberste 36 41 57 35
19 Bayern Alzenau Bayern 36 43 86 28
TEMPORADA 2011/2012
REGIONALLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Stuttgarter Kickers Stuttgarter 34 66 29 78
2 SG Sonnenhof Großaspach Sonnenhof 34 78 40 69
3 Eintracht Frankfurt II Eintracht 34 69 41 67
4 Wormatia Worms Wormatia 34 57 48 58
5 Karlsruher SC II Karlsruher 34 56 48 58
6 Greuther Fürth II Greuther 34 50 48 54
7 Hoffenheim II Hoffenheim 34 69 36 52
8 Freiburg II Freiburg II 34 49 49 49
9 Ingolstadt 04 II Ingolstadt 34 46 50 49
10 Nürnberg II Nürnberg 34 59 54 44
11 Hessen Kassel Hessen 34 43 54 42
12 Waldhof Mannheim Waldhof 34 40 46 39
13 1860 München II 1860 34 28 52 38
14 Bayern München II Bayern 34 43 54 34
15 Memmingen Memmingen 34 37 54 33
16 Pfullendorf Pfullendorf 34 40 65 33
17 FSV Frankfurt II Frankfurt 34 45 70 28
18 Bayern Alzenau Bayern 34 39 76 26
TEMPORADA 2010/2011
REGIONALLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Darmstadt 98 Darmstadt 30 50 26 62
2 Stuttgarter Kickers Stuttgarter 30 54 28 58
3 Hessen Kassel Hessen 30 59 37 54
4 Hoffenheim II Hoffenheim 31 64 40 49
5 Greuther Fürth II Greuther 30 51 42 48
6 Eintracht Frankfurt II Eintracht 30 56 48 46
7 Freiburg II Freiburg II 30 65 54 43
8 1860 München II 1860 30 39 54 41
9 Pfullendorf Pfullendorf 30 40 43 40
10 Karlsruher SC II Karlsruher 30 42 37 39
11 Nürnberg II Nürnberg 30 45 46 38
12 Wormatia Worms Wormatia 30 40 45 36
13 Memmingen Memmingen 30 33 50 36
14 SG Sonnenhof Großaspach Sonnenhof 30 29 44 33
15 FSV Frankfurt II Frankfurt 30 31 54 24
16 Wehen Wiesbaden II Wehen 30 25 71 20
17 Weiden Weiden 0 0 0 0
18 Ulm Ulm 1 0 4 0
TEMPORADA 2009/2010
REGIONALLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 VfR Aalen VfR Aalen 34 51 19 74
2 Nürnberg II Nürnberg 34 55 30 63
3 Freiburg II Freiburg II 34 63 34 61
4 Hessen Kassel Hessen 34 63 41 59
5 Karlsruher SC II Karlsruher 34 50 51 52
6 Ulm Ulm 34 52 45 51
7 1860 München II 1860 34 51 39 49
8 Eintracht Frankfurt II Eintracht 34 57 41 48
9 Stuttgarter Kickers Stuttgarter 34 43 39 48
10 Weiden Weiden 34 57 67 48
11 Greuther Fürth II Greuther 34 44 58 47
12 SG Sonnenhof Großaspach Sonnenhof 34 53 44 46
13 Pfullendorf Pfullendorf 34 39 41 41
14 Reutlingen Reutlingen 34 43 56 40
15 Darmstadt 98 Darmstadt 34 39 49 34
16 Wehen Wiesbaden II Wehen 34 32 56 29
17 Eintracht Bamberg Eintracht 34 40 76 28
18 Bayern Alzenau Bayern 34 23 69 19
TEMPORADA 2008/2009
REGIONALLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Heidenheim Heidenheim 34 61 37 72
2 Hessen Kassel Hessen 34 75 33 71
3 Eintracht Frankfurt II Eintracht 34 61 35 66
4 Waldhof Mannheim Waldhof 34 54 30 63
5 Nürnberg II Nürnberg 34 65 37 61
6 1860 München II 1860 34 59 42 55
7 Ulm Ulm 34 55 35 53
8 Pfullendorf Pfullendorf 34 50 48 50
9 Wehen Wiesbaden II Wehen 34 40 37 49
10 Eintracht Bamberg Eintracht 34 50 61 44
11 Greuther Fürth II Greuther 34 37 39 41
12 Reutlingen Reutlingen 34 41 55 40
13 Viktoria Aschaffenburg Viktoria 34 38 46 39
14 Freiburg II Freiburg II 34 46 63 38
15 Darmstadt 98 Darmstadt 34 44 54 37
16 Karlsruher SC II Karlsruher 34 37 66 34
17 Grossbardorf Grossbardorf 34 32 84 18
18 Unterhaching II Unterhaching 34 35 78 17
TEMPORADA 2007/2008
REGIONALLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 FSV Frankfurt Frankfurt 34 57 31 62
2 Ingolstadt 04 Ingolstadt 34 50 36 62
3 Stuttgart II Stuttgart 34 52 30 59
4 VfR Aalen VfR Aalen 34 64 45 57
5 Sandhausen Sandhausen 34 48 38 57
6 Unterhaching Unterhaching 34 55 44 54
7 SV Wacker Burghausen Wacker 34 36 37 49
8 Bayern München II Bayern 34 53 42 47
9 Jahn Regensburg Jahn 34 40 48 47
10 Stuttgarter Kickers Stuttgarter 34 38 35 45
11 Siegen Sportfreunde Siegen 34 35 37 45
12 Reutlingen Reutlingen 34 45 46 44
13 1860 München II 1860 34 40 44 42
14 Hessen Kassel Hessen 34 51 57 38
15 SV Elversberg Elversberg 34 35 52 38
16 Karlsruher SC II Karlsruher 34 33 45 37
17 Pfullendorf Pfullendorf 34 33 41 34
18 Ludwigshafen-Oggersheim Ludwigshafen 34 17 74 12
TEMPORADA 2006/2007
REGIONALLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Wehen Wiesbaden Wehen 34 58 25 72
2 Hoffenheim Hoffenheim 34 62 31 68
3 Stuttgart II Stuttgart 34 47 42 53
4 Stuttgarter Kickers Stuttgarter 34 51 41 51
5 Ingolstadt 04 Ingolstadt 34 45 39 51
6 VfR Aalen VfR Aalen 34 51 46 49
7 Pfullendorf Pfullendorf 34 45 46 47
8 Bayern München II Bayern 34 41 37 46
9 SV Elversberg Elversberg 34 51 54 46
10 Hessen Kassel Hessen 34 45 56 46
11 Reutlingen Reutlingen 34 31 37 45
12 Siegen Sportfreunde Siegen 34 53 49 44
13 1860 München II 1860 34 54 47 43
14 Karlsruher SC II Karlsruher 34 44 44 43
15 1. FC Saarbrücken Saarbrücken 34 52 50 42
16 Darmstadt 98 Darmstadt 34 47 59 39
17 FK Pirmasens Pirmasens 34 31 61 31
18 Kaiserslautern II Kaiserslaute 34 19 63 10
TEMPORADA 2005/2006
OBERLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 Hessen Kassel Hessen 34 75 25 75
2 FSV Frankfurt Frankfurt 34 73 26 75
3 Waldgirmes Waldgirmes 34 61 39 62
4 Buchonia Flieden Buchonia 34 49 40 55
5 Bayern Alzenau Bayern 34 48 47 53
6 Bad Vilbel Bad Vilbel 34 57 51 52
7 Vellmar Vellmar 34 57 56 49
8 Wörsdorf Wörsdorf 34 46 39 48
9 Klein-Karben Klein-Karben 34 49 46 48
10 Viktoria Aschaffenburg Viktoria 34 48 54 43
11 Eintracht Frankfurt II Eintracht 34 47 41 42
12 Erzhausen Erzhausen 34 47 56 42
13 Schwalmstadt Schwalmstadt 34 52 62 41
14 KSV Baunatal Baunatal 34 38 48 41
15 Fernwald Fernwald 34 37 47 41
16 Bruchkobel Bruchkobel 34 46 60 41
17 Germania 08 Ober Roden Germania 34 38 68 32
18 Wattenbach Wattenbach 34 27 90 13
TEMPORADA 2004/2005
OBERLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Eschborn Eschborn 34 98 22 87
2 FSV Frankfurt Frankfurt 34 77 36 79
3 Waldgirmes Waldgirmes 34 57 56 59
4 KSV Baunatal Baunatal 34 64 51 51
5 Bad Vilbel Bad Vilbel 34 53 53 50
6 Klein-Karben Klein-Karben 34 52 63 48
7 Wörsdorf Wörsdorf 34 49 35 47
8 Erzhausen Erzhausen 34 71 60 47
9 Viktoria Aschaffenburg Viktoria 34 57 59 47
10 Buchonia Flieden Buchonia 34 48 44 45
11 Germania Ober-Roden Germania 34 57 66 44
12 Eintracht Frankfurt II Eintracht 34 59 71 42
13 Hessen Kassel Hessen 34 52 48 39
14 Schwalmstadt Schwalmstadt 34 64 80 39
15 Vellmar Vellmar 34 48 69 38
16 Bernbach Bernbach 34 39 63 35
17 Eintr. Wald-Michelbach Eintr. 34 38 88 30
18 Marburg Marburg 34 40 59 24

  USO DE MEMORIA  
7,996,984 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.6677
Total Execution Time  0.6696
  CADENA URL  
/historico/Hessen-Kassel
  GET DATOS  
$_GET['/historico/Hessen-Kassel']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0141  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 = 'Hessen-Kassel' 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.0127  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=5685 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0136  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=5685 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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=5685 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5685 AND type_rel = 2
0.0168  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 = '5685' ORDER BY l.year DESC,cat.coefficient DESC
0.0157  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 = '5685' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0168  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 = '5685' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0133  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 = 72592 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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=5685 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0131  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 (72592,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.0158  SELECT count(id) as num_players from rel_players WHERE league_id = 72592 AND teamId = 5685
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 5685
0.0136  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 = 72592 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '5685' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5685' and rp.type = 4
0.0127  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 = '5685' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0140  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 = 72592 WHERE rp.league_id = 72592 AND rp.teamId = 5685 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.0137  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 = 72592 WHERE rp.league_id = 72592 AND rp.teamId = 5685 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 72592 WHERE rp.league_id = 72592 AND rp.teamId = 5685 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 5685 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0131  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 = 68047 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.0131  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 = 63290 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.0131  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 = 57336 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.0130  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 = 50466 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 44342 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 38891 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 33768 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 15531 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 3903 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 2505 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 2005 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 1332 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 16429 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 16432 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 16435 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 16439 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 16448 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 19887 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 28294 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC