4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Épinal

Épinal

Entrenador: Fabien Tissot

Temporada 2023/2024
TEMPORADA 2023/2024
NATIONAL
Equipo PJ GF GC Puntos
1 Red Star Red Star 32 50 30 62
2 FC Martigues Martigues 32 41 26 56
3 Niort Niort 32 53 41 52
4 Nancy Nancy 32 49 41 50
5 FC Rouen 1899 Rouen 1899 32 41 30 49
6 Le Mans Le Mans 32 47 41 49
7 Dijon FCO Dijon FCO 32 42 39 48
8 Sochaux Sochaux 32 48 39 47
9 Versailles Versailles 32 40 31 46
10 Nîmes Nîmes 32 32 40 41
11 Orléans Orléans 32 33 35 40
12 Chateauroux Chateauroux 32 37 41 39
13 Villefranche Villefranche 32 32 41 35
14 Avranches Avranches 32 34 56 35
15 GOAL FC GOAL FC 32 41 46 34
16 Marignane Gignac Marignane 32 34 48 34
17 Épinal Épinal 32 36 45 33
18 Cholet Cholet 32 32 52 29
TEMPORADA 2022/2023
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Épinal Épinal 30 55 34 58
2 US Fleury-Merogis Fleury-Merog 30 47 31 58
3 Bobigny Bobigny 30 59 36 52
4 Furiani Agliani Furiani 30 36 25 48
5 Creteil Creteil 30 39 31 43
6 Besancon RC Besancon RC 30 32 31 43
7 Colmar Colmar 30 35 37 43
8 FCSR Haguenau FCSR 30 36 44 40
9 US Boulogne US Boulogne 30 34 33 39
10 ES Wasquehal Wasquehal 30 49 57 38
11 Olympique St Quentin Olympique 30 33 44 38
12 St Geneviève Geneviève 30 32 40 35
13 Maur Lusitanos Maur 30 31 39 35
14 Belfort Belfort 30 31 33 34
15 Metz II Metz II 30 39 53 31
16 Stade de Reims II Stade Reims 30 29 49 22
TEMPORADA 2021/2022
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Paris 13 Atletico Paris 30 40 17 66
2 US Fleury-Merogis Fleury-Merog 30 54 23 65
3 Beauvais Oise Beauvais 30 30 26 54
4 Bobigny Bobigny 30 42 38 48
5 Maur Lusitanos Maur 30 32 22 47
6 Épinal Épinal 30 49 31 47
7 Auxerre II Auxerre II 30 33 35 42
8 Stade de Reims II Stade Reims 30 42 43 37
9 Olympique St Quentin Olympique 30 36 39 36
10 St Geneviève Geneviève 30 30 34 35
11 Belfort Belfort 30 34 43 34
12 FCSR Haguenau FCSR 30 45 53 34
13 Metz II Metz II 30 31 39 31
14 Schiltigheim Schiltigheim 30 24 33 28
15 Lens II Lens II 30 26 46 24
16 Sannois Gratien Sannois 30 20 46 24
TEMPORADA 2020/2021
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Paris 13 Atletico Paris 9 10 4 16
2 Épinal Épinal 8 10 8 15
3 FCSR Haguenau FCSR 9 9 6 14
4 Lens II Lens II 8 12 14 14
5 Bobigny Bobigny 8 8 10 14
6 Maur Lusitanos Maur 8 13 7 13
7 Beauvais Oise Beauvais 9 12 9 13
8 Metz II Metz II 8 9 7 13
9 Auxerre II Auxerre II 9 13 13 13
10 Gazélec Ajaccio Gazélec 9 12 9 12
11 Belfort Belfort 9 12 10 12
12 CS Sedan CS Sedan 8 7 6 11
13 Stade de Reims II Stade Reims 9 15 12 9
14 Sannois Gratien Sannois 9 8 13 7
15 Schiltigheim Schiltigheim 9 5 20 5
16 Olympique St Quentin Olympique 9 6 13 4
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 2
Equipo PJ GF GC Puntos
1 Villefranche Villefranche 30 50 32 58
2 Annecy Annecy 30 51 33 57
3 Andrézieux Andrézieux 30 48 36 52
4 Jura Sud Jura Sud 30 49 41 51
5 Schiltigheim Schiltigheim 30 47 35 50
6 Yzeure Yzeure 30 33 29 46
7 Épinal Épinal 30 42 36 41
8 PSG II PSG II 30 42 39 40
9 Belfort Belfort 30 43 42 39
10 Le Puy Le Puy 30 35 35 39
11 Olympique Lyonnais II Olympique 30 42 45 37
12 GOAL FC GOAL FC 30 34 39 37
13 Saint-Priest Saint-Priest 30 35 43 35
14 Saint-Louis Neuweg Saint-Louis 30 28 43 34
15 Montceau Montceau 30 34 44 33
16 Raon-l'Etape Raon-l'Etape 30 23 64 13
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
Equipo PJ GF GC Puntos
1 Red Star Red Star 34 68 30 70
2 Bourg-Péronnas Bourg-Péron 34 57 25 66
3 Paris FC Paris FC 34 50 28 66
4 Strasbourg Strasbourg 34 50 29 65
5 Luçon Luçon 34 40 25 58
6 Dunkerque Dunkerque 34 38 31 52
7 US Boulogne US Boulogne 34 49 39 50
8 Fréjus St-Raphaël Fréjus 34 42 38 49
9 Avranches Avranches 34 42 38 46
10 Colmar Colmar 34 40 44 45
11 Amiens SC Amiens SC 34 45 48 41
12 Le Poiré-sur-Vie Poiré-sur-V 34 36 44 41
13 Athlético Marseille Athlético 34 40 58 40
14 Chambly Chambly 34 42 54 37
15 CA Bastia CA Bastia 34 32 43 32
16 Colomiers Colomiers 34 30 50 32
17 Istres Istres 34 27 61 22
18 Épinal Épinal 34 30 73 15
TEMPORADA 2013/2014
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Épinal Épinal 30 56 37 55
2 Moulins Moulins 30 51 35 52
3 Yzeure Yzeure 30 43 31 48
4 Olympique Lyonnais II Olympique 30 53 45 47
5 FC Mulhouse FC Mulhouse 30 36 38 45
6 Lyon-Duchère Lyon-Duchèr 30 40 37 43
7 Belfort Belfort 30 32 32 42
8 Raon-l'Etape Raon-l'Etape 30 45 49 42
9 Sarre-Union Sarre-Union 30 48 48 40
10 Sochaux II Sochaux II 30 37 40 40
11 Villefranche Villefranche 30 34 32 38
12 GOAL FC GOAL FC 30 33 39 38
13 Saint-Priest Saint-Priest 30 28 45 38
14 Montceau Montceau 30 37 48 36
15 Jura Sud Jura Sud 30 45 44 35
16 Vesoul Vesoul 30 26 44 25
TEMPORADA 2012/2013
NATIONAL
Equipo PJ GF GC Puntos
1 Creteil Creteil 38 68 44 76
2 Metz Metz 38 62 37 70
3 CA Bastia CA Bastia 38 56 51 61
4 Fréjus St-Raphaël Fréjus 38 52 43 60
5 FC Rouen 1899 Rouen 1899 38 50 37 59
6 Carquefou Carquefou 38 53 35 57
7 Le Poiré-sur-Vie Poiré-sur-V 38 47 35 57
8 Orléans Orléans 38 43 40 57
9 Amiens SC Amiens SC 38 48 38 54
10 Vannes Vannes 38 45 34 51
11 Colmar Colmar 38 43 45 50
12 Luzenac Luzenac 38 43 47 48
13 US Boulogne US Boulogne 38 46 44 47
14 Red Star Red Star 38 34 45 46
15 Bourg-Péronnas Bourg-Péron 38 28 40 45
16 Uzès Pont du Gard Uzès Pont G. 38 31 47 43
17 Paris FC Paris FC 38 38 56 40
18 Épinal Épinal 38 45 56 39
19 Cherbourg Cherbourg 38 41 59 39
20 QRM QRM 38 34 74 23
TEMPORADA 2011/2012
NATIONAL
Equipo PJ GF GC Puntos
1 Nîmes Nîmes 38 65 38 68
2 Gazélec Ajaccio Gazélec 38 57 32 68
3 Niort Niort 38 61 33 67
4 Vannes Vannes 38 55 38 62
5 Épinal Épinal 38 61 47 62
6 FC Rouen 1899 Rouen 1899 38 48 46 60
7 Orléans Orléans 38 41 41 56
8 Colmar Colmar 38 54 44 55
9 Fréjus St-Raphaël Fréjus 38 50 58 51
10 Creteil Creteil 38 51 50 50
11 Red Star Red Star 38 44 52 50
12 Le Poiré-sur-Vie Poiré-sur-V 38 41 46 49
13 QRM QRM 38 45 54 47
14 Cherbourg Cherbourg 38 56 57 46
15 Luzenac Luzenac 38 47 56 45
16 Paris FC Paris FC 38 39 48 44
17 Beauvais Oise Beauvais 38 39 43 42
18 FC Martigues Martigues 38 43 69 39
19 Besancon RC Besancon RC 38 42 65 38
20 Bayonne Bayonne 38 38 60 34
TEMPORADA 2010/2011
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Besancon RC Besancon RC 32 41 22 64
2 Épinal Épinal 32 51 22 61
3 Ivry Ivry 32 53 31 56
4 Sochaux II Sochaux II 32 49 36 53
5 Villefranche Villefranche 32 45 34 50
6 Amnéville Amnéville 32 50 45 49
7 Bourg-Péronnas Bourg-Péron 32 50 48 47
8 PSG II PSG II 32 55 41 46
9 Auxerre II Auxerre II 32 41 32 44
10 Jura Sud Jura Sud 32 35 42 44
11 Nancy II Nancy II 32 48 40 43
12 FC Mulhouse FC Mulhouse 32 45 44 41
13 Belfort Belfort 32 35 35 38
14 Raon-l'Etape Raon-l'Etape 32 39 49 37
15 Lyon-Duchère Lyon-Duchèr 32 40 51 35
16 GOAL FC GOAL FC 32 34 68 22
17 CS Louhans Cuiseaux Louhans 32 13 84 7
TEMPORADA 2009/2010
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Colmar Colmar 36 55 33 69
2 UJA Maccabi UJA Maccabi 36 56 37 67
3 Villemomble Sports Villemomble 36 45 33 61
4 Besancon RC Besancon RC 36 59 48 56
5 Amnéville Amnéville 36 58 55 53
6 Drancy Drancy 36 49 51 52
7 Noisy-le-Sec Noisy-le-Sec 36 52 46 50
8 Nancy II Nancy II 36 47 46 50
9 Épinal Épinal 36 45 46 50
10 Lille II Lille II 36 55 47 49
11 Compiègne Compiègne 36 42 40 48
12 Raon-l'Etape Raon-l'Etape 36 47 48 45
13 Sannois Gratien Sannois 36 47 50 45
14 FC Mulhouse FC Mulhouse 36 41 48 45
15 Lens II Lens II 36 40 42 44
16 Vesoul Vesoul 36 29 45 38
17 Dunkerque Dunkerque 36 45 53 37
18 Marck Marck 36 43 57 37
19 Strasbourg II Strasbourg 36 28 58 24
TEMPORADA 2008/2009
NATIONAL 3 GRUPO 3
Equipo PJ GF GC Puntos
1 Épinal Épinal 30 63 38 59
2 Amnéville Amnéville 30 57 26 54
3 Illzach Modenheim Illzach 30 53 40 50
4 Jarville Jarville 30 58 41 48
5 Saint-Louis Neuweg Saint-Louis 30 47 35 46
6 Belfort Belfort 30 41 33 46
7 Saint-Dizier Saint-Dizier 30 33 26 45
8 FC Chaumont FC Chaumont 30 38 41 45
9 Besancon RC II Besancon 30 37 34 40
10 Selongey Selongey 30 44 49 40
11 Vauban Strasbourg Vauban 30 41 48 38
12 Saint-Dié Saint-Dié 30 38 48 35
13 Thaon Thaon 30 30 35 34
14 FCSR Haguenau FCSR 30 27 34 34
15 Vesoul II Vesoul II 30 37 46 32
16 Algrange Algrange 30 20 90 10
TEMPORADA 2007/2008
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Evian Thonon Gaillard Evian Thonon 34 52 17 74
2 Besancon RC Besancon RC 34 61 20 68
3 Vesoul Vesoul 34 61 42 61
4 Sochaux II Sochaux II 34 65 45 60
5 Saint-Priest Saint-Priest 34 50 38 53
6 Olympique Lyonnais II Olympique 34 45 32 49
7 Montceau Montceau 34 36 33 48
8 Auxerre II Auxerre II 34 52 48 45
9 Strasbourg II Strasbourg 34 42 43 45
10 Red Star Red Star 34 38 40 40
11 Jura Sud Jura Sud 34 31 37 38
12 FC Mulhouse FC Mulhouse 34 31 55 38
13 Raon-l'Etape Raon-l'Etape 33 36 57 37
14 Metz II Metz II 33 35 45 36
15 Nancy II Nancy II 34 28 36 34
16 Épinal Épinal 34 33 49 34
17 Belfort Belfort 34 30 50 32
18 RC Épernay Champagne Épernay 34 25 64 26
TEMPORADA 2006/2007
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Calais Calais 34 55 24 66
2 Besancon RC Besancon RC 34 55 31 62
3 Lille II Lille II 34 46 34 56
4 Dunkerque Dunkerque 34 50 42 50
5 Metz II Metz II 34 44 37 50
6 Sochaux II Sochaux II 34 56 43 48
7 Compiègne Compiègne 34 42 39 48
8 Épinal Épinal 34 42 42 46
9 Lens II Lens II 34 42 49 46
10 FC Mulhouse FC Mulhouse 34 38 45 46
11 Nancy II Nancy II 34 38 39 44
12 Vesoul Vesoul 34 33 39 44
13 Lesquin Lesquin 34 36 47 43
14 Olympique St Quentin Olympique 34 37 39 38
15 Strasbourg II Strasbourg 34 41 44 36
16 RC Épernay Champagne Épernay 34 35 55 35
17 Leval Leval 34 37 61 32
18 Schiltigheim Schiltigheim 34 44 61 31
TEMPORADA 2005/2006
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Beauvais Oise Beauvais 34 67 33 68
2 Dunkerque Dunkerque 34 55 37 63
3 Auxerre II Auxerre II 34 51 32 58
4 Roye-Noyon Roye-Noyon 34 47 37 51
5 Calais Calais 34 41 30 50
6 Compiègne Compiègne 34 43 34 50
7 Lens II Lens II 34 50 44 49
8 Lesquin Lesquin 34 35 41 46
9 Lille II Lille II 34 45 39 45
10 FC Mulhouse FC Mulhouse 34 40 48 43
11 Metz II Metz II 33 36 33 42
12 Strasbourg II Strasbourg 34 35 43 42
13 Nancy II Nancy II 34 38 40 39
14 Vauban Strasbourg Vauban 34 47 59 37
15 Schiltigheim Schiltigheim 34 35 48 37
16 Épinal Épinal 34 32 54 37
17 Feignies Feignies 33 36 47 36
18 ES Wasquehal Wasquehal 34 32 66 21
TEMPORADA 1997/1998
NATIONAL
Equipo PJ GF GC Puntos
1 Ajaccio Ajaccio 34 64 22 77
2 CS Sedan CS Sedan 34 65 26 75
3 Creteil Creteil 34 46 21 72
4 Istres Istres 34 61 43 58
5 Gazélec Ajaccio Gazélec 34 52 33 57
6 Paris FC Paris FC 34 46 33 53
7 Stade Poitevin Stade 34 43 48 45
8 Tours Tours 34 39 39 43
9 Racing Colombes 92 Racing 34 33 38 43
10 St. Maur Lusi Maur Lusi 34 33 39 43
11 Angouleme Angouleme 34 35 43 39
12 Noisy-le-Sec Noisy-le-Sec 34 30 45 39
13 St-Denis / St-Leu St-Denis 34 32 42 38
14 Thouars Thouars 34 37 42 35
15 Raon-l'Etape Raon-l'Etape 34 27 42 32
16 Épinal Épinal 34 24 54 31
17 Angers SCO Angers SCO 34 25 51 26
18 Fréjus St-Raphaël Fréjus 34 35 66 25

  USO DE MEMORIA  
8,015,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1607
Total Execution Time  0.1621
  CADENA URL  
/historico/Sas-Epinal
  GET DATOS  
$_GET['/historico/Sas-Epinal']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (46)  
0.0032  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 = 'Sas-Epinal' 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.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=2834 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=2834 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=2834 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=2834 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 72083
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2834 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=103 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 103 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0027  SELECT /*53 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 (1284291,1281961,1269533,1167262,1158575) ORDER BY n.cover_points DESC, update_date DESC
0.0028  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 = '2834' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '2834' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '2834' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 72083 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=2834 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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,72083,71432,68292) 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 = 72083 AND teamId = 2834
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 68292 AND teamId = 2834
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 74470 AND teamId = 2834
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2834
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 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 = 72083 AND t.round = 33 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 = '2834' 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 = '2834' and rp.type = 4
0.0020  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 = '2834' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0037  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 = 72083 WHERE rp.league_id = 72083 AND rp.teamId = 2834 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.0033  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 = 72083 WHERE rp.league_id = 72083 AND rp.teamId = 2834 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 72083 WHERE rp.league_id = 72083 AND rp.teamId = 2834 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 = 2834 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72083 AND t.round = 33 ORDER BY team.conference ASC,t.position 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 `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 = 68292 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 57114 AND t.round = 30 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 `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.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 `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.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 `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 = 39109 AND t.round = 30 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 = 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.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 `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.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 `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 = 3828 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 `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 = 2537 AND t.round = 30 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 `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 = 2096 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 `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 = 19927 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 `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 = 20014 AND t.round = 30 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 `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 = 19936 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 `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 = 19939 AND t.round = 34 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 = 19943 AND t.round = 34 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 `tables1998` 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 = 16462 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72083 ORDER BY nameShow LIMIT 100