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

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

Liga Hungría 1998

  • Újpest FC
  • Ferencvárosi
  • Budapesti Vasas
  • Györi ETO
  • MTK Budapest
  • Samsung Vác FC
  • Zalaegerszegi TE
  • Gazszer
  • Debreceni VSC
  • Budapest BVSC
  • Diósgyőr VTK
  • BFC Siófok
  • Szombathelyi Haladas
  • Budapest Honved
  • Tiszakécske
  • Fehérvár
  • Békéscsaba
  • Stadler
Ver
TEMPORADA 1997/1998
Equipo PJ GF GC Puntos
1 Újpest FC Újpest FC 34 62 26 73
2 Ferencvárosi Ferencváros 34 63 43 67
3 Budapesti Vasas Budapesti 34 66 41 64
4 Györi ETO Györi ETO 34 47 31 63
5 MTK Budapest Budapest 34 60 35 58
6 Samsung Vác FC Samsung Vác 34 45 47 51
7 Zalaegerszegi TE Zalaegerszeg 34 58 42 50
8 Gazszer Gazszer 34 55 45 49
9 Debreceni VSC Debreceni 34 46 48 48
10 Budapest BVSC Budapest 34 49 43 46
11 Diósgyőr VTK Diósgyőr 34 46 41 44
12 BFC Siófok BFC Siófok 34 38 43 41
13 Szombathelyi Haladas Szombathelyi 34 38 47 36
14 Budapest Honved Budapest 34 41 57 36
15 Tiszakécske Tiszakécske 34 36 75 32
16 Fehérvár Fehérvár 34 43 58 31
17 Békéscsaba Békéscsaba 34 28 61 31
18 Stadler Stadler 34 29 67 22
Ver
TEMPORADA 1996/1997
Equipo PJ GF GC Puntos
1 MTK Budapest Budapest 34 87 25 85
2 Újpest FC Újpest FC 34 75 35 76
3 Ferencvárosi Ferencváros 34 69 37 74
4 Budapesti Vasas Budapesti 34 50 33 64
5 Debreceni VSC Debreceni 34 55 38 52
6 Budapest BVSC Budapest 34 43 36 49
7 Budapest Honved Budapest 34 42 44 45
8 Fehérvár Fehérvár 34 45 44 42
9 Györi ETO Györi ETO 34 44 51 42
10 Szombathelyi Haladas Szombathelyi 34 39 42 40
11 Samsung Vác FC Samsung Vác 34 40 48 40
12 BFC Siófok BFC Siófok 34 36 53 40
13 Zalaegerszegi TE Zalaegerszeg 34 34 51 40
14 Békéscsaba Békéscsaba 34 37 62 36
15 III. Kerületi TVE III. 34 45 55 35
16 Stadler Stadler 34 27 50 28
17 Pécsi MFC Pécsi MFC 34 31 68 26
18 Csepel FC Csepel FC 34 43 70 25
Ver
TEMPORADA 1995/1996
Equipo PJ GF GC Puntos
1 Ferencvárosi Ferencváros 30 56 25 66
2 Budapest BVSC Budapest 30 50 29 61
3 Újpest FC Újpest FC 30 43 31 48
4 Debreceni VSC Debreceni 30 49 40 48
5 MTK Budapest Budapest 30 58 43 46
6 Budapest Honved Budapest 30 49 35 46
7 Budapesti Vasas Budapesti 30 44 40 46
8 Csepel FC Csepel FC 30 46 45 42
9 Stadler Stadler 30 35 41 36
10 Zalaegerszegi TE Zalaegerszeg 30 42 48 34
11 Samsung Vác FC Samsung Vác 30 39 46 33
12 Szombathelyi Haladas Szombathelyi 30 30 48 32
13 Fehérvár Fehérvár 30 38 54 31
14 Békéscsaba Békéscsaba 30 33 46 29
15 Györi ETO Györi ETO 30 34 54 27
16 Pécsi MFC Pécsi MFC 30 32 53 26
Ver
TEMPORADA 1994/1995
Equipo PJ GF GC Puntos
1 Ferencvárosi Ferencváros 30 62 41 59
2 Újpest FC Újpest FC 30 57 34 52
3 Debreceni VSC Debreceni 30 45 37 49
4 Budapest Honved Budapest 30 60 42 48
5 Békéscsaba Békéscsaba 30 47 32 48
6 Budapest BVSC Budapest 30 51 46 46
7 Pécsi MFC Pécsi MFC 30 38 43 42
8 Zalaegerszegi TE Zalaegerszeg 30 49 56 42
9 Györi ETO Györi ETO 30 42 40 38
10 Stadler Stadler 30 30 34 37
11 Budapesti Vasas Budapesti 30 38 45 37
12 Csepel FC Csepel FC 30 23 26 35
13 Samsung Vác FC Samsung Vác 30 37 44 35
14 Fehérvár Fehérvár 30 44 50 34
15 Sopron Sopron 30 36 56 28
16 Nagykanizsa Nagykanizsa 30 24 57 27
Ver
TEMPORADA 1989/1990
Equipo PJ GF GC Puntos
1 Újpest FC Újpest FC 30 43 20 58
2 MTK Budapest Budapest 30 48 26 58
3 Ferencvárosi Ferencváros 30 48 34 48
4 Pécsi MFC Pécsi MFC 30 37 23 48
5 Tatabánya Tatabánya 30 24 28 43
6 Veszprém Veszprém 30 27 24 41
7 BFC Siófok BFC Siófok 30 31 34 39
8 Budapesti Vasas Budapesti 30 35 42 39
9 Fehérvár Fehérvár 30 26 30 38
10 Békéscsaba Békéscsaba 30 26 34 38
11 Samsung Vác FC Samsung Vác 30 30 31 36
12 Györi ETO Györi ETO 30 34 30 35
13 Budapest Honved Budapest 30 31 39 35
14 Debreceni VSC Debreceni 30 20 30 35
15 Szombathelyi Haladas Szombathelyi 30 33 46 33
16 Csepel FC Csepel FC 30 27 49 25
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  
5,716,976 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3477
Total Execution Time  0.3496
  CADENA URL  
/hungria1998/grupo1/historico
  GET DATOS  
$_GET['/hungria1998/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0106  SELECT type FROM routes WHERE alias = 'hungria1998'
0.0213  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 = 1998 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=95 AND type_rel = 3
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 95 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0110  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1305161,1268453,1213703,1180004,1177461) ORDER BY n.cover_points DESC, update_date DESC
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=95 ORDER BY order_id ASC
0.0107  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 = 13983 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 95 AND group_code = 1 and tables = 1 AND year <= 1998 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0111  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 `tables1998` 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 = 13983 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 `tables1997` 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 = 13985 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 `tables1996` 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 = 13986 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables1995` 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 = 26389 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 `tables1990` 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 = 26393 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-10 01:04:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-10 01:04:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-10 01:04:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-10 01:04:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0112  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 = 1998 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0107  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 events1998 e ON e.player_id = p.id AND e.league_id = 13983 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 13983 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.0107  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 events1998 e ON e.player_id = p.id AND e.league_id = 13983 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 13983 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0108  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 events1998 e ON e.player_id = p.id AND e.league_id = 13983 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 13983 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0148  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1998` 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 = 13983 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC