4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2012/2013
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
Ver
TEMPORADA 2011/2012
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
Ver
TEMPORADA 2010/2011
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
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Aubervilliers Aubervillier 30 55 21 66
2 Avion Avion 30 63 24 58
3 Feignies Feignies 30 45 30 51
4 Arras Arras 30 36 24 50
5 Roye-Noyon Roye-Noyon 30 41 30 46
6 Valenciennes II Valenciennes 30 33 23 46
7 Sedan II Sedan II 30 44 36 45
8 Stade de Reims II Stade Reims 30 46 38 44
9 Beauvais II Beauvais II 30 38 34 39
10 Lesquin Lesquin 30 34 43 39
11 Saint-Dizier Saint-Dizier 30 28 37 39
12 Créteil II Créteil II 30 39 46 37
13 Les Lilas Les Lilas 30 39 43 36
14 FC Sens FC Sens 30 37 53 35
15 Tinqueux Tinqueux 29 18 55 17
16 Marnaval Marnaval 29 22 81 11
Ver
TEMPORADA 2008/2009
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
Ver
TEMPORADA 2007/2008
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,665,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0025
Controller Execution Time ( Home / Category )  0.4481
Total Execution Time  0.4507
  CADENA URL  
/ligue_cfa_22013/grupo2/historico
  GET DATOS  
$_GET['/ligue_cfa_22013/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0144  SELECT type FROM routes WHERE alias = 'ligue_cfa_22013'
0.0294  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_cfa_2' AND (l.group_code = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2013 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0147  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 2102 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 221 AND group_code = 2 and tables = 1 AND year <= 2013 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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.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 `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.0162  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.0159  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 = 20004 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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.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 `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.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 20:24:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 20:24:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 20:24:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 20:24:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0161  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_cfa_2' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2013 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0398  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2013 e ON e.player_id = p.id AND e.league_id = 2102 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2102 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0231  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2013 e ON e.player_id = p.id AND e.league_id = 2102 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2102 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0152  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2013 e ON e.player_id = p.id AND e.league_id = 2102 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2102 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0156  SELECT *,(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