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

US Boulogne

Entrenador: Christophe Raymond

Temporada 2023/2024
TEMPORADA 2023/2024
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 US Boulogne US Boulogne 24 46 22 51
2 Chambly Chambly 24 38 21 42
3 Granville Granville 24 32 29 40
4 Saint-Malo Saint-Malo 24 32 21 38
5 Stade Briochin Stade 24 30 24 36
6 Dinan-Léhon Dinan-Léhon 24 38 42 34
7 Beauvais Oise Beauvais 24 31 28 33
8 Aubervilliers Aubervillier 24 28 37 33
9 Voltigeurs Châteaubriant Voltigeurs 24 27 31 30
10 Racing Paris Racing Paris 24 24 32 28
11 Lorient II Lorient II 24 31 36 28
12 AF Virois AF Virois 24 31 34 27
13 Bastia-Borgo Bastia-Borgo 24 31 43 27
14 Guingamp II Guingamp II 24 26 45 20
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
Equipo PJ GF GC Puntos
1 Stade Lavallois Stade 34 50 31 67
2 Annecy Annecy 34 55 30 66
3 Villefranche Villefranche 34 47 29 65
4 Concarneau Concarneau 34 48 31 58
5 Chateauroux Chateauroux 34 41 28 55
6 Bourg-Péronnas Bourg-Péron 34 55 37 54
7 Stade Briochin Stade 34 47 35 52
8 CS Sedan CS Sedan 34 37 37 50
9 Orléans Orléans 34 37 35 47
10 Le Mans Le Mans 34 35 35 46
11 Red Star Red Star 34 55 50 44
12 Avranches Avranches 34 37 58 42
13 Cholet Cholet 34 49 62 41
14 Sète Sète 34 35 42 37
15 Bastia-Borgo Bastia-Borgo 34 40 58 31
16 Chambly Chambly 34 35 62 29
17 US Boulogne US Boulogne 34 28 48 26
18 Creteil Creteil 34 35 58 26
TEMPORADA 2020/2021
NATIONAL
Equipo PJ GF GC Puntos
1 Bastia Bastia 34 57 28 66
2 QRM QRM 34 48 31 58
3 Villefranche Villefranche 34 40 29 55
4 Le Mans Le Mans 34 46 36 52
5 Concarneau Concarneau 34 38 32 48
6 Red Star Red Star 34 39 33 47
7 Orléans Orléans 34 49 41 47
8 Sète Sète 34 31 32 43
9 Cholet Cholet 34 36 48 43
10 Stade Briochin Stade 34 32 33 43
11 Bourg-Péronnas Bourg-Péron 34 29 33 43
12 Stade Lavallois Stade 34 33 32 42
13 Avranches Avranches 34 36 42 41
14 Annecy Annecy 34 42 47 40
15 US Boulogne US Boulogne 34 29 38 38
16 Bastia-Borgo Bastia-Borgo 34 37 49 35
17 Creteil Creteil 34 29 48 35
18 Lyon-Duchère Lyon-Duchèr 34 33 52 31
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
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
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 1
Equipo PJ GF GC Puntos
1 Olympique Marseille Olympique 38 69 36 78
2 Olympique Lyonnais Olympique 38 64 38 72
3 Auxerre Auxerre 38 42 29 71
4 Lille Lille 38 72 40 70
5 Montpellier Montpellier 38 50 40 69
6 Girondins Bordeaux Girondins 38 58 40 64
7 Lorient Lorient 38 54 42 58
8 Monaco Monaco 38 39 45 55
9 Stade Rennais Stade 38 52 41 53
10 Valenciennes Valenciennes 38 50 50 52
11 Lens Lens 38 40 44 48
12 Nancy Nancy 38 46 53 48
13 PSG PSG 38 50 46 47
14 Toulouse Toulouse 38 36 36 47
15 Nice Nice 38 41 57 44
16 Sochaux Sochaux 38 28 52 41
17 Saint-Étienne Saint-Étien 38 27 45 40
18 Le Mans Le Mans 38 36 59 32
19 US Boulogne US Boulogne 38 31 62 31
20 Grenoble Grenoble 38 31 61 23
TEMPORADA 2008/2009
LIGUE 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
NATIONAL
Equipo PJ GF GC Puntos
1 Clermont Clermont 38 76 42 82
2 US Boulogne US Boulogne 38 61 35 75
3 Angers SCO Angers SCO 38 53 29 71
4 Stade Lavallois Stade 38 59 39 66
5 Nîmes Nîmes 38 52 43 62
6 Paris FC Paris FC 38 48 34 59
7 Sète Sète 38 46 47 57
8 CS Louhans Cuiseaux Louhans 38 49 49 56
9 Beauvais Oise Beauvais 38 50 53 50
10 Romorantin Romorantin 38 49 60 48
11 Cannes Cannes 38 43 52 45
12 Vannes Vannes 38 42 55 45
13 L Entente L Entente 38 43 46 43
14 Cherbourg Cherbourg 38 40 50 42
15 FC Martigues Martigues 38 24 35 42
16 Pau FC Pau FC 38 46 57 41
17 Sporting Toulon Var Sporting 38 37 45 39
18 Raon-l'Etape Raon-l'Etape 38 40 47 38
19 Chatellerault Chatelleraul 38 34 46 38
20 Yzeure Yzeure 38 44 72 29
TEMPORADA 2005/2006
NATIONAL
Equipo PJ GF GC Puntos
1 Niort Niort 38 57 36 70
2 Tours Tours 38 49 35 65
3 FC Libourne FC Libourne 38 46 29 64
4 Cannes Cannes 38 48 41 62
5 Nîmes Nîmes 38 50 39 58
6 US Boulogne US Boulogne 38 48 41 58
7 Sporting Toulon Var Sporting 38 35 32 57
8 Raon-l'Etape Raon-l'Etape 38 42 37 50
9 L Entente L Entente 38 39 34 50
10 Romorantin Romorantin 38 39 46 50
11 Angers SCO Angers SCO 38 42 35 49
12 Vannes Vannes 38 44 45 49
13 CS Louhans Cuiseaux Louhans 38 42 51 48
14 Cherbourg Cherbourg 38 34 39 46
15 Pau FC Pau FC 38 34 38 45
16 Chatellerault Chatelleraul 38 37 47 42
17 Bayonne Bayonne 38 34 41 41
18 Croix Savoi Croix Savoi 38 28 40 41
19 Moulins Moulins 38 44 61 41
20 GFCO Ajaccio GFCO Ajaccio 38 27 52 29
TEMPORADA 2001/2002
NATIONAL
Equipo PJ GF GC Puntos
1 Clermont Clermont 38 52 28 77
2 Toulouse Toulouse 38 54 20 74
3 Valence Valence 38 58 33 74
4 Stade de Reims Stade Reims 38 50 23 73
5 Cannes Cannes 38 47 28 69
6 Angouleme Angouleme 38 51 36 69
7 CS Louhans Cuiseaux Louhans 38 43 33 55
8 Angers SCO Angers SCO 38 37 34 48
9 Besancon RC Besancon RC 38 34 42 47
10 La Roche VF La Roche VF 38 40 51 47
11 Racing Paris Racing Paris 38 41 40 46
12 Sète Sète 38 35 47 45
13 Stade Brestois Stade 38 40 43 44
14 Dijon FCO Dijon FCO 38 40 53 42
15 Pau FC Pau FC 38 32 47 42
16 US Boulogne US Boulogne 38 31 44 41
17 St. Maur Lusi Maur Lusi 38 32 49 37
18 Noisy-le-Sec Noisy-le-Sec 38 28 55 31
19 Calais Calais 38 23 57 19

  USO DE MEMORIA  
8,112,152 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6672
Total Execution Time  0.6684
  CADENA URL  
/historico/Us-Boulogne
  GET DATOS  
$_GET['/historico/Us-Boulogne']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0137  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 = 'Us-Boulogne' 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.0109  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=2623 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112  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=2623 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112  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=2623 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0113  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2623 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0239  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 = 72964
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2623 AND type_rel = 2
0.0115  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2623 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0112  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 (357995) ORDER BY n.cover_points DESC, update_date DESC
0.0137  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 = '2623' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0139  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 = '2623' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0117  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 = 72964 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0139  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=2623 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0115  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,72964,71432) 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.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 72964 AND teamId = 2623
0.0167  SELECT count(id) as num_players from rel_players WHERE league_id = 74470 AND teamId = 2623
0.0155  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2623
0.0124  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 = 72964 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0117  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 = '2623' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0110  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2623' and rp.type = 4
0.0117  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 = '2623' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0171  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 = 72964 WHERE rp.league_id = 72964 AND rp.teamId = 2623 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.0169  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 = 72964 WHERE rp.league_id = 72964 AND rp.teamId = 2623 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72964 WHERE rp.league_id = 72964 AND rp.teamId = 2623 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139  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 = 2623 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0125  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 = 72964 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 63266 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.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 57035 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.0125  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.0125  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.0141  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.0124  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.0126  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0132  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.0115  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0115  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0115  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0118  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.0122  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 = 544 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 545 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 595 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118  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 = 72964 ORDER BY nameShow LIMIT 100