4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Raon-l'Etape
TEMPORADA 2023/2024
NATIONAL 3 GRUPO 9
Equipo PJ GF GC Puntos
1 US Thionville Lusitanos Thionville 24 47 23 50
2 Troyes II Troyes II 24 44 36 44
3 Stade de Reims II Stade Reims 24 55 37 42
4 Thaon Thaon 24 37 27 39
5 Sarre-Union Sarre-Union 24 44 40 34
6 Strasbourg Koenigshoffen Strasbourg 24 29 30 33
7 Reims Sainte-Anne Reims 24 27 29 33
8 Metz II Metz II 24 39 34 32
9 Nancy II Nancy II 24 32 30 32
10 Prix lès Mézières Prix lès Mé. 23 29 31 31
11 Raon-l'Etape Raon-l'Etape 24 33 44 31
12 Belfort Belfort 23 31 42 27
13 Strasbourg II Strasbourg 24 32 42 24
14 Métropole Troyenne Métropole 24 20 54 12
TEMPORADA 2022/2023
NATIONAL 3 GRUPO 5
Equipo PJ GF GC Puntos
1 Biesheim Biesheim 26 54 21 55
2 Troyes II Troyes II 26 44 27 48
3 Raon-l'Etape Raon-l'Etape 25 55 29 47
4 Prix lès Mézières Prix lès Mé. 26 44 30 46
5 Thaon Thaon 26 41 30 45
6 Sarre-Union Sarre-Union 26 55 35 44
7 Strasbourg II Strasbourg 26 54 39 44
8 Nancy II Nancy II 26 33 31 40
9 Reims Sainte-Anne Reims 26 57 37 38
10 Schiltigheim Schiltigheim 26 55 52 34
11 RC Épernay Champagne Épernay 26 35 41 27
12 Champigneulles Champigneull 26 20 57 16
13 Illkirch Graffenstaden Illkirch 25 16 63 10
14 Jarville Jarville 26 18 89 6
TEMPORADA 2021/2022
NATIONAL 3 GRUPO 6
Equipo PJ GF GC Puntos
1 Colmar Colmar 26 49 20 59
2 Raon-l'Etape Raon-l'Etape 26 47 27 48
3 Troyes II Troyes II 26 54 36 48
4 Sarre-Union Sarre-Union 26 47 33 42
5 Strasbourg II Strasbourg 26 35 28 39
6 Biesheim Biesheim 26 34 41 37
7 FC Mulhouse FC Mulhouse 26 45 38 35
8 Nancy II Nancy II 26 47 36 35
9 Thaon Thaon 26 41 40 35
10 Prix lès Mézières Prix lès Mé. 26 27 38 32
11 RC Épernay Champagne Épernay 26 31 39 31
12 Illkirch Graffenstaden Illkirch 26 34 48 24
13 Saint-Louis Neuweg Saint-Louis 26 30 47 22
14 Amnéville Amnéville 26 18 68 7
TEMPORADA 2020/2021
NATIONAL 3 GRUPO 8
Equipo PJ GF GC Puntos
1 Biesheim Biesheim 7 16 5 17
2 Thaon Thaon 7 14 6 16
3 Colmar Colmar 7 13 10 11
4 Sarre-Union Sarre-Union 6 12 10 10
5 FC Mulhouse FC Mulhouse 6 9 8 10
6 Saint-Louis Neuweg Saint-Louis 7 12 12 9
7 Nancy II Nancy II 7 9 15 9
8 RC Épernay Champagne Épernay 6 7 6 7
9 Prix lès Mézières Prix lès Mé. 7 9 11 7
10 Illkirch Graffenstaden Illkirch 6 7 12 7
11 Raon-l'Etape Raon-l'Etape 7 5 11 7
12 Strasbourg II Strasbourg 6 9 10 6
13 Troyes II Troyes II 6 5 6 6
14 Amnéville Amnéville 7 6 11 5
TEMPORADA 2019/2020
NATIONAL 3 GRUPO 6
Equipo PJ GF GC Puntos
1 Sarre-Union Sarre-Union 15 25 16 29
2 Metz II Metz II 15 27 16 28
3 Thaon Thaon 14 28 19 23
4 Strasbourg II Strasbourg 15 16 17 22
5 Raon-l'Etape Raon-l'Etape 14 19 18 22
6 Troyes II Troyes II 15 26 21 21
7 Prix lès Mézières Prix lès Mé. 15 16 15 21
8 Saint-Louis Neuweg Saint-Louis 15 16 20 19
9 Biesheim Biesheim 15 24 24 18
10 Illkirch Graffenstaden Illkirch 15 19 20 17
11 Métropole Troyenne Métropole 14 16 18 17
12 Vauban Strasbourg Vauban 14 25 27 16
13 Amnéville Amnéville 15 20 27 14
14 Sarreguemines Sarreguemine 15 21 40 13
TEMPORADA 2018/2019
NATIONAL 3 GRUPO 6
Equipo PJ GF GC Puntos
1 FC Mulhouse FC Mulhouse 26 40 21 48
2 Strasbourg II Strasbourg 26 48 32 47
3 Sarre-Union Sarre-Union 26 37 28 43
4 Thaon Thaon 26 42 40 38
5 Troyes II Troyes II 26 38 26 36
6 Saint-Louis Neuweg Saint-Louis 26 32 34 35
7 FCA Troyes FCA Troyes 26 24 21 34
8 Vauban Strasbourg Vauban 26 34 41 33
9 Biesheim Biesheim 26 32 38 33
10 Raon-l'Etape Raon-l'Etape 26 38 44 33
11 Amnéville Amnéville 26 36 41 32
12 Sarreguemines Sarreguemine 26 44 48 31
13 Nancy II Nancy II 26 31 43 29
14 RC Épernay Champagne Épernay 26 28 47 20
TEMPORADA 2017/2018
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Villefranche Villefranche 30 50 32 58
2 Annecy Annecy 30 51 33 57
3 Andrézieux Andrézieux 30 48 36 52
4 Jura Sud Jura Sud 30 49 41 51
5 Schiltigheim Schiltigheim 30 47 35 50
6 Yzeure Yzeure 30 33 29 46
7 Épinal Épinal 30 42 36 41
8 PSG II PSG II 30 42 39 40
9 Belfort Belfort 30 43 42 39
10 Le Puy Le Puy 30 35 35 39
11 Olympique Lyonnais II Olympique 30 42 45 37
12 GOAL FC GOAL FC 30 34 39 37
13 Saint-Priest Saint-Priest 30 35 43 35
14 Saint-Louis Neuweg Saint-Louis 30 28 43 34
15 Montceau Montceau 30 34 44 33
16 Raon-l'Etape Raon-l'Etape 30 23 64 13
TEMPORADA 2016/2017
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Grenoble Grenoble 28 47 15 66
2 Le Puy Le Puy 28 40 15 57
3 Annecy Annecy 28 50 32 50
4 Olympique Lyonnais II Olympique 28 54 44 46
5 Jura Sud Jura Sud 28 44 38 44
6 Villefranche Villefranche 28 34 34 40
7 Stade de Reims II Stade Reims 28 43 41 36
8 Andrézieux Andrézieux 28 37 44 33
9 Raon-l'Etape Raon-l'Etape 28 37 49 32
10 GOAL FC GOAL FC 28 29 37 31
11 Saint-Louis Neuweg Saint-Louis 28 30 44 31
12 Yzeure Yzeure 28 28 38 29
13 Montceau Montceau 28 35 48 28
14 FC Mulhouse FC Mulhouse 28 30 43 26
15 Auxerre II Auxerre II 28 35 51 25
16 Evian Thonon Gaillard Evian Thonon 0 0 0 0
TEMPORADA 2015/2016
NATIONAL 3 GRUPO 6
Equipo PJ GF GC Puntos
1 Stade de Reims II Stade Reims 26 66 26 56
2 Raon-l'Etape Raon-l'Etape 26 60 37 46
3 Sarreguemines Sarreguemine 26 42 37 44
4 Nancy II Nancy II 26 46 40 40
5 Metz II Metz II 26 59 54 40
6 Schiltigheim Schiltigheim 26 37 33 36
7 Illzach Modenheim Illzach 26 41 44 35
8 Strasbourg II Strasbourg 26 46 46 34
9 FCSR Haguenau FCSR 26 34 35 33
10 Pagny Sur Moselle Pagny 26 26 38 33
11 Forbach Forbach 26 35 44 31
12 Biesheim Biesheim 26 38 50 28
13 RC Épernay Champagne Épernay 26 31 44 24
14 Thaon Thaon 26 25 58 17
TEMPORADA 2014/2015
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Belfort Belfort 30 51 30 61
2 US Fleury-Merogis Fleury-Merog 30 38 25 51
3 FC Mulhouse FC Mulhouse 30 45 32 48
4 Montceau Montceau 30 41 38 45
5 Sarre-Union Sarre-Union 30 47 42 44
6 Moulins Moulins 30 35 30 44
7 Aubervilliers Aubervillier 30 29 35 43
8 Jura Sud Jura Sud 30 40 42 40
9 Drancy Drancy 30 40 43 36
10 Troyes II Troyes II 30 34 43 35
11 Yzeure Yzeure 30 24 29 34
12 V.Châtillon V.Châtillon 30 24 32 34
13 Sochaux II Sochaux II 30 38 43 33
14 Metz II Metz II 30 29 35 33
15 Raon-l'Etape Raon-l'Etape 30 37 44 32
16 Saint-Étienne II Saint-Étien 30 33 42 31
TEMPORADA 2013/2014
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Épinal Épinal 30 56 37 55
2 Moulins Moulins 30 51 35 52
3 Yzeure Yzeure 30 43 31 48
4 Olympique Lyonnais II Olympique 30 53 45 47
5 FC Mulhouse FC Mulhouse 30 36 38 45
6 Lyon-Duchère Lyon-Duchèr 30 40 37 43
7 Belfort Belfort 30 32 32 42
8 Raon-l'Etape Raon-l'Etape 30 45 49 42
9 Sarre-Union Sarre-Union 30 48 48 40
10 Sochaux II Sochaux II 30 37 40 40
11 Villefranche Villefranche 30 34 32 38
12 GOAL FC GOAL FC 30 33 39 38
13 Saint-Priest Saint-Priest 30 28 45 38
14 Montceau Montceau 30 37 48 36
15 Jura Sud Jura Sud 30 45 44 35
16 Vesoul Vesoul 30 26 44 25
TEMPORADA 2012/2013
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Grenoble Grenoble 34 63 30 62
2 Raon-l'Etape Raon-l'Etape 34 53 31 62
3 Strasbourg Strasbourg 34 47 29 62
4 Lyon-Duchère Lyon-Duchèr 34 49 39 55
5 Moulins Moulins 34 51 36 54
6 FC Mulhouse FC Mulhouse 34 46 39 53
7 Villefranche Villefranche 34 44 42 47
8 PSG II PSG II 34 44 49 44
9 Yzeure Yzeure 34 37 35 43
10 Jura Sud Jura Sud 34 31 38 43
11 Sochaux II Sochaux II 34 30 34 40
12 Sarre-Union Sarre-Union 34 28 52 40
13 Belfort Belfort 34 31 37 38
14 Montceau Montceau 34 30 43 38
15 GOAL FC GOAL FC 34 37 47 37
16 Auxerre II Auxerre II 34 29 52 37
17 UJA Maccabi UJA Maccabi 34 25 33 35
18 Nancy II Nancy II 34 42 51 33
TEMPORADA 2011/2012
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Olympique Lyonnais II Olympique 32 71 34 66
2 Bourg-Péronnas Bourg-Péron 32 56 26 62
3 Lyon-Duchère Lyon-Duchèr 32 57 33 61
4 Raon-l'Etape Raon-l'Etape 32 50 30 53
5 Metz II Metz II 32 58 40 47
6 Valence Valence 32 40 31 47
7 Yzeure Yzeure 32 42 36 45
8 FC Mulhouse FC Mulhouse 32 44 40 43
9 Moulins Moulins 32 31 30 43
10 Nancy II Nancy II 32 34 42 42
11 Belfort Belfort 32 38 42 39
12 Villefranche Villefranche 32 28 51 37
13 Sochaux II Sochaux II 32 40 44 35
14 GOAL FC GOAL FC 32 28 49 34
15 Amnéville Amnéville 32 50 61 33
16 Sarre-Union Sarre-Union 32 33 69 27
17 Jura Sud Jura Sud 32 31 73 19
TEMPORADA 2010/2011
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Besancon RC Besancon RC 32 41 22 64
2 Épinal Épinal 32 51 22 61
3 Ivry Ivry 32 53 31 56
4 Sochaux II Sochaux II 32 49 36 53
5 Villefranche Villefranche 32 45 34 50
6 Amnéville Amnéville 32 50 45 49
7 Bourg-Péronnas Bourg-Péron 32 50 48 47
8 PSG II PSG II 32 55 41 46
9 Auxerre II Auxerre II 32 41 32 44
10 Jura Sud Jura Sud 32 35 42 44
11 Nancy II Nancy II 32 48 40 43
12 FC Mulhouse FC Mulhouse 32 45 44 41
13 Belfort Belfort 32 35 35 38
14 Raon-l'Etape Raon-l'Etape 32 39 49 37
15 Lyon-Duchère Lyon-Duchèr 32 40 51 35
16 GOAL FC GOAL FC 32 34 68 22
17 CS Louhans Cuiseaux Louhans 32 13 84 7
TEMPORADA 2009/2010
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Colmar Colmar 36 55 33 69
2 UJA Maccabi UJA Maccabi 36 56 37 67
3 Villemomble Sports Villemomble 36 45 33 61
4 Besancon RC Besancon RC 36 59 48 56
5 Amnéville Amnéville 36 58 55 53
6 Drancy Drancy 36 49 51 52
7 Noisy-le-Sec Noisy-le-Sec 36 52 46 50
8 Nancy II Nancy II 36 47 46 50
9 Épinal Épinal 36 45 46 50
10 Lille II Lille II 36 55 47 49
11 Compiègne Compiègne 36 42 40 48
12 Raon-l'Etape Raon-l'Etape 36 47 48 45
13 Sannois Gratien Sannois 36 47 50 45
14 FC Mulhouse FC Mulhouse 36 41 48 45
15 Lens II Lens II 36 40 42 44
16 Vesoul Vesoul 36 29 45 38
17 Dunkerque Dunkerque 36 45 53 37
18 Marck Marck 36 43 57 37
19 Strasbourg II Strasbourg 36 28 58 24
TEMPORADA 2008/2009
NATIONAL 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 2
Equipo PJ GF GC Puntos
1 Evian Thonon Gaillard Evian Thonon 34 52 17 74
2 Besancon RC Besancon RC 34 61 20 68
3 Vesoul Vesoul 34 61 42 61
4 Sochaux II Sochaux II 34 65 45 60
5 Saint-Priest Saint-Priest 34 50 38 53
6 Olympique Lyonnais II Olympique 34 45 32 49
7 Montceau Montceau 34 36 33 48
8 Auxerre II Auxerre II 34 52 48 45
9 Strasbourg II Strasbourg 34 42 43 45
10 Red Star Red Star 34 38 40 40
11 Jura Sud Jura Sud 34 31 37 38
12 FC Mulhouse FC Mulhouse 34 31 55 38
13 Raon-l'Etape Raon-l'Etape 33 36 57 37
14 Metz II Metz II 33 35 45 36
15 Nancy II Nancy II 34 28 36 34
16 Épinal Épinal 34 33 49 34
17 Belfort Belfort 34 30 50 32
18 RC Épernay Champagne Épernay 34 25 64 26
TEMPORADA 2006/2007
NATIONAL
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 2004/2005
NATIONAL
Equipo PJ GF GC Puntos
1 Valenciennes Valenciennes 38 52 28 74
2 Valence Valence 38 49 35 67
3 Sète Sète 38 53 35 65
4 L Entente L Entente 38 61 45 63
5 Nîmes Nîmes 38 44 37 56
6 Racing Paris Racing Paris 38 33 37 56
7 GFCO Ajaccio GFCO Ajaccio 38 43 37 55
8 Tours Tours 38 39 39 55
9 Cherbourg Cherbourg 38 40 35 49
10 Pau FC Pau FC 38 40 40 49
11 Bayonne Bayonne 38 45 52 48
12 FC Libourne FC Libourne 38 36 33 47
13 Cannes Cannes 38 42 42 47
14 Romorantin Romorantin 38 42 42 46
15 Croix Savoi Croix Savoi 38 31 46 46
16 Raon-l'Etape Raon-l'Etape 38 35 46 45
17 Besancon RC Besancon RC 38 40 47 44
18 ES Wasquehal Wasquehal 38 30 39 40
19 FC Rouen 1899 Rouen 1899 38 30 47 38
20 Roye-Noyon Roye-Noyon 38 32 55 34

  USO DE MEMORIA  
7,402,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1338
Total Execution Time  0.1350
  CADENA URL  
/historico/Raon-L-Etape
  GET DATOS  
$_GET['/historico/Raon-L-Etape']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0029  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 = 'Raon-L-Etape' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2875 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2875 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2875 AND type_rel = 2
0.0024  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 = '2875' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '2875' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '2875' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73252 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=2875 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (73252,70208) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 73252 AND teamId = 2875
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 70208 AND teamId = 2875
0.0021  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 = 73252 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '2875' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2875' and rp.type = 4
0.0020  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '2875' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031  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 = 73252 WHERE rp.league_id = 73252 AND rp.teamId = 2875 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.0027  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 = 73252 WHERE rp.league_id = 73252 AND rp.teamId = 2875 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 73252 WHERE rp.league_id = 73252 AND rp.teamId = 2875 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 2875 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021  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 = 68299 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 63488 AND t.round = 26 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 `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 = 57539 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 50959 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 44565 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 39109 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 33907 AND t.round = 30 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 `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 = 15903 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 4378 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2537 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 `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 = 2098 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 1680 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 19924 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.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 `tables2008` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 19936 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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.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 `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.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 592 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC