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

Troyes II

Entrenador: Alou Diarra

Temporada 2015/2016
TEMPORADA 2015/2016
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 QRM QRM 30 50 22 62
2 Iris Club de Croix Iris Club C. 30 55 37 55
3 Poissy Poissy 30 55 42 52
4 Sannois Gratien Sannois 30 46 39 46
5 ES Wasquehal Wasquehal 30 44 41 46
6 Arras Arras 30 43 43 41
7 Amiens AC Amiens AC 30 35 34 40
8 PSG II PSG II 30 35 40 40
9 Mantes Mantes 30 31 38 39
10 Boulogne-Billancourt Boulogne-Bil 30 43 40 38
11 Calais Calais 30 32 37 38
12 Dieppe Dieppe 30 31 24 37
13 Troyes II Troyes II 30 41 47 36
14 Lens II Lens II 30 37 45 36
15 Aubervilliers Aubervillier 30 27 47 24
16 Roye-Noyon Roye-Noyon 30 38 67 22
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 3 GRUPO 3
Equipo PJ GF GC Puntos
1 Metz II Metz II 26 63 23 58
2 Troyes II Troyes II 26 72 22 56
3 Nancy II Nancy II 26 62 25 54
4 Pontarlier Pontarlier 26 53 20 50
5 Colmar II Colmar II 26 44 49 37
6 Sarreguemines Sarreguemine 26 51 66 37
7 Schiltigheim Schiltigheim 26 44 45 35
8 Saint-Louis Neuweg Saint-Louis 26 35 39 33
9 Amnéville Amnéville 26 29 33 32
10 Illzach Modenheim Illzach 26 32 51 31
11 Biesheim Biesheim 26 35 41 28
12 Thaon Thaon 26 29 52 25
13 Belfort Sud Belfort Sud 26 27 57 19
14 Morteau Montlebon Morteau 26 20 73 17
TEMPORADA 2012/2013
NATIONAL 3 GRUPO 3
Equipo PJ GF GC Puntos
1 Saint-Pryve Saint-Pryve 26 43 29 48
2 Vesoul Vesoul 26 37 25 48
3 Dijon II Dijon II 26 54 36 46
4 Saint-Louis Neuweg Saint-Louis 26 37 29 41
5 Colmar II Colmar II 26 46 37 39
6 Illzach Modenheim Illzach 26 38 46 39
7 Troyes II Troyes II 26 50 40 38
8 Schiltigheim Schiltigheim 26 41 43 36
9 Thaon Thaon 26 34 38 36
10 Belfort Sud Belfort Sud 26 47 53 34
11 RC Épernay Champagne Épernay 26 43 41 30
12 Lunéville Lunéville 26 32 42 29
13 Jarville Jarville 26 39 47 24
14 Forbach Forbach 26 20 55 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 3
Equipo PJ GF GC Puntos
1 Strasbourg II Strasbourg 30 47 21 58
2 Dijon II Dijon II 30 53 36 53
3 Sarre-Union Sarre-Union 30 50 36 52
4 Saint-Louis Neuweg Saint-Louis 30 46 36 52
5 Schiltigheim Schiltigheim 30 37 29 46
6 Vesoul Vesoul 30 42 35 46
7 Troyes II Troyes II 30 57 32 44
8 Auxerre III Auxerre III 30 39 28 40
9 Forbach Forbach 30 33 45 39
10 Illzach Modenheim Illzach 30 49 49 38
11 Jarville Jarville 30 37 54 35
12 Saint-Dizier Saint-Dizier 30 28 49 33
13 Saint-Dié Saint-Dié 30 36 51 32
14 Selongey Selongey 30 30 43 31
15 Vauban Strasbourg Vauban 30 30 42 27
16 Jura Dolois Jura Dolois 30 32 60 23
TEMPORADA 2009/2010
NATIONAL 3 GRUPO 3
Equipo PJ GF GC Puntos
1 Metz II Metz II 30 67 21 77
2 Belfort Belfort 30 50 23 56
3 Troyes II Troyes II 30 58 40 51
4 Auxerre III Auxerre III 30 60 37 48
5 Pontarlier Pontarlier 30 46 35 47
6 Jarville Jarville 30 49 48 43
7 Saint-Louis Neuweg Saint-Louis 30 34 42 40
8 Selongey Selongey 30 36 47 40
9 Illzach Modenheim Illzach 30 43 45 38
10 Sarre-Union Sarre-Union 30 49 55 36
11 Saint-Dié Saint-Dié 30 38 42 35
12 Vauban Strasbourg Vauban 30 32 41 31
13 Neuves-Maisons Neuves-Maiso 30 35 47 30
14 FC Chaumont FC Chaumont 30 31 54 29
15 Besancon RC II Besancon 30 38 42 28
16 Thionville Thionville 30 26 73 16
TEMPORADA 2008/2009
NATIONAL 3 GRUPO 2
Equipo PJ GF GC Puntos
1 Drancy Drancy 30 39 24 59
2 Ivry Ivry 30 44 16 54
3 Stade de Reims II Stade Reims 30 50 37 45
4 Arras Arras 30 34 26 45
5 Troyes II Troyes II 30 43 37 45
6 Feignies Feignies 30 45 35 44
7 FC Sens FC Sens 30 33 33 40
8 Sedan II Sedan II 30 41 42 39
9 Roye-Noyon Roye-Noyon 30 33 39 39
10 Les Lilas Les Lilas 30 36 39 38
11 Lesquin Lesquin 30 24 31 38
12 Valenciennes II Valenciennes 30 37 39 37
13 Reims Sainte-Anne Reims 30 32 41 37
14 Avion Avion 30 40 53 37
15 Leval Leval 30 32 40 35
16 Chauny Chauny 30 26 57 23
TEMPORADA 2007/2008
NATIONAL 3 GRUPO 2
Equipo PJ GF GC Puntos
1 Troyes II Troyes II 30 60 23 59
2 Colmar Colmar 30 49 27 57
3 Illzach Modenheim Illzach 30 65 37 51
4 Saint-Dié Saint-Dié 30 46 35 50
5 Amnéville Amnéville 30 46 32 47
6 Vauban Strasbourg Vauban 30 45 34 47
7 Selongey Selongey 30 39 38 47
8 FC Sens FC Sens 30 44 51 39
9 Jarville Jarville 30 51 50 38
10 FCSR Haguenau FCSR 30 23 32 38
11 Besancon RC II Besancon 30 35 37 36
12 Thaon Thaon 30 32 47 35
13 Saint-Dizier Saint-Dizier 30 39 44 34
14 Schiltigheim Schiltigheim 30 32 53 30
15 Pont-de-Roide Pont-de-Roid 30 36 56 29
16 FCSR Obernai FCSR Obernai 30 30 76 17

  USO DE MEMORIA  
5,833,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5184
Total Execution Time  0.5196
  CADENA URL  
/historico/Troyes-Ii/2016
  GET DATOS  
$_GET['/historico/Troyes-Ii/2016']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0135  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 = 'Troyes-Ii' AND l.year = 2016 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.0125  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=6728 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=6728 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253  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 = 15745
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6728 AND type_rel = 2
0.0129  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 = '6728' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '6728' AND l.year = 2016 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '6728' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 15745 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=6728 AND l.year in (2015,2016,2017) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (34011,15745) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 15745 AND teamId = 6728
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 34011 AND teamId = 6728
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 15745 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '6728' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6728' and rp.type = 4
0.0127  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 = '6728' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0142  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 events2016 e ON e.player_id = p.id AND e.league_id = 15745 WHERE rp.league_id = 15745 AND rp.teamId = 6728 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.0135  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 events2016 e ON e.player_id = p.id AND e.league_id = 15745 WHERE rp.league_id = 15745 AND rp.teamId = 6728 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 events2016 e ON e.player_id = p.id AND e.league_id = 15745 WHERE rp.league_id = 15745 AND rp.teamId = 6728 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 6728 AND l.year <= 2016 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130  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 = 15745 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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.0129  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 = 2542 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 2103 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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.0129  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 = 19997 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 20005 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0197  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 = 20013 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 20021 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 15745 ORDER BY nameShow LIMIT 100