4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Nueva Chicago Nueva 19 30 20 35
2 Belgrano Belgrano 19 29 19 35
3 San Martín San Juan Martín Juan 19 23 15 33
4 Talleres Córdoba Talleres 19 27 20 33
5 Atletico Rafaela Atletico 19 27 21 31
6 Tigre Tigre 19 13 13 31
7 San Martín Mendoza Martín 19 27 25 30
8 Aldosivi Aldosivi 19 20 21 29
9 Chacarita Juniors Chacarita 19 24 18 26
10 Juventud Antoniana Juventud 19 23 20 26
11 Ben Hur Ben Hur 19 17 16 26
12 El Porvenir El Porvenir 19 14 23 24
13 Godoy Cruz Godoy Cruz 19 20 21 23
14 CAI CAI 19 19 25 23
15 CA Huracán CA Huracán 19 27 29 22
16 Unión Santa Fe Unión Santa 19 16 19 22
17 Defensa y Justicia Defensa 19 28 25 21
18 Almagro Almagro 19 14 24 17
19 Huracán Tres Arroyos Huracán 19 15 26 16
20 Ferro Carril Oeste Ferro Carril 19 15 28 14
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Gimnasia Jujuy Gimnasia 19 30 17 35
2 CAI CAI 19 26 18 34
3 Atletico Rafaela Atletico 19 26 23 29
4 Talleres Córdoba Talleres 19 27 18 28
5 Belgrano Belgrano 19 22 23 28
6 Chacarita Juniors Chacarita 19 30 28 27
7 CA Huracán CA Huracán 19 25 23 27
8 Tiro Federal Rosario Tiro Federal 19 14 17 27
9 San Martín Mendoza Martín 19 29 24 26
10 Juventud Antoniana Juventud 19 23 20 26
11 San Martín San Juan Martín Juan 19 18 16 25
12 Godoy Cruz Godoy Cruz 19 23 27 25
13 Unión Santa Fe Unión Santa 19 23 28 25
14 Ferro Carril Oeste Ferro Carril 19 24 20 24
15 Nueva Chicago Nueva 19 21 20 23
16 Racing Córdoba Racing 19 22 27 19
17 El Porvenir El Porvenir 19 14 22 19
18 Def. Belgrano Def. 19 18 27 19
19 Defensa y Justicia Defensa 19 15 20 18
20 Sarmiento Sarmiento 19 25 37 14
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Almagro Almagro 19 35 19 37
2 Argentinos Juniors Argentinos 19 28 18 36
3 Huracán Tres Arroyos Huracán 19 26 15 34
4 Godoy Cruz Godoy Cruz 19 26 21 33
5 El Porvenir El Porvenir 19 26 16 31
6 Ferro Carril Oeste Ferro Carril 19 20 19 30
7 San Martín San Juan Martín Juan 19 22 23 29
8 Belgrano Belgrano 19 22 15 28
9 CA Huracán CA Huracán 19 31 28 28
10 Tiro Federal Rosario Tiro Federal 19 27 26 27
11 Unión Santa Fe Unión Santa 19 28 29 26
12 Los Andes Los Andes 19 23 29 25
13 Instituto Instituto 19 22 23 24
14 Gimnasia Jujuy Gimnasia 19 26 32 22
15 Defensa y Justicia Defensa 19 27 34 21
16 CAI CAI 19 23 25 20
17 Def. Belgrano Def. 19 21 26 20
18 Gimnasia Concepción Gimnasia 19 25 31 19
19 Juventud Antoniana Juventud 19 17 32 17
20 San Martín Mendoza Martín 19 16 30 13
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Atletico Rafaela Atletico 19 35 26 39
2 Argentinos Juniors Argentinos 19 30 11 38
3 San Martín Mendoza Martín 19 27 20 33
4 Godoy Cruz Godoy Cruz 19 31 19 32
5 Almagro Almagro 19 31 22 32
6 Belgrano Belgrano 19 21 15 31
7 Quilmes Quilmes 19 28 23 31
8 Huracán Tres Arroyos Huracán 19 30 23 28
9 Defensores Belgrano VR Defensores 19 28 26 28
10 Instituto Instituto 19 20 20 28
11 Defensa y Justicia Defensa 19 19 21 24
12 Juventud Antoniana Juventud 19 16 18 24
13 Los Andes Los Andes 19 25 30 23
14 C.A.I C.A.I 19 24 33 23
15 Gimnasia Jujuy Gimnasia 19 19 26 22
16 Almirante Brown Almirante 19 25 33 21
17 El Porvenir El Porvenir 19 21 28 19
18 San Martín San Juan Martín Juan 19 18 23 18
19 Gimnasia Concepción Gimnasia 19 26 41 15
20 Dep. Español Dep. 19 18 34 7
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Arsenal de Sarandí Arsenal 14 27 8 31
2 Central Córdoba Rosario Central 14 30 20 30
3 Instituto Instituto 14 20 23 21
4 Quilmes Quilmes 14 17 15 20
5 Almirante Brown Almirante 14 18 19 19
6 Los Andes Los Andes 14 20 23 16
7 Juventud Antoniana Juventud 14 12 23 13
8 Tigre Tigre 14 12 25 8

  USO DE MEMORIA  
5,679,368 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0820
Total Execution Time  0.0839
  CADENA URL  
/primera_b_nacional_clausura2006/grupo1/historico
  GET DATOS  
$_GET['/primera_b_nacional_clausura2006/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0018  SELECT type FROM routes WHERE alias = 'primera_b_nacional_clausura2006'
0.0040  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_clausura' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1774 AND type_rel = 3
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1774 ORDER BY order_id ASC
0.0019  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1774 GROUP BY l.categoryId
0.0018  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=1774 GROUP BY l.year ORDER BY l.year DESC
0.0020  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 = 12945 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1774 AND group_code = 1 and tables = 1 AND year <= 2006 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 12945 AND t.round = 19 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 `tables2005` 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 = 12947 AND t.round = 19 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 `tables2004` 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 = 12948 AND t.round = 19 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 `tables2003` 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 = 27499 AND t.round = 19 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 `tables2002` 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 = 27503 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-06 04:34:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-06 04:34:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-06 04:34:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-06 04:34:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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_clausura' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  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 events2006 e ON e.player_id = p.id AND e.league_id = 12945 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 12945 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.0019  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 events2006 e ON e.player_id = p.id AND e.league_id = 12945 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 12945 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 events2006 e ON e.player_id = p.id AND e.league_id = 12945 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 12945 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0046  SELECT *,(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 = 12945 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC