4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SG Sonnenhof Großaspach
TEMPORADA 2023/2024
OBERLIGA GRUPO 9
Equipo PJ GF GC Puntos
1 SG Sonnenhof Großaspach Sonnenhof 29 71 24 60
2 Villingen Villingen 29 69 36 59
3 Göppinger SV Göppinger 29 58 32 59
4 CfR Pforzheim Pforzheim 29 64 37 54
5 Nottingen Nottingen 29 62 38 45
6 Normannia Gmünd Normannia 29 42 35 44
7 TSV Essingen Essingen 29 42 40 44
8 FSV Hollenbach Hollenbach 29 56 52 43
9 TSG Backnang Backnang 29 40 49 39
10 Ravensburg Ravensburg 29 41 48 36
11 ATSV Mutschelbach ATSV 29 63 72 36
12 VfR Mannheim Mannheim 29 36 54 36
13 Oberachern Oberachern 29 46 58 34
14 Reutlingen Reutlingen 29 47 55 33
15 Bissingen Bissingen 29 47 52 32
16 FC Holzhausen Holzhausen 29 40 52 31
17 Denzlingen Denzlingen 29 37 66 28
18 Offenburger FV Offenburger 29 28 89 10
TEMPORADA 2022/2023
OBERLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 Stuttgarter Kickers Stuttgarter 34 108 17 84
2 SG Sonnenhof Großaspach Sonnenhof 34 66 42 69
3 CfR Pforzheim Pforzheim 34 80 51 66
4 Göppinger SV Göppinger 34 57 48 58
5 ATSV Mutschelbach ATSV 34 71 66 57
6 Oberachern Oberachern 34 57 52 49
7 FC Holzhausen Holzhausen 34 69 62 48
8 FSV Hollenbach Hollenbach 34 46 42 48
9 Bissingen Bissingen 34 68 72 47
10 Nottingen Nottingen 34 68 66 45
11 Villingen Villingen 34 69 62 44
12 Offenburger FV Offenburger 34 48 75 40
13 TSG Backnang Backnang 34 56 76 39
14 Reutlingen Reutlingen 34 46 63 37
15 Ravensburg Ravensburg 34 44 62 37
16 1.FC Rielasingen-Arlen 1.FC 34 55 77 37
17 Neckarsulmer SU Neckarsulmer 34 46 68 31
18 Freiburger FC Freiburger 34 38 91 18
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
3. LIGA
Equipo PJ GF GC Puntos
1 Bayern München II Bayern 38 76 60 65
2 Würzburger Kickers Würzburger 38 71 60 64
3 Eintracht Braunschweig Eintracht 38 64 53 64
4 Ingolstadt 04 Ingolstadt 38 61 40 63
5 MSV Duisburg Duisburg 38 68 48 62
6 Hansa Rostock Hansa 38 54 43 59
7 SV Meppen SV Meppen 38 69 57 58
8 1860 München 1860 38 63 54 58
9 Waldhof Mannheim Waldhof 38 52 47 56
10 Kaiserslautern Kaiserslaute 38 59 54 55
11 Unterhaching Unterhaching 38 50 53 51
12 Viktoria Köln Viktoria 38 65 71 51
13 KFC Uerdingen 05 Uerdingen 38 40 54 48
14 Magdeburg Magdeburg 38 49 42 47
15 Hallescher FC Hallescher 38 64 66 46
16 Zwickau Zwickau 38 56 61 44
17 Chemnitzer Chemnitzer 38 54 60 44
18 Preußen Münster Preußen 38 49 62 40
19 SG Sonnenhof Großaspach Sonnenhof 38 33 67 32
20 FC Carl Zeiss Jena Carl Zeiss. 38 40 85 23
TEMPORADA 2018/2019
3. LIGA
Equipo PJ GF GC Puntos
1 VfL Osnabrück Osnabrück 38 56 31 76
2 Karlsruher SC Karlsruher 38 64 38 71
3 Wehen Wiesbaden Wehen 38 71 47 70
4 Hallescher FC Hallescher 38 47 34 66
5 Würzburger Kickers Würzburger 38 56 45 57
6 Hansa Rostock Hansa 38 47 46 55
7 Zwickau Zwickau 38 49 47 52
8 Preußen Münster Preußen 38 48 50 52
9 Kaiserslautern Kaiserslaute 38 49 51 51
10 KFC Uerdingen 05 Uerdingen 38 47 62 48
11 1860 München 1860 38 48 52 47
12 Unterhaching Unterhaching 37 53 46 47
13 SV Meppen SV Meppen 38 48 53 47
14 FC Carl Zeiss Jena Carl Zeiss. 38 48 57 46
15 SG Sonnenhof Großaspach Sonnenhof 38 38 39 45
16 Eintracht Braunschweig Eintracht 38 48 54 45
17 Energie Cottbus Energie 37 51 58 44
18 Sportfreunde Lotte Sportfreunde 38 31 46 40
19 Fortuna Köln Fortuna 38 38 64 39
20 VfR Aalen VfR Aalen 38 45 62 31
TEMPORADA 2017/2018
3. LIGA
Equipo PJ GF GC Puntos
1 Magdeburg Magdeburg 38 70 32 85
2 Paderborn Paderborn 38 90 33 83
3 Karlsruher SC Karlsruher 38 49 29 69
4 Wehen Wiesbaden Wehen 38 76 39 68
5 Würzburger Kickers Würzburger 38 53 46 61
6 Hansa Rostock Hansa 38 48 34 60
7 SV Meppen SV Meppen 38 50 47 58
8 Fortuna Köln Fortuna 38 53 48 54
9 Unterhaching Unterhaching 38 54 55 54
10 Preußen Münster Preußen 38 50 49 52
11 FC Carl Zeiss Jena Carl Zeiss. 38 49 59 52
12 VfR Aalen VfR Aalen 38 48 57 50
13 Hallescher FC Hallescher 38 52 54 49
14 SG Sonnenhof Großaspach Sonnenhof 38 55 60 47
15 Zwickau Zwickau 38 38 55 41
16 Sportfreunde Lotte Sportfreunde 38 43 60 40
17 VfL Osnabrück Osnabrück 38 47 67 37
18 Werder Bremen II Werder 38 39 62 31
19 Chemnitzer Chemnitzer 38 48 74 22
20 Rot-Weiss Erfurt Rot-Weiss 38 26 78 13
TEMPORADA 2016/2017
3. LIGA
Equipo PJ GF GC Puntos
1 MSV Duisburg Duisburg 38 52 32 68
2 Holstein Kiel Holstein 38 59 25 67
3 Jahn Regensburg Jahn 38 62 50 63
4 Magdeburg Magdeburg 38 53 36 61
5 Zwickau Zwickau 38 47 54 56
6 VfL Osnabrück Osnabrück 38 46 43 54
7 Wehen Wiesbaden Wehen 38 45 42 53
8 Chemnitzer Chemnitzer 38 54 51 52
9 Preußen Münster Preußen 38 49 43 51
10 SG Sonnenhof Großaspach Sonnenhof 38 48 48 51
11 VfR Aalen VfR Aalen 38 52 36 48
12 Sportfreunde Lotte Sportfreunde 38 46 47 48
13 Hallescher FC Hallescher 38 34 39 48
14 Rot-Weiss Erfurt Rot-Weiss 38 34 47 47
15 Hansa Rostock Hansa 38 44 46 46
16 Fortuna Köln Fortuna 38 37 59 46
17 Werder Bremen II Werder 38 32 48 45
18 Paderborn Paderborn 38 38 57 44
19 Mainz 05 II Mainz 05 II 38 41 58 40
20 FSV Frankfurt Frankfurt 38 38 50 25
TEMPORADA 2015/2016
3. LIGA
Equipo PJ GF GC Puntos
1 Dynamo Dresden Dynamo 38 75 35 78
2 Erzgebirge Aue Erzgebirge 38 42 21 70
3 Würzburger Kickers Würzburger 38 43 25 64
4 Magdeburg Magdeburg 38 49 37 56
5 VfL Osnabrück Osnabrück 38 46 41 56
6 Chemnitzer Chemnitzer 38 52 46 55
7 SG Sonnenhof Großaspach Sonnenhof 38 58 47 54
8 Rot-Weiss Erfurt Rot-Weiss 38 47 50 50
9 Preußen Münster Preußen 38 43 41 49
10 Hansa Rostock Hansa 38 42 48 49
11 Fortuna Köln Fortuna 38 56 69 49
12 Mainz 05 II Mainz 05 II 38 48 47 48
13 Hallescher FC Hallescher 38 48 48 48
14 Holstein Kiel Holstein 38 44 47 48
15 VfR Aalen VfR Aalen 38 35 40 44
16 Wehen Wiesbaden Wehen 38 35 48 43
17 Werder Bremen II Werder 38 42 56 43
18 Stuttgarter Kickers Stuttgarter 38 38 52 43
19 Energie Cottbus Energie 38 32 52 41
20 Stuttgart II Stuttgart 38 38 63 31
TEMPORADA 2014/2015
3. LIGA
Equipo PJ GF GC Puntos
1 Arminia Bielefeld Arminia 38 75 41 74
2 MSV Duisburg Duisburg 38 63 40 71
3 Holstein Kiel Holstein 38 53 30 67
4 Stuttgarter Kickers Stuttgarter 38 61 47 65
5 Chemnitzer Chemnitzer 38 44 36 59
6 Dynamo Dresden Dynamo 38 52 48 56
7 Energie Cottbus Energie 38 50 50 56
8 Preußen Münster Preußen 38 53 49 54
9 Wehen Wiesbaden Wehen 38 54 44 53
10 Hallescher FC Hallescher 38 51 53 53
11 VfL Osnabrück Osnabrück 38 49 51 52
12 Rot-Weiss Erfurt Rot-Weiss 38 47 54 51
13 Stuttgart II Stuttgart 38 48 57 47
14 Fortuna Köln Fortuna 38 38 47 46
15 SG Sonnenhof Großaspach Sonnenhof 38 39 60 46
16 Mainz 05 II Mainz 05 II 38 43 52 42
17 Hansa Rostock Hansa 38 54 68 41
18 B. Dortmund II Dortmund 38 41 51 39
19 Unterhaching Unterhaching 38 51 67 39
20 Jahn Regensburg Jahn 38 44 65 31
TEMPORADA 2013/2014
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
OBERLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 SG Sonnenhof Großaspach Sonnenhof 34 81 19 81
2 Hoffenheim II Hoffenheim 34 77 20 72
3 TSG Balingen Balingen 34 66 42 64
4 Astoria Walldorf Astoria 34 65 40 57
5 Nottingen Nottingen 34 54 43 57
6 Bahlinger SC Bahlinger 34 57 51 56
7 Stuttgarter Kickers II Stuttgarter 34 65 58 48
8 Illertissen Illertissen 34 58 56 48
9 Normannia Gmünd Normannia 34 53 55 48
10 Kirchheim/Teck Kirchheim/Te 34 49 58 48
11 Freiberg Freiberg 34 53 51 47
12 Villingen Villingen 34 42 38 45
13 Crailsheim Crailsheim 34 54 61 45
14 ASV Durlach ASV Durlach 34 41 65 38
15 Kehler FV Kehler FV 34 32 58 30
16 VfR Mannheim Mannheim 34 42 87 23
17 Au Iller Au Iller 34 29 70 22
18 Offenburger FV Offenburger 34 34 80 20
TEMPORADA 2007/2008
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 Freiburg II Freiburg II 34 62 36 73
2 Ulm Ulm 34 61 25 71
3 Waldhof Mannheim Waldhof 34 54 22 71
4 Heidenheim Heidenheim 34 69 29 69
5 Hoffenheim II Hoffenheim 34 59 31 67
6 Villingen Villingen 34 71 35 63
7 Crailsheim Crailsheim 33 65 40 58
8 Astoria Walldorf Astoria 33 65 51 54
9 Normannia Gmünd Normannia 34 51 49 48
10 SG Sonnenhof Großaspach Sonnenhof 34 38 40 42
11 Nottingen Nottingen 34 51 54 41
12 Freiberg Freiberg 34 53 56 38
13 Bahlinger SC Bahlinger 34 38 65 31
14 Kirchheim/Teck Kirchheim/Te 34 39 69 28
15 Stuttgarter Kickers II Stuttgarter 34 48 81 28
16 VfR Mannheim Mannheim 34 34 66 24
17 Schwieberdingen 1906 Schwieberdin 34 36 90 24
18 Linx Linx 34 34 89 17
TEMPORADA 2006/2007
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 Sandhausen Sandhausen 34 91 36 77
2 Ulm Ulm 34 84 29 76
3 Heidenheim Heidenheim 34 75 36 72
4 Villingen Villingen 34 66 56 56
5 Freiberg Freiberg 34 54 44 54
6 Crailsheim Crailsheim 34 65 53 53
7 Freiburg II Freiburg II 34 62 43 52
8 Hoffenheim II Hoffenheim 34 62 53 51
9 Stuttgarter Kickers II Stuttgarter 34 61 61 49
10 Waldhof Mannheim Waldhof 34 43 39 48
11 Normannia Gmünd Normannia 34 36 51 40
12 Bahlinger SC Bahlinger 34 51 63 39
13 SG Sonnenhof Großaspach Sonnenhof 34 46 73 39
14 Nottingen Nottingen 34 42 54 37
15 VfR Mannheim Mannheim 34 45 60 35
16 Pforzheim Pforzheim 34 27 66 29
17 FC Emmendingen Emmendingen 34 26 65 26
18 Bonlanden Bonlanden 34 20 74 22
TEMPORADA 2005/2006
OBERLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Reutlingen Reutlingen 34 68 16 82
2 Heidenheim Heidenheim 34 67 30 78
3 Ulm Ulm 34 89 32 75
4 Freiburg II Freiburg II 34 62 33 64
5 Sandhausen Sandhausen 34 65 34 60
6 Hoffenheim II Hoffenheim 34 58 51 51
7 Freiberg Freiberg 34 52 59 51
8 Waldhof Mannheim Waldhof 34 46 49 46
9 Nottingen Nottingen 34 61 55 45
10 VfR Mannheim Mannheim 34 43 51 43
11 Crailsheim Crailsheim 34 55 53 40
12 Normannia Gmünd Normannia 34 38 57 38
13 Stuttgarter Kickers II Stuttgarter 34 36 57 38
14 SG Sonnenhof Großaspach Sonnenhof 34 38 63 33
15 FC Emmendingen Emmendingen 34 29 54 31
16 ASV Durlach ASV Durlach 34 42 71 29
17 Lauda Lauda 34 27 65 26
18 Linx Linx 34 42 88 24

  USO DE MEMORIA  
7,844,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.4532
Total Execution Time  0.4546
  CADENA URL  
/historico/Sonnenhof-Gro-Szlig
  GET DATOS  
$_GET['/historico/Sonnenhof-Gro-Szlig']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0137  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 = 'Sonnenhof-Gro-Szlig' 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.0125  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=5684 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=5684 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133  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=5684 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0155  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 = '5684' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0142  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 = 5684 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0135  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 = 72633 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 68133 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.0135  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.0136  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.0142  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.0145  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.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 = 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.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 `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15102 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 3885 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 `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.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 `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.0134  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.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 `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.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 `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 = 19857 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 `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 = 19872 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 19881 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 19886 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC