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

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

Liga Hungría 2006

  • Debreceni VSC
  • Újpest FC
  • Fehérvár
  • MTK Budapest
  • Ferencvárosi
  • Tatabánya
  • Kaposvari Rakoczi
  • Diósgyőr VTK
  • Györi ETO
  • Sopron
  • Zalaegerszegi TE
  • Pécsi MFC
  • Budapest Honved
  • REAC
  • Budapesti Vasas
  • Lombard Pápa TFC

Clasificación

Equipo PJ GF GC Puntos
1 Debreceni VSC Debreceni 30 69 34 68
2 Újpest FC Újpest FC 30 74 37 65
3 Fehérvár Fehérvár 30 52 24 64
4 MTK Budapest Budapest 30 65 33 60
5 Ferencvárosi Ferencváros 30 43 38 41
6 Tatabánya Tatabánya 30 46 45 41
7 Kaposvari Rakoczi Kaposvari 30 35 41 37
8 Diósgyőr VTK Diósgyőr 30 33 44 37
9 Györi ETO Györi ETO 30 47 50 36
10 Sopron Sopron 30 39 39 35
11 Zalaegerszegi TE Zalaegerszeg 30 42 47 35
12 Pécsi MFC Pécsi MFC 30 37 41 33
13 Budapest Honved Budapest 30 33 52 33
14 REAC REAC 30 30 59 26
15 Budapesti Vasas Budapesti 30 32 47 25
16 Lombard Pápa TFC Lombard 30 30 76 22

  USO DE MEMORIA  
5,239,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.1308
Total Execution Time  0.1341
  CADENA URL  
/hungria2006/grupo1/resumen/30
  GET DATOS  
$_GET['/hungria2006/grupo1/resumen/30']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0018  SELECT type FROM routes WHERE alias = 'hungria2006'
0.0040  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 = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=95 ORDER BY order_id ASC
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 = 667 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2 FROM `calendars2006` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 667 AND c.`round` = 30 ORDER BY shedule ASC LIMIT 200
0.0099  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2006` e INNER JOIN calendars2006 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 30 AND e.real_date IS NOT NULL AND e.league_id = 667 ORDER BY total DESC LIMIT 100
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 11:02:15' 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-28 11:02:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 11:02:15' 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-28 11:02:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0033  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 = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0157  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 = 667 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 667 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.0159  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 = 667 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 667 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0129  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 = 667 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 667 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0054  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 = 667 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC