4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1970/1971
LIGUE 1
Equipo PJ GF GC Puntos
1 Olympique Marseille Olympique 38 94 48 55
2 Saint-Étienne Saint-Étien 38 83 45 51
3 Nantes Nantes 38 61 41 46
4 Nîmes Nîmes 38 68 54 45
5 Girondins Bordeaux Girondins 38 58 51 40
6 Ajaccio Ajaccio 38 54 52 40
7 Olympique Lyonnais Olympique 38 51 51 40
8 Metz Metz 38 46 56 40
9 Stade de Reims Stade Reims 38 54 44 39
10 Sochaux Sochaux 38 58 55 38
11 Stade Rennais Stade 38 56 53 37
12 Angers SCO Angers SCO 38 61 66 35
13 Nancy Nancy 38 45 56 35
14 Nice Nice 38 48 55 34
15 Red Star Red Star 38 46 65 33
16 Angouleme Angouleme 38 30 47 32
17 Bastia Bastia 38 52 83 32
18 Strasbourg Strasbourg 38 54 63 31
19 Valenciennes Valenciennes 38 47 59 29
20 CS Sedan CS Sedan 38 42 64 28
TEMPORADA 1968/1969
LIGUE 1
Equipo PJ GF GC Puntos
1 Saint-Étienne Saint-Étien 34 70 26 53
2 Girondins Bordeaux Girondins 34 77 34 51
3 Metz Metz 34 41 27 42
4 FC Rouen 1899 Rouen 1899 34 44 43 40
5 CS Sedan CS Sedan 34 49 35 39
6 Bastia Bastia 34 50 66 34
7 Olympique Marseille Olympique 34 51 48 33
8 Valenciennes Valenciennes 34 38 37 33
9 Olympique Lyonnais Olympique 34 53 51 32
10 Nantes Nantes 34 44 45 32
11 Stade Rennais Stade 34 50 57 31
12 Sochaux Sochaux 34 49 55 29
13 Strasbourg Strasbourg 34 34 41 29
14 Nîmes Nîmes 34 32 39 29
15 Red Star Red Star 34 35 48 29
16 Ajaccio Ajaccio 34 36 53 28
17 Monaco Monaco 34 33 50 27
18 Nice Nice 34 30 61 21
TEMPORADA 1967/1968
LIGUE 1
Equipo PJ GF GC Puntos
1 Saint-Étienne Saint-Étien 38 78 30 57
2 Nice Nice 38 49 41 46
3 Sochaux Sochaux 38 48 39 43
4 Olympique Marseille Olympique 38 49 46 43
5 Valenciennes Valenciennes 38 42 34 42
6 Metz Metz 38 49 44 42
7 Nantes Nantes 38 55 50 41
8 Girondins Bordeaux Girondins 38 57 44 40
9 Ajaccio Ajaccio 38 59 59 39
10 CS Sedan CS Sedan 38 56 47 38
11 Monaco Monaco 38 45 48 37
12 Olympique Lyonnais Olympique 38 53 51 36
13 Red Star Red Star 38 44 43 36
14 Stade Rennais Stade 38 49 57 36
15 FC Rouen 1899 Rouen 1899 38 48 51 35
16 Strasbourg Strasbourg 38 34 40 34
17 Lens Lens 38 48 61 34
18 Angers SCO Angers SCO 38 56 70 34
19 Lille Lille 38 35 52 27
20 AS Aix AS Aix 38 48 95 20
TEMPORADA 1966/1967
LIGUE 1
Equipo PJ GF GC Puntos
1 Saint-Étienne Saint-Étien 38 82 37 54
2 Nantes Nantes 38 81 51 50
3 Angers SCO Angers SCO 38 66 46 44
4 Girondins Bordeaux Girondins 38 53 43 43
5 CS Sedan CS Sedan 38 58 50 42
6 Nice Nice 38 53 55 41
7 Valenciennes Valenciennes 38 42 37 40
8 Lens Lens 38 58 55 40
9 Olympique Marseille Olympique 38 44 45 39
10 Lille Lille 38 48 50 38
11 Stade Rennais Stade 38 59 56 37
12 Strasbourg Strasbourg 38 54 52 36
13 Sochaux Sochaux 38 43 53 35
14 Monaco Monaco 38 44 44 34
15 Olympique Lyonnais Olympique 38 40 56 34
16 FC Rouen 1899 Rouen 1899 38 37 44 33
17 Toulouse Toulouse 38 40 52 32
18 Nîmes Nîmes 38 43 64 32
19 Stade de Reims Stade Reims 38 40 66 30
20 Stade Français Stade 38 18 47 26
TEMPORADA 1965/1966
LIGUE 1
Equipo PJ GF GC Puntos
1 Nantes Nantes 38 84 36 60
2 Girondins Bordeaux Girondins 38 84 36 53
3 Valenciennes Valenciennes 38 58 44 52
4 Toulouse Toulouse 38 61 46 46
5 Saint-Étienne Saint-Étien 38 85 62 45
6 Stade Rennais Stade 38 80 70 42
7 Sochaux Sochaux 38 61 56 39
8 Strasbourg Strasbourg 38 59 47 38
9 CS Sedan CS Sedan 38 68 58 38
10 Nice Nice 38 66 59 36
11 Angers SCO Angers SCO 38 68 66 36
12 Lens Lens 38 55 57 36
13 Monaco Monaco 38 48 54 35
14 FC Rouen 1899 Rouen 1899 38 41 62 34
15 Stade Français Stade 38 45 57 33
16 Olympique Lyonnais Olympique 38 43 56 33
17 Nîmes Nîmes 38 52 67 33
18 Lille Lille 38 51 71 30
19 Cannes Cannes 38 37 86 21
20 Red Star Red Star 38 44 100 20
TEMPORADA 1963/1964
LIGUE 1
Equipo PJ GF GC Puntos
1 Saint-Étienne Saint-Étien 34 71 48 44
2 Monaco Monaco 34 62 45 41
3 Lens Lens 34 71 46 40
4 Olympique Lyonnais Olympique 34 58 53 39
5 Toulouse Toulouse 34 56 54 37
6 Valenciennes Valenciennes 34 49 39 35
7 Girondins Bordeaux Girondins 34 55 58 34
8 Nantes Nantes 34 51 59 34
9 Strasbourg Strasbourg 34 43 41 33
10 Angers SCO Angers SCO 34 54 62 33
11 Stade Rennais Stade 34 54 65 33
12 CS Sedan CS Sedan 34 62 52 32
13 Nîmes Nîmes 34 45 45 32
14 FC Rouen 1899 Rouen 1899 34 50 51 32
15 Stade Français Stade 34 48 53 32
16 Racing Paris Racing Paris 34 66 76 31
17 Stade de Reims Stade Reims 34 37 56 27
18 Nice Nice 34 45 74 23
TEMPORADA 1962/1963
LIGUE 1
Equipo PJ GF GC Puntos
1 Monaco Monaco 38 77 44 50
2 Stade de Reims Stade Reims 38 79 52 47
3 CS Sedan CS Sedan 38 68 46 46
4 Girondins Bordeaux Girondins 38 63 38 45
5 Olympique Lyonnais Olympique 38 52 41 43
6 Nîmes Nîmes 38 67 47 42
7 Toulouse Toulouse 38 64 52 42
8 FC Rouen 1899 Rouen 1899 38 59 57 42
9 Valenciennes Valenciennes 38 60 45 41
10 Racing Paris Racing Paris 38 80 71 41
11 Stade Rennais Stade 38 69 71 41
12 Nice Nice 38 64 79 38
13 Angers SCO Angers SCO 38 51 64 37
14 Strasbourg Strasbourg 38 54 63 34
15 Stade Français Stade 38 54 70 32
16 Lens Lens 38 60 67 30
17 Grenoble Grenoble 38 36 61 28
18 Nancy Nancy 38 37 66 28
19 Montpellier Montpellier 38 50 77 27
20 Olympique Marseille Olympique 38 42 75 26
TEMPORADA 1961/1962
LIGUE 1
Equipo PJ GF GC Puntos
1 Racing Paris Racing Paris 38 86 63 48
2 Stade de Reims Stade Reims 38 83 60 48
3 Nîmes Nîmes 38 68 60 47
4 Nancy Nancy 38 52 46 44
5 CS Sedan CS Sedan 38 63 49 43
6 Monaco Monaco 38 65 57 43
7 Lens Lens 38 67 52 42
8 Montpellier Montpellier 38 69 64 39
9 Toulouse Toulouse 38 62 61 38
10 Stade Français Stade 38 58 57 38
11 FC Rouen 1899 Rouen 1899 38 57 56 38
12 Stade Rennais Stade 38 58 63 38
13 Nice Nice 38 53 64 38
14 Angers SCO Angers SCO 38 56 59 36
15 Strasbourg Strasbourg 38 45 54 34
16 Olympique Lyonnais Olympique 38 57 62 33
17 Saint-Étienne Saint-Étien 38 55 60 30
18 Sochaux Sochaux 38 55 69 28
19 Le Havre Le Havre 38 34 57 28
20 Metz Metz 38 49 79 27
TEMPORADA 1960/1961
LIGUE 1
Equipo PJ GF GC Puntos
1 Monaco Monaco 38 77 42 57
2 Racing Paris Racing Paris 38 93 57 56
3 Stade de Reims Stade Reims 38 78 44 50
4 FC Rouen 1899 Rouen 1899 38 56 42 46
5 Saint-Étienne Saint-Étien 38 60 54 43
6 Nîmes Nîmes 38 70 61 42
7 Angers SCO Angers SCO 38 64 56 40
8 Nancy Nancy 38 55 52 39
9 CS Sedan CS Sedan 38 64 63 38
10 Lens Lens 38 50 54 37
11 Le Havre Le Havre 38 61 62 36
12 Toulouse Toulouse 38 49 58 36
13 Nice Nice 38 66 73 34
14 Stade Rennais Stade 38 52 59 34
15 Olympique Lyonnais Olympique 38 60 71 34
16 Stade Français Stade 38 52 59 32
17 Grenoble Grenoble 38 47 55 31
18 Limoges Limoges 38 55 69 30
19 Valenciennes Valenciennes 38 35 57 30
20 Troyes Troyes 38 52 108 15
TEMPORADA 1959/1960
LIGUE 1
Equipo PJ GF GC Puntos
1 Stade de Reims Stade Reims 38 109 46 60
2 Nîmes Nîmes 38 78 43 53
3 Racing Paris Racing Paris 38 118 56 49
4 Monaco Monaco 38 70 45 45
5 Toulouse Toulouse 38 74 61 44
6 Lens Lens 38 55 57 44
7 Le Havre Le Havre 38 63 68 42
8 Valenciennes Valenciennes 38 65 60 40
9 Nice Nice 38 71 74 40
10 Limoges Limoges 38 46 46 38
11 CS Sedan CS Sedan 38 62 62 37
12 Saint-Étienne Saint-Étien 38 62 65 36
13 Angers SCO Angers SCO 38 60 67 36
14 Stade Français Stade 38 59 70 34
15 Stade Rennais Stade 38 47 59 33
16 Olympique Lyonnais Olympique 38 41 52 31
17 Sochaux Sochaux 38 40 67 27
18 Sporting Toulon Var Sporting 38 50 85 25
19 Strasbourg Strasbourg 38 55 92 25
20 Girondins Bordeaux Girondins 38 52 102 21
TEMPORADA 1958/1959
LIGUE 1
Equipo PJ GF GC Puntos
1 Nice Nice 38 80 38 56
2 Nîmes Nîmes 38 75 40 53
3 Racing Paris Racing Paris 38 84 47 49
4 Stade de Reims Stade Reims 38 84 59 48
5 Sochaux Sochaux 38 72 66 43
6 Saint-Étienne Saint-Étien 38 68 73 40
7 Angers SCO Angers SCO 38 66 58 39
8 Monaco Monaco 38 52 51 39
9 Olympique Lyonnais Olympique 38 62 68 39
10 CS Sedan CS Sedan 38 65 53 38
11 Strasbourg Strasbourg 38 65 76 38
12 Stade Rennais Stade 38 63 63 36
13 Valenciennes Valenciennes 38 53 63 36
14 Toulouse Toulouse 38 59 59 35
15 Limoges Limoges 38 48 57 34
16 Lens Lens 38 56 66 32
17 Nancy Nancy 38 58 79 29
18 Lille Lille 38 56 78 29
19 Olympique Alès Olympique 38 45 83 24
20 Olympique Marseille Olympique 38 50 84 23
TEMPORADA 1957/1958
LIGUE 1
Equipo PJ GF GC Puntos
1 Stade de Reims Stade Reims 34 89 42 48
2 Nîmes Nîmes 34 61 39 41
3 Angers SCO Angers SCO 34 65 46 41
4 Monaco Monaco 34 50 35 41
5 CS Sedan CS Sedan 34 74 70 38
6 Lille Lille 34 71 59 37
7 Saint-Étienne Saint-Étien 34 55 52 37
8 Olympique Lyonnais Olympique 34 51 53 35
9 Racing Paris Racing Paris 34 61 62 33
10 Toulouse Toulouse 34 53 57 33
11 Lens Lens 34 55 62 33
12 Sochaux Sochaux 34 61 61 32
13 Nice Nice 34 71 53 31
14 Olympique Alès Olympique 34 41 59 28
15 Valenciennes Valenciennes 34 37 64 28
16 Olympique Marseille Olympique 34 46 65 26
17 Metz Metz 34 45 68 26
18 Béziers Béziers 34 38 77 24
TEMPORADA 1956/1957
LIGUE 1
Equipo PJ GF GC Puntos
1 Saint-Étienne Saint-Étien 34 88 45 49
2 Lens Lens 34 77 49 45
3 Stade de Reims Stade Reims 34 73 47 43
4 Racing Paris Racing Paris 34 86 55 42
5 Monaco Monaco 34 57 44 40
6 Olympique Marseille Olympique 34 60 53 39
7 Sochaux Sochaux 34 63 62 33
8 Toulouse Toulouse 34 61 49 32
9 CS Sedan CS Sedan 34 51 59 32
10 Nîmes Nîmes 34 52 56 31
11 Angers SCO Angers SCO 34 42 51 31
12 Olympique Lyonnais Olympique 34 45 53 30
13 Nice Nice 34 59 72 30
14 Valenciennes Valenciennes 34 43 72 29
15 Metz Metz 34 51 58 28
16 Stade Rennais Stade 34 36 63 27
17 Strasbourg Strasbourg 34 43 66 26
18 Nancy Nancy 34 43 76 25
TEMPORADA 1955/1956
LIGUE 1
Equipo PJ GF GC Puntos
1 Nice Nice 34 60 43 43
2 Lens Lens 34 65 49 42
3 Monaco Monaco 34 63 45 41
4 Saint-Étienne Saint-Étien 34 68 53 41
5 Racing Paris Racing Paris 34 74 58 39
6 Olympique Marseille Olympique 34 54 49 39
7 Toulouse Toulouse 34 51 46 38
8 Olympique Lyonnais Olympique 34 50 49 37
9 CS Sedan CS Sedan 34 53 56 36
10 Stade de Reims Stade Reims 34 61 50 34
11 Nancy Nancy 34 51 60 33
12 Sochaux Sochaux 34 47 50 32
13 Nîmes Nîmes 34 64 56 31
14 Strasbourg Strasbourg 34 54 66 30
15 Metz Metz 34 49 68 29
16 Lille Lille 34 58 65 24
17 Girondins Bordeaux Girondins 34 45 69 24
18 Troyes Troyes 34 43 78 19
TEMPORADA 1954/1955
LIGUE 1
Equipo PJ GF GC Puntos
1 Stade de Reims Stade Reims 34 78 53 44
2 Toulouse Toulouse 34 57 45 40
3 Lens Lens 34 56 55 38
4 Strasbourg Strasbourg 34 74 55 37
5 Sochaux Sochaux 34 64 53 36
6 Girondins Bordeaux Girondins 34 63 51 35
7 Saint-Étienne Saint-Étien 34 58 51 35
8 Racing Paris Racing Paris 34 62 57 34
9 Nice Nice 34 75 81 34
10 Olympique Marseille Olympique 34 58 51 33
11 Nîmes Nîmes 34 48 52 33
12 Olympique Lyonnais Olympique 34 54 63 33
13 Nancy Nancy 34 59 54 32
14 Monaco Monaco 34 43 45 31
15 Metz Metz 34 42 72 31
16 Lille Lille 34 61 58 30
17 Troyes Troyes 34 48 66 30
18 RC Roubaix RC Roubaix 34 52 90 26
TEMPORADA 1953/1954
LIGUE 1
Equipo PJ GF GC Puntos
1 Lille Lille 34 49 22 47
2 Stade de Reims Stade Reims 34 62 36 46
3 Girondins Bordeaux Girondins 34 69 44 46
4 Toulouse Toulouse 34 55 39 44
5 Saint-Étienne Saint-Étien 34 48 47 38
6 Strasbourg Strasbourg 34 60 61 36
7 Lens Lens 34 58 56 35
8 Nice Nice 34 73 59 34
9 Nîmes Nîmes 34 49 46 33
10 Monaco Monaco 34 44 48 31
11 Sochaux Sochaux 34 55 57 30
12 Metz Metz 34 45 59 30
13 Nancy Nancy 34 50 65 30
14 Olympique Marseille Olympique 34 49 56 29
15 RC Roubaix RC Roubaix 34 47 65 28
16 Stade Français Stade 34 44 49 27
17 Le Havre Le Havre 34 54 69 26
18 Sète Sète 34 38 71 22
TEMPORADA 1952/1953
LIGUE 1
Equipo PJ GF GC Puntos
1 Stade de Reims Stade Reims 34 86 36 48
2 Sochaux Sochaux 34 72 58 44
3 Girondins Bordeaux Girondins 34 79 56 43
4 Lille Lille 34 61 43 40
5 Nîmes Nîmes 34 62 47 40
6 Olympique Marseille Olympique 34 62 53 37
7 Lens Lens 34 50 48 34
8 Nancy Nancy 34 48 58 34
9 Stade Français Stade 34 54 51 33
10 Sète Sète 34 42 49 33
11 Saint-Étienne Saint-Étien 34 44 59 30
12 Metz Metz 34 44 48 29
13 Nice Nice 34 49 57 29
14 Le Havre Le Havre 34 47 63 29
15 RC Roubaix RC Roubaix 34 42 49 28
16 Stade Rennais Stade 34 37 56 28
17 Racing Paris Racing Paris 34 40 64 28
18 Montpellier Montpellier 34 43 67 25
TEMPORADA 1951/1952
LIGUE 1
Equipo PJ GF GC Puntos
1 Nice Nice 34 65 42 46
2 Girondins Bordeaux Girondins 34 88 49 45
3 Lille Lille 34 85 50 44
4 Stade de Reims Stade Reims 34 64 48 38
5 Metz Metz 34 48 45 38
6 Nîmes Nîmes 34 63 47 37
7 Le Havre Le Havre 34 55 44 37
8 RC Roubaix RC Roubaix 34 57 44 36
9 Saint-Étienne Saint-Étien 34 69 68 36
10 Sète Sète 34 54 56 36
11 Nancy Nancy 34 59 53 35
12 Sochaux Sochaux 34 51 54 31
13 Lens Lens 34 54 61 31
14 Racing Paris Racing Paris 34 60 71 30
15 Olympique Marseille Olympique 34 52 76 28
16 Stade Rennais Stade 34 51 85 28
17 Olympique Lyonnais Olympique 34 38 78 20
18 Strasbourg Strasbourg 34 38 80 16
TEMPORADA 1950/1951
LIGUE 1
Equipo PJ GF GC Puntos
1 Nice Nice 34 73 46 41
2 Lille Lille 34 57 43 41
3 Le Havre Le Havre 34 59 43 40
4 Nîmes Nîmes 34 64 53 40
5 Stade de Reims Stade Reims 34 61 50 40
6 Girondins Bordeaux Girondins 34 58 49 37
7 Saint-Étienne Saint-Étien 34 63 59 37
8 Olympique Marseille Olympique 34 60 46 36
9 Strasbourg Strasbourg 34 49 58 34
10 RC Roubaix RC Roubaix 34 55 53 32
11 Nancy Nancy 34 66 66 32
12 Sochaux Sochaux 34 52 56 32
13 Racing Paris Racing Paris 34 53 59 32
14 Stade Rennais Stade 34 63 69 31
15 Sète Sète 34 47 53 30
16 Lens Lens 34 59 77 29
17 Toulouse Toulouse 34 39 64 27
18 Stade Français Stade 34 38 72 21
TEMPORADA 1949/1950
LIGUE 1
Equipo PJ GF GC Puntos
1 Girondins Bordeaux Girondins 34 88 40 51
2 Lille Lille 34 79 44 45
3 Stade de Reims Stade Reims 34 62 47 44
4 Toulouse Toulouse 34 65 41 42
5 Nice Nice 34 67 52 39
6 Sochaux Sochaux 34 65 51 38
7 Racing Paris Racing Paris 34 67 56 36
8 Olympique Marseille Olympique 34 56 60 35
9 Stade Rennais Stade 34 64 58 34
10 RC Roubaix RC Roubaix 34 49 46 33
11 Saint-Étienne Saint-Étien 34 60 58 32
12 Nancy Nancy 34 52 58 31
13 Strasbourg Strasbourg 34 46 73 31
14 Sète Sète 34 59 72 29
15 Lens Lens 34 49 68 26
16 Stade Français Stade 34 51 71 26
17 Montpellier Montpellier 34 50 87 23
18 Metz Metz 34 53 100 17

  USO DE MEMORIA  
8,086,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7111
Total Execution Time  0.7124
  CADENA URL  
/historico/Nice/1971
  GET DATOS  
$_GET['/historico/Nice/1971']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0210  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 = 'Nice' AND l.year = 1971 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.0131  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=1799 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=1799 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0258  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 = 9780
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1799 AND type_rel = 2
0.0144  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1799 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (4599,5576,7169,10844,12678) ORDER BY n.cover_points DESC, update_date DESC
0.0135  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 = '1799' AND l.year = 1971 ORDER BY l.year DESC,cat.coefficient DESC
0.0137  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 = '1799' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 9780 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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=1799 AND l.year in (1970,1971,1972) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (25464,9780) 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.0141  SELECT count(id) as num_players from rel_players WHERE league_id = 9780 AND teamId = 1799
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 25464 AND teamId = 1799
0.0140  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1971` 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 = 9780 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0132  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 = '1799' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1799' and rp.type = 4
0.0134  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 = '1799' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0186  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 events1971 e ON e.player_id = p.id AND e.league_id = 9780 WHERE rp.league_id = 9780 AND rp.teamId = 1799 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.0133  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 events1971 e ON e.player_id = p.id AND e.league_id = 9780 WHERE rp.league_id = 9780 AND rp.teamId = 1799 AND (e.action = 4 or e.action = 5) 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 events1971 e ON e.player_id = p.id AND e.league_id = 9780 WHERE rp.league_id = 9780 AND rp.teamId = 1799 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 1799 AND l.year <= 1971 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables1971` 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 = 9780 AND t.round = 38 ORDER BY team.conference 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 `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 = 9782 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 `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 = 9783 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 `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 = 9784 AND t.round = 38 ORDER BY team.conference 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 `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 = 9785 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 9787 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 `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 = 9788 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 `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 = 9789 AND t.round = 38 ORDER BY team.conference 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 `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 = 9790 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 `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 = 9791 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 `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 = 9792 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 `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 = 9793 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 `tables1957` 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 = 9794 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 `tables1956` 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 = 9795 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 `tables1955` 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 = 9796 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 `tables1954` 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 = 9797 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 `tables1953` 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 = 9798 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 `tables1952` 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 = 9799 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 `tables1951` 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 = 9800 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 `tables1950` 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 = 9801 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC