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

  USO DE MEMORIA  
5,464,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3642
Total Execution Time  0.3662
  CADENA URL  
/primera_b_nacional_apertura2004/grupo1/historico
  GET DATOS  
$_GET['/primera_b_nacional_apertura2004/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0125  SELECT type FROM routes WHERE alias = 'primera_b_nacional_apertura2004'
0.0254  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_apertura' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2004 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1773 AND type_rel = 3
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1773 ORDER BY order_id ASC
0.0125  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1773 GROUP BY l.categoryId
0.0125  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=1773 GROUP BY l.year ORDER BY l.year DESC
0.0130  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 = 27496 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1773 AND group_code = 1 and tables = 1 AND year <= 2004 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0131  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 = 27496 AND t.round = 19 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 `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 = 27497 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 27498 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 13:59:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 13:59:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 13:59:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 13:59:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  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_apertura' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2004 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0126  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 events2004 e ON e.player_id = p.id AND e.league_id = 27496 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 27496 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.0126  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 events2004 e ON e.player_id = p.id AND e.league_id = 27496 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 27496 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  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 events2004 e ON e.player_id = p.id AND e.league_id = 27496 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 27496 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0138  SELECT *,(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 = 27496 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC