4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1976/1977
BUNDESLIGA
Equipo PJ GF GC Puntos
1 B. Mönchengladbach Mönchenglad 34 58 34 44
2 Schalke 04 Schalke 04 34 77 52 43
3 Eintracht Braunschweig Eintracht 34 56 38 43
4 Eintracht Frankfurt Eintracht 34 86 57 42
5 Köln Köln 34 83 61 40
6 Hamburger SV Hamburger 34 67 56 38
7 Bayern München Bayern 34 74 65 37
8 B. Dortmund B. Dortmund 34 73 64 34
9 MSV Duisburg Duisburg 34 60 51 34
10 Hertha BSC Hertha BSC 34 55 54 34
11 Werder Bremen Werder 34 51 59 33
12 Fortuna Düsseldorf Fortuna 34 51 54 31
13 Kaiserslautern Kaiserslaute 34 53 58 29
14 1. FC Saarbrücken Saarbrücken 34 43 55 29
15 VfL Bochum VfL Bochum 34 47 62 29
16 Karlsruher SC Karlsruher 34 53 75 28
17 Tennis Borussia Tennis 34 47 85 22
18 Rot-Weiss Essen Rot-Weiss 34 49 103 22
TEMPORADA 1975/1976
BUNDESLIGA
Equipo PJ GF GC Puntos
1 B. Mönchengladbach Mönchenglad 34 66 37 45
2 Hamburger SV Hamburger 34 59 32 41
3 Bayern München Bayern 34 72 50 40
4 Köln Köln 34 62 45 39
5 Eintracht Braunschweig Eintracht 34 52 48 39
6 Schalke 04 Schalke 04 34 76 55 37
7 Kaiserslautern Kaiserslaute 34 66 60 37
8 Rot-Weiss Essen Rot-Weiss 34 61 67 37
9 Eintracht Frankfurt Eintracht 34 79 58 36
10 MSV Duisburg Duisburg 34 55 62 33
11 Hertha BSC Hertha BSC 34 59 61 32
12 Fortuna Düsseldorf Fortuna 34 47 57 30
13 Werder Bremen Werder 34 44 55 30
14 VfL Bochum VfL Bochum 34 49 62 30
15 Karlsruher SC Karlsruher 34 46 59 30
16 Hannover 96 Hannover 96 34 48 60 27
17 Kickers Offenbach FC Kickers 34 40 72 27
18 KFC Uerdingen 05 Uerdingen 34 28 69 22
TEMPORADA 1974/1975
BUNDESLIGA
Equipo PJ GF GC Puntos
1 B. Mönchengladbach Mönchenglad 34 86 40 50
2 Hertha BSC Hertha BSC 34 61 43 44
3 Eintracht Frankfurt Eintracht 34 89 49 43
4 Hamburger SV Hamburger 34 55 38 43
5 Köln Köln 34 77 51 41
6 Fortuna Düsseldorf Fortuna 34 66 55 41
7 Schalke 04 Schalke 04 34 52 37 39
8 Kickers Offenbach FC Kickers 34 72 62 38
9 Eintracht Braunschweig Eintracht 34 52 42 36
10 Bayern München Bayern 34 57 63 34
11 VfL Bochum VfL Bochum 34 53 53 33
12 Rot-Weiss Essen Rot-Weiss 34 56 68 32
13 Kaiserslautern Kaiserslaute 34 56 55 31
14 MSV Duisburg Duisburg 34 59 77 30
15 Werder Bremen Werder 34 45 69 25
16 Stuttgart Stuttgart 34 50 79 24
17 Tennis Borussia Tennis 34 38 89 16
18 Wuppertaler SV Wuppertaler 34 32 86 12
TEMPORADA 1973/1974
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 95 53 49
2 B. Mönchengladbach Mönchenglad 34 93 52 48
3 Fortuna Düsseldorf Fortuna 34 61 47 41
4 Eintracht Frankfurt Eintracht 34 63 50 41
5 Köln Köln 34 69 56 39
6 Kaiserslautern Kaiserslaute 34 80 69 38
7 Schalke 04 Schalke 04 34 72 68 37
8 Hertha BSC Hertha BSC 34 56 60 33
9 Stuttgart Stuttgart 34 58 57 31
10 Kickers Offenbach FC Kickers 34 56 62 31
11 Werder Bremen Werder 34 48 56 31
12 Hamburger SV Hamburger 34 53 62 31
13 Rot-Weiss Essen Rot-Weiss 34 56 70 31
14 VfL Bochum VfL Bochum 34 45 57 30
15 MSV Duisburg Duisburg 34 42 56 29
16 Wuppertaler SV Wuppertaler 34 42 65 25
17 Fortuna Köln Fortuna 34 46 79 25
18 Hannover 96 Hannover 96 34 50 66 22
TEMPORADA 1972/1973
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 93 29 54
2 Köln Köln 34 66 51 43
3 Fortuna Düsseldorf Fortuna 34 62 45 42
4 Wuppertaler SV Wuppertaler 34 62 49 40
5 B. Mönchengladbach Mönchenglad 34 82 61 39
6 Stuttgart Stuttgart 34 71 65 37
7 Kickers Offenbach FC Kickers 34 61 60 35
8 Eintracht Frankfurt Eintracht 34 58 54 34
9 Kaiserslautern Kaiserslaute 34 58 68 34
10 MSV Duisburg Duisburg 34 53 54 33
11 Werder Bremen Werder 34 50 52 31
12 VfL Bochum VfL Bochum 34 50 68 31
13 Hertha BSC Hertha BSC 34 53 64 30
14 Hamburger SV Hamburger 34 53 59 28
15 Schalke 04 Schalke 04 34 46 61 28
16 Hannover 96 Hannover 96 34 49 65 26
17 Eintracht Braunschweig Eintracht 34 33 56 25
18 Rot-Weiß Oberhausen Rot-Weiß 34 45 84 22
TEMPORADA 1971/1972
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 101 38 55
2 Schalke 04 Schalke 04 34 76 35 52
3 B. Mönchengladbach Mönchenglad 34 82 40 43
4 Köln Köln 34 64 44 43
5 Eintracht Frankfurt Eintracht 34 71 61 39
6 Hertha BSC Hertha BSC 34 46 55 37
7 Kaiserslautern Kaiserslaute 34 59 53 35
8 Stuttgart Stuttgart 34 52 56 35
9 VfL Bochum VfL Bochum 34 59 69 34
10 Hamburger SV Hamburger 34 52 52 33
11 Werder Bremen Werder 34 63 58 31
12 Eintracht Braunschweig Eintracht 34 43 48 31
13 Fortuna Düsseldorf Fortuna 34 40 53 30
14 MSV Duisburg Duisburg 34 36 51 27
15 Rot-Weiß Oberhausen Rot-Weiß 34 33 66 25
16 Hannover 96 Hannover 96 34 54 69 23
17 B. Dortmund B. Dortmund 34 34 83 20
18 Arminia Bielefeld Arminia 34 41 75 0
TEMPORADA 1970/1971
BUNDESLIGA
Equipo PJ GF GC Puntos
1 B. Mönchengladbach Mönchenglad 34 78 34 51
2 Bayern München Bayern 34 74 36 48
3 Hertha BSC Hertha BSC 34 61 43 41
4 Eintracht Braunschweig Eintracht 34 52 40 39
5 Hamburger SV Hamburger 34 54 63 37
6 Schalke 04 Schalke 04 34 44 40 36
7 MSV Duisburg Duisburg 34 43 47 35
8 Kaiserslautern Kaiserslaute 34 54 57 34
9 Hannover 96 Hannover 96 34 53 49 33
10 Köln Köln 34 46 56 33
11 Werder Bremen Werder 34 40 41 32
12 Stuttgart Stuttgart 34 49 49 30
13 B. Dortmund B. Dortmund 34 54 60 29
14 Arminia Bielefeld Arminia 34 34 53 29
15 Eintracht Frankfurt Eintracht 34 39 56 28
16 Rot-Weiß Oberhausen Rot-Weiß 34 54 69 27
17 Kickers Offenbach FC Kickers 34 49 65 27
18 Rot-Weiss Essen Rot-Weiss 34 48 68 23
TEMPORADA 1969/1970
BUNDESLIGA
Equipo PJ GF GC Puntos
1 B. Mönchengladbach Mönchenglad 34 71 29 51
2 Bayern München Bayern 34 88 37 47
3 Hertha BSC Hertha BSC 34 67 41 45
4 Köln Köln 34 83 38 43
5 B. Dortmund B. Dortmund 34 60 67 36
6 Hamburger SV Hamburger 34 57 54 35
7 Stuttgart Stuttgart 34 59 62 35
8 Eintracht Frankfurt Eintracht 34 54 54 34
9 Schalke 04 Schalke 04 34 43 54 34
10 Kaiserslautern Kaiserslaute 34 44 55 32
11 Werder Bremen Werder 34 38 47 31
12 Rot-Weiss Essen Rot-Weiss 34 41 54 31
13 Hannover 96 Hannover 96 34 49 61 30
14 Rot-Weiß Oberhausen Rot-Weiß 34 50 62 29
15 MSV Duisburg Duisburg 34 35 48 29
16 Eintracht Braunschweig Eintracht 34 40 49 28
17 1860 München 1860 34 41 56 25
18 Alemannia Aachen Alemannia 34 31 83 17
TEMPORADA 1968/1969
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Bayern München Bayern 34 61 31 46
2 Alemannia Aachen Alemannia 34 57 51 38
3 B. Mönchengladbach Mönchenglad 34 61 46 37
4 Eintracht Braunschweig Eintracht 34 46 43 37
5 Stuttgart Stuttgart 34 60 54 36
6 Hamburger SV Hamburger 34 55 55 36
7 Schalke 04 Schalke 04 34 45 40 35
8 Eintracht Frankfurt Eintracht 34 46 43 34
9 Werder Bremen Werder 34 59 59 34
10 1860 München 1860 34 44 59 34
11 Hannover 96 Hannover 96 34 47 45 32
12 MSV Duisburg Duisburg 34 33 37 32
13 Köln Köln 34 47 56 32
14 Hertha BSC Hertha BSC 34 31 39 32
15 Kaiserslautern Kaiserslaute 34 45 47 30
16 B. Dortmund B. Dortmund 34 49 54 30
17 Nürnberg Nürnberg 34 45 55 29
18 Kickers Offenbach FC Kickers 34 42 59 28
TEMPORADA 1967/1968
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Nürnberg Nürnberg 34 71 37 47
2 Werder Bremen Werder 34 68 51 44
3 B. Mönchengladbach Mönchenglad 34 77 45 42
4 Köln Köln 34 68 52 38
5 Bayern München Bayern 34 68 58 38
6 Eintracht Frankfurt Eintracht 34 58 51 38
7 MSV Duisburg Duisburg 34 69 58 36
8 Stuttgart Stuttgart 34 65 54 35
9 Eintracht Braunschweig Eintracht 34 37 39 35
10 Hannover 96 Hannover 96 34 48 52 34
11 Alemannia Aachen Alemannia 34 52 66 34
12 1860 München 1860 34 55 39 33
13 Hamburger SV Hamburger 34 51 54 33
14 B. Dortmund B. Dortmund 34 60 59 31
15 Schalke 04 Schalke 04 34 42 48 30
16 Kaiserslautern Kaiserslaute 34 39 67 28
17 Neunkirchen Neunkirchen 34 33 93 19
18 Karlsruher SC Karlsruher 34 32 70 17
TEMPORADA 1966/1967
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Eintracht Braunschweig Eintracht 34 49 27 43
2 1860 München 1860 34 60 47 41
3 B. Dortmund B. Dortmund 34 70 41 39
4 Eintracht Frankfurt Eintracht 34 66 49 39
5 Kaiserslautern Kaiserslaute 34 43 42 38
6 Bayern München Bayern 34 62 47 37
7 Köln Köln 34 48 48 37
8 B. Mönchengladbach Mönchenglad 34 70 49 34
9 Hannover 96 Hannover 96 34 40 46 34
10 Nürnberg Nürnberg 34 43 50 34
11 MSV Duisburg Duisburg 34 40 42 33
12 Stuttgart Stuttgart 34 48 54 33
13 Karlsruher SC Karlsruher 34 54 62 31
14 Hamburger SV Hamburger 34 37 53 30
15 Schalke 04 Schalke 04 34 37 63 30
16 Werder Bremen Werder 34 49 56 29
17 Fortuna Düsseldorf Fortuna 34 44 66 25
18 Rot-Weiss Essen Rot-Weiss 34 35 53 25
TEMPORADA 1965/1966
BUNDESLIGA
Equipo PJ GF GC Puntos
1 1860 München 1860 34 80 40 50
2 B. Dortmund B. Dortmund 34 70 36 47
3 Bayern München Bayern 34 71 38 47
4 Werder Bremen Werder 34 76 40 45
5 Köln Köln 34 74 41 44
6 Nürnberg Nürnberg 34 54 43 39
7 Eintracht Frankfurt Eintracht 34 64 46 38
8 MSV Duisburg Duisburg 34 70 48 36
9 Hamburger SV Hamburger 34 64 52 34
10 Eintracht Braunschweig Eintracht 34 49 49 34
11 Stuttgart Stuttgart 34 42 48 32
12 Hannover 96 Hannover 96 34 59 57 30
13 B. Mönchengladbach Mönchenglad 34 57 68 29
14 Schalke 04 Schalke 04 34 33 55 27
15 Kaiserslautern Kaiserslaute 34 42 65 26
16 Karlsruher SC Karlsruher 34 35 71 24
17 Neunkirchen Neunkirchen 34 32 82 22
18 Tasmania Berlin Tasmania 34 15 108 8
TEMPORADA 1964/1965
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Werder Bremen Werder 30 54 29 41
2 Köln Köln 30 66 45 38
3 B. Dortmund B. Dortmund 30 67 48 36
4 1860 München 1860 30 70 50 35
5 Hannover 96 Hannover 96 30 48 42 33
6 Nürnberg Nürnberg 30 44 38 32
7 MSV Duisburg Duisburg 30 46 48 32
8 Eintracht Frankfurt Eintracht 30 50 58 29
9 Eintracht Braunschweig Eintracht 30 42 47 28
10 Neunkirchen Neunkirchen 30 44 48 27
11 Hamburger SV Hamburger 30 46 56 27
12 Stuttgart Stuttgart 30 46 50 26
13 Kaiserslautern Kaiserslaute 30 41 53 25
14 Hertha BSC Hertha BSC 30 40 62 25
15 Karlsruher SC Karlsruher 30 47 62 24
16 Schalke 04 Schalke 04 30 45 60 22
TEMPORADA 1963/1964
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Köln Köln 30 78 40 45
2 MSV Duisburg Duisburg 30 60 36 39
3 Eintracht Frankfurt Eintracht 30 65 41 39
4 B. Dortmund B. Dortmund 30 73 57 33
5 Stuttgart Stuttgart 30 48 40 33
6 Hamburger SV Hamburger 30 69 60 32
7 1860 München 1860 30 66 50 31
8 Schalke 04 Schalke 04 30 51 53 29
9 Nürnberg Nürnberg 30 45 56 29
10 Werder Bremen Werder 30 53 62 28
11 Eintracht Braunschweig Eintracht 30 36 49 28
12 Kaiserslautern Kaiserslaute 30 48 69 26
13 Karlsruher SC Karlsruher 30 42 55 24
14 Hertha BSC Hertha BSC 30 45 65 24
15 Preußen Münster Preußen 30 34 52 23
16 1. FC Saarbrücken Saarbrücken 30 44 72 17
TEMPORADA 1962/1963
OBERLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 1860 München 1860 30 72 38 63
2 Nürnberg Nürnberg 30 87 41 59
3 Bayern München Bayern 30 67 52 58
4 Eintracht Frankfurt Eintracht 30 56 32 53
5 Karlsruher SC Karlsruher 30 59 48 47
6 Stuttgart Stuttgart 30 49 40 44
7 Kickers Offenbach FC Kickers 30 57 49 43
8 Ulm Ulm 30 64 58 40
9 Greuther Fürth Greuther 30 49 48 40
10 Hessen Kassel Hessen 30 49 57 38
11 Schweinfurt Schweinfurt 30 43 53 36
12 VfR Mannheim Mannheim 30 49 62 35
13 Bayern Hof Bayern Hof 30 40 62 30
14 Reutlingen Reutlingen 30 48 75 27
15 TSV Schwaben Augsburg Schwaben 30 49 73 26
16 FC Augsburg FC Augsburg 30 38 88 22
TEMPORADA 1961/1962
OBERLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 Nürnberg Nürnberg 30 70 30 63
2 Eintracht Frankfurt Eintracht 30 81 37 62
3 Bayern München Bayern 30 67 55 57
4 Kickers Offenbach FC Kickers 30 65 50 53
5 Stuttgart Stuttgart 30 66 53 47
6 Bayern Hof Bayern Hof 30 55 56 44
7 1860 München 1860 30 64 57 41
8 Reutlingen Reutlingen 30 57 51 41
9 VfR Mannheim Mannheim 30 47 59 37
10 Karlsruher SC Karlsruher 30 47 44 36
11 FC Augsburg FC Augsburg 30 55 63 35
12 TSV Schwaben Augsburg Schwaben 30 43 78 33
13 Schweinfurt Schweinfurt 30 39 63 31
14 Greuther Fürth Greuther 30 31 39 30
15 FSV Frankfurt Frankfurt 30 35 65 28
16 Waldhof Mannheim Waldhof 30 39 61 26
TEMPORADA 1960/1961
OBERLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 Waldhof Mannheim Waldhof 60 100 107 77
2 Nürnberg Nürnberg 30 96 30 71
3 Eintracht Frankfurt Eintracht 30 78 38 59
4 Karlsruher SC Karlsruher 30 75 51 55
5 Kickers Offenbach FC Kickers 30 57 46 52
6 Reutlingen Reutlingen 30 65 55 47
7 1860 München 1860 30 61 66 46
8 Stuttgart Stuttgart 30 57 53 44
9 Bayern München Bayern 30 57 54 42
10 Greuther Fürth Greuther 30 40 47 37
11 Bayern Hof Bayern Hof 30 41 60 36
12 FSV Frankfurt Frankfurt 30 45 59 35
13 Schweinfurt Schweinfurt 30 42 54 34
14 Ulm Ulm 30 48 62 33
15 Jahn Regensburg Jahn 30 27 107 14
TEMPORADA 1959/1960
OBERLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 Karlsruher SC Karlsruher 30 78 39 65
2 Kickers Offenbach FC Kickers 30 75 45 56
3 Bayern München Bayern 30 81 55 55
4 Eintracht Frankfurt Eintracht 30 81 57 53
5 Nürnberg Nürnberg 30 73 54 49
6 1860 München 1860 30 65 56 49
7 Stuttgart Stuttgart 30 66 57 46
8 Reutlingen Reutlingen 30 55 57 43
9 FSV Frankfurt Frankfurt 30 59 53 39
10 VfR Mannheim Mannheim 30 55 52 38
11 Greuther Fürth Greuther 30 48 59 36
12 Schweinfurt Schweinfurt 30 48 64 35
13 Bayern Hof Bayern Hof 30 45 84 35
14 Ulm Ulm 30 39 64 29
15 Viktoria Aschaffenburg Viktoria 30 43 73 28
16 Stuttgarter Kickers Stuttgarter 30 38 80 20
TEMPORADA 1958/1959
OBERLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Eintracht Frankfurt Eintracht 30 71 25 71
2 Kickers Offenbach FC Kickers 30 73 31 67
3 Nürnberg Nürnberg 30 80 38 62
4 Bayern München Bayern 30 79 49 56
5 1860 München 1860 30 61 57 42
6 Stuttgart Stuttgart 30 61 49 41
7 Greuther Fürth Greuther 30 47 45 41
8 VfR Mannheim Mannheim 30 65 71 41
9 Karlsruher SC Karlsruher 30 73 69 40
10 FSV Frankfurt Frankfurt 30 49 69 34
11 Schweinfurt Schweinfurt 30 47 59 33
12 Reutlingen Reutlingen 30 44 71 33
13 Viktoria Aschaffenburg Viktoria 30 43 69 31
14 Ulm Ulm 30 39 57 30
15 FC Augsburg FC Augsburg 30 53 85 29
16 Waldhof Mannheim Waldhof 30 43 84 23
TEMPORADA 1957/1958
OBERLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Karlsruher SC Karlsruher 30 60 38 61
2 Nürnberg Nürnberg 30 74 45 60
3 Greuther Fürth Greuther 30 54 33 56
4 Eintracht Frankfurt Eintracht 30 58 32 54
5 Kickers Offenbach FC Kickers 30 68 45 54
6 1860 München 1860 30 50 48 50
7 Bayern München Bayern 30 66 56 42
8 Schweinfurt Schweinfurt 30 51 48 40
9 Stuttgart Stuttgart 30 55 46 39
10 VfR Mannheim Mannheim 30 43 57 38
11 Viktoria Aschaffenburg Viktoria 30 51 54 36
12 FSV Frankfurt Frankfurt 30 34 46 35
13 FC Augsburg FC Augsburg 30 45 66 34
14 Reutlingen Reutlingen 30 41 55 32
15 Jahn Regensburg Jahn 30 29 79 22
16 Stuttgarter Kickers Stuttgarter 30 31 62 19

  USO DE MEMORIA  
8,187,152 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.2740
Total Execution Time  0.2762
  CADENA URL  
/historico/Eintracht-Frankfurt/1977
  GET DATOS  
$_GET['/historico/Eintracht-Frankfurt/1977']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (50)  
0.0147  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 = 'Eintracht-Frankfurt' AND l.year = 1977 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.0026  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=960 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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=960 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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=960 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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=960 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0047  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 = 5439
0.0045  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 = 22450
0.0045  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 = 72445
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=960 AND type_rel = 2
0.0120  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 960 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0032  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 (1312829,1514,1994,2815,3378) ORDER BY n.cover_points DESC, update_date DESC
0.0099  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 = '960' AND l.year = 1977 ORDER BY l.year DESC,cat.coefficient DESC
0.0115  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 = '960' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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 = 5439 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0031  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 = 22450 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0059  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=960 AND l.year in (1976,1977,1978) ORDER BY l.id DESC, l.year DESC ;
0.0022  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 (72445,22451,11053,10944,5440) 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.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 5440 AND teamId = 960
0.0033  SELECT count(id) as num_players from rel_players WHERE league_id = 10944 AND teamId = 960
0.0045  SELECT count(id) as num_players from rel_players WHERE league_id = 22451 AND teamId = 960
0.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 11053 AND teamId = 960
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72445 AND teamId = 960
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 FROM `tables1977` 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 = 5439 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0029  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 = '960' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '960' and rp.type = 4
0.0027  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 = '960' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '960' and rp.type = 4
0.0048  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 events1977 e ON e.player_id = p.id AND e.league_id = 5439 WHERE rp.league_id = 5439 AND rp.teamId = 960 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.0040  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 events1977 e ON e.player_id = p.id AND e.league_id = 5439 WHERE rp.league_id = 5439 AND rp.teamId = 960 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 events1977 e ON e.player_id = p.id AND e.league_id = 5439 WHERE rp.league_id = 5439 AND rp.teamId = 960 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0077  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 = 960 AND l.year <= 1977 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables1977` 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 = 5439 AND t.round = 34 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 `tables1976` 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 = 5438 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1974` 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 = 5436 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1973` 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 = 5435 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 `tables1972` 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 = 5434 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0266  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 `tables1970` 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 = 5432 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0101  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 `tables1969` 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 = 5431 AND t.round = 34 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 `tables1968` 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 = 5430 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1967` 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 = 5429 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 `tables1966` 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 = 5428 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 `tables1965` 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 = 5427 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables1964` 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 = 5426 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables1963` 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 = 28397 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables1962` 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 = 28401 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables1961` 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 = 28403 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables1960` 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 = 28418 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables1959` 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 = 28451 AND t.round = 30 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 `tables1958` 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 = 28460 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 5439 ORDER BY nameShow LIMIT 100