TEMPORADA 2023/2024
LIGUE 1
Equipo PJ GF GC Puntos
1 PSG PSG 26 62 23 59
2 Stade Brestois Stade 26 36 20 47
3 Monaco Monaco 26 47 36 46
4 Lille Lille 26 37 23 43
5 Nice Nice 26 27 20 43
6 Lens Lens 26 35 27 42
7 Olympique Marseille Olympique 26 40 28 39
8 Stade Rennais Stade 26 40 31 39
9 Stade de Reims Stade Reims 26 34 35 38
10 Olympique Lyonnais Olympique 26 30 40 34
11 Toulouse Toulouse 26 29 36 29
12 Strasbourg Strasbourg 26 28 39 29
13 Le Havre Le Havre 26 26 33 27
14 Montpellier Montpellier 26 31 40 26
15 Lorient Lorient 26 35 49 26
16 Nantes Nantes 26 24 41 25
17 Metz Metz 26 23 39 23
18 Clermont Clermont 26 19 43 20
TEMPORADA 2022/2023
LIGUE 1
Equipo PJ GF GC Puntos
1 PSG PSG 38 89 40 85
2 Lens Lens 38 68 29 84
3 Olympique Marseille Olympique 38 67 40 73
4 Stade Rennais Stade 38 69 39 68
5 Lille Lille 38 65 44 67
6 Monaco Monaco 38 70 58 65
7 Olympique Lyonnais Olympique 38 65 47 62
8 Clermont Clermont 38 45 49 59
9 Nice Nice 38 48 37 58
10 Lorient Lorient 38 52 53 55
11 Stade de Reims Stade Reims 38 45 45 51
12 Montpellier Montpellier 38 65 62 50
13 Toulouse Toulouse 38 51 57 48
14 Stade Brestois Stade 38 44 54 44
15 Strasbourg Strasbourg 38 51 59 40
16 Nantes Nantes 38 37 55 36
17 Auxerre Auxerre 38 35 63 35
18 Ajaccio Ajaccio 38 23 74 26
19 Troyes Troyes 38 45 81 24
20 Angers SCO Angers SCO 38 33 81 18
TEMPORADA 2021/2022
LIGUE 1
Equipo PJ GF GC Puntos
1 PSG PSG 38 90 36 86
2 Olympique Marseille Olympique 38 63 38 71
3 Monaco Monaco 38 65 40 69
4 Stade Rennais Stade 38 82 40 66
5 Nice Nice 38 52 36 66
6 Strasbourg Strasbourg 38 60 43 63
7 Lens Lens 38 62 48 62
8 Olympique Lyonnais Olympique 38 66 51 61
9 Nantes Nantes 38 55 48 55
10 Lille Lille 38 48 48 55
11 Stade Brestois Stade 38 49 57 48
12 Stade de Reims Stade Reims 38 43 44 46
13 Montpellier Montpellier 38 49 61 43
14 Angers SCO Angers SCO 38 44 55 41
15 Troyes Troyes 38 37 53 38
16 Lorient Lorient 38 35 63 36
17 Clermont Clermont 38 38 69 36
18 Saint-Étienne Saint-Étien 38 42 77 32
19 Metz Metz 38 35 69 31
20 Girondins Bordeaux Girondins 38 52 91 31
TEMPORADA 2020/2021
LIGUE 1
Equipo PJ GF GC Puntos
1 Lille Lille 38 64 23 83
2 PSG PSG 38 86 28 82
3 Monaco Monaco 38 76 42 78
4 Olympique Lyonnais Olympique 38 81 43 76
5 Olympique Marseille Olympique 38 54 47 60
6 Stade Rennais Stade 38 52 40 58
7 Lens Lens 38 55 54 57
8 Montpellier Montpellier 38 60 62 54
9 Nice Nice 38 50 53 52
10 Metz Metz 38 44 48 47
11 Saint-Étienne Saint-Étien 38 42 54 46
12 Girondins Bordeaux Girondins 38 42 56 45
13 Angers SCO Angers SCO 38 40 58 44
14 Stade de Reims Stade Reims 38 42 50 42
15 Strasbourg Strasbourg 38 49 58 42
16 Lorient Lorient 38 50 68 42
17 Stade Brestois Stade 38 50 66 41
18 Nantes Nantes 38 47 55 40
19 Nîmes Nîmes 38 40 71 35
20 Dijon FCO Dijon FCO 38 25 73 21
TEMPORADA 2019/2020
LIGUE 1
Equipo PJ GF GC Puntos
1 PSG PSG 27 75 24 68
2 Olympique Marseille Olympique 28 41 29 56
3 Stade Rennais Stade 28 38 24 50
4 Lille Lille 28 35 27 49
5 Stade de Reims Stade Reims 28 26 21 41
6 Nice Nice 28 41 38 41
7 Olympique Lyonnais Olympique 28 42 27 40
8 Montpellier Montpellier 28 35 34 40
9 Monaco Monaco 28 44 44 40
10 Angers SCO Angers SCO 28 28 33 39
11 Strasbourg Strasbourg 27 32 32 38
12 Girondins Bordeaux Girondins 28 40 34 37
13 Nantes Nantes 28 28 31 37
14 Stade Brestois Stade 28 34 37 34
15 Metz Metz 28 27 35 34
16 Dijon FCO Dijon FCO 28 27 37 30
17 Saint-Étienne Saint-Étien 28 29 45 30
18 Nîmes Nîmes 28 29 44 27
19 Amiens SC Amiens SC 28 31 50 23
20 Toulouse Toulouse 28 22 58 13
TEMPORADA 2018/2019
LIGUE 1
Equipo PJ GF GC Puntos
1 PSG PSG 38 105 35 91
2 Lille Lille 38 68 33 75
3 Olympique Lyonnais Olympique 38 70 47 72
4 Saint-Étienne Saint-Étien 38 59 41 66
5 Olympique Marseille Olympique 38 60 52 61
6 Montpellier Montpellier 38 53 42 59
7 Nice Nice 38 30 35 56
8 Stade de Reims Stade Reims 38 39 42 55
9 Nîmes Nîmes 38 57 58 53
10 Stade Rennais Stade 38 55 52 52
11 Strasbourg Strasbourg 38 58 48 49
12 Nantes Nantes 38 48 48 48
13 Angers SCO Angers SCO 38 44 49 46
14 Girondins Bordeaux Girondins 38 34 42 41
15 Amiens SC Amiens SC 38 31 52 38
16 Toulouse Toulouse 38 35 57 38
17 Monaco Monaco 38 38 57 36
18 Dijon FCO Dijon FCO 38 31 60 34
19 Caen Caen 38 29 54 33
20 Guingamp Guingamp 38 28 68 27
TEMPORADA 2017/2018
LIGUE 1
Equipo PJ GF GC Puntos
1 PSG PSG 38 108 29 93
2 Monaco Monaco 38 85 45 80
3 Olympique Lyonnais Olympique 38 87 43 78
4 Olympique Marseille Olympique 38 80 47 77
5 Stade Rennais Stade 38 50 44 58
6 Girondins Bordeaux Girondins 38 53 48 55
7 Saint-Étienne Saint-Étien 38 47 50 55
8 Nice Nice 38 53 52 54
9 Nantes Nantes 38 36 41 52
10 Montpellier Montpellier 38 36 33 51
11 Dijon FCO Dijon FCO 38 55 73 48
12 Guingamp Guingamp 38 48 59 47
13 Amiens SC Amiens SC 38 37 42 45
14 Angers SCO Angers SCO 38 42 52 41
15 Strasbourg Strasbourg 38 44 67 38
16 Caen Caen 38 27 52 38
17 Lille Lille 38 41 67 38
18 Toulouse Toulouse 38 38 54 37
19 Troyes Troyes 38 32 59 33
20 Metz Metz 38 34 76 26
TEMPORADA 2016/2017
LIGUE 1
Equipo PJ GF GC Puntos
1 Monaco Monaco 38 107 31 95
2 PSG PSG 38 83 27 87
3 Nice Nice 38 63 36 78
4 Olympique Lyonnais Olympique 38 77 48 67
5 Olympique Marseille Olympique 38 57 41 62
6 Girondins Bordeaux Girondins 38 53 43 59
7 Nantes Nantes 38 40 54 51
8 Saint-Étienne Saint-Étien 38 41 42 50
9 Stade Rennais Stade 38 36 42 50
10 Guingamp Guingamp 38 46 53 50
11 Lille Lille 38 40 47 46
12 Angers SCO Angers SCO 38 40 49 46
13 Toulouse Toulouse 38 37 41 44
14 Metz Metz 38 39 72 43
15 Montpellier Montpellier 38 48 66 39
16 Dijon FCO Dijon FCO 38 46 58 37
17 Caen Caen 38 36 65 37
18 Lorient Lorient 38 44 70 36
19 Nancy Nancy 38 29 52 35
20 Bastia Bastia 38 29 54 34
TEMPORADA 2015/2016
LIGUE 1
Equipo PJ GF GC Puntos
1 PSG PSG 38 102 19 96
2 Olympique Lyonnais Olympique 38 67 43 65
3 Monaco Monaco 38 57 50 65
4 Nice Nice 38 58 41 63
5 Lille Lille 38 39 27 60
6 Saint-Étienne Saint-Étien 38 42 37 58
7 Caen Caen 38 39 52 54
8 Stade Rennais Stade 38 52 54 52
9 Angers SCO Angers SCO 38 40 38 50
10 Bastia Bastia 38 36 42 50
11 Girondins Bordeaux Girondins 38 50 57 50
12 Montpellier Montpellier 38 49 47 49
13 Olympique Marseille Olympique 38 48 42 48
14 Nantes Nantes 38 33 44 48
15 Lorient Lorient 38 47 58 46
16 Guingamp Guingamp 38 47 56 44
17 Toulouse Toulouse 38 45 55 40
18 Stade de Reims Stade Reims 38 44 57 39
19 Gazélec Ajaccio Gazélec 38 37 58 37
20 Troyes Troyes 38 28 83 18
TEMPORADA 2014/2015
LIGUE 1
Equipo PJ GF GC Puntos
1 PSG PSG 38 83 36 83
2 Olympique Lyonnais Olympique 38 72 33 75
3 Monaco Monaco 38 51 26 71
4 Olympique Marseille Olympique 38 76 42 69
5 Saint-Étienne Saint-Étien 38 51 30 69
6 Girondins Bordeaux Girondins 38 47 44 63
7 Montpellier Montpellier 38 46 39 56
8 Lille Lille 38 43 42 56
9 Stade Rennais Stade 38 35 42 50
10 Guingamp Guingamp 38 41 55 49
11 Nice Nice 38 44 53 48
12 Bastia Bastia 38 37 46 47
13 Caen Caen 38 54 55 46
14 Nantes Nantes 38 29 40 45
15 Stade de Reims Stade Reims 38 47 66 44
16 Lorient Lorient 38 44 50 43
17 Toulouse Toulouse 38 43 64 42
18 Evian Thonon Gaillard Evian Thonon 38 41 62 37
19 Metz Metz 38 31 61 30
20 Lens Lens 38 32 61 29
TEMPORADA 2013/2014
LIGUE 1
Equipo PJ GF GC Puntos
1 PSG PSG 38 84 23 89
2 Monaco Monaco 38 63 31 80
3 Lille Lille 38 46 26 71
4 Saint-Étienne Saint-Étien 38 56 34 69
5 Olympique Lyonnais Olympique 38 56 44 61
6 Olympique Marseille Olympique 38 53 40 60
7 Girondins Bordeaux Girondins 38 49 43 53
8 Lorient Lorient 38 48 53 49
9 Toulouse Toulouse 38 46 53 49
10 Stade de Reims Stade Reims 38 44 52 48
11 Nantes Nantes 38 38 43 47
12 Bastia Bastia 38 42 56 47
13 Stade Rennais Stade 38 47 45 46
14 Evian Thonon Gaillard Evian Thonon 38 39 51 44
15 Montpellier Montpellier 38 45 53 42
16 Guingamp Guingamp 38 34 42 42
17 Nice Nice 38 30 44 42
18 Sochaux Sochaux 38 37 61 40
19 Valenciennes Valenciennes 38 37 65 29
20 Ajaccio Ajaccio 38 37 72 23
TEMPORADA 2012/2013
LIGUE 1
Equipo PJ GF GC Puntos
1 PSG PSG 38 69 23 83
2 Olympique Marseille Olympique 38 42 36 71
3 Olympique Lyonnais Olympique 38 61 38 67
4 Nice Nice 38 57 46 64
5 Saint-Étienne Saint-Étien 38 60 32 63
6 Lille Lille 38 59 40 62
7 Girondins Bordeaux Girondins 38 40 34 55
8 Lorient Lorient 38 57 58 53
9 Montpellier Montpellier 38 54 51 52
10 Toulouse Toulouse 38 49 47 51
11 Valenciennes Valenciennes 38 49 53 48
12 Bastia Bastia 38 50 66 47
13 Stade Rennais Stade 38 48 59 46
14 Stade de Reims Stade Reims 38 33 42 43
15 Ajaccio Ajaccio 38 39 51 42
16 Sochaux Sochaux 38 41 57 41
17 Evian Thonon Gaillard Evian Thonon 38 46 53 40
18 Nancy Nancy 38 38 58 38
19 Troyes Troyes 38 43 61 37
20 Stade Brestois Stade 38 32 62 29
TEMPORADA 2011/2012
LIGUE 1
Equipo PJ GF GC Puntos
1 Montpellier Montpellier 38 68 34 82
2 PSG PSG 38 75 41 79
3 Lille Lille 38 72 39 74
4 Olympique Lyonnais Olympique 38 64 51 64
5 Girondins Bordeaux Girondins 38 53 41 61
6 Stade Rennais Stade 38 53 44 60
7 Saint-Étienne Saint-Étien 38 49 45 57
8 Toulouse Toulouse 38 37 34 56
9 Evian Thonon Gaillard Evian Thonon 38 54 55 50
10 Olympique Marseille Olympique 38 45 41 48
11 Nancy Nancy 38 38 48 45
12 Valenciennes Valenciennes 38 40 50 43
13 Nice Nice 38 39 46 42
14 Sochaux Sochaux 38 40 60 42
15 Stade Brestois Stade 38 31 38 41
16 Ajaccio Ajaccio 38 40 61 41
17 Lorient Lorient 38 35 49 39
18 Caen Caen 38 39 59 38
19 Dijon FCO Dijon FCO 38 38 63 36
20 Auxerre Auxerre 38 46 57 34
TEMPORADA 2010/2011
LIGUE 1
Equipo PJ GF GC Puntos
1 Lille Lille 38 68 36 76
2 Olympique Marseille Olympique 38 62 39 68
3 Olympique Lyonnais Olympique 38 61 40 64
4 PSG PSG 38 56 41 60
5 Sochaux Sochaux 38 60 43 58
6 Stade Rennais Stade 38 38 35 56
7 Girondins Bordeaux Girondins 38 43 42 51
8 Toulouse Toulouse 38 38 36 50
9 Auxerre Auxerre 38 45 41 49
10 Saint-Étienne Saint-Étien 38 46 47 49
11 Lorient Lorient 38 46 48 49
12 Valenciennes Valenciennes 38 45 41 48
13 Nancy Nancy 38 43 48 48
14 Montpellier Montpellier 38 32 43 47
15 Caen Caen 38 46 51 46
16 Stade Brestois Stade 38 36 43 46
17 Nice Nice 38 33 48 46
18 Monaco Monaco 38 36 40 44
19 Lens Lens 38 35 58 35
20 Arles Arles 38 21 70 20
TEMPORADA 2009/2010
LIGUE 1
Equipo PJ GF GC Puntos
1 Olympique Marseille Olympique 38 69 36 78
2 Olympique Lyonnais Olympique 38 64 38 72
3 Auxerre Auxerre 38 42 29 71
4 Lille Lille 38 72 40 70
5 Montpellier Montpellier 38 50 40 69
6 Girondins Bordeaux Girondins 38 58 40 64
7 Lorient Lorient 38 54 42 58
8 Monaco Monaco 38 39 45 55
9 Stade Rennais Stade 38 52 41 53
10 Valenciennes Valenciennes 38 50 50 52
11 Lens Lens 38 40 44 48
12 Nancy Nancy 38 46 53 48
13 PSG PSG 38 50 46 47
14 Toulouse Toulouse 38 36 36 47
15 Nice Nice 38 41 57 44
16 Sochaux Sochaux 38 28 52 41
17 Saint-Étienne Saint-Étien 38 27 45 40
18 Le Mans Le Mans 38 36 59 32
19 US Boulogne US Boulogne 38 31 62 31
20 Grenoble Grenoble 38 31 61 23
TEMPORADA 2008/2009
LIGUE 1
Equipo PJ GF GC Puntos
1 Girondins Bordeaux Girondins 38 64 34 80
2 Olympique Marseille Olympique 38 67 35 77
3 Olympique Lyonnais Olympique 38 52 29 71
4 Toulouse Toulouse 38 45 27 64
5 Lille Lille 38 51 39 64
6 PSG PSG 38 49 38 64
7 Stade Rennais Stade 38 42 34 61
8 Auxerre Auxerre 38 35 35 55
9 Nice Nice 38 40 41 50
10 Lorient Lorient 38 47 47 45
11 Monaco Monaco 38 41 45 45
12 Valenciennes Valenciennes 38 35 42 44
13 Grenoble Grenoble 38 24 37 44
14 Sochaux Sochaux 38 40 48 42
15 Nancy Nancy 38 38 47 42
16 Le Mans Le Mans 38 43 54 40
17 Saint-Étienne Saint-Étien 38 40 56 40
18 Caen Caen 38 42 49 37
19 Nantes Nantes 38 33 54 37
20 Le Havre Le Havre 38 30 67 26
TEMPORADA 2007/2008
LIGUE 1
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Olympique 38 74 37 79
2 Girondins Bordeaux Girondins 38 65 38 75
3 Olympique Marseille Olympique 38 58 45 62
4 Nancy Nancy 38 44 30 60
5 Saint-Étienne Saint-Étien 38 47 34 58
6 Stade Rennais Stade 38 47 44 58
7 Lille Lille 38 45 32 57
8 Nice Nice 38 35 30 55
9 Le Mans Le Mans 38 46 49 53
10 Lorient Lorient 38 32 35 52
11 Caen Caen 38 48 53 51
12 Monaco Monaco 38 40 48 47
13 Valenciennes Valenciennes 38 42 40 45
14 Sochaux Sochaux 38 34 43 44
15 Auxerre Auxerre 38 33 52 44
16 PSG PSG 38 37 45 43
17 Toulouse Toulouse 38 36 42 42
18 Lens Lens 38 43 52 40
19 Strasbourg Strasbourg 38 34 55 35
20 Metz Metz 38 28 64 24
TEMPORADA 2006/2007
LIGUE 1
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Olympique 38 64 27 81
2 Olympique Marseille Olympique 38 53 38 64
3 Stade Rennais Stade 38 38 30 57
4 Lens Lens 38 47 41 57
5 Girondins Bordeaux Girondins 38 39 35 57
6 Sochaux Sochaux 38 46 48 57
7 Toulouse Toulouse 38 44 43 56
8 Auxerre Auxerre 38 41 41 54
9 Monaco Monaco 38 45 38 51
10 Lille Lille 38 45 43 50
11 Saint-Étienne Saint-Étien 38 52 50 49
12 Le Mans Le Mans 38 45 46 49
13 Nancy Nancy 38 37 44 49
14 Lorient Lorient 38 33 40 49
15 PSG PSG 38 42 42 48
16 Nice Nice 38 34 40 43
17 Valenciennes Valenciennes 38 36 48 43
18 Troyes Troyes 38 39 54 39
19 CS Sedan CS Sedan 38 46 58 35
20 Nantes Nantes 38 29 49 35
TEMPORADA 2005/2006
LIGUE 1
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Olympique 38 73 31 84
2 Girondins Bordeaux Girondins 38 43 25 69
3 Lille Lille 38 56 31 62
4 Lens Lens 38 48 34 60
5 Olympique Marseille Olympique 38 44 35 60
6 Auxerre Auxerre 38 50 39 59
7 Stade Rennais Stade 38 48 49 59
8 Nice Nice 38 36 31 58
9 PSG PSG 38 44 38 52
10 Monaco Monaco 38 42 36 52
11 Le Mans Le Mans 38 33 36 52
12 Nancy Nancy 38 35 37 48
13 Saint-Étienne Saint-Étien 38 29 39 47
14 Nantes Nantes 38 37 41 45
15 Sochaux Sochaux 38 34 47 44
16 Toulouse Toulouse 38 36 47 41
17 Troyes Troyes 38 37 47 39
18 Ajaccio Ajaccio 38 27 53 33
19 Strasbourg Strasbourg 38 33 56 29
20 Metz Metz 38 26 59 29
TEMPORADA 2004/2005
LIGUE 1
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Olympique 38 56 22 79
2 Lille Lille 38 52 29 67
3 Monaco Monaco 38 52 35 63
4 Stade Rennais Stade 38 49 42 55
5 Olympique Marseille Olympique 38 47 42 55
6 Saint-Étienne Saint-Étien 38 47 34 53
7 Lens Lens 38 45 39 52
8 Auxerre Auxerre 38 48 47 52
9 PSG PSG 38 40 41 51
10 Sochaux Sochaux 38 42 41 50
11 Strasbourg Strasbourg 38 42 43 48
12 Nice Nice 38 38 45 46
13 Toulouse Toulouse 38 36 43 46
14 Ajaccio Ajaccio 38 36 40 45
15 Girondins Bordeaux Girondins 38 37 41 44
16 Metz Metz 38 33 45 44
17 Nantes Nantes 38 33 38 43
18 Caen Caen 38 36 60 42
19 Bastia Bastia 38 32 48 41
20 Istres Istres 38 25 51 32
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
8,596,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6805
Total Execution Time  0.6817
  CADENA URL  
/historico/Nice
  GET DATOS  
$_GET['/historico/Nice']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (46)  
0.0187  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 = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0113  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.0113  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.0114  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.0113  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.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1799 AND type_rel = 2
0.0177  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.0118  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.0177  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' ORDER BY l.year DESC,cat.coefficient DESC
0.0157  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 = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0120  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.0108  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 = 72046 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0116  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 (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0107  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 (74470,72046,71432,70410,67758) 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.0115  SELECT count(id) as num_players from rel_players WHERE league_id = 72046 AND teamId = 1799
0.0111  SELECT count(id) as num_players from rel_players WHERE league_id = 70410 AND teamId = 1799
0.0116  SELECT count(id) as num_players from rel_players WHERE league_id = 74470 AND teamId = 1799
0.0111  SELECT count(id) as num_players from rel_players WHERE league_id = 67758 AND teamId = 1799
0.0201  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1799
0.0107  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.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1799' and rp.type = 4
0.0109  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.0157  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 events2024 e ON e.player_id = p.id AND e.league_id = 72046 WHERE rp.league_id = 72046 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.0121  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 events2024 e ON e.player_id = p.id AND e.league_id = 72046 WHERE rp.league_id = 72046 AND rp.teamId = 1799 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0121  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 events2024 e ON e.player_id = p.id AND e.league_id = 72046 WHERE rp.league_id = 72046 AND rp.teamId = 1799 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0122  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 <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0115  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72046 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0120  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 67675 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 `tables2022` 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 = 62745 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 56825 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 49849 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 43549 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 `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 38644 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 29189 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0116  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15065 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 3771 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2432 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1910 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0117  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2012` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1327 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0117  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2011` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1072 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 816 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 151 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2008` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 26 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2007` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 54 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 53 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 `tables2005` 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 = 52 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC