4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1996/1997
LIGUE 1
Equipo PJ GF GC Puntos
1 Monaco Monaco 38 69 30 79
2 PSG PSG 38 57 31 67
3 Nantes Nantes 38 61 32 64
4 Girondins Bordeaux Girondins 38 59 42 63
5 Metz Metz 38 40 30 62
6 Auxerre Auxerre 38 49 32 61
7 Bastia Bastia 38 54 47 61
8 Olympique Lyonnais Olympique 38 59 50 60
9 Strasbourg Strasbourg 38 52 49 60
10 Montpellier Montpellier 38 40 40 51
11 Olympique Marseille Olympique 38 43 48 49
12 Guingamp Guingamp 38 32 36 46
13 Lens Lens 38 40 52 45
14 Le Havre Le Havre 38 34 43 43
15 Cannes Cannes 38 25 41 41
16 Stade Rennais Stade 38 40 58 40
17 Caen Caen 38 35 46 37
18 Nancy Nancy 38 33 51 37
19 Lille Lille 38 32 58 35
20 Nice Nice 38 30 68 23
TEMPORADA 1995/1996
LIGUE 2
Equipo PJ GF GC Puntos
1 Caen Caen 42 59 34 81
2 Olympique Marseille Olympique 42 69 35 80
3 Nancy Nancy 42 56 23 76
4 Stade Lavallois Stade 42 52 47 69
5 Toulouse Toulouse 42 40 34 63
6 Le Mans Le Mans 42 37 36 62
7 Red Star Red Star 42 56 38 61
8 Perpignan Perpignan 42 44 53 61
9 Chateauroux Chateauroux 42 40 35 60
10 Sochaux Sochaux 42 49 40 59
11 CS Louhans Cuiseaux Louhans 42 57 49 58
12 Lorient Lorient 42 44 46 58
13 Amiens SC Amiens SC 42 41 49 52
14 FC Mulhouse FC Mulhouse 42 44 45 51
15 Valence Valence 42 34 42 51
16 Niort Niort 42 48 50 50
17 Épinal Épinal 42 42 46 48
18 Charleville Charleville 42 34 54 48
19 Stade Poitevin Stade 42 36 48 46
20 Dunkerque Dunkerque 42 30 43 43
21 Angers SCO Angers SCO 42 31 53 37
22 Olympique Alès Olympique 42 29 72 25
TEMPORADA 1994/1995
LIGUE 2
Equipo PJ GF GC Puntos
1 Olympique Marseille Olympique 42 72 34 84
2 Guingamp Guingamp 42 50 32 79
3 FC Gueugnon FC Gueugnon 42 62 40 78
4 Toulouse Toulouse 42 69 43 77
5 Chateauroux Chateauroux 42 56 34 71
6 Red Star Red Star 42 55 44 70
7 Nancy Nancy 42 46 39 63
8 Dunkerque Dunkerque 42 42 38 60
9 Amiens SC Amiens SC 42 59 61 58
10 Olympique Alès Olympique 42 44 44 53
11 Charleville Charleville 42 45 49 52
12 Le Mans Le Mans 42 46 48 50
13 FC Mulhouse FC Mulhouse 42 49 58 49
14 Valence Valence 42 46 52 47
15 Stade Lavallois Stade 42 42 56 44
16 Perpignan Perpignan 42 35 51 44
17 Angers SCO Angers SCO 42 38 50 43
18 Stade Briochin Stade 42 38 52 43
19 Niort Niort 42 34 49 43
20 Beauvais Oise Beauvais 42 50 66 42
21 CS Sedan CS Sedan 42 34 60 41
22 Nîmes Nîmes 42 48 60 38
TEMPORADA 1993/1994
LIGUE 1
Equipo PJ GF GC Puntos
1 PSG PSG 38 54 22 59
2 Olympique Marseille Olympique 38 56 33 51
3 Auxerre Auxerre 38 54 29 46
4 Girondins Bordeaux Girondins 38 54 37 46
5 Nantes Nantes 38 47 32 45
6 Cannes Cannes 38 50 43 44
7 Montpellier Montpellier 38 41 37 43
8 Olympique Lyonnais Olympique 38 38 40 42
9 Monaco Monaco 38 52 36 41
10 Lens Lens 38 49 40 39
11 Saint-Étienne Saint-Étien 38 38 36 37
12 Metz Metz 38 36 35 37
13 Strasbourg Strasbourg 38 43 47 34
14 Sochaux Sochaux 38 39 48 33
15 Lille Lille 38 41 52 32
16 Caen Caen 38 29 54 31
17 Le Havre Le Havre 38 29 48 29
18 FC Martigues Martigues 38 37 58 27
19 Toulouse Toulouse 38 26 60 23
20 Angers SCO Angers SCO 38 37 63 21
TEMPORADA 1992/1993
LIGUE 1
Equipo PJ GF GC Puntos
1 Olympique Marseille Olympique 38 72 36 55
2 PSG PSG 38 61 29 51
3 Monaco Monaco 38 56 29 51
4 Girondins Bordeaux Girondins 38 42 25 48
5 Nantes Nantes 38 54 39 45
6 Auxerre Auxerre 38 57 44 43
7 Saint-Étienne Saint-Étien 38 34 26 43
8 Strasbourg Strasbourg 38 58 57 40
9 Lens Lens 38 36 41 40
10 Montpellier Montpellier 38 36 41 36
11 Caen Caen 38 55 54 35
12 Metz Metz 38 44 45 35
13 Toulouse Toulouse 38 36 45 34
14 Olympique Lyonnais Olympique 38 40 45 33
15 Le Havre Le Havre 38 42 53 33
16 Sochaux Sochaux 38 33 50 32
17 Lille Lille 38 26 48 30
18 Valenciennes Valenciennes 38 42 57 29
19 Sporting Toulon Var Sporting 38 31 57 25
20 Nîmes Nîmes 38 32 66 22
TEMPORADA 1991/1992
LIGUE 1
Equipo PJ GF GC Puntos
1 Olympique Marseille Olympique 38 67 21 58
2 Monaco Monaco 38 55 33 52
3 PSG PSG 38 43 27 47
4 Auxerre Auxerre 38 55 32 44
5 Caen Caen 38 46 45 44
6 Montpellier Montpellier 38 40 32 42
7 Le Havre Le Havre 38 35 32 42
8 Lens Lens 38 36 30 39
9 Nantes Nantes 38 37 39 38
10 Saint-Étienne Saint-Étien 38 42 37 37
11 Toulouse Toulouse 38 33 40 36
12 Metz Metz 38 42 43 35
13 Lille Lille 38 31 34 35
14 Sporting Toulon Var Sporting 38 41 55 32
15 Nîmes Nîmes 38 31 50 32
16 Olympique Lyonnais Olympique 38 25 39 31
17 Sochaux Sochaux 38 35 50 31
18 Stade Rennais Stade 38 25 42 29
19 Cannes Cannes 38 34 48 28
20 Nancy Nancy 38 43 67 28
TEMPORADA 1990/1991
LIGUE 1
Equipo PJ GF GC Puntos
1 Olympique Marseille Olympique 38 67 28 55
2 Monaco Monaco 38 51 30 51
3 Auxerre Auxerre 38 63 36 48
4 Cannes Cannes 38 32 28 41
5 Olympique Lyonnais Olympique 38 39 44 41
6 Lille Lille 38 39 37 39
7 Montpellier Montpellier 38 44 35 38
8 Caen Caen 38 38 36 38
9 Girondins Bordeaux Girondins 38 34 32 37
10 Stade Brestois Stade 38 45 46 37
11 PSG PSG 38 40 42 37
12 Metz Metz 38 44 51 36
13 Saint-Étienne Saint-Étien 38 40 46 35
14 Sporting Toulon Var Sporting 38 31 41 35
15 Nice Nice 38 40 42 34
16 Nantes Nantes 38 34 44 34
17 Nancy Nancy 38 38 58 33
18 Sochaux Sochaux 38 24 33 32
19 Toulouse Toulouse 38 33 45 31
20 Stade Rennais Stade 38 29 51 28
TEMPORADA 1989/1990
LIGUE 1
Equipo PJ GF GC Puntos
1 Olympique Marseille Olympique 38 75 34 53
2 Girondins Bordeaux Girondins 38 51 25 51
3 Monaco Monaco 38 38 24 46
4 Sochaux Sochaux 38 46 39 43
5 PSG PSG 38 50 48 42
6 Auxerre Auxerre 38 49 40 41
7 Nantes Nantes 38 42 34 40
8 Olympique Lyonnais Olympique 38 43 41 39
9 Toulouse Toulouse 38 39 39 38
10 Stade Brestois Stade 38 39 44 38
11 Cannes Cannes 38 44 50 36
12 Sporting Toulon Var Sporting 38 35 50 35
13 Montpellier Montpellier 38 49 48 34
14 Metz Metz 38 33 36 34
15 Saint-Étienne Saint-Étien 38 38 46 34
16 Caen Caen 38 34 48 34
17 Lille Lille 38 43 52 33
18 Nice Nice 38 34 48 31
19 Racing Paris Racing Paris 38 39 59 30
20 FC Mulhouse FC Mulhouse 38 42 58 28
TEMPORADA 1988/1989
LIGUE 1
Equipo PJ GF GC Puntos
1 Olympique Marseille Olympique 38 56 35 53
2 PSG PSG 38 45 26 51
3 Monaco Monaco 38 62 38 50
4 Sochaux Sochaux 38 50 28 49
5 Auxerre Auxerre 38 41 32 45
6 Nantes Nantes 38 41 40 42
7 Lille Lille 38 50 38 41
8 Nice Nice 38 45 40 41
9 Toulouse Toulouse 38 44 46 39
10 Sporting Toulon Var Sporting 38 30 29 38
11 Montpellier Montpellier 38 51 53 38
12 Girondins Bordeaux Girondins 38 54 46 37
13 Cannes Cannes 38 45 47 36
14 Saint-Étienne Saint-Étien 38 39 50 36
15 Metz Metz 38 47 49 35
16 Caen Caen 38 39 60 30
17 Racing Paris Racing Paris 38 49 56 29
18 Strasbourg Strasbourg 38 47 59 29
19 Stade Lavallois Stade 38 33 55 27
20 Lens Lens 38 32 73 14
TEMPORADA 1987/1988
LIGUE 1
Equipo PJ GF GC Puntos
1 Monaco Monaco 38 53 29 52
2 Girondins Bordeaux Girondins 38 46 30 46
3 Montpellier Montpellier 38 68 38 45
4 Saint-Étienne Saint-Étien 38 54 56 42
5 Sporting Toulon Var Sporting 38 41 26 41
6 Olympique Marseille Olympique 38 49 43 41
7 Racing Paris Racing Paris 38 35 42 41
8 Metz Metz 38 46 40 40
9 Auxerre Auxerre 38 37 29 39
10 Nantes Nantes 38 46 41 39
11 Lille Lille 38 45 39 37
12 Cannes Cannes 38 42 52 37
13 Toulouse Toulouse 38 35 47 35
14 Stade Lavallois Stade 38 38 38 34
15 PSG PSG 38 36 45 34
16 Nice Nice 38 42 47 33
17 Lens Lens 38 40 62 33
18 Niort Niort 38 34 42 32
19 Stade Brestois Stade 38 32 52 32
20 Le Havre Le Havre 38 35 56 27
TEMPORADA 1986/1987
LIGUE 1
Equipo PJ GF GC Puntos
1 Girondins Bordeaux Girondins 38 57 27 53
2 Olympique Marseille Olympique 38 52 33 49
3 Toulouse Toulouse 38 54 32 48
4 Auxerre Auxerre 38 45 32 47
5 Monaco Monaco 38 41 33 45
6 Metz Metz 38 54 32 43
7 PSG PSG 38 35 33 41
8 Stade Brestois Stade 38 43 41 40
9 Stade Lavallois Stade 38 40 46 38
10 Lens Lens 38 37 40 37
11 Nice Nice 38 38 49 37
12 Nantes Nantes 38 35 38 36
13 Racing Paris Racing Paris 38 41 45 36
14 Lille Lille 38 39 38 34
15 Sporting Toulon Var Sporting 38 36 46 34
16 Saint-Étienne Saint-Étien 38 27 32 33
17 Le Havre Le Havre 38 39 50 32
18 Sochaux Sochaux 38 35 51 31
19 Nancy Nancy 38 28 40 29
20 Stade Rennais Stade 38 20 58 17
TEMPORADA 1985/1986
LIGUE 1
Equipo PJ GF GC Puntos
1 PSG PSG 38 66 33 56
2 Nantes Nantes 38 53 27 53
3 Girondins Bordeaux Girondins 38 55 46 49
4 Toulouse Toulouse 38 59 44 43
5 Lens Lens 38 51 43 43
6 Metz Metz 38 53 34 42
7 Auxerre Auxerre 38 45 39 41
8 Nice Nice 38 39 44 39
9 Monaco Monaco 38 49 42 37
10 Lille Lille 38 40 49 36
11 Stade Lavallois Stade 38 39 47 35
12 Olympique Marseille Olympique 38 43 39 34
13 Stade Rennais Stade 38 36 41 34
14 Stade Brestois Stade 38 53 63 34
15 Sochaux Sochaux 38 47 57 34
16 Sporting Toulon Var Sporting 38 43 46 33
17 Le Havre Le Havre 38 49 53 33
18 Nancy Nancy 38 45 51 33
19 Strasbourg Strasbourg 38 36 54 31
20 Bastia Bastia 38 30 79 20
TEMPORADA 1984/1985
LIGUE 1
Equipo PJ GF GC Puntos
1 Girondins Bordeaux Girondins 38 70 27 59
2 Nantes Nantes 38 62 32 56
3 Monaco Monaco 38 65 28 48
4 Auxerre Auxerre 38 53 39 47
5 Metz Metz 38 50 46 45
6 Sporting Toulon Var Sporting 38 46 37 44
7 Lens Lens 38 57 43 40
8 Sochaux Sochaux 38 56 43 38
9 Stade Brestois Stade 38 50 51 36
10 Stade Lavallois Stade 38 39 52 36
11 Toulouse Toulouse 38 43 49 35
12 Nancy Nancy 38 52 54 34
13 PSG PSG 38 58 73 33
14 Bastia Bastia 38 39 68 32
15 Lille Lille 38 37 45 31
16 Strasbourg Strasbourg 38 47 57 31
17 Olympique Marseille Olympique 38 51 67 31
18 FC Rouen 1899 Rouen 1899 38 28 46 29
19 Tours Tours 38 44 66 29
20 Racing Paris Racing Paris 38 32 56 26
TEMPORADA 1979/1980
LIGUE 1
Equipo PJ GF GC Puntos
1 Nantes Nantes 38 76 30 57
2 Sochaux Sochaux 38 77 36 54
3 Saint-Étienne Saint-Étien 38 73 50 54
4 Monaco Monaco 38 61 30 50
5 Strasbourg Strasbourg 38 58 50 43
6 Girondins Bordeaux Girondins 38 64 53 40
7 PSG PSG 38 59 52 40
8 Valenciennes Valenciennes 38 47 47 40
9 Lens Lens 38 51 52 38
10 Nîmes Nîmes 38 45 50 38
11 Nancy Nancy 38 55 61 37
12 Stade Lavallois Stade 38 57 55 35
13 Lille Lille 38 45 49 35
14 Angers SCO Angers SCO 38 45 55 35
15 Nice Nice 38 53 62 32
16 Bastia Bastia 38 39 51 32
17 Metz Metz 38 45 60 32
18 Olympique Lyonnais Olympique 38 43 65 29
19 Olympique Marseille Olympique 38 45 78 24
20 Stade Brestois Stade 38 35 87 15
TEMPORADA 1978/1979
LIGUE 1
Equipo PJ GF GC Puntos
1 Strasbourg Strasbourg 38 68 28 56
2 Nantes Nantes 38 85 33 54
3 Saint-Étienne Saint-Étien 38 77 34 54
4 Monaco Monaco 38 70 51 44
5 Metz Metz 38 61 56 44
6 Lille Lille 38 67 62 40
7 Olympique Lyonnais Olympique 38 53 56 40
8 Nîmes Nîmes 38 61 50 39
9 Sochaux Sochaux 38 63 53 39
10 Girondins Bordeaux Girondins 38 45 42 39
11 Nancy Nancy 38 77 61 38
12 Olympique Marseille Olympique 38 50 55 37
13 PSG PSG 38 59 66 36
14 Bastia Bastia 38 53 65 35
15 Nice Nice 38 58 75 32
16 Stade Lavallois Stade 38 53 73 30
17 Angers SCO Angers SCO 38 37 68 30
18 Valenciennes Valenciennes 38 36 65 28
19 Paris FC Paris FC 38 42 77 28
20 Stade de Reims Stade Reims 38 26 71 17
TEMPORADA 1977/1978
LIGUE 1
Equipo PJ GF GC Puntos
1 Monaco Monaco 38 79 46 53
2 Nantes Nantes 38 60 26 52
3 Strasbourg Strasbourg 38 70 40 50
4 Olympique Marseille Olympique 38 70 41 47
5 Bastia Bastia 38 62 44 44
6 Nancy Nancy 38 63 49 43
7 Saint-Étienne Saint-Étien 38 50 49 42
8 Nice Nice 38 72 70 41
9 Sochaux Sochaux 38 65 54 40
10 Stade Lavallois Stade 38 50 58 37
11 PSG PSG 38 75 66 36
12 Metz Metz 38 41 57 35
13 Nîmes Nîmes 38 49 63 33
14 Valenciennes Valenciennes 38 48 58 32
15 Stade de Reims Stade Reims 38 42 55 32
16 Girondins Bordeaux Girondins 38 46 69 32
17 Olympique Lyonnais Olympique 38 56 59 31
18 Lens Lens 38 56 71 31
19 Troyes Troyes 38 41 69 31
20 FC Rouen 1899 Rouen 1899 38 40 91 18
TEMPORADA 1976/1977
LIGUE 1
Equipo PJ GF GC Puntos
1 Nantes Nantes 38 80 40 58
2 Lens Lens 38 73 53 49
3 Bastia Bastia 38 82 53 47
4 Nancy Nancy 38 78 53 45
5 Saint-Étienne Saint-Étien 38 55 36 45
6 Olympique Lyonnais Olympique 38 54 47 44
7 Nice Nice 38 60 54 44
8 Metz Metz 38 67 54 43
9 PSG PSG 38 65 55 42
10 Girondins Bordeaux Girondins 38 66 57 38
11 Stade de Reims Stade Reims 38 53 60 36
12 Olympique Marseille Olympique 38 48 63 36
13 Nîmes Nîmes 38 45 56 34
14 Sochaux Sochaux 38 44 56 34
15 Troyes Troyes 38 41 59 33
16 Stade Lavallois Stade 38 46 62 32
17 Valenciennes Valenciennes 38 41 56 31
18 Angers SCO Angers SCO 38 44 65 27
19 Lille Lille 38 40 67 21
20 Stade Rennais Stade 38 43 79 21
TEMPORADA 1975/1976
LIGUE 1
Equipo PJ GF GC Puntos
1 Saint-Étienne Saint-Étien 38 68 39 51
2 Nice Nice 38 67 40 47
3 Sochaux Sochaux 38 59 50 46
4 Nantes Nantes 38 67 44 44
5 Stade de Reims Stade Reims 38 68 49 42
6 Bastia Bastia 38 59 53 41
7 Olympique Marseille Olympique 38 60 60 41
8 Metz Metz 38 72 62 40
9 Girondins Bordeaux Girondins 38 59 59 39
10 Nancy Nancy 38 67 59 38
11 PSG PSG 38 63 60 37
12 Nîmes Nîmes 38 50 53 37
13 Lens Lens 38 58 66 36
14 Valenciennes Valenciennes 38 44 54 36
15 Lille Lille 38 59 73 36
16 Troyes Troyes 38 48 54 34
17 Olympique Lyonnais Olympique 38 55 61 33
18 Monaco Monaco 38 53 73 33
19 Strasbourg Strasbourg 38 39 56 29
20 Avignon AS Avignon AS 38 30 80 20
TEMPORADA 1974/1975
LIGUE 1
Equipo PJ GF GC Puntos
1 Saint-Étienne Saint-Étien 38 70 39 52
2 Olympique Marseille Olympique 38 65 45 45
3 Olympique Lyonnais Olympique 38 64 53 43
4 Nantes Nantes 38 50 42 43
5 Nîmes Nîmes 38 56 49 43
6 Bastia Bastia 38 54 47 41
7 Lens Lens 38 59 59 40
8 Metz Metz 38 54 56 40
9 Monaco Monaco 38 64 68 40
10 Strasbourg Strasbourg 38 49 56 40
11 Stade de Reims Stade Reims 38 57 57 38
12 Girondins Bordeaux Girondins 38 48 49 37
13 Nice Nice 38 59 63 36
14 PSG PSG 38 57 65 36
15 Lille Lille 38 53 56 35
16 Troyes Troyes 38 46 55 34
17 Sochaux Sochaux 38 41 49 32
18 Stade Rennais Stade 38 38 52 31
19 Angers SCO Angers SCO 38 48 60 28
20 Red Star Red Star 38 43 55 26
TEMPORADA 1973/1974
LIGUE 1
Equipo PJ GF GC Puntos
1 Saint-Étienne Saint-Étien 38 74 40 55
2 Nantes Nantes 38 63 41 47
3 Olympique Lyonnais Olympique 38 64 51 47
4 Angers SCO Angers SCO 38 77 57 43
5 Nice Nice 38 71 55 42
6 Sochaux Sochaux 38 59 46 42
7 Nîmes Nîmes 38 41 37 41
8 Stade Rennais Stade 38 42 47 40
9 Stade de Reims Stade Reims 38 67 62 39
10 Strasbourg Strasbourg 38 62 67 37
11 Bastia Bastia 38 44 49 36
12 Lens Lens 38 58 65 36
13 Metz Metz 38 53 53 35
14 Olympique Marseille Olympique 38 58 62 35
15 Girondins Bordeaux Girondins 38 55 57 34
16 Monaco Monaco 38 64 73 33
17 Troyes Troyes 38 52 63 33
18 Nancy Nancy 38 51 67 33
19 Paris FC Paris FC 38 54 79 27
20 CS Sedan CS Sedan 38 42 80 25

  USO DE MEMORIA  
8,910,104 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.7274
Total Execution Time  0.7289
  CADENA URL  
/historico/Olympique-Marsella/1997
  GET DATOS  
$_GET['/historico/Olympique-Marsella/1997']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0146  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 = 'Olympique-Marsella' AND l.year = 1997 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.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=5117 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=5117 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=5117 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=5117 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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 = 200
0.0132  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 = 67544
0.0131  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 = 53498
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5117 AND type_rel = 2
0.0152  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5117 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 (196,832,834,960,1162) ORDER BY n.cover_points DESC, update_date DESC
0.0137  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 = '5117' AND l.year = 1997 ORDER BY l.year DESC,cat.coefficient DESC
0.0138  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 = '5117' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = 67544 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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 = 53498 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 200 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0137  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=5117 AND l.year in (1996,1997,1998) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (67545,53499,22398,200) 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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 200 AND teamId = 5117
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 22398 AND teamId = 5117
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 67545 AND teamId = 5117
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 53499 AND teamId = 5117
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 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 = 200 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0139  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 events1997 e ON e.player_id = p.id AND e.league_id = 200 WHERE rp.league_id = 200 AND rp.teamId = 5117 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1997 e ON e.player_id = p.id AND e.league_id = 200 WHERE rp.league_id = 200 AND rp.teamId = 5117 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 events1997 e ON e.player_id = p.id AND e.league_id = 200 WHERE rp.league_id = 200 AND rp.teamId = 5117 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 = 5117 AND l.year <= 1997 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 200 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 `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 = 22398 AND t.round = 42 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 `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 = 30916 AND t.round = 42 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 `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 = 9757 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 `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 = 9758 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 9759 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 `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 = 9760 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 `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 = 9763 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 `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 = 9764 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 `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 = 9765 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 9766 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 `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 = 9771 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 `tables1979` 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 = 9772 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 `tables1978` 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 = 9773 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 `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 = 9774 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 `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 = 9775 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 `tables1975` 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 = 9776 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 `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 = 9777 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC