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

Dunkerque

Entrenador: Luís Castro

Temporada 2023/2024
TEMPORADA 2023/2024
LIGUE 2
Equipo PJ GF GC Puntos
1 Auxerre Auxerre 35 66 35 67
2 Saint-Étienne Saint-Étien 35 44 26 63
3 Angers SCO Angers SCO 35 52 40 61
4 Rodez Rodez 35 58 47 56
5 Paris FC Paris FC 35 46 38 55
6 Stade Lavallois Stade 35 38 42 52
7 Pau FC Pau FC 35 56 50 51
8 Caen Caen 35 45 43 51
9 Guingamp Guingamp 35 41 35 50
10 Amiens SC Amiens SC 35 31 34 46
11 Bastia Bastia 35 40 44 46
12 Ajaccio Ajaccio 35 34 38 46
13 Grenoble Grenoble 35 38 39 45
14 Girondins Bordeaux Girondins 35 41 46 44
15 Annecy Annecy 35 44 46 42
16 Dunkerque Dunkerque 35 32 49 41
17 Troyes Troyes 35 39 47 37
18 QRM QRM 35 47 50 35
19 Concarneau Concarneau 35 33 49 35
20 Valenciennes Valenciennes 35 23 50 23
TEMPORADA 2022/2023
NATIONAL
Equipo PJ GF GC Puntos
1 Concarneau Concarneau 34 60 37 62
2 Dunkerque Dunkerque 34 50 32 62
3 Red Star Red Star 34 51 30 60
4 FC Martigues Martigues 34 54 40 60
5 Versailles Versailles 34 41 41 51
6 Villefranche Villefranche 34 49 40 46
7 CS Sedan CS Sedan 34 41 47 46
8 Cholet Cholet 34 38 41 45
9 Avranches Avranches 34 44 46 45
10 Orléans Orléans 34 38 37 44
11 Chateauroux Chateauroux 34 41 46 44
12 Le Mans Le Mans 34 50 42 43
13 Nancy Nancy 34 37 42 41
14 Bourg-Péronnas Bourg-Péron 34 42 46 40
15 Stade Briochin Stade 34 36 46 38
16 Le Puy Le Puy 34 34 50 35
17 Paris 13 Atletico Paris 34 28 42 31
18 Bastia-Borgo Bastia-Borgo 34 32 61 26
TEMPORADA 2021/2022
LIGUE 2
Equipo PJ GF GC Puntos
1 Toulouse Toulouse 38 82 33 79
2 Ajaccio Ajaccio 38 39 19 75
3 Auxerre Auxerre 38 61 39 74
4 Paris FC Paris FC 38 54 35 70
5 Sochaux Sochaux 38 47 34 68
6 Guingamp Guingamp 38 52 48 58
7 Caen Caen 38 51 42 50
8 Le Havre Le Havre 38 38 41 50
9 Nîmes Nîmes 38 44 51 49
10 Pau FC Pau FC 38 41 49 49
11 Dijon FCO Dijon FCO 38 48 53 47
12 Bastia Bastia 38 38 36 46
13 Niort Niort 38 39 42 46
14 Amiens SC Amiens SC 38 43 41 44
15 Grenoble Grenoble 38 32 44 44
16 Valenciennes Valenciennes 38 34 47 44
17 Rodez Rodez 38 32 42 43
18 QRM QRM 38 33 50 40
19 Dunkerque Dunkerque 38 28 53 31
20 Nancy Nancy 38 32 69 27
TEMPORADA 2020/2021
LIGUE 2
Equipo PJ GF GC Puntos
1 Troyes Troyes 38 60 36 77
2 Clermont Clermont 38 61 25 72
3 Toulouse Toulouse 38 71 42 70
4 Grenoble Grenoble 38 51 35 65
5 Paris FC Paris FC 38 53 37 64
6 Auxerre Auxerre 38 64 43 62
7 Sochaux Sochaux 38 45 37 51
8 Nancy Nancy 38 53 53 47
9 Guingamp Guingamp 38 41 43 47
10 Amiens SC Amiens SC 38 34 40 47
11 Valenciennes Valenciennes 38 50 59 47
12 Le Havre Le Havre 38 38 48 47
13 Ajaccio Ajaccio 38 34 43 46
14 Pau FC Pau FC 38 42 49 44
15 Rodez Rodez 38 38 44 43
16 Dunkerque Dunkerque 38 34 47 41
17 Caen Caen 38 34 49 41
18 Niort Niort 38 34 58 41
19 Chambly Chambly 38 41 64 38
20 Chateauroux Chateauroux 38 32 58 23
TEMPORADA 2019/2020
NATIONAL
Equipo PJ GF GC Puntos
1 Pau FC Pau FC 25 43 20 48
2 Dunkerque Dunkerque 25 42 26 47
3 US Boulogne US Boulogne 25 32 17 46
4 Red Star Red Star 25 30 22 42
5 Bourg-Péronnas Bourg-Péron 25 38 30 42
6 Avranches Avranches 24 30 26 42
7 Villefranche Villefranche 25 34 24 41
8 Lyon-Duchère Lyon-Duchèr 25 37 32 40
9 Creteil Creteil 25 33 27 35
10 Stade Lavallois Stade 25 26 24 35
11 Concarneau Concarneau 25 21 25 31
12 Cholet Cholet 25 32 40 28
13 Bastia-Borgo Bastia-Borgo 23 22 32 24
14 QRM QRM 24 26 34 24
15 Le Puy Le Puy 25 27 40 23
16 Béziers Béziers 25 26 43 23
17 Gazélec Ajaccio Gazélec 25 15 35 19
18 Sporting Toulon Var Sporting 25 17 34 13
TEMPORADA 2018/2019
NATIONAL
Equipo PJ GF GC Puntos
1 Rodez Rodez 34 54 21 76
2 Chambly Chambly 34 48 31 62
3 Le Mans Le Mans 34 38 29 59
4 Stade Lavallois Stade 34 51 43 54
5 Lyon-Duchère Lyon-Duchèr 34 43 42 50
6 US Boulogne US Boulogne 34 38 33 49
7 Pau FC Pau FC 34 45 35 48
8 Cholet Cholet 34 41 38 46
9 Avranches Avranches 34 37 40 45
10 QRM QRM 34 37 37 45
11 Dunkerque Dunkerque 34 37 39 43
12 Villefranche Villefranche 34 34 34 42
13 Concarneau Concarneau 34 30 43 40
14 Tours Tours 34 21 29 37
15 Bourg-Péronnas Bourg-Péron 34 32 42 36
16 Marignane Gignac Marignane 34 31 43 34
17 Sannois Gratien Sannois 34 27 46 29
18 Drancy Drancy 34 21 40 26
TEMPORADA 2017/2018
NATIONAL
Equipo PJ GF GC Puntos
1 Red Star Red Star 32 41 25 56
2 Béziers Béziers 32 41 29 52
3 Grenoble Grenoble 32 33 23 51
4 Rodez Rodez 32 33 33 45
5 Avranches Avranches 32 39 42 43
6 Lyon-Duchère Lyon-Duchèr 32 30 33 42
7 US Boulogne US Boulogne 32 36 34 42
8 Stade Lavallois Stade 32 37 36 42
9 Dunkerque Dunkerque 32 39 39 41
10 Concarneau Concarneau 32 38 38 40
11 Chambly Chambly 32 36 32 40
12 Sannois Gratien Sannois 32 41 46 40
13 Pau FC Pau FC 32 43 37 40
14 Cholet Cholet 32 49 53 39
15 Les Herbiers Herbiers 32 37 45 39
16 Athlético Marseille Athlético 32 37 46 37
17 Creteil Creteil 32 29 48 26
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
Equipo PJ GF GC Puntos
1 Orléans Orléans 34 46 22 65
2 Luzenac Luzenac 34 51 30 63
3 Gazélec Ajaccio Gazélec 34 45 27 60
4 Dunkerque Dunkerque 34 35 30 50
5 Colmar Colmar 34 37 39 50
6 Amiens SC Amiens SC 34 32 24 49
7 Red Star Red Star 34 37 33 48
8 Carquefou Carquefou 34 32 30 47
9 Paris FC Paris FC 34 32 27 46
10 Fréjus St-Raphaël Fréjus 34 35 35 46
11 Bourg-Péronnas Bourg-Péron 34 38 45 43
12 Luçon Luçon 34 32 41 41
13 Le Poiré-sur-Vie Poiré-sur-V 34 37 52 41
14 US Boulogne US Boulogne 34 36 40 40
15 Colomiers Colomiers 34 39 39 39
16 Strasbourg Strasbourg 34 36 40 35
17 Vannes Vannes 34 35 45 32
18 Uzès Pont du Gard Uzès Pont G. 34 25 61 23
TEMPORADA 2012/2013
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Dunkerque Dunkerque 34 47 22 69
2 Chambly Chambly 34 39 14 65
3 Beauvais Oise Beauvais 34 42 38 56
4 Roye-Noyon Roye-Noyon 34 39 35 50
5 Amnéville Amnéville 34 50 42 47
6 Lille II Lille II 34 39 43 47
7 Aubervilliers Aubervillier 34 35 44 47
8 FC Calvi FC Calvi 34 60 45 46
9 Ivry Ivry 34 33 31 46
10 Mantes Mantes 34 38 40 44
11 Villemomble Sports Villemomble 34 37 39 44
12 Amiens AC Amiens AC 34 38 44 44
13 Drancy Drancy 34 30 28 43
14 Lens II Lens II 34 42 46 43
15 Poissy Poissy 34 40 45 40
16 Compiègne Compiègne 34 30 42 33
17 Metz II Metz II 34 33 47 32
18 Valenciennes II Valenciennes 34 29 56 25
TEMPORADA 2011/2012
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 CA Bastia CA Bastia 34 53 33 67
2 Aubervilliers Aubervillier 34 53 34 64
3 Dunkerque Dunkerque 34 50 31 63
4 Auxerre II Auxerre II 34 60 36 62
5 Drancy Drancy 34 35 32 55
6 Lens II Lens II 34 48 39 50
7 FC Calvi FC Calvi 34 58 51 50
8 Amiens AC Amiens AC 34 41 40 50
9 Ivry Ivry 34 50 40 49
10 Lille II Lille II 34 44 42 48
11 Compiègne Compiègne 34 44 52 43
12 Poissy Poissy 34 43 47 38
13 Valenciennes II Valenciennes 34 44 52 38
14 PSG II PSG II 34 32 38 35
15 Alfortville Alfortville 34 36 55 32
16 Sénart Moissy Sénart 34 22 45 31
17 Villemomble Sports Villemomble 34 24 47 30
18 Avion Avion 34 34 57 25
TEMPORADA 2010/2011
NATIONAL 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Amiens AC Amiens AC 30 39 18 59
2 Dunkerque Dunkerque 30 38 18 56
3 Oissel Oissel 30 39 25 49
4 Saint-Omer Saint-Omer 30 46 47 43
5 Dieppe Dieppe 30 40 28 41
6 Chartres Chartres 30 39 38 41
7 Bastia II Bastia II 30 39 40 41
8 Paris II Paris II 30 34 36 38
9 Marck Marck 30 33 35 38
10 Grande-Synthe Grande-Synth 30 25 30 38
11 Gravelines Gravelines 30 32 39 38
12 Evreux 27 Evreux 27 30 31 33 37
13 Beauvais II Beauvais II 30 30 33 37
14 Pacy Vallée-d'Eure II Pacy 30 30 41 33
15 Hazebrouck Hazebrouck 30 35 37 32
16 Dives Dives 30 33 65 26
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 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Besancon RC Besancon RC 34 67 34 72
2 Compiègne Compiègne 34 52 30 64
3 FC Mulhouse FC Mulhouse 34 46 32 62
4 Montceau Montceau 34 46 33 58
5 Colmar Colmar 34 33 29 54
6 Sochaux II Sochaux II 34 45 36 53
7 Dunkerque Dunkerque 34 43 39 49
8 Auxerre II Auxerre II 34 39 37 47
9 Lens II Lens II 34 45 40 45
10 Strasbourg II Strasbourg 34 34 35 44
11 Lille II Lille II 34 40 48 43
12 Raon-l'Etape Raon-l'Etape 34 39 49 41
13 Sénart Moissy Sénart 34 24 32 37
14 Nancy II Nancy II 34 32 41 36
15 Noisy-le-Sec Noisy-le-Sec 34 31 43 36
16 Vesoul Vesoul 34 39 49 35
17 Metz II Metz II 34 30 47 35
18 St Geneviève Geneviève 34 28 59 22
TEMPORADA 2007/2008
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Pacy Vallée-d.Eure Pacy 34 51 31 62
2 FC Rouen 1899 Rouen 1899 34 43 26 60
3 QRM QRM 34 49 38 56
4 Dunkerque Dunkerque 34 55 42 55
5 Lille II Lille II 34 48 37 52
6 Racing Colombes 92 Racing 34 42 45 49
7 Caen II Caen II 34 41 41 48
8 Vitré Vitré 34 37 47 48
9 La Vitréenne Vitréenne 34 29 28 47
10 Guingamp II Guingamp II 34 46 38 46
11 Compiègne Compiègne 34 39 42 46
12 Lens II Lens II 34 47 48 45
13 Stade Rennais II Stade 34 40 39 44
14 Le Havre II Le Havre II 34 43 41 42
15 Plabennec Plabennec 34 30 44 40
16 Lesquin Lesquin 34 43 46 39
17 ES Wasquehal Wasquehal 34 32 43 35
18 Valenciennes II Valenciennes 34 29 68 17
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 1995/1996
LIGUE 2
Equipo PJ GF GC Puntos
1 Caen Caen 42 59 34 81
2 Olympique Marseille Olympique 42 69 35 80
3 Nancy Nancy 42 56 23 76
4 Stade Lavallois Stade 42 52 47 69
5 Toulouse Toulouse 42 40 34 63
6 Le Mans Le Mans 42 37 36 62
7 Red Star Red Star 42 56 38 61
8 Perpignan Perpignan 42 44 53 61
9 Chateauroux Chateauroux 42 40 35 60
10 Sochaux Sochaux 42 49 40 59
11 CS Louhans Cuiseaux Louhans 42 57 49 58
12 Lorient Lorient 42 44 46 58
13 Amiens SC Amiens SC 42 41 49 52
14 FC Mulhouse FC Mulhouse 42 44 45 51
15 Valence Valence 42 34 42 51
16 Niort Niort 42 48 50 50
17 Épinal Épinal 42 42 46 48
18 Charleville Charleville 42 34 54 48
19 Stade Poitevin Stade 42 36 48 46
20 Dunkerque Dunkerque 42 30 43 43
21 Angers SCO Angers SCO 42 31 53 37
22 Olympique Alès Olympique 42 29 72 25

  USO DE MEMORIA  
8,228,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5978
Total Execution Time  0.5990
  CADENA URL  
/historico/Dunkerque
  GET DATOS  
$_GET['/historico/Dunkerque']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0119  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 = 'Dunkerque' 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.0106  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=6674 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=6674 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=6674 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=6674 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6674 AND type_rel = 2
0.0106  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6674 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0108  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 (769348,785807,1086807) ORDER BY n.cover_points DESC, update_date DESC
0.0113  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 = '6674' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0114  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 = '6674' 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 = 72082 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110  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=6674 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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,72082,71432,68050) 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 = 72082 AND teamId = 6674
0.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 68050 AND teamId = 6674
0.0116  SELECT count(id) as num_players from rel_players WHERE league_id = 74470 AND teamId = 6674
0.0111  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6674
0.0214  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 = 72082 AND t.round = 36 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0108  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 = '6674' 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 = '6674' and rp.type = 4
0.0107  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 = '6674' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0122  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 = 72082 WHERE rp.league_id = 72082 AND rp.teamId = 6674 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 = 72082 WHERE rp.league_id = 72082 AND rp.teamId = 6674 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0115  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 = 72082 WHERE rp.league_id = 72082 AND rp.teamId = 6674 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0112  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 = 6674 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68050 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `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 = 62747 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.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 `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 = 56826 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.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 `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 = 50111 AND t.round = 25 ORDER BY team.conference ASC,t.position 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 `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 = 44443 AND t.round = 34 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 `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 = 38779 AND t.round = 34 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 `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.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 `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.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 `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.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 `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 = 2534 AND t.round = 34 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 `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 = 2097 AND t.round = 34 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 `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 = 1679 AND t.round = 34 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 `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 = 19995 AND t.round = 30 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 `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.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 `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 = 19931 AND t.round = 34 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 `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 = 19935 AND t.round = 34 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 `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.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 `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