4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1991/1992
Equipo PJ GF GC Puntos
1 Newell's Old Boys Newell's 19 27 8 40
2 Vélez Sarsfield Vélez 19 29 16 37
3 Dep. Español Dep. 19 24 11 36
4 Boca Juniors Boca Juniors 19 20 11 36
5 River Plate River Plate 19 31 22 32
6 Platense Platense 19 23 16 30
7 Gimnasia La Plata Gimnasia 19 25 20 26
8 Racing Club Racing Club 19 12 9 26
9 Rosario Central Rosario 19 19 24 25
10 Belgrano Belgrano 19 18 18 24
11 CA Huracán CA Huracán 19 18 19 24
12 Ferro Carril Oeste Ferro Carril 19 13 14 23
13 Independiente Independient 19 16 16 21
14 Argentinos Juniors Argentinos 19 16 19 21
15 Talleres Córdoba Talleres 19 14 17 21
16 CD Mandiyú CD Mandiyú 19 16 30 16
17 Unión Santa Fe Unión Santa 19 11 18 15
18 Estudiantes La Plata Estudiantes 19 14 26 15
19 San Lorenzo San Lorenzo 19 11 25 15
20 Quilmes Quilmes 19 14 32 15
Ver
TEMPORADA 1990/1991
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 19 32 6 45
2 San Lorenzo San Lorenzo 19 29 18 38
3 Racing Club Racing Club 19 23 22 32
4 CD Mandiyú CD Mandiyú 19 20 13 31
5 Independiente Independient 19 22 15 28
6 Vélez Sarsfield Vélez 19 25 22 28
7 CA Huracán CA Huracán 19 16 16 28
8 Newell's Old Boys Newell's 19 21 14 26
9 Estudiantes La Plata Estudiantes 19 18 15 25
10 Lanús Lanús 19 15 15 24
11 River Plate River Plate 19 19 19 23
12 Platense Platense 19 10 16 22
13 Unión Santa Fe Unión Santa 19 21 26 21
14 Gimnasia La Plata Gimnasia 19 16 22 21
15 Rosario Central Rosario 19 15 23 20
16 Dep. Español Dep. 19 22 25 18
17 Ferro Carril Oeste Ferro Carril 19 15 20 17
18 Argentinos Juniors Argentinos 19 19 30 16
19 Talleres Córdoba Talleres 19 24 34 15
20 Chaco For Ever Chaco Ever 19 15 26 13

  USO DE MEMORIA  
5,305,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0027
Controller Execution Time ( Home / Category )  0.3561
Total Execution Time  0.3588
  CADENA URL  
/torneo_final1992/grupo1/historico
  GET DATOS  
$_GET['/torneo_final1992/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0147  SELECT type FROM routes WHERE alias = 'torneo_final1992'
0.0304  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_final' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1992 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0155  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 = 8421 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0154  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 118 AND group_code = 1 and tables = 1 AND year <= 1992 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0176  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 `tables1992` 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 = 8421 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 `tables1991` 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 = 8422 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 09:36:51' 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-05-01 09:36:51' 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-05-01 09:36:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 09:36:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0154  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_final' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1992 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0149  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 events1992 e ON e.player_id = p.id AND e.league_id = 8421 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8421 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.0151  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 events1992 e ON e.player_id = p.id AND e.league_id = 8421 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8421 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 events1992 e ON e.player_id = p.id AND e.league_id = 8421 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8421 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0224  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1992` 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 = 8421 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC