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

FC Martigues

Entrenador: Grégory Poirier

Temporada 2013/2014
TEMPORADA 2013/2014
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Athlético Marseille Athlético 29 48 26 50
2 Rodez Rodez 28 38 27 50
3 Grenoble Grenoble 28 41 26 46
4 Hyères Hyères 28 31 32 45
5 Pau FC Pau FC 29 33 27 44
6 Cannes Cannes 29 34 30 40
7 FC Martigues Martigues 28 30 29 37
8 Monaco II Monaco II 28 43 42 36
9 Béziers Béziers 28 35 32 35
10 Marignane Marignane 28 29 35 35
11 Nice II Nice II 29 34 41 34
12 US Le Pontet Pontet 28 23 36 33
13 Tarbes Tarbes 28 24 35 31
14 Valence Valence 28 26 34 30
15 Stade Montois Stade 28 29 46 24
TEMPORADA 2012/2013
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Colomiers Colomiers 34 42 17 65
2 Cannes Cannes 34 50 24 59
3 Hyères Hyères 34 39 27 57
4 FC Martigues Martigues 34 46 31 55
5 Olympique Lyonnais II Olympique 34 52 34 52
6 Marignane Marignane 34 40 34 49
7 Athlético Marseille Athlético 34 55 52 49
8 Rodez Rodez 34 38 50 48
9 Béziers Béziers 34 37 37 46
10 Monaco II Monaco II 34 46 40 45
11 US Le Pontet Pontet 34 46 47 44
12 Tarbes Tarbes 34 38 53 44
13 Valence Valence 34 35 44 42
14 Pau FC Pau FC 34 41 45 41
15 Albi Albi 34 41 57 35
16 Stade Montois Stade 34 42 61 35
17 Bayonne Bayonne 34 21 36 33
18 Saint-Étienne II Saint-Étien 34 24 44 25
TEMPORADA 2011/2012
NATIONAL
Equipo PJ GF GC Puntos
1 Nîmes Nîmes 38 65 38 68
2 Gazélec Ajaccio Gazélec 38 57 32 68
3 Niort Niort 38 61 33 67
4 Vannes Vannes 38 55 38 62
5 Épinal Épinal 38 61 47 62
6 FC Rouen 1899 Rouen 1899 38 48 46 60
7 Orléans Orléans 38 41 41 56
8 Colmar Colmar 38 54 44 55
9 Fréjus St-Raphaël Fréjus 38 50 58 51
10 Creteil Creteil 38 51 50 50
11 Red Star Red Star 38 44 52 50
12 Le Poiré-sur-Vie Poiré-sur-V 38 41 46 49
13 QRM QRM 38 45 54 47
14 Cherbourg Cherbourg 38 56 57 46
15 Luzenac Luzenac 38 47 56 45
16 Paris FC Paris FC 38 39 48 44
17 Beauvais Oise Beauvais 38 39 43 42
18 FC Martigues Martigues 38 43 69 39
19 Besancon RC Besancon RC 38 42 65 38
20 Bayonne Bayonne 38 38 60 34
TEMPORADA 2010/2011
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Gazélec Ajaccio Gazélec 34 51 32 68
2 FC Martigues Martigues 34 57 28 64
3 Pau FC Pau FC 34 56 33 61
4 Olympique Lyonnais II Olympique 34 53 41 53
5 Monaco II Monaco II 34 49 41 50
6 Sporting Toulon Var Sporting 34 41 40 49
7 Colomiers Colomiers 34 46 40 45
8 Saint-Étienne II Saint-Étien 34 50 49 45
9 Albi Albi 34 44 49 45
10 Hyères Hyères 34 47 47 44
11 US Le Pontet Pontet 34 61 63 44
12 Uzès Pont du Gard Uzès Pont G. 34 38 40 42
13 Agde Agde 34 37 46 41
14 Marignane Marignane 34 28 36 40
15 Tarbes Tarbes 34 38 42 39
16 Béziers Béziers 34 42 51 39
17 Aurillac Arpajon Aurillac 34 33 57 29
18 Anglet Genets Anglet 34 32 68 27
TEMPORADA 2009/2010
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Gap Gap 34 57 34 60
2 Gazélec Ajaccio Gazélec 34 45 29 58
3 Jura Sud Jura Sud 34 47 37 57
4 Olympique Lyonnais II Olympique 34 50 38 51
5 Sporting Toulon Var Sporting 34 40 32 50
6 FC Martigues Martigues 34 39 35 49
7 Marignane Marignane 34 33 38 49
8 Agde Agde 34 30 39 46
9 Montceau Montceau 34 42 42 45
10 CA Bastia CA Bastia 34 40 38 44
11 Bourg-Péronnas Bourg-Péron 34 37 47 44
12 Sochaux II Sochaux II 34 37 32 42
13 Villefranche Villefranche 34 41 45 42
14 Andrézieux Andrézieux 34 36 39 41
15 Lyon-Duchère Lyon-Duchèr 34 30 35 41
16 US Le Pontet Pontet 34 40 54 41
17 Montpellier II Montpellier 34 35 41 36
18 Grenoble Foot 38 II Grenoble 34 31 55 28
TEMPORADA 2008/2009
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Hyères Hyères 34 37 24 66
2 Fréjus St-Raphaël Fréjus 34 50 29 58
3 Villefranche Villefranche 34 59 44 56
4 Andrézieux Andrézieux 34 43 29 53
5 FC Martigues Martigues 34 51 39 53
6 Sporting Toulon Var Sporting 34 42 40 53
7 Olympique Lyonnais II Olympique 34 52 36 52
8 Montpellier II Montpellier 34 64 46 49
9 Gazélec Ajaccio Gazélec 34 40 41 46
10 CA Bastia CA Bastia 34 55 64 45
11 Agde Agde 34 39 49 43
12 Jura Sud Jura Sud 34 36 47 42
13 Marignane Marignane 34 27 31 40
14 Lyon-Duchère Lyon-Duchèr 34 36 50 40
15 Gap Gap 34 42 54 38
16 Saint-Étienne II Saint-Étien 34 40 45 35
17 Saint-Priest Saint-Priest 34 36 58 30
18 Monaco II Monaco II 34 34 57 30
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
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 FC Martigues Martigues 34 41 19 67
2 Olympique Lyonnais II Olympique 34 65 40 59
3 US Le Pontet Pontet 34 30 23 58
4 Cassis-Carnoux Cassis-Carno 33 46 33 53
5 Nice II Nice II 34 48 45 53
6 Saint-Priest Saint-Priest 34 45 42 50
7 Sochaux II Sochaux II 34 43 35 48
8 Jura Sud Jura Sud 34 35 38 48
9 Gap Gap 34 40 38 46
10 Monaco II Monaco II 34 49 44 45
11 Montpellier II Montpellier 34 45 42 45
12 Fréjus St-Raphaël Fréjus 33 39 36 44
13 Besancon RC Besancon RC 34 39 43 41
14 Agde Agde 34 30 44 39
15 Marseille Endoume Marseille 34 43 63 37
16 Racing Colombes 92 Racing 34 45 51 34
17 Bourg-Péronnas Bourg-Péron 34 39 58 29
18 Lyon-Duchère Lyon-Duchèr 34 21 49 26
TEMPORADA 2002/2003
NATIONAL
Equipo PJ GF GC Puntos
1 Besancon RC Besancon RC 38 55 33 67
2 Angers SCO Angers SCO 38 39 22 65
3 FC Rouen 1899 Rouen 1899 38 50 40 64
4 FC Martigues Martigues 38 40 26 61
5 Dijon FCO Dijon FCO 38 65 59 61
6 Valenciennes Valenciennes 38 51 42 58
7 Cannes Cannes 38 53 44 56
8 CS Louhans Cuiseaux Louhans 38 43 43 54
9 Sète Sète 38 50 44 51
10 Nîmes Nîmes 38 47 49 51
11 Stade Brestois Stade 38 49 44 50
12 Cherbourg Cherbourg 38 42 42 50
13 Romorantin Romorantin 38 39 40 50
14 Angouleme Angouleme 38 42 42 49
15 Pau FC Pau FC 38 46 47 47
16 Trelissac Trelissac 38 46 57 43
17 ES Viry-Châtillon Viry-Châtil 38 36 51 39
18 La Roche VF La Roche VF 38 33 48 31
19 Stade Beaucairois Stade 38 26 79 17
TEMPORADA 2001/2002
LIGUE 2
Equipo PJ GF GC Puntos
1 Ajaccio Ajaccio 38 47 25 72
2 Strasbourg Strasbourg 38 47 27 68
3 Nice Nice 38 56 40 66
4 Le Havre Le Havre 38 56 32 65
5 Le Mans Le Mans 38 48 41 58
6 Caen Caen 38 59 55 58
7 Beauvais Oise Beauvais 38 37 25 57
8 Chateauroux Chateauroux 38 41 42 53
9 Nancy Nancy 38 42 38 51
10 Stade Lavallois Stade 38 50 56 50
11 Niort Niort 38 40 39 48
12 Amiens SC Amiens SC 38 46 50 47
13 Saint-Étienne Saint-Étien 38 35 42 46
14 FC Gueugnon FC Gueugnon 38 42 49 44
15 ES Wasquehal Wasquehal 38 43 55 43
16 Grenoble Grenoble 38 38 55 42
17 Istres Istres 38 34 43 41
18 Creteil Creteil 38 35 46 41
19 Nîmes Nîmes 38 33 48 32
20 FC Martigues Martigues 38 32 53 32
TEMPORADA 2000/2001
LIGUE 2
Equipo PJ GF GC Puntos
1 Sochaux Sochaux 38 67 27 75
2 Lorient Lorient 38 58 34 74
3 Montpellier Montpellier 38 52 26 68
4 Niort Niort 38 58 44 59
5 Nancy Nancy 38 46 32 56
6 Chateauroux Chateauroux 38 50 38 56
7 Le Havre Le Havre 38 48 42 56
8 Nîmes Nîmes 38 53 56 53
9 Stade Lavallois Stade 38 39 43 53
10 FC Gueugnon FC Gueugnon 38 44 50 50
11 Beauvais Oise Beauvais 38 38 42 47
12 Ajaccio Ajaccio 38 32 40 46
13 ES Wasquehal Wasquehal 38 37 40 45
14 Le Mans Le Mans 38 37 45 45
15 Nice Nice 38 39 56 45
16 Creteil Creteil 38 37 43 43
17 Caen Caen 38 38 53 43
18 FC Martigues Martigues 38 30 46 39
19 Cannes Cannes 38 45 66 34
20 Angers SCO Angers SCO 38 35 60 33
TEMPORADA 1999/2000
NATIONAL
Equipo PJ GF GC Puntos
1 Beauvais Oise Beauvais 38 51 29 73
2 FC Martigues Martigues 38 67 41 66
3 Angers SCO Angers SCO 38 48 29 64
4 Grenoble Grenoble 38 60 51 61
5 Valenciennes Valenciennes 38 53 43 58
6 Pau FC Pau FC 38 57 50 57
7 Clermont Clermont 38 36 35 57
8 Besancon RC Besancon RC 38 48 33 56
9 Racing Colombes 92 Racing 38 51 39 56
10 Istres Istres 38 46 36 55
11 Stade de Reims Stade Reims 38 46 47 54
12 Red Star Red Star 38 44 40 52
13 Noisy-le-Sec Noisy-le-Sec 38 38 41 48
14 Thouars Thouars 38 40 46 48
15 Gazélec Ajaccio Gazélec 38 26 46 45
16 Pacy Vallée-d.Eure Pacy 38 37 56 43
17 Paris FC Paris FC 38 32 48 41
18 Evry Evry 38 28 46 35
19 Fréjus St-Raphaël Fréjus 38 36 63 32
20 Raon-l'Etape Raon-l'Etape 38 23 48 30
TEMPORADA 1998/1999
NATIONAL
Equipo PJ GF GC Puntos
1 CS Louhans Cuiseaux Louhans 36 51 26 68
2 Creteil Creteil 36 52 25 66
3 Gazélec Ajaccio Gazélec 36 50 34 65
4 Racing Colombes 92 Racing 36 43 28 63
5 Valenciennes Valenciennes 36 54 27 62
6 Noisy-le-Sec Noisy-le-Sec 36 35 26 58
7 Pau FC Pau FC 36 41 37 50
8 Raon-l'Etape Raon-l'Etape 36 42 40 49
9 Paris FC Paris FC 36 46 51 49
10 Fréjus St-Raphaël Fréjus 36 36 41 44
11 FC Martigues Martigues 36 34 37 42
12 Istres Istres 36 39 43 42
13 Angers SCO Angers SCO 36 45 55 42
14 Thouars Thouars 36 39 43 40
15 FC Mulhouse FC Mulhouse 36 40 56 40
16 St. Maur Lusi Maur Lusi 36 40 45 39
17 Pacy Vallée-d.Eure Pacy 36 32 51 39
18 Angouleme Angouleme 36 34 52 34
19 Saint-Priest Saint-Priest 36 29 65 30
TEMPORADA 1997/1998
LIGUE 2
Equipo PJ GF GC Puntos
1 Nancy Nancy 42 64 37 76
2 Lorient Lorient 42 68 38 75
3 Sochaux Sochaux 42 56 37 66
4 Lille Lille 42 62 44 65
5 Troyes Troyes 42 48 38 63
6 Le Mans Le Mans 42 54 46 62
7 Valence Valence 42 51 45 58
8 Red Star Red Star 42 51 61 57
9 Caen Caen 42 61 55 56
10 Niort Niort 42 42 38 55
11 FC Gueugnon FC Gueugnon 42 47 54 55
12 Amiens SC Amiens SC 42 40 49 55
13 Stade Lavallois Stade 42 50 48 54
14 Nice Nice 42 40 40 52
15 Nîmes Nîmes 42 41 51 52
16 Beauvais Oise Beauvais 42 40 47 51
17 Saint-Étienne Saint-Étien 42 47 60 51
18 ES Wasquehal Wasquehal 42 49 63 51
19 CS Louhans Cuiseaux Louhans 42 41 51 49
20 Sporting Toulon Var Sporting 42 43 62 46
21 FC Martigues Martigues 42 37 63 45
22 FC Mulhouse FC Mulhouse 42 51 56 41
TEMPORADA 1996/1997
LIGUE 2
Equipo PJ GF GC Puntos
1 Chateauroux Chateauroux 42 54 27 76
2 Toulouse Toulouse 42 61 32 75
3 FC Martigues Martigues 42 54 33 67
4 FC Gueugnon FC Gueugnon 42 54 47 67
5 Niort Niort 42 44 36 65
6 Le Mans Le Mans 42 49 41 62
7 Beauvais Oise Beauvais 42 43 43 61
8 Stade Lavallois Stade 42 48 39 58
9 Lorient Lorient 42 50 50 58
10 Valence Valence 42 48 53 58
11 Sochaux Sochaux 42 54 47 57
12 FC Mulhouse FC Mulhouse 42 51 49 54
13 Red Star Red Star 42 50 48 54
14 Sporting Toulon Var Sporting 42 50 57 54
15 Amiens SC Amiens SC 42 44 47 52
16 Perpignan Perpignan 42 38 42 51
17 Saint-Étienne Saint-Étien 42 48 56 51
18 CS Louhans Cuiseaux Louhans 42 39 52 51
19 Charleville Charleville 42 37 48 49
20 Troyes Troyes 42 36 42 48
21 Stade Briochin Stade 42 32 46 38
22 Épinal Épinal 42 26 75 26
TEMPORADA 1995/1996
LIGUE 1
Equipo PJ GF GC Puntos
1 Auxerre Auxerre 38 66 30 72
2 PSG PSG 38 65 36 68
3 Monaco Monaco 38 64 39 68
4 Metz Metz 38 42 30 65
5 Lens Lens 38 45 31 63
6 Montpellier Montpellier 38 51 40 60
7 Nantes Nantes 38 44 42 55
8 Stade Rennais Stade 38 44 41 54
9 Strasbourg Strasbourg 38 46 44 54
10 Guingamp Guingamp 38 34 33 53
11 Olympique Lyonnais Olympique 38 41 41 48
12 Nice Nice 38 37 44 45
13 Le Havre Le Havre 38 33 45 45
14 Cannes Cannes 38 45 51 44
15 Bastia Bastia 38 45 55 44
16 Girondins Bordeaux Girondins 38 44 52 42
17 Lille Lille 38 27 50 39
18 FC Gueugnon FC Gueugnon 38 27 46 38
19 Saint-Étienne Saint-Étien 38 36 59 34
20 FC Martigues Martigues 38 31 58 34
TEMPORADA 1994/1995
LIGUE 1
Equipo PJ GF GC Puntos
1 Nantes Nantes 38 71 34 79
2 Olympique Lyonnais Olympique 38 56 38 69
3 PSG PSG 38 58 41 67
4 Auxerre Auxerre 38 59 34 62
5 Lens Lens 38 48 44 59
6 Monaco Monaco 38 60 39 57
7 Girondins Bordeaux Girondins 38 52 47 57
8 Metz Metz 38 50 44 56
9 Cannes Cannes 38 56 48 53
10 Strasbourg Strasbourg 38 43 43 51
11 FC Martigues Martigues 38 37 49 51
12 Le Havre Le Havre 38 46 49 49
13 Stade Rennais Stade 38 53 55 48
14 Lille Lille 38 29 44 48
15 Bastia Bastia 38 44 56 44
16 Nice Nice 38 39 52 43
17 Montpellier Montpellier 38 38 53 41
18 Saint-Étienne Saint-Étien 38 45 55 38
19 Caen Caen 38 38 58 36
20 Sochaux Sochaux 38 29 68 23
TEMPORADA 1993/1994
LIGUE 1
Equipo PJ GF GC Puntos
1 PSG PSG 38 54 22 59
2 Olympique Marseille Olympique 38 56 33 51
3 Auxerre Auxerre 38 54 29 46
4 Girondins Bordeaux Girondins 38 54 37 46
5 Nantes Nantes 38 47 32 45
6 Cannes Cannes 38 50 43 44
7 Montpellier Montpellier 38 41 37 43
8 Olympique Lyonnais Olympique 38 38 40 42
9 Monaco Monaco 38 52 36 41
10 Lens Lens 38 49 40 39
11 Saint-Étienne Saint-Étien 38 38 36 37
12 Metz Metz 38 36 35 37
13 Strasbourg Strasbourg 38 43 47 34
14 Sochaux Sochaux 38 39 48 33
15 Lille Lille 38 41 52 32
16 Caen Caen 38 29 54 31
17 Le Havre Le Havre 38 29 48 29
18 FC Martigues Martigues 38 37 58 27
19 Toulouse Toulouse 38 26 60 23
20 Angers SCO Angers SCO 38 37 63 21

  USO DE MEMORIA  
7,763,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.7756
Total Execution Time  0.7771
  CADENA URL  
/historico/Fc-Martigues/2014
  GET DATOS  
$_GET['/historico/Fc-Martigues/2014']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0217  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 = 'Fc-Martigues' AND l.year = 2014 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.0150  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=1083 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=1083 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1083 AND type_rel = 2
0.0149  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1083 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147  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 (314576) ORDER BY n.cover_points DESC, update_date DESC
0.0151  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 = '1083' ORDER BY l.year DESC,cat.coefficient DESC
0.0186  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 = '1083' AND l.year = 2014 ORDER BY l.year DESC,cat.coefficient DESC
0.0155  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 = '1083' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = 2538 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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=1083 AND l.year in (2013,2014,2015) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (20491,4379) 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.0159  SELECT count(id) as num_players from rel_players WHERE league_id = 4379 AND teamId = 1083
0.0192  SELECT count(id) as num_players from rel_players WHERE league_id = 20491 AND teamId = 1083
0.0164  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 2538 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0157  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 = '1083' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0149  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1083' and rp.type = 4
0.0155  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 = '1083' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0185  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 events2014 e ON e.player_id = p.id AND e.league_id = 2538 WHERE rp.league_id = 2538 AND rp.teamId = 1083 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.0186  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 events2014 e ON e.player_id = p.id AND e.league_id = 2538 WHERE rp.league_id = 2538 AND rp.teamId = 1083 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0172  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 events2014 e ON e.player_id = p.id AND e.league_id = 2538 WHERE rp.league_id = 2538 AND rp.teamId = 1083 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0161  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 = 1083 AND l.year <= 2014 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0152  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 = 2538 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 2099 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 1353 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 19925 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 19928 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 19932 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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.0150  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.0151  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 = 19944 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2003` 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 = 594 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 523 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables2001` 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 = 524 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 `tables2000` 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 = 16460 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables1999` 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 = 16461 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 `tables1998` 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 = 527 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 `tables1997` 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 = 528 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables1996` 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 = 201 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 `tables1995` 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 = 202 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables1994` 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 = 9757 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC