4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2019/2020
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Bastia Bastia 21 37 15 53
2 CS Sedan CS Sedan 21 27 4 48
3 Bobigny Bobigny 21 35 12 45
4 Stade de Reims II Stade Reims 21 39 30 36
5 St Geneviève Geneviève 21 30 25 34
6 Épinal Épinal 21 22 15 30
7 Lens II Lens II 21 26 27 28
8 Maur Lusitanos Maur 21 22 23 24
9 Olympique St Quentin Olympique 21 23 27 23
10 FCSR Haguenau FCSR 21 21 29 23
11 Schiltigheim Schiltigheim 21 26 36 22
12 FC Mulhouse FC Mulhouse 21 17 27 20
13 Belfort Belfort 21 24 34 19
14 Lille II Lille II 21 12 21 18
15 Drancy Drancy 21 16 28 17
16 Iris Club de Croix Iris Club C. 21 17 41 16
TEMPORADA 2018/2019
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Creteil Creteil 30 55 21 59
2 Lille II Lille II 30 53 33 56
3 CS Sedan CS Sedan 30 39 29 47
4 Maur Lusitanos Maur 30 53 39 46
5 St Geneviève Geneviève 30 38 39 45
6 Iris Club de Croix Iris Club C. 30 38 44 43
7 Schiltigheim Schiltigheim 30 40 38 42
8 Épinal Épinal 30 33 37 42
9 Stade de Reims II Stade Reims 30 34 36 41
10 US Fleury-Merogis Fleury-Merog 30 48 50 39
11 Belfort Belfort 30 24 31 35
12 Bobigny Bobigny 30 33 44 35
13 Lens II Lens II 30 45 47 34
14 FCSR Haguenau FCSR 30 35 42 31
15 Feignies Feignies 30 33 43 31
16 Arras Arras 30 35 63 21
TEMPORADA 2017/2018
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Drancy Drancy 30 41 17 59
2 CS Sedan CS Sedan 30 52 30 56
3 St Geneviève Geneviève 30 41 31 54
4 US Fleury-Merogis Fleury-Merog 30 45 34 51
5 Arras Arras 30 46 37 48
6 Maur Lusitanos Maur 30 37 33 46
7 Bastia-Borgo Bastia-Borgo 30 33 24 44
8 Poissy Poissy 30 34 36 40
9 Iris Club de Croix Iris Club C. 30 26 32 36
10 Lille II Lille II 30 39 48 34
11 Lens II Lens II 30 46 48 34
12 Stade de Reims II Stade Reims 30 41 43 32
13 Furiani Agliani Furiani 30 31 48 32
14 Amiens AC Amiens AC 30 18 28 30
15 V.Châtillon V.Châtillon 30 28 50 29
16 Beauvais Oise Beauvais 30 31 50 24
TEMPORADA 2016/2017
NATIONAL
Equipo PJ GF GC Puntos
1 Chateauroux Chateauroux 34 43 35 59
2 QRM QRM 34 50 37 58
3 Paris FC Paris FC 34 30 18 54
4 Athlético Marseille Athlético 34 52 44 54
5 Chambly Chambly 34 42 34 54
6 Dunkerque Dunkerque 34 51 37 53
7 Béziers Béziers 34 44 41 50
8 Lyon-Duchère Lyon-Duchèr 34 40 37 50
9 US Boulogne US Boulogne 34 47 38 49
10 Avranches Avranches 34 47 46 46
11 Concarneau Concarneau 34 38 43 46
12 Creteil Creteil 34 40 49 42
13 Les Herbiers Herbiers 34 38 42 39
14 Pau FC Pau FC 34 28 37 38
15 Épinal Épinal 34 33 39 37
16 CA Bastia CA Bastia 34 34 53 36
17 CS Sedan CS Sedan 34 39 52 35
18 Belfort Belfort 34 32 46 31
TEMPORADA 2015/2016
NATIONAL
Equipo PJ GF GC Puntos
1 Strasbourg Strasbourg 34 35 19 58
2 Orléans Orléans 34 50 37 56
3 Amiens SC Amiens SC 34 44 35 55
4 Athlético Marseille Athlético 34 50 43 54
5 Chateauroux Chateauroux 34 52 45 52
6 Dunkerque Dunkerque 34 42 42 47
7 Avranches Avranches 34 44 36 46
8 US Boulogne US Boulogne 34 50 45 46
9 Chambly Chambly 34 46 40 44
10 Béziers Béziers 34 35 38 44
11 Luçon Luçon 34 45 50 44
12 CS Sedan CS Sedan 34 31 34 43
13 CA Bastia CA Bastia 34 29 33 43
14 Belfort Belfort 34 26 32 41
15 Les Herbiers Herbiers 34 44 51 39
16 Colmar Colmar 34 39 46 37
17 Épinal Épinal 34 39 53 30
18 Fréjus St-Raphaël Fréjus 34 22 44 27
TEMPORADA 2014/2015
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 CS Sedan CS Sedan 30 61 25 75
2 QRM QRM 30 41 32 48
3 Iris Club de Croix Iris Club C. 30 37 32 43
4 PSG II PSG II 30 35 36 43
5 Dieppe Dieppe 30 33 29 41
6 Calais Calais 30 26 35 39
7 Amiens AC Amiens AC 30 34 26 38
8 Romorantin Romorantin 30 29 35 38
9 Sannois Gratien Sannois 30 29 29 37
10 Roye-Noyon Roye-Noyon 30 24 29 37
11 Lens II Lens II 30 35 37 36
12 Arras Arras 30 37 44 36
13 Mantes Mantes 30 31 45 36
14 Lille II Lille II 30 33 36 35
15 Beauvais Oise Beauvais 30 26 28 34
16 Ivry Ivry 30 31 44 34
TEMPORADA 2013/2014
NATIONAL 3 GRUPO 2
Equipo PJ GF GC Puntos
1 Iris Club de Croix Iris Club C. 28 63 13 69
2 CS Sedan CS Sedan 26 52 19 58
3 Poissy Poissy 28 37 27 45
4 Feignies Feignies 27 42 33 36
5 ES Wasquehal Wasquehal 27 36 37 35
6 Olympique St Quentin Olympique 28 26 37 35
7 Sénart Moissy Sénart 28 36 41 33
8 Valenciennes II Valenciennes 28 33 39 33
9 Evry Evry 27 35 44 33
10 Paris II Paris II 27 41 44 32
11 Aulnoye Aulnoye 28 38 62 32
12 RC Épernay Champagne Épernay 27 18 32 29
13 Stade de Reims II Stade Reims 27 36 46 26
14 Compiègne Compiègne 28 16 61 12
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 2
Equipo PJ GF GC Puntos
1 Lens Lens 38 47 35 68
2 Montpellier Montpellier 38 61 36 66
3 US Boulogne US Boulogne 38 51 36 66
4 Strasbourg Strasbourg 38 57 45 65
5 Metz Metz 38 48 35 63
6 Tours Tours 38 50 41 61
7 Angers SCO Angers SCO 38 46 42 53
8 Dijon FCO Dijon FCO 38 43 46 52
9 CS Sedan CS Sedan 38 46 49 51
10 Vannes Vannes 38 34 45 51
11 Bastia Bastia 38 38 47 48
12 Clermont Clermont 38 46 50 47
13 Guingamp Guingamp 38 37 35 46
14 Stade Brestois Stade 38 45 50 45
15 Chateauroux Chateauroux 38 40 46 44
16 Ajaccio Ajaccio 38 44 56 44
17 Nîmes Nîmes 38 32 46 44
18 Amiens SC Amiens SC 38 35 40 43
19 Troyes Troyes 38 39 48 38
20 Stade de Reims Stade Reims 38 40 51 36
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 2
Equipo PJ GF GC Puntos
1 Valenciennes Valenciennes 38 51 28 74
2 CS Sedan CS Sedan 38 50 32 71
3 Lorient Lorient 38 49 26 66
4 Caen Caen 38 56 35 66
5 Dijon FCO Dijon FCO 38 47 32 60
6 Bastia Bastia 38 47 40 58
7 Le Havre Le Havre 38 48 41 55
8 Creteil Creteil 38 46 33 54
9 Guingamp Guingamp 38 36 32 50
10 Grenoble Grenoble 38 42 45 48
11 FC Gueugnon FC Gueugnon 38 29 37 48
12 Montpellier Montpellier 38 34 43 47
13 Istres Istres 38 33 45 47
14 Stade de Reims Stade Reims 38 32 31 45
15 Chateauroux Chateauroux 38 48 48 44
16 Amiens SC Amiens SC 38 32 44 43
17 Stade Brestois Stade 38 34 48 42
18 Clermont Clermont 38 35 59 38
19 Stade Lavallois Stade 38 38 59 35
20 Sète Sète 38 31 60 23
TEMPORADA 2004/2005
LIGUE 2
Equipo PJ GF GC Puntos
1 Nancy Nancy 38 54 33 71
2 Le Mans Le Mans 38 51 30 68
3 Troyes Troyes 38 61 48 68
4 Dijon FCO Dijon FCO 38 44 34 57
5 Chateauroux Chateauroux 38 51 43 57
6 CS Sedan CS Sedan 38 38 38 57
7 Guingamp Guingamp 38 53 43 56
8 Montpellier Montpellier 38 44 39 55
9 Stade Brestois Stade 38 38 34 55
10 Grenoble Grenoble 38 45 50 48
11 FC Gueugnon FC Gueugnon 38 30 40 48
12 Amiens SC Amiens SC 38 41 41 47
13 Stade Lavallois Stade 38 43 51 47
14 Lorient Lorient 38 44 53 47
15 Creteil Creteil 38 42 38 46
16 Stade de Reims Stade Reims 38 34 55 43
17 Le Havre Le Havre 38 28 42 42
18 Clermont Clermont 38 34 39 39
19 Niort Niort 38 40 52 38
20 Angers SCO Angers SCO 38 32 44 38
TEMPORADA 2003/2004
LIGUE 2
Equipo PJ GF GC Puntos
1 Saint-Étienne Saint-Étien 38 44 29 73
2 Caen Caen 38 56 31 71
3 Istres Istres 38 44 26 66
4 Lorient Lorient 38 57 45 61
5 CS Sedan CS Sedan 38 42 31 60
6 Nancy Nancy 38 45 36 55
7 Le Havre Le Havre 38 44 46 55
8 Niort Niort 38 47 44 53
9 Amiens SC Amiens SC 38 43 45 53
10 Troyes Troyes 38 43 48 52
11 Chateauroux Chateauroux 38 44 49 49
12 Creteil Creteil 38 41 47 45
13 Angers SCO Angers SCO 38 36 43 45
14 Clermont Clermont 38 36 48 44
15 Grenoble Grenoble 38 38 43 43
16 FC Gueugnon FC Gueugnon 38 40 43 42
17 Stade Lavallois Stade 38 51 55 42
18 Valence Valence 38 45 56 40
19 Besancon RC Besancon RC 38 37 45 38
20 FC Rouen 1899 Rouen 1899 38 27 50 29
TEMPORADA 2002/2003
LIGUE 1
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Olympique 38 63 41 68
2 Monaco Monaco 38 66 33 67
3 Olympique Marseille Olympique 38 41 36 65
4 Girondins Bordeaux Girondins 38 57 36 64
5 Sochaux Sochaux 38 46 31 64
6 Auxerre Auxerre 38 38 29 64
7 Guingamp Guingamp 38 59 46 62
8 Lens Lens 38 43 31 57
9 Nantes Nantes 38 37 39 56
10 Nice Nice 38 39 31 55
11 PSG PSG 38 47 36 54
12 Bastia Bastia 38 40 48 47
13 Strasbourg Strasbourg 38 40 54 45
14 Lille Lille 38 29 44 42
15 Stade Rennais Stade 38 35 45 40
16 Montpellier Montpellier 38 37 54 40
17 Ajaccio Ajaccio 38 29 49 39
18 Le Havre Le Havre 38 27 47 38
19 CS Sedan CS Sedan 38 41 59 36
20 Troyes Troyes 38 23 48 31
TEMPORADA 2001/2002
LIGUE 1
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Olympique 34 62 32 66
2 Lens Lens 34 55 30 64
3 Auxerre Auxerre 34 48 38 59
4 PSG PSG 34 43 24 58
5 Lille Lille 34 39 32 56
6 Girondins Bordeaux Girondins 34 34 31 50
7 Troyes Troyes 34 40 35 47
8 Sochaux Sochaux 34 41 40 46
9 Olympique Marseille Olympique 34 34 39 44
10 Nantes Nantes 34 35 41 43
11 Bastia Bastia 34 38 44 41
12 Stade Rennais Stade 34 40 51 41
13 Montpellier Montpellier 34 28 31 40
14 CS Sedan CS Sedan 34 35 39 39
15 Monaco Monaco 34 36 41 39
16 Guingamp Guingamp 34 34 57 35
17 Metz Metz 34 31 47 33
18 Lorient Lorient 34 43 64 31
TEMPORADA 2000/2001
LIGUE 1
Equipo PJ GF GC Puntos
1 Nantes Nantes 34 58 36 68
2 Olympique Lyonnais Olympique 34 57 30 64
3 Lille Lille 34 43 27 59
4 Girondins Bordeaux Girondins 34 48 33 57
5 CS Sedan CS Sedan 34 47 40 52
6 Stade Rennais Stade 34 46 39 48
7 Troyes Troyes 34 45 47 46
8 Bastia Bastia 34 45 41 45
9 PSG PSG 34 44 45 44
10 Guingamp Guingamp 34 40 48 44
11 Monaco Monaco 34 53 50 43
12 Metz Metz 34 37 44 43
13 Auxerre Auxerre 34 31 41 41
14 Lens Lens 34 37 39 40
15 Olympique Marseille Olympique 34 31 40 40
16 Saint-Étienne Saint-Étien 34 43 56 37
17 Toulouse Toulouse 34 34 50 34
18 Strasbourg Strasbourg 34 28 61 29

  USO DE MEMORIA  
7,997,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1724
Total Execution Time  0.1736
  CADENA URL  
/historico/Sedan/2020
  GET DATOS  
$_GET['/historico/Sedan/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0030  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 = 'Sedan' AND l.year = 2020 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.0018  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=2303 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=2303 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=2303 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 50567
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2303 AND type_rel = 2
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2303 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (96417,131707,140103,244123,289591) ORDER BY n.cover_points DESC, update_date DESC
0.0033  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 = '2303' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0028  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 = '2303' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0044  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 = '2303' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 50567 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  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=2303 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (60328,57114,56547) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 57114 AND teamId = 2303
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 60328 AND teamId = 2303
0.0121  SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 2303
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 50567 AND t.round = 21 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '2303' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2303' 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 = '2303' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0035  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 events2020 e ON e.player_id = p.id AND e.league_id = 50567 WHERE rp.league_id = 50567 AND rp.teamId = 2303 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.0030  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 events2020 e ON e.player_id = p.id AND e.league_id = 50567 WHERE rp.league_id = 50567 AND rp.teamId = 2303 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 events2020 e ON e.player_id = p.id AND e.league_id = 50567 WHERE rp.league_id = 50567 AND rp.teamId = 2303 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 = 2303 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 50567 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 44575 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 39110 AND t.round = 30 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 `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 = 33315 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 15088 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 4044 AND t.round = 30 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 `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 = 2541 AND t.round = 26 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 `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.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 `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.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 `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.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 `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 = 450 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 `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.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 `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.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 `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 = 519 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 `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 = 520 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 `tables2004` 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 = 521 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2003` 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 = 50 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 `tables2002` 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 = 49 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2001` 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 = 196 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC