4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Diósgyőr VTK

Diósgyőr VTK

Entrenador: Vladimir Radenkovic

Temporada 2011/2012
TEMPORADA 2011/2012
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Debreceni VSC Debreceni 30 64 18 74
2 Fehérvár Fehérvár 30 58 19 66
3 Györi ETO Györi ETO 30 56 31 63
4 Budapest Honved Budapest 30 48 40 46
5 Kecskemét Kecskemét 30 47 39 45
6 Paksi SE Paksi SE 30 47 51 45
7 Diósgyőr VTK Diósgyőr 30 42 43 43
8 Szombathelyi Haladas Szombathelyi 30 39 37 38
9 BFC Siófok BFC Siófok 30 30 41 36
10 Kaposvari Rakoczi Kaposvari 30 35 42 35
11 Ferencvárosi Ferencváros 30 32 35 34
12 Pécsi MFC Pécsi MFC 30 36 50 34
13 Újpest FC Újpest FC 30 34 46 32
14 Lombard Pápa TFC Lombard 30 26 40 30
15 Budapesti Vasas Budapesti 30 29 51 22
16 Zalaegerszegi TE Zalaegerszeg 30 25 65 13
TEMPORADA 2010/2011
SEGUNDA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Diósgyőr VTK Diósgyőr 30 66 23 68
2 Mezőkövesd-Zsory Mezőkövesd 30 47 20 62
3 Nyíregyháza Spartacus FC Nyíregyház 30 66 23 60
4 Samsung Vác FC Samsung Vác 30 47 27 60
5 MTK Budapest II Budapest 30 48 34 55
6 Békéscsaba Békéscsaba 30 45 40 43
7 Vecsés FC Vecsés FC 30 36 37 38
8 Debreceni VSC II Debreceni 30 37 45 37
9 Újpest FC II Újpest 30 43 58 35
10 REAC REAC 30 30 38 33
11 Kazincbarcika Kazincbarcik 30 37 60 31
12 Hajdúböszörményi Hajdúbösz 30 29 42 30
13 Cegledi Cegledi 30 46 61 30
14 Orosháza Orosháza 30 32 51 30
15 Makó FC Makó FC 30 30 54 30
16 Bocs KSC Bocs KSC 30 27 53 22
TEMPORADA 2009/2010
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Debreceni VSC Debreceni 30 63 37 62
2 Fehérvár Fehérvár 30 59 31 61
3 Györi ETO Györi ETO 30 38 18 57
4 Újpest FC Újpest FC 30 49 39 55
5 Zalaegerszegi TE Zalaegerszeg 30 59 45 53
6 MTK Budapest Budapest 30 52 41 43
7 Ferencvárosi Ferencváros 30 35 35 41
8 Szombathelyi Haladas Szombathelyi 30 46 49 39
9 Budapest Honved Budapest 30 38 35 38
10 Kecskemét Kecskemét 30 50 56 37
11 Lombard Pápa TFC Lombard 30 39 50 35
12 Kaposvari Rakoczi Kaposvari 30 38 50 32
13 Paksi SE Paksi SE 30 31 44 31
14 Budapesti Vasas Budapesti 30 39 61 31
15 Nyíregyháza Spartacus FC Nyíregyház 30 41 60 27
16 Diósgyőr VTK Diósgyőr 30 31 57 17
TEMPORADA 2008/2009
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Debreceni VSC Debreceni 30 70 29 68
2 Újpest FC Újpest FC 30 61 38 59
3 Szombathelyi Haladas Szombathelyi 30 44 29 53
4 Zalaegerszegi TE Zalaegerszeg 30 52 44 52
5 Kecskemét Kecskemét 30 55 44 48
6 Fehérvár Fehérvár 30 42 34 48
7 MTK Budapest Budapest 30 43 41 45
8 Györi ETO Györi ETO 30 57 41 43
9 Kaposvari Rakoczi Kaposvari 30 51 46 40
10 Budapesti Vasas Budapesti 30 42 52 38
11 Paksi SE Paksi SE 30 38 51 35
12 Diósgyőr VTK Diósgyőr 30 29 45 33
13 Nyíregyháza Spartacus FC Nyíregyház 30 32 41 32
14 Budapest Honved Budapest 30 31 46 32
15 BFC Siófok BFC Siófok 30 30 56 26
16 REAC REAC 30 33 73 15
TEMPORADA 2007/2008
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 MTK Budapest Budapest 30 67 23 66
2 Debreceni VSC Debreceni 30 67 29 64
3 Györi ETO Györi ETO 30 64 35 58
4 Újpest FC Újpest FC 30 58 40 55
5 Fehérvár Fehérvár 30 48 32 54
6 Kaposvari Rakoczi Kaposvari 30 48 38 51
7 Zalaegerszegi TE Zalaegerszeg 30 55 39 46
8 Budapest Honved Budapest 30 45 36 43
9 Budapesti Vasas Budapesti 30 41 45 41
10 Nyíregyháza Spartacus FC Nyíregyház 30 34 37 40
11 Paksi SE Paksi SE 30 51 51 37
12 REAC REAC 30 42 60 30
13 Diósgyőr VTK Diósgyőr 30 43 63 28
14 BFC Siófok BFC Siófok 30 33 46 27
15 Tatabánya Tatabánya 30 34 93 10
16 Sopron Sopron 30 10 73 0
TEMPORADA 2006/2007
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Debreceni VSC Debreceni 30 63 21 69
2 MTK Budapest Budapest 30 61 33 61
3 Zalaegerszegi TE Zalaegerszeg 30 54 38 55
4 Újpest FC Újpest FC 30 39 32 46
5 Budapesti Vasas Budapesti 30 43 41 45
6 Fehérvár Fehérvár 30 45 43 44
7 Budapest Honved Budapest 30 48 43 41
8 Kaposvari Rakoczi Kaposvari 30 40 36 41
9 Diósgyőr VTK Diósgyőr 30 40 52 38
10 Paksi SE Paksi SE 30 34 38 37
11 Sopron Sopron 30 33 46 37
12 Tatabánya Tatabánya 30 46 58 36
13 Györi ETO Györi ETO 30 37 43 35
14 REAC REAC 30 42 55 34
15 Pécsi MFC Pécsi MFC 30 31 41 33
16 Samsung Vác FC Samsung Vác 30 21 57 19
TEMPORADA 2005/2006
LIGA HUNGRÍA
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
TEMPORADA 2004/2005
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Debreceni VSC Debreceni 30 57 25 62
2 Ferencvárosi Ferencváros 30 56 31 56
3 MTK Budapest Budapest 30 47 26 56
4 Újpest FC Újpest FC 30 60 34 55
5 Györi ETO Györi ETO 30 44 32 54
6 Zalaegerszegi TE Zalaegerszeg 30 48 45 44
7 Sopron Sopron 30 44 44 42
8 Fehérvár Fehérvár 30 44 36 40
9 Diósgyőr VTK Diósgyőr 30 39 45 37
10 Pécsi MFC Pécsi MFC 30 33 35 36
11 Budapest Honved Budapest 30 37 58 35
12 Kaposvari Rakoczi Kaposvari 30 34 47 34
13 Budapesti Vasas Budapesti 30 34 48 33
14 Lombard Pápa TFC Lombard 30 40 47 30
15 Nyíregyháza Spartacus FC Nyíregyház 30 38 63 26
16 Békéscsaba Békéscsaba 30 26 65 4
TEMPORADA 2003/2004
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 Budapest Honved Budapest 33 75 23 75
2 Budapesti Vasas Budapesti 33 57 36 61
3 Kaposvari Rakoczi Kaposvari 33 52 31 60
4 Diósgyőr VTK Diósgyőr 33 54 43 57
5 Nyíregyháza Spartacus FC Nyíregyház 33 40 36 55
6 REAC REAC 33 46 37 52
7 BKV Előre BKV Előre 33 39 36 48
8 Tatabánya Tatabánya 33 44 41 45
9 Lombard Pápa TFC Lombard 33 46 53 45
10 Balassagyarmat VSE Balassagyarm 33 36 35 43
11 Bodajk FC Bodajk FC 33 49 50 42
12 Kecskemét Kecskemét 33 33 33 41
13 Szeged SC Szeged SC 33 44 63 38
14 Szolnoki MÁV Szolnoki 33 42 43 37
15 Samsung Vác FC Samsung Vác 33 38 54 35
16 Dunaújváros Dunaújváro 33 37 51 34
17 Dabas Dabas 33 37 60 33
18 Héviz FC Héviz FC 33 32 76 23
TEMPORADA 1997/1998
LIGA HUNGRÍA
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

  USO DE MEMORIA  
6,516,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0034
Controller Execution Time ( Home / Category )  0.6168
Total Execution Time  0.6203
  CADENA URL  
/historico/Diosgyori-Vtk/2012
  GET DATOS  
$_GET['/historico/Diosgyori-Vtk/2012']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0163  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Diosgyori-Vtk' AND l.year = 2012 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0147  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=927 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=927 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=927 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=927 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=927 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=927 AND type_rel = 2
0.0156  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 927 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0157  SELECT /*35 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 (109675,417137,439526,440630,469877) ORDER BY n.cover_points DESC, update_date DESC
0.0174  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '927' AND l.year = 2012 ORDER BY l.year DESC,cat.coefficient DESC
0.0175  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '927' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0174  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=927 AND l.year in (2011,2012,2013) ORDER BY l.id DESC, l.year DESC ;
0.0155  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (22509,21232,14528,2036,1323) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0171  SELECT count(id) as num_players from rel_players WHERE league_id = 2036 AND teamId = 927
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 14528 AND teamId = 927
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 21232 AND teamId = 927
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 22509 AND teamId = 927
0.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 1323 AND teamId = 927
0.0163  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2012 e ON e.player_id = p.id AND e.league_id = 1365 WHERE rp.league_id = 1365 AND rp.teamId = 927 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0171  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2012 e ON e.player_id = p.id AND e.league_id = 1365 WHERE rp.league_id = 1365 AND rp.teamId = 927 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0173  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2012 e ON e.player_id = p.id AND e.league_id = 1365 WHERE rp.league_id = 1365 AND rp.teamId = 927 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 927 AND l.year <= 2012 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0149  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 `tables2012` 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 = 1365 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2011` 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 = 14528 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables2010` 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 = 872 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2009` 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 = 453 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables2008` 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 = 665 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables2007` 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 = 666 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `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
0.0154  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 `tables2005` 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 = 668 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 14516 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167  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