4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Atl. Tucumán Atl. 38 59 30 74
2 Chacarita Juniors Chacarita 38 58 30 72
3 Atletico Rafaela Atletico 38 47 39 62
4 Belgrano Belgrano 38 36 29 62
5 Instituto Instituto 38 50 43 59
6 Aldosivi Aldosivi 38 32 33 57
7 Ferro Carril Oeste Ferro Carril 38 52 48 52
8 Quilmes Quilmes 38 39 41 51
9 All Boys All Boys 38 46 46 50
10 Tiro Federal Rosario Tiro Federal 38 45 46 50
11 Indep. Rivadavia Indep. 38 46 48 50
12 Talleres Córdoba Talleres 38 50 54 50
13 San Martín San Juan Martín Juan 38 46 41 49
14 Defensa y Justicia Defensa 38 47 47 49
15 Unión Santa Fe Unión Santa 38 48 52 49
16 Los Andes Los Andes 38 51 57 45
17 Olimpo Olimpo 38 39 59 40
18 Platense Platense 38 37 51 37
19 CAI CAI 38 35 45 36
20 Almagro Almagro 38 36 60 32
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 San Martín Tucumán Martín 38 47 28 66
2 Godoy Cruz Godoy Cruz 38 54 41 65
3 Unión Santa Fe Unión Santa 38 52 43 56
4 Belgrano Belgrano 38 45 41 56
5 Chacarita Juniors Chacarita 38 46 45 56
6 Quilmes Quilmes 38 43 36 55
7 Tiro Federal Rosario Tiro Federal 38 44 36 54
8 Atletico Rafaela Atletico 38 49 44 53
9 CAI CAI 38 48 52 51
10 Ferro Carril Oeste Ferro Carril 38 40 44 51
11 Aldosivi Aldosivi 38 54 47 48
12 Indep. Rivadavia Indep. 38 50 51 47
13 Talleres Córdoba Talleres 38 48 64 46
14 Almagro Almagro 38 40 49 43
15 Instituto Instituto 38 32 46 43
16 Defensa y Justicia Defensa 38 32 49 43
17 Platense Platense 38 45 55 42
18 Almirante Brown Almirante 38 42 26 41
19 Ben Hur Ben Hur 38 29 46 38
20 Nueva Chicago Nueva 38 47 44 34

  USO DE MEMORIA  
5,508,552 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3965
Total Execution Time  0.3984
  CADENA URL  
/primera_b_nacional2009/grupo1/historico
  GET DATOS  
$_GET['/primera_b_nacional2009/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0144  SELECT type FROM routes WHERE alias = 'primera_b_nacional2009'
0.0290  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_b_nacional' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 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 = 12932 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 192 AND group_code = 1 and tables = 1 AND year <= 2009 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 12932 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 `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 = 12931 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 00:11:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 00:11:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 00:11:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 00:11:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_b_nacional' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0365  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 events2009 e ON e.player_id = p.id AND e.league_id = 12932 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 12932 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.0342  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 events2009 e ON e.player_id = p.id AND e.league_id = 12932 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 12932 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0241  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 events2009 e ON e.player_id = p.id AND e.league_id = 12932 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 12932 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 `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 = 12932 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC