4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1989
Temporada Siguiente »
Liga Hungría 1989 G 1
1988/1989

nemzeti bajnoksag 1, primera division de hungria, primera division hungara, nb1, OTP Bank Liga,liga hungria,liga hungara

Liga Hungría 1989 G 1

  • Fehérvár
  • Ferencvárosi
  • Budapest Honved
  • Györi ETO
  • MTK Budapest
  • Tatabánya
  • Békéscsaba
  • Samsung Vác FC
  • Újpest FC
  • Pécsi MFC
  • Veszprém
  • BFC Siófok
  • Budapesti Vasas
  • Zalaegerszegi TE
  • Szombathelyi Haladas
  • Dunaújváros
Ver
TEMPORADA 1988/1989
Equipo PJ GF GC Puntos
1 Fehérvár Fehérvár 30 57 32 56
2 Ferencvárosi Ferencváros 30 49 29 55
3 Budapest Honved Budapest 30 44 28 55
4 Györi ETO Györi ETO 30 44 31 53
5 MTK Budapest Budapest 30 41 34 50
6 Tatabánya Tatabánya 30 39 35 45
7 Békéscsaba Békéscsaba 30 40 36 42
8 Samsung Vác FC Samsung Vác 30 33 34 40
9 Újpest FC Újpest FC 30 37 35 39
10 Pécsi MFC Pécsi MFC 30 35 37 37
11 Veszprém Veszprém 30 23 35 35
12 BFC Siófok BFC Siófok 30 34 41 34
13 Budapesti Vasas Budapesti 30 35 58 33
14 Zalaegerszegi TE Zalaegerszeg 30 38 45 30
15 Szombathelyi Haladas Szombathelyi 30 31 44 30
16 Dunaújváros Dunaújváro 30 26 52 20

  USO DE MEMORIA  
4,953,024 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0604
Total Execution Time  0.0624
  CADENA URL  
/hungria1989/grupo1/historico
  GET DATOS  
$_GET['/hungria1989/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0017  SELECT type FROM routes WHERE alias = 'hungria1989'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'hungria' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1989 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=95 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=95 ORDER BY order_id ASC
0.0019  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 = 26390 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 95 AND group_code = 1 and tables = 1 AND year <= 1989 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `tables1989` 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 = 26390 AND t.round = 30 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-04-27 10:12:14' 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-04-27 10:12:14' 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-04-27 10:12:14' 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-04-27 10:12:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'hungria' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1989 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  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 events1989 e ON e.player_id = p.id AND e.league_id = 26390 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 26390 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.0020  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 events1989 e ON e.player_id = p.id AND e.league_id = 26390 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 26390 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 events1989 e ON e.player_id = p.id AND e.league_id = 26390 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 26390 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0048  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1989` 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 = 26390 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC