TEMPORADA 2023/2024
LIGUE 1
Equipo PJ GF GC Puntos
1 PSG PSG 28 65 24 63
2 Stade Brestois Stade 29 44 27 53
3 Monaco Monaco 28 53 38 52
4 Lille Lille 28 42 25 49
5 Nice Nice 28 28 22 44
6 Lens Lens 29 38 32 43
7 Olympique Lyonnais Olympique 29 38 45 41
8 Stade de Reims Stade Reims 29 36 39 40
9 Olympique Marseille Olympique 28 41 33 39
10 Stade Rennais Stade 29 41 36 39
11 Toulouse Toulouse 29 34 37 36
12 Strasbourg Strasbourg 29 33 40 36
13 Montpellier Montpellier 29 36 41 33
14 Nantes Nantes 29 28 45 31
15 Le Havre Le Havre 29 27 37 28
16 Lorient Lorient 28 35 52 26
17 Metz Metz 29 30 49 26
18 Clermont Clermont 29 21 48 22
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 2
Equipo PJ GF GC Puntos
1 Monaco Monaco 38 64 33 76
2 Guingamp Guingamp 38 63 38 70
3 Nantes Nantes 38 54 29 69
4 Caen Caen 38 48 28 63
5 Angers SCO Angers SCO 38 52 39 61
6 Le Havre Le Havre 38 52 47 59
7 Dijon FCO Dijon FCO 38 52 49 59
8 Nîmes Nîmes 38 52 42 58
9 Auxerre Auxerre 38 51 53 49
10 Tours Tours 38 40 49 49
11 Arles Arles 38 36 48 46
12 Lens Lens 38 39 53 45
13 Istres Istres 38 38 45 43
14 Clermont Clermont 38 33 47 43
15 Niort Niort 38 39 42 42
16 Chateauroux Chateauroux 38 43 47 42
17 Stade Lavallois Stade 38 47 54 42
18 Le Mans Le Mans 38 39 62 40
19 CS Sedan CS Sedan 38 41 58 31
20 Gazélec Ajaccio Gazélec 38 34 54 28
TEMPORADA 2011/2012
LIGUE 2
Equipo PJ GF GC Puntos
1 Bastia Bastia 38 61 36 71
2 Stade de Reims Stade Reims 38 54 37 65
3 Troyes Troyes 38 45 35 64
4 CS Sedan CS Sedan 38 56 45 59
5 Clermont Clermont 38 48 39 58
6 Tours Tours 38 44 43 56
7 Guingamp Guingamp 38 46 43 55
8 Monaco Monaco 38 41 48 52
9 Nantes Nantes 38 51 42 51
10 Istres Istres 38 46 44 51
11 Angers SCO Angers SCO 38 44 45 51
12 Lens Lens 38 42 48 48
13 Arles Arles 38 34 41 48
14 Chateauroux Chateauroux 38 38 54 48
15 Le Havre Le Havre 38 38 34 47
16 Stade Lavallois Stade 38 46 50 47
17 Le Mans Le Mans 38 39 40 45
18 Metz Metz 38 30 44 42
19 US Boulogne US Boulogne 38 40 47 36
20 Amiens SC Amiens SC 38 29 57 26
TEMPORADA 2010/2011
LIGUE 2
Equipo PJ GF GC Puntos
1 Evian Thonon Gaillard Evian Thonon 38 63 41 67
2 Ajaccio Ajaccio 38 45 37 64
3 Dijon FCO Dijon FCO 38 55 40 62
4 Le Mans Le Mans 38 48 37 62
5 CS Sedan CS Sedan 38 57 37 59
6 Angers SCO Angers SCO 38 41 32 57
7 Clermont Clermont 38 51 49 52
8 US Boulogne US Boulogne 38 35 41 52
9 Le Havre Le Havre 38 43 38 49
10 Stade de Reims Stade Reims 38 53 51 49
11 Istres Istres 38 45 47 49
12 Tours Tours 38 52 59 49
13 Nantes Nantes 38 38 40 47
14 Chateauroux Chateauroux 38 41 47 47
15 Stade Lavallois Stade 38 36 43 47
16 Troyes Troyes 38 35 45 46
17 Metz Metz 38 43 40 45
18 Vannes Vannes 38 39 61 44
19 Nîmes Nîmes 38 35 46 37
20 Grenoble Grenoble 38 36 60 33
TEMPORADA 2009/2010
LIGUE 2
Equipo PJ GF GC Puntos
1 Caen Caen 38 52 30 69
2 Stade Brestois Stade 38 53 34 67
3 Arles Arles 38 43 39 60
4 Metz Metz 38 43 39 56
5 Angers SCO Angers SCO 38 46 43 55
6 Clermont Clermont 38 48 41 54
7 Le Havre Le Havre 38 45 50 52
8 Stade Lavallois Stade 38 49 41 51
9 Dijon FCO Dijon FCO 38 52 46 51
10 Nîmes Nîmes 38 37 43 51
11 Tours Tours 38 47 46 49
12 CS Sedan CS Sedan 38 46 46 49
13 Ajaccio Ajaccio 38 41 42 48
14 Vannes Vannes 38 40 49 46
15 Nantes Nantes 38 43 54 45
16 Chateauroux Chateauroux 38 50 54 44
17 Istres Istres 38 34 52 44
18 Guingamp Guingamp 38 35 40 43
19 Strasbourg Strasbourg 38 42 49 42
20 Bastia Bastia 38 40 48 39
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 2
Equipo PJ GF GC Puntos
1 Le Havre Le Havre 38 66 30 78
2 Nantes Nantes 38 58 34 70
3 Grenoble Grenoble 38 44 30 63
4 CS Sedan CS Sedan 38 46 40 58
5 Clermont Clermont 38 50 41 57
6 Troyes Troyes 38 46 44 57
7 Stade Brestois Stade 38 38 38 57
8 Montpellier Montpellier 38 43 32 54
9 Ajaccio Ajaccio 38 37 41 54
10 Angers SCO Angers SCO 38 39 35 53
11 Bastia Bastia 38 45 46 51
12 Guingamp Guingamp 38 41 37 48
13 Stade de Reims Stade Reims 38 44 52 46
14 Amiens SC Amiens SC 38 49 51 45
15 Chateauroux Chateauroux 38 34 42 45
16 US Boulogne US Boulogne 38 37 54 43
17 Dijon FCO Dijon FCO 38 32 51 42
18 Niort Niort 38 38 48 41
19 FC Libourne FC Libourne 38 41 62 32
20 FC Gueugnon FC Gueugnon 38 39 59 27
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 MEMORIA  
8,669,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1827
Total Execution Time  0.1840
  CADENA URL  
/historico/Nantes
  GET DATOS  
$_GET['/historico/Nantes']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1776 AND type_rel = 2
0.0029  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1776 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (1257869,1310886,3223,4729,9648) ORDER BY n.cover_points DESC, update_date DESC
0.0038  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 = '1776' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0040  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=1776 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (74470,72046,71432,70409,67697) 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.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 72046 AND teamId = 1776
0.0036  SELECT count(id) as num_players from rel_players WHERE league_id = 70409 AND teamId = 1776
0.0057  SELECT count(id) as num_players from rel_players WHERE league_id = 74470 AND teamId = 1776
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 67697 AND teamId = 1776
0.0043  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1776
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0026  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 = '1776' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1776' and rp.type = 4
0.0021  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 = '1776' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0049  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 = 1776 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 events2024 e ON e.player_id = p.id AND e.league_id = 72046 WHERE rp.league_id = 72046 AND rp.teamId = 1776 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 = 1776 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0061  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 = 1776 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 29 ORDER BY team.conference ASC,t.position 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 `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.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 `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.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.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 `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.0028  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.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 `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.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 `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.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 `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.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 `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.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 `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 = 1921 AND t.round = 38 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 `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 = 1328 AND t.round = 38 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 `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 = 1074 AND t.round = 38 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 `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 = 877 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0042  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 = 517 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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.0041  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.0043  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