4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Racing Colombes 92
TEMPORADA 2019/2020
NATIONAL 3 GRUPO 11
Equipo PJ GF GC Puntos
1 Versailles Versailles 18 35 7 42
2 Ivry Ivry 18 25 9 40
3 Créteil II Créteil II 17 20 14 28
4 Paris II Paris II 17 23 19 27
5 Racing Colombes 92 Racing 17 25 15 26
6 Blanc Mesnil Blanc Mesnil 16 14 15 25
7 Les Ulis Les Ulis 17 27 24 24
8 Les Mureaux Les Mureaux 17 17 18 21
9 Aubervilliers Aubervillier 17 17 20 21
10 PSG II PSG II 17 21 24 20
11 Noisy Le Grand Noisy Grand 18 13 29 16
12 US Torcy US Torcy 16 15 24 14
13 Saint-Leu Saint-Leu 18 11 26 14
14 Boulogne-Billancourt Boulogne-Bil 17 8 27 12
TEMPORADA 2018/2019
NATIONAL 3 GRUPO 11
Equipo PJ GF GC Puntos
1 Paris 13 Atletico Paris 26 50 24 49
2 Versailles Versailles 26 38 26 47
3 Aubervilliers Aubervillier 26 47 34 42
4 Racing Colombes 92 Racing 26 32 26 41
5 Les Mureaux Les Mureaux 26 31 29 39
6 Paris II Paris II 26 35 29 38
7 Ivry Ivry 26 37 31 35
8 Les Ulis Les Ulis 26 31 28 35
9 Blanc Mesnil Blanc Mesnil 26 30 34 33
10 Créteil II Créteil II 26 35 42 32
11 Noisy-le-Sec Noisy-le-Sec 26 25 35 28
12 Brétigny Foot Brétigny 26 15 28 28
13 Meaux Academy Meaux 26 29 42 27
14 Le Mée Le Mée 26 24 51 24
TEMPORADA 2017/2018
NATIONAL 3 GRUPO 12
Equipo PJ GF GC Puntos
1 Bobigny Bobigny 26 45 21 51
2 Aubervilliers Aubervillier 26 38 32 45
3 Noisy-le-Sec Noisy-le-Sec 26 46 26 43
4 Versailles Versailles 26 35 31 43
5 Paris 13 Atletico Paris 26 37 31 40
6 Blanc Mesnil Blanc Mesnil 26 37 29 38
7 Ivry Ivry 26 37 35 36
8 Les Mureaux Les Mureaux 26 21 21 34
9 Les Ulis Les Ulis 26 36 43 33
10 Créteil II Créteil II 26 38 33 32
11 Racing Colombes 92 Racing 26 30 41 29
12 Paris II Paris II 26 34 45 28
13 Saint-Ouen-l'Aumône Saint-Ouen-l 26 26 41 25
14 Sénart Moissy Sénart 26 26 57 19
TEMPORADA 2012/2013
NATIONAL 3 GRUPO 2
Equipo PJ GF GC Puntos
1 Sannois Gratien Sannois 26 39 17 56
2 US Fleury-Merogis Fleury-Merog 26 43 26 53
3 St Geneviève Geneviève 26 42 23 50
4 Chartres Chartres 26 36 25 46
5 Bastia II Bastia II 26 44 25 40
6 Oissel Oissel 26 32 30 36
7 Sénart Moissy Sénart 26 28 35 33
8 Paris II Paris II 26 24 30 32
9 Evry Evry 26 23 29 32
10 Noisy-le-Sec Noisy-le-Sec 26 21 25 31
11 FC Rouen 1899 II Rouen 1899 26 26 36 30
12 Racing Colombes 92 Racing 26 35 43 29
13 Beauvais II Beauvais II 26 24 41 21
14 AM Neiges Le Havre Neiges Havre 26 22 54 15
TEMPORADA 2011/2012
NATIONAL 3 GRUPO 2
Equipo PJ GF GC Puntos
1 Iris Club de Croix Iris Club C. 9 13 3 20
2 ES Wasquehal Wasquehal 9 21 11 19
3 US Fleury-Merogis Fleury-Merog 9 15 12 17
4 Sedan II Sedan II 9 19 12 16
5 Roye-Noyon Roye-Noyon 9 14 10 16
6 Feignies Feignies 9 12 6 15
7 Stade de Reims II Stade Reims 9 10 8 15
8 Sézanne Sézanne 9 17 16 14
9 Troyes II Troyes II 9 16 14 13
10 Arras Arras 9 11 14 11
11 Racing Colombes 92 Racing 9 9 15 11
12 St Geneviève Geneviève 9 10 14 9
13 Fresnoy-Saint-Quentin Fresnoy-Sain 9 6 10 8
14 Paris II Paris II 9 9 16 8
15 Saint-Dizier Saint-Dizier 9 5 11 5
16 Créteil II Créteil II 9 7 22 2
TEMPORADA 2010/2011
NATIONAL 3 GRUPO 2
Equipo PJ GF GC Puntos
1 Calais Calais 30 45 26 58
2 Valenciennes II Valenciennes 30 44 28 53
3 Racing Colombes 92 Racing 30 43 29 50
4 Sedan II Sedan II 30 53 27 48
5 Roye-Noyon Roye-Noyon 30 40 34 48
6 Feignies Feignies 30 44 29 47
7 ES Wasquehal Wasquehal 30 40 26 45
8 Arras Arras 30 40 29 45
9 Chambly Chambly 30 32 35 44
10 St Geneviève Geneviève 30 40 31 42
11 Stade de Reims II Stade Reims 30 39 46 42
12 Créteil II Créteil II 30 35 41 39
13 Lesquin Lesquin 30 30 37 39
14 Les Lilas Les Lilas 30 41 57 33
15 Douai Douai 30 24 58 21
16 Prix lès Mézières Prix lès Mé. 30 19 76 7
TEMPORADA 2009/2010
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Orléans Orléans 34 43 21 69
2 La Vitréenne Vitréenne 34 49 33 61
3 Le Havre II Le Havre II 34 59 39 59
4 Cherbourg Cherbourg 34 45 33 59
5 Racing Colombes 92 Racing 34 46 36 50
6 QRM QRM 34 52 46 48
7 Romorantin Romorantin 34 59 57 47
8 V.Châtillon V.Châtillon 34 50 58 47
9 Ivry Ivry 34 40 37 46
10 Sénart Moissy Sénart 34 49 47 45
11 Carquefou Carquefou 34 37 42 45
12 Auxerre II Auxerre II 34 47 44 44
13 Stade Rennais II Stade 34 33 41 42
14 Avranches Avranches 34 37 44 41
15 Caen II Caen II 34 46 45 39
16 Mantes Mantes 34 35 49 37
17 Pontivy Pontivy 34 36 57 25
18 Quimper Cornouaille Quimper 34 23 57 25
TEMPORADA 2008/2009
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 FC Rouen 1899 Rouen 1899 34 56 27 65
2 Plabennec Plabennec 34 41 31 60
3 QRM QRM 34 53 31 57
4 Orléans Orléans 34 48 35 56
5 Villemomble Sports Villemomble 34 31 29 51
6 La Vitréenne Vitréenne 34 36 28 49
7 Stade Rennais II Stade 34 40 39 47
8 Racing Colombes 92 Racing 34 36 34 46
9 Caen II Caen II 34 41 43 44
10 V.Châtillon V.Châtillon 34 43 49 44
11 PSG II PSG II 34 38 44 43
12 UJA Maccabi UJA Maccabi 34 40 43 40
13 Le Havre II Le Havre II 34 39 43 39
14 Red Star Red Star 34 28 36 39
15 Quimper Cornouaille Quimper 34 28 41 39
16 Pontivy Pontivy 34 31 45 38
17 Guingamp II Guingamp II 34 35 41 37
18 Vitré Vitré 34 25 50 28
TEMPORADA 2007/2008
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Pacy Vallée-d.Eure Pacy 34 51 31 62
2 FC Rouen 1899 Rouen 1899 34 43 26 60
3 QRM QRM 34 49 38 56
4 Dunkerque Dunkerque 34 55 42 55
5 Lille II Lille II 34 48 37 52
6 Racing Colombes 92 Racing 34 42 45 49
7 Caen II Caen II 34 41 41 48
8 Vitré Vitré 34 37 47 48
9 La Vitréenne Vitréenne 34 29 28 47
10 Guingamp II Guingamp II 34 46 38 46
11 Compiègne Compiègne 34 39 42 46
12 Lens II Lens II 34 47 48 45
13 Stade Rennais II Stade 34 40 39 44
14 Le Havre II Le Havre II 34 43 41 42
15 Plabennec Plabennec 34 30 44 40
16 Lesquin Lesquin 34 43 46 39
17 ES Wasquehal Wasquehal 34 32 43 35
18 Valenciennes II Valenciennes 34 29 68 17
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 2000/2001
NATIONAL
Equipo PJ GF GC Puntos
1 Grenoble Grenoble 38 57 31 76
2 Amiens SC Amiens SC 38 63 29 75
3 Istres Istres 38 53 34 69
4 Clermont Clermont 38 71 34 68
5 Stade de Reims Stade Reims 38 48 36 65
6 Stade Brestois Stade 38 64 48 63
7 Racing Colombes 92 Racing 38 49 44 58
8 Gazélec Ajaccio Gazélec 38 60 55 55
9 La Roche VF La Roche VF 38 56 60 53
10 Valence Valence 38 59 53 51
11 Olympique Alès Olympique 38 48 49 48
12 Besancon RC Besancon RC 38 41 41 47
13 CS Louhans Cuiseaux Louhans 38 48 58 46
14 Noisy-le-Sec Noisy-le-Sec 38 29 49 45
15 Pau FC Pau FC 38 40 54 43
16 Dijon FCO Dijon FCO 38 43 53 42
17 Valenciennes Valenciennes 38 39 56 40
18 Pacy Vallée-d.Eure Pacy 38 44 62 34
19 Thouars Thouars 38 29 66 28
20 Red Star Red Star 38 42 71 27
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
NATIONAL
Equipo PJ GF GC Puntos
1 Ajaccio Ajaccio 34 64 22 77
2 CS Sedan CS Sedan 34 65 26 75
3 Creteil Creteil 34 46 21 72
4 Istres Istres 34 61 43 58
5 Gazélec Ajaccio Gazélec 34 52 33 57
6 Paris FC Paris FC 34 46 33 53
7 Stade Poitevin Stade 34 43 48 45
8 Tours Tours 34 39 39 43
9 Racing Colombes 92 Racing 34 33 38 43
10 St. Maur Lusi Maur Lusi 34 33 39 43
11 Angouleme Angouleme 34 35 43 39
12 Noisy-le-Sec Noisy-le-Sec 34 30 45 39
13 St-Denis / St-Leu St-Denis 34 32 42 38
14 Thouars Thouars 34 37 42 35
15 Raon-l'Etape Raon-l'Etape 34 27 42 32
16 Épinal Épinal 34 24 54 31
17 Angers SCO Angers SCO 34 25 51 26
18 Fréjus St-Raphaël Fréjus 34 35 66 25

  USO DE MEMORIA  
6,630,704 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1630
Total Execution Time  0.1648
  CADENA URL  
/historico/Racing-Colombes-92
  GET DATOS  
$_GET['/historico/Racing-Colombes-92']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (52)  
0.0023  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 = 'Racing-Colombes-92' 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.0036  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 = 'Racing-Colombes-92' 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=11668 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=11668 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=11668 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0058  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=11668 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=11668 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=11668 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=11668 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=11668 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=11668 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=11668 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=11668 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=11668 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=11668 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=11668 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=11668 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=11668 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=11668 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 50964
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11668 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=221 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 221 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  SELECT /*53 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 (1115226,1099907,1026668,943823,937135) ORDER BY n.cover_points DESC, update_date DESC
0.0021  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 = '11668' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = '11668' 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 = 50964 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=11668 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0024  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 (50964) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 50964 AND teamId = 11668
0.0029  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 50964 AND t.round = 18 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 = '11668' 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 = '11668' and rp.type = 4
0.0019  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 = '11668' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0048  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 events2020 e ON e.player_id = p.id AND e.league_id = 50964 WHERE rp.league_id = 50964 AND rp.teamId = 11668 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.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 events2020 e ON e.player_id = p.id AND e.league_id = 50964 WHERE rp.league_id = 50964 AND rp.teamId = 11668 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 events2020 e ON e.player_id = p.id AND e.league_id = 50964 WHERE rp.league_id = 50964 AND rp.teamId = 11668 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 11668 AND l.year <= 2020 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 `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 = 50964 AND t.round = 18 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 `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 = 44570 AND t.round = 26 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 `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 = 39141 AND t.round = 26 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 = 2102 AND t.round = 26 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 `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 = 1684 AND t.round = 9 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 `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 = 19996 AND t.round = 30 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 `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 = 19930 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 `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 = 19934 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 `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 = 19935 AND t.round = 34 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 `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.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 `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 = 16459 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 `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.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 `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.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 `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 = 16462 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC