4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Kisvárda

Kisvárda

Entrenador: Tamás Feczkó

TEMPORADA 2023/2024
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Ferencvárosi Ferencváros 29 71 26 65
2 Fehérvár Fehérvár 29 51 38 50
3 Paksi SE Paksi SE 29 46 39 50
4 Puskás Akadémia Puskás 30 49 31 46
5 MTK Budapest Budapest 29 40 52 43
6 Debreceni VSC Debreceni 29 45 39 42
7 Diósgyőr VTK Diósgyőr 29 48 49 40
8 Zalaegerszegi TE Zalaegerszeg 30 50 56 39
9 Kecskemét Kecskemét 29 40 44 37
10 Újpest FC Újpest FC 29 38 61 34
11 Kisvárda Kisvárda 29 32 46 25
12 Mezőkövesd-Zsory Mezőkövesd 29 25 54 20
TEMPORADA 2022/2023
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Ferencvárosi Ferencváros 33 62 33 63
2 Kecskemét Kecskemét 33 48 32 57
3 Debreceni VSC Debreceni 33 52 39 54
4 Puskás Akadémia Puskás 33 48 42 53
5 Paksi SE Paksi SE 33 57 57 49
6 Kisvárda Kisvárda 33 43 49 43
7 Mezőkövesd-Zsory Mezőkövesd 33 40 43 42
8 Újpest FC Újpest FC 33 42 55 41
9 Zalaegerszegi TE Zalaegerszeg 33 37 43 39
10 Fehérvár Fehérvár 33 38 43 35
11 Budapest Honved Budapest 33 34 51 33
12 Budapesti Vasas Budapesti 33 29 43 26
TEMPORADA 2021/2022
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Ferencvárosi Ferencváros 33 60 31 71
2 Kisvárda Kisvárda 33 50 34 59
3 Puskás Akadémia Puskás 33 43 34 54
4 Fehérvár Fehérvár 33 48 43 48
5 Újpest FC Újpest FC 33 50 48 44
6 Paksi SE Paksi SE 33 75 63 43
7 Debreceni VSC Debreceni 33 45 52 39
8 Zalaegerszegi TE Zalaegerszeg 33 44 58 39
9 Budapest Honved Budapest 33 48 51 38
10 Mezőkövesd-Zsory Mezőkövesd 33 37 49 38
11 MTK Budapest Budapest 33 28 50 36
12 Gyirmot Gyirmot 33 34 49 32
TEMPORADA 2020/2021
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Ferencvárosi Ferencváros 33 69 22 78
2 Puskás Akadémia Puskás 33 52 42 58
3 Fehérvár Fehérvár 33 68 38 56
4 Paksi SE Paksi SE 33 76 64 50
5 Kisvárda Kisvárda 33 30 36 46
6 Újpest FC Újpest FC 33 46 67 42
7 MTK Budapest Budapest 33 44 49 42
8 Mezőkövesd-Zsory Mezőkövesd 33 40 46 42
9 Zalaegerszegi TE Zalaegerszeg 33 58 58 37
10 Budapest Honved Budapest 33 46 48 37
11 Diósgyőr VTK Diósgyőr 33 34 53 33
12 Budafoki Budafoki 33 34 74 27
TEMPORADA 2019/2020
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Ferencvárosi Ferencváros 33 58 24 76
2 Fehérvár Fehérvár 33 56 29 63
3 Puskás Akadémia Puskás 33 52 41 54
4 Mezőkövesd-Zsory Mezőkövesd 33 42 31 50
5 Budapest Honved Budapest 33 36 44 44
6 Újpest FC Újpest FC 33 45 45 43
7 Zalaegerszegi TE Zalaegerszeg 33 51 44 43
8 Kisvárda Kisvárda 33 42 43 42
9 Paksi SE Paksi SE 33 46 53 41
10 Diósgyőr VTK Diósgyőr 33 40 52 41
11 Debreceni VSC Debreceni 33 48 57 39
12 Kaposvari Rakoczi Kaposvari 33 27 80 14
TEMPORADA 2018/2019
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Ferencvárosi Ferencváros 33 72 27 74
2 Fehérvár Fehérvár 33 53 37 61
3 Debreceni VSC Debreceni 33 44 39 51
4 Budapest Honved Budapest 33 46 38 49
5 Újpest FC Újpest FC 33 38 28 48
6 Mezőkövesd-Zsory Mezőkövesd 33 45 40 44
7 Puskás Akadémia Puskás 33 36 45 40
8 Paksi SE Paksi SE 33 33 46 39
9 Kisvárda Kisvárda 33 36 48 38
10 Diósgyőr VTK Diósgyőr 33 36 57 38
11 MTK Budapest Budapest 33 42 56 34
12 Szombathelyi Haladas Szombathelyi 33 31 51 30
TEMPORADA 2017/2018
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 MTK Budapest Budapest 38 88 44 82
2 Kisvárda Kisvárda 38 70 40 75
3 Békéscsaba Békéscsaba 38 64 43 65
4 Budaörsi Budaörsi 38 70 52 63
5 Nyíregyháza Spartacus FC Nyíregyház 38 54 40 60
6 Gyirmot Gyirmot 38 58 46 59
7 Györi ETO Györi ETO 38 55 53 58
8 Soroksár SC Soroksár 38 48 41 56
9 Cegledi Cegledi 38 42 49 52
10 Samsung Vác FC Samsung Vác 38 42 38 51
11 Csákvári TK Csákvári 38 50 66 47
12 Dorogi FC Dorogi FC 38 45 47 46
13 BFC Siófok BFC Siófok 38 40 45 45
14 Budafoki Budafoki 38 42 56 45
15 Mosonmagyaróvári TE Mosonmagyar 38 38 45 45
16 Zalaegerszegi TE Zalaegerszeg 38 45 58 44
17 Kazincbarcika Kazincbarcik 38 39 56 44
18 Szolnoki MÁV Szolnoki 38 38 58 42
19 Szeged 2011 Szeged 2011 38 31 40 41
20 Soproni Vasutas SE Soproni 38 31 73 20
TEMPORADA 2016/2017
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 Puskás Akadémia Puskás 38 67 39 77
2 Balmazujvaros Balmazujvaro 38 49 34 73
3 Kisvárda Kisvárda 38 55 30 69
4 Soroksár SC Soroksár 38 63 40 67
5 Békéscsaba Békéscsaba 38 55 34 65
6 Samsung Vác FC Samsung Vác 38 45 38 59
7 Zalaegerszegi TE Zalaegerszeg 38 56 49 55
8 Dorogi FC Dorogi FC 38 46 35 54
9 Mosonmagyaróvári TE Mosonmagyar 38 48 40 54
10 Szolnoki MÁV Szolnoki 38 49 50 52
11 Szeged 2011 Szeged 2011 38 39 29 51
12 Nyíregyháza Spartacus FC Nyíregyház 38 48 50 50
13 Soproni Vasutas SE Soproni 38 37 38 49
14 BFC Siófok BFC Siófok 38 43 51 48
15 Budaörsi Budaörsi 38 48 56 47
16 Csákvári TK Csákvári 38 44 57 40
17 Cegledi Cegledi 38 42 55 39
18 Kozarmisleny Kozarmisleny 38 33 61 37
19 Cigánd SE Cigánd SE 38 27 64 29
20 Szeol Szeol 38 20 64 19
TEMPORADA 2015/2016
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 Gyirmot Gyirmot 30 58 28 65
2 Mezőkövesd-Zsory Mezőkövesd 30 45 25 57
3 Zalaegerszegi TE Zalaegerszeg 30 55 30 55
4 Kisvárda Kisvárda 30 63 36 52
5 Balmazujvaros Balmazujvaro 30 46 39 51
6 Csákvári TK Csákvári 30 55 55 48
7 Soroksár SC Soroksár 30 45 29 47
8 Budaörsi Budaörsi 30 45 43 43
9 BFC Siófok BFC Siófok 30 36 47 41
10 Szeged 2011 Szeged 2011 30 42 40 40
11 Soproni Vasutas SE Soproni 30 38 42 33
12 Samsung Vác FC Samsung Vác 30 32 51 33
13 Szolnoki MÁV Szolnoki 30 34 41 31
14 Szigetszentmiklosi Szigetszentm 30 31 61 27
15 Dunaújváros Dunaújváro 30 32 63 27
16 FC Ajka FC Ajka 30 24 51 20
TEMPORADA 2014/2015
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Kisvárda Kisvárda 28 92 21 74
2 Putnok VSE Putnok VSE 28 71 24 69
3 FC Hatvan FC Hatvan 28 59 36 51
4 Kazincbarcika Kazincbarcik 28 46 25 51
5 Cigánd SE Cigánd SE 28 46 30 49
6 Tiszaújváros Tiszaújvár 28 36 52 44
7 Budapest Honvéd II Budapest 28 44 29 41
8 Nyírbátori FC Nyírbátori 28 52 51 39
9 Jászberényi Vasas Jászberény 28 46 50 39
10 Debreceni VSC II Debreceni 28 48 33 38
11 Felsőtárkány SE Felsőtárk 28 37 64 31
12 Veresegyhaz VSK Veresegyhaz 28 28 61 24
13 Hajdúböszörményi Hajdúbösz 28 32 57 21
14 Salgótarjáni BTC Salgótarjá 28 32 70 19
15 Gyöngyös Gyöngyös 28 13 79 8
16 Létavértes SC Létavértes 0 0 0 0
TEMPORADA 2012/2013
TERCERA HUNGRÍA GRUPO 6
Equipo PJ GF GC Puntos
1 Kisvárda Kisvárda 26 77 15 63
2 Tiszaújváros Tiszaújvár 26 54 17 54
3 Nyírbátori FC Nyírbátori 26 57 28 54
4 Cigánd SE Cigánd SE 26 41 27 48
5 Létavértes SC Létavértes 26 52 20 47
6 Hajdúböszörményi Hajdúbösz 26 51 44 44
7 Hajdúszoboszlói SE Hajdúszobos 26 43 40 37
8 Tiszakanyár SE Tiszakanyár 26 42 45 36
9 Szatmár Unió Szatmár 26 33 40 33
10 Baktalórántháza VSE Baktalórán 26 37 53 33
11 Ibrány SE Ibrány SE 26 26 34 28
12 Nagyecsed RSE Nagyecsed 26 31 52 23
13 Debreceni EAC Debreceni 26 15 58 13
14 Diósgyőr VTK II Diósgyőr 26 17 103 4
TEMPORADA 2011/2012
TERCERA HUNGRÍA GRUPO 4
Equipo PJ GF GC Puntos
1 Kisvárda Kisvárda 30 78 16 75
2 Nyírbátori FC Nyírbátori 30 76 26 65
3 Cigánd SE Cigánd SE 30 56 36 64
4 Létavértes SC Létavértes 30 59 26 57
5 Tiszakanyár SE Tiszakanyár 30 59 35 55
6 Hajdúszoboszlói SE Hajdúszobos 30 51 25 54
7 Kemecse Kemecse 30 59 42 46
8 Debreceni EAC Debreceni 30 52 40 46
9 Nagyecsed RSE Nagyecsed 30 49 43 46
10 Baktalórántháza VSE Baktalórán 30 62 55 40
11 Hajdúböszörményi Hajdúbösz 30 57 51 35
12 Ibrány SE Ibrány SE 30 36 58 26
13 Tiszalöki VSE Tiszalöki 30 33 72 25
14 Kótaj SE Kótaj SE 30 28 63 19
15 Tuzsér SE Tuzsér SE 30 28 105 17
16 Sárospataki TC Sárospataki 30 19 109 9
TEMPORADA 2008/2009
TERCERA HUNGRÍA GRUPO 6
Equipo PJ GF GC Puntos
1 Hajdúböszörményi Hajdúbösz 30 54 18 63
2 Nagyecsed RSE Nagyecsed 30 56 35 57
3 Nyirmadai ISE Nyirmadai 30 53 33 52
4 Kisvárda Kisvárda 30 49 36 50
5 Kemecse Kemecse 29 47 27 48
6 Ibrány SE Ibrány SE 30 55 47 47
7 Diósgyőr VTK II Diósgyőr 30 43 44 46
8 Nyíregyháza Spartacus II Nyíregyház 30 39 35 43
9 Tiszakanyár SE Tiszakanyár 30 48 48 42
10 Létavértes SC Létavértes 30 32 36 37
11 Berettyoujfalui Berettyoujfa 30 36 47 37
12 Tuzsér SE Tuzsér SE 30 44 51 34
13 Tiszalöki VSE Tiszalöki 29 44 46 33
14 Balkanyi Balkanyi 30 35 65 33
15 Hajdúszoboszlói SE Hajdúszobos 30 30 57 28
16 Volan Senyo Volan Senyo 30 25 65 20

  USO DE MEMORIA  
6,583,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.3604
Total Execution Time  0.3616
  CADENA URL  
/historico/Varda-Se
  GET DATOS  
$_GET['/historico/Varda-Se']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20441 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 20441 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  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 (604900,628823,846526,901439,1145240) ORDER BY n.cover_points DESC, update_date DESC
0.0129  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 = '20441' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 72191 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0129  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 = 20441 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128  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 `tables2024` 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 = 72191 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2023` 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 = 68146 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables2022` 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 = 63100 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables2021` 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 = 56837 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables2020` 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 = 49916 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2019` 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 = 43696 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2018` 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 = 39020 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables2017` 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 = 33936 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 `tables2016` 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 = 15505 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables2015` 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 = 4412 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables2013` 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 = 24577 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 24613 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 24681 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72191 ORDER BY nameShow LIMIT 100