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

SC Freiburg

Entrenador: Christian Streich

Temporada 1997/1998
TEMPORADA 1997/1998
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Eintracht Frankfurt Eintracht 34 50 32 64
2 SC Freiburg SC Freiburg 34 57 36 61
3 Nürnberg Nürnberg 34 52 35 59
4 FC St Pauli FC St Pauli 34 43 31 56
5 Gutersloh Gutersloh 34 43 26 55
6 Fortuna Köln Fortuna 34 53 53 46
7 Fortuna Düsseldorf Fortuna 34 52 54 46
8 Energie Cottbus Energie 34 38 36 45
9 Greuther Fürth Greuther 34 32 32 45
10 Mainz 05 Mainz 05 34 55 48 44
11 Unterhaching Unterhaching 34 41 35 44
12 Stuttgarter Kickers Stuttgarter 34 44 47 44
13 KFC Uerdingen 05 Uerdingen 34 36 40 43
14 Wattenscheid 09 Wattenscheid 34 41 41 40
15 Lokomotive Leipzig Lokomotive 34 31 51 39
16 FC Carl Zeiss Jena Carl Zeiss. 34 39 61 33
17 Zwickau Zwickau 34 32 55 28
18 SV Meppen SV Meppen 34 35 61 27
TEMPORADA 1996/1997
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 68 34 71
2 B. Leverkusen Leverkusen 34 69 41 69
3 B. Dortmund B. Dortmund 34 63 41 63
4 Stuttgart Stuttgart 34 78 40 61
5 VfL Bochum VfL Bochum 34 54 51 53
6 Karlsruher SC Karlsruher 34 55 44 49
7 1860 München 1860 34 56 56 49
8 Werder Bremen Werder 34 53 52 48
9 MSV Duisburg Duisburg 34 44 49 45
10 Köln Köln 34 62 62 44
11 B. Mönchengladbach Mönchenglad 34 46 48 43
12 Schalke 04 Schalke 04 34 35 40 43
13 Hamburger SV Hamburger 34 46 60 41
14 Arminia Bielefeld Arminia 34 46 54 40
15 Hansa Rostock Hansa 34 35 46 40
16 Fortuna Düsseldorf Fortuna 34 26 57 33
17 SC Freiburg SC Freiburg 34 43 67 29
18 FC St Pauli FC St Pauli 34 32 69 27
TEMPORADA 1995/1996
BUNDESLIGA
Equipo PJ GF GC Puntos
1 B. Dortmund B. Dortmund 34 76 38 68
2 Bayern München Bayern 34 66 46 62
3 Schalke 04 Schalke 04 34 45 36 56
4 B. Mönchengladbach Mönchenglad 34 52 51 53
5 Hamburger SV Hamburger 34 52 47 50
6 Hansa Rostock Hansa 34 47 43 49
7 Karlsruher SC Karlsruher 34 53 47 48
8 1860 München 1860 34 52 46 45
9 Werder Bremen Werder 34 39 42 44
10 Stuttgart Stuttgart 34 59 62 43
11 SC Freiburg SC Freiburg 34 30 41 42
12 Köln Köln 34 33 35 40
13 Fortuna Düsseldorf Fortuna 34 40 47 40
14 B. Leverkusen Leverkusen 34 37 38 38
15 FC St Pauli FC St Pauli 34 43 51 38
16 Kaiserslautern Kaiserslaute 34 31 37 36
17 Eintracht Frankfurt Eintracht 34 43 68 32
18 KFC Uerdingen 05 Uerdingen 34 33 56 26
TEMPORADA 1994/1995
BUNDESLIGA
Equipo PJ GF GC Puntos
1 B. Dortmund B. Dortmund 34 67 33 49
2 Werder Bremen Werder 34 70 39 48
3 SC Freiburg SC Freiburg 34 66 44 46
4 Kaiserslautern Kaiserslaute 34 58 41 46
5 B. Mönchengladbach Mönchenglad 34 66 41 43
6 Bayern München Bayern 34 55 41 43
7 B. Leverkusen Leverkusen 34 62 51 36
8 Karlsruher SC Karlsruher 34 51 47 36
9 Eintracht Frankfurt Eintracht 34 41 49 33
10 Köln Köln 34 54 54 32
11 Schalke 04 Schalke 04 34 48 54 31
12 Stuttgart Stuttgart 34 52 66 30
13 Hamburger SV Hamburger 34 43 50 29
14 1860 München 1860 34 41 57 27
15 KFC Uerdingen 05 Uerdingen 34 37 52 25
16 VfL Bochum VfL Bochum 34 43 67 22
17 MSV Duisburg Duisburg 34 31 64 20
18 Dynamo Dresden Dynamo 34 33 68 16
TEMPORADA 1993/1994
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 68 37 44
2 Kaiserslautern Kaiserslaute 34 64 36 43
3 B. Leverkusen Leverkusen 34 60 47 39
4 B. Dortmund B. Dortmund 34 49 45 39
5 Eintracht Frankfurt Eintracht 34 57 41 38
6 Karlsruher SC Karlsruher 34 46 43 38
7 Stuttgart Stuttgart 34 51 43 37
8 Werder Bremen Werder 34 51 44 36
9 MSV Duisburg Duisburg 34 41 52 36
10 B. Mönchengladbach Mönchenglad 34 65 59 35
11 Köln Köln 34 49 51 34
12 Hamburger SV Hamburger 34 48 52 34
13 Dynamo Dresden Dynamo 34 33 44 30
14 Schalke 04 Schalke 04 34 38 50 29
15 SC Freiburg SC Freiburg 34 54 57 28
16 Nürnberg Nürnberg 34 41 55 28
17 Wattenscheid 09 Wattenscheid 34 48 70 23
18 Lokomotive Leipzig Lokomotive 34 32 69 17
TEMPORADA 1992/1993
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 SC Freiburg SC Freiburg 46 102 57 65
2 MSV Duisburg Duisburg 46 65 40 60
3 Lokomotive Leipzig Lokomotive 46 66 45 58
4 Waldhof Mannheim Waldhof 46 66 53 55
5 Hertha BSC Hertha BSC 46 82 55 53
6 Fortuna Köln Fortuna 46 56 44 50
7 Chemnitzer Chemnitzer 46 64 56 50
8 FC Carl Zeiss Jena Carl Zeiss. 46 66 59 50
9 Hannover 96 Hannover 96 46 60 60 48
10 SV Meppen SV Meppen 46 41 43 47
11 Hansa Rostock Hansa 46 54 52 46
12 Mainz 05 Mainz 05 46 54 58 46
13 Wuppertaler SV Wuppertaler 46 55 50 45
14 Wolfsburg Wolfsburg 46 65 69 45
15 Stuttgarter Kickers Stuttgarter 46 60 59 43
16 FC 08 Homburg Homburg 46 50 53 43
17 FC St Pauli FC St Pauli 46 47 52 43
18 Unterhaching Unterhaching 46 58 67 42
19 Eintracht Braunschweig Eintracht 46 65 73 41
20 VfL Osnabrück Osnabrück 46 63 72 41
21 Fortuna Düsseldorf Fortuna 46 45 65 34
22 VfB Oldenburg Oldenburg 46 57 90 34
23 FC Remscheid Remscheid 46 50 83 33
24 Darmstadt 98 Darmstadt 46 43 79 32
TEMPORADA 1991/1992
2. BUNDESLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 1. FC Saarbrücken Saarbrücken 10 14 6 42
2 Waldhof Mannheim Waldhof 10 17 14 38
3 SC Freiburg SC Freiburg 10 11 16 37
4 Chemnitzer Chemnitzer 10 9 11 36
5 FC Carl Zeiss Jena Carl Zeiss. 10 11 15 33
6 FC 08 Homburg Homburg 10 14 14 32
TEMPORADA 1990/1991
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Schalke 04 Schalke 04 38 64 29 57
2 MSV Duisburg Duisburg 38 70 34 53
3 Stuttgarter Kickers Stuttgarter 38 63 32 51
4 FC 08 Homburg Homburg 38 42 37 45
5 1. FC Saarbrücken Saarbrücken 38 47 30 44
6 Blau-Weiß 1890 Berlin Blau-Weiß 38 55 42 44
7 Waldhof Mannheim Waldhof 38 60 47 42
8 Mainz 05 Mainz 05 38 45 52 41
9 SC Freiburg SC Freiburg 38 54 48 40
10 Hannover 96 Hannover 96 38 49 49 38
11 Fortuna Köln Fortuna 38 51 53 37
12 VfB Oldenburg Oldenburg 38 58 53 36
13 Eintracht Braunschweig Eintracht 38 53 52 35
14 VfL Osnabrück Osnabrück 38 51 55 35
15 Rot-Weiss Essen Rot-Weiss 38 49 52 34
16 SV Meppen SV Meppen 38 35 42 34
17 Darmstadt 98 Darmstadt 38 46 54 33
18 Preußen Münster Preußen 38 35 59 29
19 Havelse Havelse 38 44 82 19
20 Schweinfurt Schweinfurt 38 26 95 13
TEMPORADA 1989/1990
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Hertha BSC Hertha BSC 38 65 39 53
2 Wattenscheid 09 Wattenscheid 38 70 35 51
3 1. FC Saarbrücken Saarbrücken 38 58 33 46
4 Stuttgarter Kickers Stuttgarter 38 68 48 45
5 Schalke 04 Schalke 04 38 69 51 43
6 Rot-Weiss Essen Rot-Weiss 38 49 46 42
7 Eintracht Braunschweig Eintracht 38 55 51 39
8 Hannover 96 Hannover 96 38 53 43 38
9 Blau-Weiß 1890 Berlin Blau-Weiß 38 46 52 37
10 MSV Duisburg Duisburg 38 50 58 37
11 SV Meppen SV Meppen 38 47 57 36
12 Preußen Münster Preußen 38 45 65 36
13 SC Freiburg SC Freiburg 38 53 52 34
14 Fortuna Köln Fortuna 38 48 60 34
15 VfL Osnabrück Osnabrück 38 58 69 33
16 Darmstadt 98 Darmstadt 38 43 55 33
17 Hessen Kassel Hessen 38 35 64 33
18 Bayreuth SpVgg Bayreuth 38 54 59 31
19 Alemannia Aachen Alemannia 38 52 63 30
20 Unterhaching Unterhaching 38 43 61 29
TEMPORADA 1988/1989
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Fortuna Düsseldorf Fortuna 38 85 52 49
2 FC 08 Homburg Homburg 38 55 36 47
3 1. FC Saarbrücken Saarbrücken 38 53 43 46
4 Fortuna Köln Fortuna 38 80 57 45
5 SC Freiburg SC Freiburg 38 66 52 42
6 Wattenscheid 09 Wattenscheid 38 68 58 42
7 Alemannia Aachen Alemannia 38 58 55 41
8 Blau-Weiß 1890 Berlin Blau-Weiß 38 56 54 41
9 Eintracht Braunschweig Eintracht 38 43 43 38
10 SV Meppen SV Meppen 38 55 54 37
11 Darmstadt 98 Darmstadt 38 56 57 37
12 Schalke 04 Schalke 04 38 58 51 36
13 Hertha BSC Hertha BSC 38 45 44 36
14 VfL Osnabrück Osnabrück 38 58 66 36
15 Kickers Offenbach FC Kickers 38 51 53 35
16 Rot-Weiss Essen Rot-Weiss 38 54 60 35
17 Bayreuth SpVgg Bayreuth 38 52 60 34
18 Viktoria Aschaffenburg Viktoria 38 47 60 34
19 Mainz 05 Mainz 05 38 44 76 29
20 Union Solingen Union 38 24 77 20
TEMPORADA 1987/1988
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Stuttgarter Kickers Stuttgarter 38 89 49 51
2 FC St Pauli FC St Pauli 38 65 38 49
3 Darmstadt 98 Darmstadt 38 48 32 47
4 Wattenscheid 09 Wattenscheid 38 62 48 47
5 Fortuna Düsseldorf Fortuna 38 63 38 46
6 Alemannia Aachen Alemannia 38 60 45 46
7 Blau-Weiß 1890 Berlin Blau-Weiß 38 65 48 43
8 Kickers Offenbach FC Kickers 38 56 49 39
9 VfL Osnabrück Osnabrück 38 47 47 38
10 SC Freiburg SC Freiburg 38 61 63 38
11 Rot-Weiss Essen Rot-Weiss 38 53 60 34
12 Fortuna Köln Fortuna 38 58 67 34
13 1. FC Saarbrücken Saarbrücken 38 57 67 34
14 SV Meppen SV Meppen 38 55 72 34
15 Union Solingen Union 38 48 65 34
16 Rot-Weiß Oberhausen Rot-Weiß 38 48 54 33
17 Bayreuth SpVgg Bayreuth 38 55 66 33
18 FC Remscheid Remscheid 38 54 74 29
19 Ulm Ulm 38 51 75 29
20 Arminia Bielefeld Arminia 38 29 67 22
TEMPORADA 1986/1987
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Hannover 96 Hannover 96 38 86 48 56
2 Karlsruher SC Karlsruher 38 79 49 52
3 FC St Pauli FC St Pauli 38 63 45 49
4 Darmstadt 98 Darmstadt 38 72 48 47
5 Alemannia Aachen Alemannia 38 55 36 46
6 VfL Osnabrück Osnabrück 38 69 66 44
7 Stuttgarter Kickers Stuttgarter 38 72 55 42
8 SC Freiburg SC Freiburg 38 59 56 39
9 Arminia Bielefeld Arminia 38 58 55 38
10 Rot-Weiss Essen Rot-Weiss 38 70 69 38
11 Wattenscheid 09 Wattenscheid 38 59 66 38
12 Union Solingen Union 38 61 65 35
13 Ulm Ulm 38 55 63 35
14 Fortuna Köln Fortuna 38 51 66 35
15 1. FC Saarbrücken Saarbrücken 38 53 71 34
16 Rot-Weiß Oberhausen Rot-Weiß 38 52 55 33
17 Eintracht Braunschweig Eintracht 38 52 47 32
18 Viktoria Aschaffenburg Viktoria 38 47 72 24
19 Hessen Kassel Hessen 38 40 75 22
20 Salmrohr Salmrohr 38 48 94 21
TEMPORADA 1985/1986
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 FC 08 Homburg Homburg 38 75 42 49
2 Blau-Weiß 1890 Berlin Blau-Weiß 38 76 48 47
3 Fortuna Köln Fortuna 38 64 52 46
4 Arminia Bielefeld Arminia 38 60 47 45
5 Hessen Kassel Hessen 38 58 47 44
6 Stuttgarter Kickers Stuttgarter 38 73 55 43
7 Karlsruher SC Karlsruher 38 64 50 43
8 Alemannia Aachen Alemannia 38 56 45 43
9 Wattenscheid 09 Wattenscheid 38 63 56 43
10 Darmstadt 98 Darmstadt 38 63 57 41
11 Rot-Weiß Oberhausen Rot-Weiß 38 61 60 37
12 Eintracht Braunschweig Eintracht 38 65 62 36
13 Viktoria Aschaffenburg Viktoria 38 57 59 35
14 VfL Osnabrück Osnabrück 38 48 57 35
15 Union Solingen Union 38 48 64 34
16 SC Freiburg SC Freiburg 38 54 62 33
17 Hertha BSC Hertha BSC 38 50 62 31
18 Bayreuth SpVgg Bayreuth 38 40 73 31
19 Tennis Borussia Tennis 38 48 73 29
20 MSV Duisburg Duisburg 38 34 86 15
TEMPORADA 1984/1985
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Nürnberg Nürnberg 38 71 45 50
2 Hannover 96 Hannover 96 38 79 58 50
3 1. FC Saarbrücken Saarbrücken 38 70 41 49
4 Hessen Kassel Hessen 38 72 48 49
5 Alemannia Aachen Alemannia 38 60 46 43
6 Union Solingen Union 38 64 70 41
7 Blau-Weiß 1890 Berlin Blau-Weiß 38 66 56 39
8 SC Freiburg SC Freiburg 38 45 49 38
9 Stuttgarter Kickers Stuttgarter 38 51 49 37
10 Wattenscheid 09 Wattenscheid 38 61 68 36
11 Fortuna Köln Fortuna 38 58 67 36
12 Rot-Weiß Oberhausen Rot-Weiß 38 64 70 35
13 MSV Duisburg Duisburg 38 56 63 35
14 Hertha BSC Hertha BSC 38 50 59 35
15 Darmstadt 98 Darmstadt 38 52 64 35
16 FC 08 Homburg Homburg 38 57 58 34
17 FC St Pauli FC St Pauli 38 48 59 33
18 Kickers Offenbach FC Kickers 38 43 56 32
19 VfR Bürstadt Bürstadt 38 48 56 31
20 Ulm Ulm 38 48 81 22
TEMPORADA 1983/1984
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Karlsruher SC Karlsruher 38 94 45 57
2 Schalke 04 Schalke 04 38 95 45 55
3 MSV Duisburg Duisburg 38 69 41 50
4 Hessen Kassel Hessen 38 68 39 48
5 Union Solingen Union 38 70 54 44
6 Alemannia Aachen Alemannia 38 49 43 44
7 SC Freiburg SC Freiburg 38 50 49 43
8 Stuttgarter Kickers Stuttgarter 38 54 52 39
9 Fortuna Köln Fortuna 38 66 65 38
10 1. FC Saarbrücken Saarbrücken 38 61 69 38
11 Hertha BSC Hertha BSC 38 64 57 37
12 Darmstadt 98 Darmstadt 38 48 72 35
13 Ulm Ulm 38 58 68 32
14 Hannover 96 Hannover 96 38 54 69 32
15 Wattenscheid 09 Wattenscheid 38 58 74 32
16 Rot-Weiß Oberhausen Rot-Weiß 38 51 62 31
17 Rot-Weiss Essen Rot-Weiss 38 48 63 29
18 SC Charlottenburg Charlottenbu 38 49 68 29
19 VfL Osnabrück Osnabrück 38 46 66 29
20 BV 08 Lüttringhausen Lüttringhau 38 36 87 18
TEMPORADA 1982/1983
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Waldhof Mannheim Waldhof 38 83 38 52
2 Kickers Offenbach FC Kickers 38 77 45 50
3 KFC Uerdingen 05 Uerdingen 38 65 44 48
4 Hessen Kassel Hessen 38 69 54 45
5 Stuttgarter Kickers Stuttgarter 38 78 51 44
6 Fortuna Köln Fortuna 38 76 50 43
7 Darmstadt 98 Darmstadt 38 77 61 42
8 SC Freiburg SC Freiburg 38 50 45 42
9 Alemannia Aachen Alemannia 38 49 53 40
10 VfL Osnabrück Osnabrück 38 66 65 38
11 MSV Duisburg Duisburg 38 55 57 37
12 Hannover 96 Hannover 96 38 70 72 36
13 BV 08 Lüttringhausen Lüttringhau 38 53 76 34
14 Rot-Weiss Essen Rot-Weiss 38 56 60 33
15 Wattenscheid 09 Wattenscheid 38 59 65 33
16 Union Solingen Union 38 56 76 32
17 FC Augsburg FC Augsburg 38 32 54 32
18 Greuther Fürth Greuther 38 55 75 31
19 FSV Frankfurt Frankfurt 38 50 86 26
20 TuS Schloß-Neuhaus Schloß-Neuh 38 43 92 22
TEMPORADA 1981/1982
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Schalke 04 Schalke 04 38 70 35 51
2 Hertha BSC Hertha BSC 38 84 47 48
3 Kickers Offenbach FC Kickers 38 70 67 46
4 1860 München 1860 38 87 56 45
5 Hannover 96 Hannover 96 38 72 52 45
6 Waldhof Mannheim Waldhof 38 51 44 44
7 Stuttgarter Kickers Stuttgarter 38 76 55 43
8 Hessen Kassel Hessen 38 56 46 43
9 Alemannia Aachen Alemannia 38 47 39 41
10 Fortuna Köln Fortuna 38 70 72 39
11 Rot-Weiss Essen Rot-Weiss 38 60 62 38
12 KFC Uerdingen 05 Uerdingen 38 47 57 38
13 VfL Osnabrück Osnabrück 38 49 59 37
14 Greuther Fürth Greuther 38 61 60 35
15 SC Freiburg SC Freiburg 38 49 54 34
16 Union Solingen Union 38 51 62 33
17 Wattenscheid 09 Wattenscheid 38 41 62 31
18 Wormatia Worms Wormatia 38 34 74 24
19 Freiburger FC Freiburger 38 52 88 23
20 Bayreuth SpVgg Bayreuth 38 40 76 22
TEMPORADA 1980/1981
2. BUNDESLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Darmstadt 98 Darmstadt 38 85 42 55
2 Kickers Offenbach FC Kickers 38 87 42 50
3 Stuttgarter Kickers Stuttgarter 38 81 40 48
4 Hessen Kassel Hessen 38 59 35 48
5 Ulm Ulm 38 59 39 47
6 Waldhof Mannheim Waldhof 38 65 43 45
7 SC Freiburg SC Freiburg 38 57 50 41
8 Eintracht Trier Eintracht 38 56 52 41
9 Bayreuth SpVgg Bayreuth 38 60 53 39
10 Freiburger FC Freiburger 38 76 75 39
11 FC 08 Homburg Homburg 38 66 69 38
12 Wormatia Worms Wormatia 38 60 70 37
13 VfR Bürstadt Bürstadt 38 54 66 37
14 Greuther Fürth Greuther 38 54 54 35
15 FSV Frankfurt Frankfurt 38 51 76 32
16 ESV Ingolstadt Ingolstadt 38 62 92 31
17 1. FC Saarbrücken Saarbrücken 38 43 61 28
18 FC Augsburg FC Augsburg 38 55 88 24
19 Borussia Neunkirchen Borussia 38 44 85 23
20 VfB Eppingen Eppingen 38 44 86 22
TEMPORADA 1979/1980
2. BUNDESLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Nürnberg Nürnberg 40 88 38 61
2 Karlsruher SC Karlsruher 40 104 52 59
3 Stuttgarter Kickers Stuttgarter 40 94 54 52
4 Darmstadt 98 Darmstadt 40 81 42 48
5 1. FC Saarbrücken Saarbrücken 40 69 56 47
6 SC Freiburg SC Freiburg 40 68 54 46
7 Greuther Fürth Greuther 40 56 51 44
8 Kickers Offenbach FC Kickers 40 78 64 43
9 Freiburger FC Freiburger 40 78 83 43
10 Wormatia Worms Wormatia 40 67 73 38
11 Waldhof Mannheim Waldhof 40 57 69 38
12 FC 08 Homburg Homburg 40 58 62 37
13 Bayreuth SpVgg Bayreuth 40 77 82 37
14 VfR Bürstadt Bürstadt 40 57 68 37
15 Eintracht Trier Eintracht 40 60 57 36
16 Ulm Ulm 40 51 57 36
17 ESV Ingolstadt Ingolstadt 40 57 89 34
18 FSV Frankfurt Frankfurt 40 63 97 32
19 MTV Ingolstadt Ingolstadt 40 58 81 29
20 Rochling Volklingen Rochling 40 49 101 22
21 Würzburger FV Würzburger 40 42 82 21

  USO DE MEMORIA  
8,142,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2040
Total Execution Time  0.2059
  CADENA URL  
/historico/Sc-Freiburg/1998
  GET DATOS  
$_GET['/historico/Sc-Freiburg/1998']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0041  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 = 'Sc-Freiburg' AND l.year = 1998 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=2286 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=2286 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=2286 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 22419
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2286 AND type_rel = 2
0.0027  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2286 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1255719,3005,3494,30857,38230) ORDER BY n.cover_points DESC, update_date DESC
0.0056  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 = '2286' AND l.year = 1998 ORDER BY l.year DESC,cat.coefficient DESC
0.0051  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 = '2286' 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 = 9842 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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 = 22419 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0041  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=2286 AND l.year in (1997,1998,1999) 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 (22420,9842,209) 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.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 209 AND teamId = 2286
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 9842 AND teamId = 2286
0.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 22420 AND teamId = 2286
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 FROM `tables1998` 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 = 9842 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0067  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 events1998 e ON e.player_id = p.id AND e.league_id = 9842 WHERE rp.league_id = 9842 AND rp.teamId = 2286 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.0066  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 events1998 e ON e.player_id = p.id AND e.league_id = 9842 WHERE rp.league_id = 9842 AND rp.teamId = 2286 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0060  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 events1998 e ON e.player_id = p.id AND e.league_id = 9842 WHERE rp.league_id = 9842 AND rp.teamId = 2286 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0084  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 = 2286 AND l.year <= 1998 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables1998` 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 = 9842 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 `tables1997` 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 = 209 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 `tables1996` 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 = 210 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 `tables1995` 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 = 211 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 `tables1994` 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 = 212 AND t.round = 34 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 `tables1993` 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 = 9858 AND t.round = 46 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 `tables1992` 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 = 9944 AND t.round = 22 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 `tables1992` 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 = 9945 AND t.round = 32 ORDER BY team.conference 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 `tables1991` 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 = 9868 AND t.round = 38 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 `tables1990` 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 = 9867 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 `tables1989` 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 = 9866 AND t.round = 38 ORDER BY team.conference 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 `tables1988` 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 = 9865 AND t.round = 38 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 `tables1987` 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 = 9864 AND t.round = 38 ORDER BY team.conference 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 `tables1986` 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 = 9863 AND t.round = 38 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 `tables1985` 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 = 9862 AND t.round = 38 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 `tables1984` 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 = 9861 AND t.round = 38 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 `tables1983` 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 = 9860 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 `tables1982` 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 = 9859 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 `tables1980` 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 = 9903 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC