Escudo del Chateauroux

Chateauroux

Entrenador: Olivier Saragaglia

Temporada 2023/2024
TEMPORADA 2023/2024
NATIONAL
Equipo PJ GF GC Puntos
1 Red Star Red Star 29 49 25 62
2 Niort Niort 29 49 32 52
3 FC Martigues Martigues 29 34 22 49
4 Nancy Nancy 29 40 33 44
5 Le Mans Le Mans 29 37 34 44
6 FC Rouen 1899 Rouen 1899 29 33 24 43
7 Dijon FCO Dijon FCO 29 37 39 41
8 Sochaux Sochaux 29 44 37 40
9 Versailles Versailles 29 37 30 39
10 Orléans Orléans 29 33 34 38
11 Chateauroux Chateauroux 29 35 36 36
12 Villefranche Villefranche 29 31 38 34
13 Marignane Gignac Marignane 29 32 41 34
14 Nîmes Nîmes 29 28 39 32
15 GOAL FC GOAL FC 29 37 41 31
16 Épinal Épinal 29 32 43 29
17 Avranches Avranches 29 32 53 29
18 Cholet Cholet 29 26 45 27
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
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
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
LIGUE 2
Equipo PJ GF GC Puntos
1 Lorient Lorient 28 45 25 54
2 Lens Lens 28 39 24 53
3 Ajaccio Ajaccio 28 38 22 52
4 Troyes Troyes 28 34 25 51
5 Clermont Clermont 28 35 25 50
6 Le Havre Le Havre 28 38 25 44
7 Valenciennes Valenciennes 28 24 20 42
8 Guingamp Guingamp 28 40 33 39
9 Grenoble Grenoble 28 27 29 35
10 Chambly Chambly 28 26 32 35
11 Auxerre Auxerre 28 31 30 34
12 Nancy Nancy 28 27 26 34
13 Caen Caen 28 33 34 34
14 Sochaux Sochaux 28 28 30 34
15 Chateauroux Chateauroux 28 22 38 34
16 Rodez Rodez 28 31 34 32
17 Paris FC Paris FC 28 22 40 28
18 Niort Niort 28 30 41 26
19 Le Mans Le Mans 28 30 45 26
20 Orléans Orléans 28 21 43 19
TEMPORADA 2018/2019
LIGUE 2
Equipo PJ GF GC Puntos
1 Metz Metz 38 60 23 81
2 Stade Brestois Stade 38 64 35 74
3 Troyes Troyes 38 51 28 71
4 Paris FC Paris FC 38 36 22 65
5 Lens Lens 38 49 28 63
6 Lorient Lorient 38 51 41 63
7 Le Havre Le Havre 38 45 40 54
8 Orléans Orléans 38 51 53 52
9 Grenoble Grenoble 38 43 47 50
10 Clermont Clermont 38 44 37 48
11 Chateauroux Chateauroux 38 37 42 48
12 Niort Niort 38 34 41 47
13 Valenciennes Valenciennes 38 52 61 43
14 Nancy Nancy 38 36 50 42
15 Auxerre Auxerre 38 34 36 41
16 Sochaux Sochaux 38 27 43 41
17 Ajaccio Ajaccio 38 29 45 40
18 Gazélec Ajaccio Gazélec 38 30 54 39
19 Béziers Béziers 38 33 50 38
20 Red Star Red Star 38 28 58 30
TEMPORADA 2017/2018
LIGUE 2
Equipo PJ GF GC Puntos
1 Stade de Reims Stade Reims 38 74 24 88
2 Nîmes Nîmes 38 75 37 73
3 Ajaccio Ajaccio 38 62 43 68
4 Le Havre Le Havre 38 53 34 66
5 Stade Brestois Stade 38 58 43 65
6 Clermont Clermont 38 54 36 63
7 Lorient Lorient 38 61 46 62
8 Paris FC Paris FC 38 46 36 61
9 Chateauroux Chateauroux 38 50 50 60
10 Sochaux Sochaux 38 51 62 53
11 Auxerre Auxerre 38 51 55 47
12 Orléans Orléans 38 52 61 46
13 Valenciennes Valenciennes 38 50 64 45
14 Lens Lens 38 48 49 43
15 Niort Niort 38 47 60 42
16 Gazélec Ajaccio Gazélec 38 35 60 41
17 Nancy Nancy 38 39 54 38
18 Bourg-Péronnas Bourg-Péron 38 50 87 36
19 QRM QRM 38 45 66 33
20 Tours Tours 38 34 68 23
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
LIGUE 2
Equipo PJ GF GC Puntos
1 Troyes Troyes 38 61 24 78
2 Gazélec Ajaccio Gazélec 38 49 37 65
3 Angers SCO Angers SCO 38 47 30 64
4 Dijon FCO Dijon FCO 38 44 34 61
5 Nancy Nancy 38 53 39 58
6 Stade Brestois Stade 38 41 27 57
7 Le Havre Le Havre 38 47 37 55
8 Stade Lavallois Stade 38 41 34 54
9 Auxerre Auxerre 38 48 42 52
10 Sochaux Sochaux 38 39 37 52
11 Niort Niort 38 41 42 50
12 Clermont Clermont 38 43 47 49
13 Nîmes Nîmes 38 44 57 46
14 Creteil Creteil 38 44 52 45
15 Tours Tours 38 49 54 44
16 Valenciennes Valenciennes 38 34 51 42
17 Ajaccio Ajaccio 38 32 42 41
18 Orléans Orléans 38 36 47 40
19 Chateauroux Chateauroux 38 31 63 32
20 Arles Arles 38 31 59 30
TEMPORADA 2013/2014
LIGUE 2
Equipo PJ GF GC Puntos
1 Metz Metz 38 55 28 76
2 Lens Lens 38 58 40 65
3 Caen Caen 38 65 44 64
4 Nancy Nancy 38 47 37 61
5 Niort Niort 38 51 47 58
6 Dijon FCO Dijon FCO 38 53 42 57
7 Stade Brestois Stade 38 38 32 56
8 Tours Tours 38 63 56 55
9 Angers SCO Angers SCO 38 46 45 55
10 Troyes Troyes 38 56 44 52
11 Creteil Creteil 38 57 58 50
12 Le Havre Le Havre 38 43 43 48
13 Arles Arles 38 36 38 46
14 Clermont Clermont 38 31 38 45
15 Nîmes Nîmes 38 49 54 44
16 Auxerre Auxerre 38 35 45 43
17 Stade Lavallois Stade 38 44 52 42
18 Chateauroux Chateauroux 38 43 59 40
19 Istres Istres 38 48 74 36
20 CA Bastia CA Bastia 38 21 63 24
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 2
Equipo PJ GF GC Puntos
1 Metz Metz 38 54 22 76
2 Caen Caen 38 65 40 71
3 Strasbourg Strasbourg 38 47 33 70
4 Amiens SC Amiens SC 38 57 42 69
5 Grenoble Grenoble 38 51 39 59
6 Le Havre Le Havre 38 52 38 56
7 Chateauroux Chateauroux 38 42 43 54
8 Dijon FCO Dijon FCO 38 44 47 54
9 Bastia Bastia 38 52 49 53
10 FC Gueugnon FC Gueugnon 38 47 52 48
11 Stade de Reims Stade Reims 38 43 46 47
12 Ajaccio Ajaccio 38 44 50 47
13 Guingamp Guingamp 38 45 44 46
14 Stade Brestois Stade 38 40 40 45
15 Montpellier Montpellier 38 41 48 44
16 Niort Niort 38 36 44 44
17 FC Libourne FC Libourne 38 43 52 44
18 Creteil Creteil 38 33 50 40
19 Istres Istres 38 35 63 35
20 Tours Tours 38 29 58 26
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

  USO DE MEMORIA  
8,447,000 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5301
Total Execution Time  0.5313
  CADENA URL  
/historico/Berrichonne-Chateauroux
  GET DATOS  
$_GET['/historico/Berrichonne-Chateauroux']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=482 AND type_rel = 2
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 482 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 (879,8821,81910,84920,110523) ORDER BY n.cover_points DESC, update_date DESC
0.0117  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 = '482' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0115  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 = 74470 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110  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.0119  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=482 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0107  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) 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.0119  SELECT count(id) as num_players from rel_players WHERE league_id = 72083 AND teamId = 482
0.0165  SELECT count(id) as num_players from rel_players WHERE league_id = 74470 AND teamId = 482
0.0171  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 482
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 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 = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = 72083 WHERE rp.league_id = 72083 AND rp.teamId = 482 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.0133  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 = 482 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0119  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 = 482 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0114  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 = 482 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0109  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 = 30 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 `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.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 `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.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 `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.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 `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 = 49879 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 `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 = 43687 AND t.round = 38 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 = 38663 AND t.round = 38 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 `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.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 `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 = 3823 AND t.round = 38 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 `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 = 2447 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 `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.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 `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.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 = 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.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 `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.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 `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.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 `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.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 `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 = 518 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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.0109  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