4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Le Poiré-sur-Vie Poiré-sur-V 32 47 24 59
2 Cherbourg Cherbourg 32 42 37 49
3 La Vitréenne Vitréenne 32 39 26 48
4 Les Herbiers Herbiers 32 48 36 46
5 Carquefou Carquefou 32 42 36 46
6 Yzeure Yzeure 32 30 26 44
7 Moulins Moulins 32 42 43 44
8 Le Mans II Le Mans II 32 44 38 42
9 Avranches Avranches 32 32 31 42
10 V.Châtillon V.Châtillon 32 36 39 42
11 Romorantin Romorantin 32 43 44 41
12 Luçon Luçon 32 36 43 40
13 Lorient II Lorient II 32 39 42 39
14 Fontenay Fontenay 32 34 43 39
15 Caen II Caen II 32 40 55 38
16 Saint-Pryve Saint-Pryve 32 40 53 36
17 Stade Rennais II Stade 32 27 45 29
Ver
TEMPORADA 2009/2010
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
Ver
TEMPORADA 2008/2009
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
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Girondins Bordeaux II Girondins 34 56 28 63
2 Bayonne Bayonne 34 47 30 58
3 Fontenay Fontenay 34 40 33 54
4 Moulins Moulins 34 44 34 53
5 Orléans Orléans 34 44 35 50
6 Le Mans II Le Mans II 34 55 49 50
7 Anglet Genets Anglet 34 42 37 48
8 PSG II PSG II 34 28 26 48
9 St Geneviève Geneviève 34 43 50 46
10 Chatellerault Chatelleraul 33 43 49 45
11 Montluçon Montluçon 34 44 37 42
12 Stade Bordelais Stade 34 40 48 41
13 Yzeure Yzeure 33 35 44 41
14 Sénart Moissy Sénart 34 43 54 38
15 Aurillac Arpajon Aurillac 34 34 46 35
16 Nantes II Nantes II 34 27 41 35
17 Les Sables D`olonne Sables 34 29 45 34
18 Poissy Poissy 34 40 48 32
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Villemomble Sports Villemomble 34 41 29 63
2 Stade Rennais II Stade 34 57 36 57
3 Auxerre II Auxerre II 34 48 37 54
4 Guingamp II Guingamp II 34 41 38 52
5 FUSC Bois Guillaume FUSC Bois G. 34 38 27 51
6 Poissy Poissy 34 47 43 50
7 FC Rouen 1899 Rouen 1899 34 32 29 50
8 St Geneviève Geneviève 34 48 38 49
9 Pacy Vallée-d.Eure Pacy 34 35 28 49
10 Red Star Red Star 34 39 33 47
11 Sénart Moissy Sénart 34 34 29 45
12 QRM QRM 34 47 48 41
13 PSG II PSG II 33 40 42 41
14 Vitré Vitré 33 35 37 39
15 Plabennec Plabennec 34 30 38 37
16 Pontivy Pontivy 34 35 64 34
17 Dieppe Dieppe 33 27 47 28
18 Concarneau Concarneau 33 25 56 21
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Paris FC Paris FC 34 43 23 65
2 Stade Rennais II Stade 34 53 34 60
3 Guingamp II Guingamp II 34 46 30 54
4 FC Rouen 1899 Rouen 1899 33 44 33 52
5 Vitré Vitré 33 41 27 50
6 Villemomble Sports Villemomble 34 49 38 49
7 FUSC Bois Guillaume FUSC Bois G. 34 35 28 48
8 PSG II PSG II 33 46 43 48
9 Poissy Poissy 34 44 30 46
10 Sénart Moissy Sénart 34 36 36 43
11 Dieppe Dieppe 33 28 38 41
12 Pontivy Pontivy 34 39 51 41
13 Pacy Vallée-d.Eure Pacy 34 31 45 41
14 QRM QRM 34 35 43 39
15 St Geneviève Geneviève 34 37 44 37
16 Noisy-le-Sec Noisy-le-Sec 34 22 29 34
17 Mantes Mantes 34 24 46 28
18 Mondeville Mondeville 34 25 60 23

  USO DE MEMORIA  
5,903,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.3415
Total Execution Time  0.3437
  CADENA URL  
/ligue_cfa2011/grupo4/historico
  GET DATOS  
$_GET['/ligue_cfa2011/grupo4/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0105  SELECT type FROM routes WHERE alias = 'ligue_cfa2011'
0.0213  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_cfa' AND (l.group_code = 4 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2011 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=4 DESC LIMIT 1
0.0106  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 = 19926 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 220 AND group_code = 4 and tables = 1 AND year <= 2011 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0111  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 = 19926 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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.0112  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.0112  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 = 19938 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 19942 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 19946 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 21:54:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 21:54:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 21:54:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 21:54:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_cfa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2011 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0203  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 events2011 e ON e.player_id = p.id AND e.league_id = 19926 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 19926 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.0339  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 events2011 e ON e.player_id = p.id AND e.league_id = 19926 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 19926 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0120  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 events2011 e ON e.player_id = p.id AND e.league_id = 19926 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 19926 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0117  SELECT *,(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 = 19926 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC