4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGUE 2
Equipo PJ GF GC Puntos
1 Auxerre Auxerre 34 63 34 64
2 Saint-Étienne Saint-Étien 35 44 26 63
3 Angers SCO Angers SCO 35 52 38 62
4 Rodez Rodez 35 57 46 56
5 Paris FC Paris FC 35 44 38 53
6 Stade Lavallois Stade 35 38 42 52
7 Pau FC Pau FC 35 55 49 51
8 Caen Caen 35 45 43 51
9 Guingamp Guingamp 35 40 34 50
10 Amiens SC Amiens SC 35 31 34 46
11 Ajaccio Ajaccio 35 34 38 46
12 Bastia Bastia 35 39 44 46
13 Grenoble Grenoble 35 38 39 45
14 Girondins Bordeaux Girondins 35 41 46 44
15 Annecy Annecy 35 44 45 42
16 Dunkerque Dunkerque 34 31 46 41
17 Troyes Troyes 35 39 47 37
18 QRM QRM 35 47 50 35
19 Concarneau Concarneau 35 32 48 35
20 Valenciennes Valenciennes 35 23 50 23
TEMPORADA 2022/2023
LIGUE 2
Equipo PJ GF GC Puntos
1 Le Havre Le Havre 38 46 19 75
2 Metz Metz 38 61 33 72
3 Girondins Bordeaux Girondins 38 51 28 69
4 Bastia Bastia 38 52 45 60
5 Caen Caen 38 52 43 59
6 Guingamp Guingamp 38 51 46 55
7 Paris FC Paris FC 38 45 43 55
8 Saint-Étienne Saint-Étien 38 63 57 53
9 Sochaux Sochaux 38 54 41 52
10 Grenoble Grenoble 38 33 36 51
11 QRM QRM 38 47 49 50
12 Amiens SC Amiens SC 38 40 52 47
13 Pau FC Pau FC 38 40 52 47
14 Rodez Rodez 38 39 44 46
15 Stade Lavallois Stade 38 44 56 46
16 Valenciennes Valenciennes 38 42 49 45
17 Annecy Annecy 38 39 51 45
18 Dijon FCO Dijon FCO 38 38 43 42
19 Nîmes Nîmes 38 44 62 36
20 Niort Niort 38 35 67 29
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
LIGUE 2
Equipo PJ GF GC Puntos
1 Strasbourg Strasbourg 38 63 47 67
2 Amiens SC Amiens SC 38 56 38 66
3 Troyes Troyes 38 59 43 66
4 Lens Lens 38 59 40 65
5 Stade Brestois Stade 38 58 44 65
6 Nîmes Nîmes 38 58 40 64
7 Stade de Reims Stade Reims 38 42 39 55
8 Le Havre Le Havre 38 39 31 54
9 Gazélec Ajaccio Gazélec 38 47 51 51
10 Niort Niort 38 45 57 49
11 Ajaccio Ajaccio 38 47 58 48
12 Clermont Clermont 38 46 48 46
13 Sochaux Sochaux 38 38 43 46
14 Valenciennes Valenciennes 38 44 44 45
15 Bourg-Péronnas Bourg-Péron 38 49 58 44
16 Tours Tours 38 55 60 43
17 Auxerre Auxerre 38 28 40 43
18 Orléans Orléans 38 41 54 38
19 Red Star Red Star 38 36 56 36
20 Stade Lavallois Stade 38 33 52 30
TEMPORADA 2015/2016
LIGUE 2
Equipo PJ GF GC Puntos
1 Nancy Nancy 38 60 32 74
2 Dijon FCO Dijon FCO 38 62 36 70
3 Metz Metz 38 54 39 65
4 Le Havre Le Havre 38 52 37 65
5 Red Star Red Star 38 43 38 64
6 Lens Lens 38 39 35 58
7 Clermont Clermont 38 56 53 58
8 Auxerre Auxerre 38 47 46 55
9 Tours Tours 38 36 41 47
10 Stade Brestois Stade 38 34 41 47
11 Bourg-Péronnas Bourg-Péron 38 47 59 47
12 Valenciennes Valenciennes 38 39 43 44
13 Stade Lavallois Stade 38 35 42 44
14 Nîmes Nîmes 38 50 52 43
15 Sochaux Sochaux 38 34 36 42
16 Niort Niort 38 38 45 42
17 Ajaccio Ajaccio 38 34 42 42
18 Evian Thonon Gaillard Evian Thonon 38 41 41 39
19 Creteil Creteil 38 42 66 34
20 Paris FC Paris FC 38 32 51 30
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
NATIONAL
Equipo PJ GF GC Puntos
1 Istres Istres 38 55 24 75
2 Stade Lavallois Stade 38 52 31 71
3 Arles Arles 38 52 37 66
4 Cannes Cannes 38 46 33 61
5 Evian Thonon Gaillard Evian Thonon 38 51 43 57
6 Sète Sète 38 41 35 57
7 Paris FC Paris FC 38 46 43 55
8 Pacy Vallée-d.Eure Pacy 38 41 42 52
9 Creteil Creteil 38 38 28 49
10 CS Louhans Cuiseaux Louhans 38 38 48 49
11 FC Gueugnon FC Gueugnon 38 38 36 47
12 Beauvais Oise Beauvais 38 47 50 47
13 Rodez Rodez 38 40 39 46
14 Cassis-Carnoux Cassis-Carno 38 37 47 46
15 Bayonne Bayonne 38 21 31 46
16 FC Libourne FC Libourne 38 40 55 46
17 Niort Niort 38 31 37 41
18 Calais Calais 38 34 50 40
19 Sannois Gratien Sannois 38 29 48 36
20 Cherbourg Cherbourg 38 30 50 36
TEMPORADA 2007/2008
NATIONAL
Equipo PJ GF GC Puntos
1 Vannes Vannes 38 47 31 69
2 Tours Tours 38 53 31 65
3 Nîmes Nîmes 38 51 40 63
4 Cherbourg Cherbourg 38 47 37 61
5 Stade Lavallois Stade 38 51 31 58
6 Sète Sète 38 39 29 56
7 Creteil Creteil 38 47 35 51
8 Arles Arles 38 37 36 51
9 Beauvais Oise Beauvais 38 44 44 51
10 Paris FC Paris FC 38 52 53 50
11 Istres Istres 38 40 42 50
12 L Entente L Entente 38 46 52 50
13 Cannes Cannes 38 41 49 50
14 Rodez Rodez 38 42 49 48
15 Calais Calais 38 39 41 47
16 CS Louhans Cuiseaux Louhans 38 40 61 45
17 Villemomble Sports Villemomble 38 29 38 41
18 Pau FC Pau FC 38 39 61 41
19 FC Martigues Martigues 38 40 48 40
20 Romorantin Romorantin 38 31 47 37
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
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,485,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1807
Total Execution Time  0.1821
  CADENA URL  
/historico/Stade-Lavallois
  GET DATOS  
$_GET['/historico/Stade-Lavallois']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0040  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 = '2837' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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.0046  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=2837 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (74470,72082,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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 72082 AND teamId = 2837
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 74470 AND teamId = 2837
0.0158  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2837
0.0064  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 = 35 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0041  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 = 2837 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.0057  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 = 2837 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 = 2837 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 2837 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 35 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 = 67946 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.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 `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.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 `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.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 `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.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.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 `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 = 29229 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 `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 = 15084 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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.0035  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.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 `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.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 `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.0028  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.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 `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 = 886 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 543 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.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 `tables2006` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 519 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2005` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 520 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC