4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Budafoki
TEMPORADA 2023/2024
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 Nyíregyháza Spartacus FC Nyíregyház 29 60 23 67
2 Budapesti Vasas Budapesti 29 61 29 57
3 Györi ETO Györi ETO 29 50 32 54
4 Szeged 2011 Szeged 2011 29 30 18 54
5 Kozarmisleny Kozarmisleny 29 46 35 46
6 Gyirmot Gyirmot 29 40 33 44
7 Soroksár SC Soroksár 29 33 34 41
8 Budapest Honved Budapest 29 35 30 39
9 FC Ajka FC Ajka 29 25 27 37
10 Szombathelyi Haladas Szombathelyi 29 38 42 37
11 Kazincbarcika Kazincbarcik 29 29 33 37
12 Csákvári TK Csákvári 29 32 38 37
13 Budafoki Budafoki 29 31 42 33
14 Pécsi MFC Pécsi MFC 29 16 32 31
15 Budapest BVSC Budapest 29 22 37 30
16 BFC Siófok BFC Siófok 29 31 52 27
17 Tiszakécske Tiszakécske 29 26 35 25
18 Mosonmagyaróvári TE Mosonmagyar 29 21 54 17
TEMPORADA 2022/2023
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 Diósgyőr VTK Diósgyőr 38 79 36 87
2 MTK Budapest Budapest 38 86 48 74
3 FC Ajka FC Ajka 38 54 37 68
4 Szeged 2011 Szeged 2011 38 50 38 64
5 Soroksár SC Soroksár 38 57 48 61
6 Gyirmot Gyirmot 38 59 46 60
7 Pécsi MFC Pécsi MFC 38 38 31 58
8 BFC Siófok BFC Siófok 38 45 51 56
9 Szombathelyi Haladas Szombathelyi 38 54 56 51
10 Budafoki Budafoki 38 39 46 47
11 Tiszakécske Tiszakécske 38 38 50 46
12 Mosonmagyaróvári TE Mosonmagyar 38 36 44 46
13 Györi ETO Györi ETO 38 37 42 46
14 Kazincbarcika Kazincbarcik 38 41 56 45
15 Csákvári TK Csákvári 38 44 50 42
16 Kozarmisleny Kozarmisleny 38 46 63 41
17 Szentlőrinc SE Szentlőrinc 38 44 58 39
18 Nyíregyháza Spartacus FC Nyíregyház 38 46 55 38
19 Békéscsaba Békéscsaba 38 47 56 37
20 Dorogi FC Dorogi FC 38 32 61 31
TEMPORADA 2021/2022
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 Budapesti Vasas Budapesti 38 80 22 85
2 Kecskemét Kecskemét 38 75 36 77
3 Diósgyőr VTK Diósgyőr 38 57 40 72
4 Szeged 2011 Szeged 2011 38 64 34 66
5 BFC Siófok BFC Siófok 38 42 37 59
6 Szombathelyi Haladas Szombathelyi 38 37 30 57
7 Györi ETO Györi ETO 38 57 46 56
8 Soroksár SC Soroksár 38 67 61 52
9 FC Ajka FC Ajka 38 49 49 51
10 Nyíregyháza Spartacus FC Nyíregyház 38 45 51 50
11 Pécsi MFC Pécsi MFC 38 38 39 48
12 Csákvári TK Csákvári 38 52 57 43
13 Tiszakécske Tiszakécske 38 41 65 42
14 Budafoki Budafoki 38 39 50 42
15 Békéscsaba Békéscsaba 38 53 69 42
16 Szentlőrinc SE Szentlőrinc 38 39 57 42
17 Dorogi FC Dorogi FC 38 35 60 41
18 Szolnoki MÁV Szolnoki 38 35 55 38
19 Budaörsi Budaörsi 38 40 61 38
20 III. Kerületi TVE III. 38 36 62 37
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
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 MTK Budapest Budapest 27 60 33 59
2 Budafoki Budafoki 27 42 23 54
3 Budapesti Vasas Budapesti 27 55 39 47
4 Csákvári TK Csákvári 26 40 43 43
5 BFC Siófok BFC Siófok 26 40 31 42
6 Györi ETO Györi ETO 27 36 32 41
7 Gyirmot Gyirmot 27 32 29 38
8 Nyíregyháza Spartacus FC Nyíregyház 27 45 45 35
9 FC Ajka FC Ajka 26 41 40 35
10 Soroksár SC Soroksár 26 38 44 35
11 Budaörsi Budaörsi 26 38 37 34
12 Szeged 2011 Szeged 2011 26 31 29 34
13 Dorogi FC Dorogi FC 26 29 29 33
14 Kazincbarcika Kazincbarcik 27 33 38 33
15 Békéscsaba Békéscsaba 26 30 35 32
16 Szolnoki MÁV Szolnoki 26 22 27 31
17 Szombathelyi Haladas Szombathelyi 27 32 34 30
18 Tiszakécske Tiszakécske 27 25 50 26
19 Samsung Vác FC Samsung Vác 27 17 48 12
20 Balmazujvaros Balmazujvaro 0 0 0 0
TEMPORADA 2018/2019
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 Zalaegerszegi TE Zalaegerszeg 38 77 41 82
2 Kaposvari Rakoczi Kaposvari 38 62 41 74
3 Gyirmot Gyirmot 38 75 50 65
4 Budapesti Vasas Budapesti 38 73 64 65
5 Budaörsi Budaörsi 38 65 46 64
6 Békéscsaba Békéscsaba 38 56 49 60
7 Soroksár SC Soroksár 38 68 61 59
8 Györi ETO Györi ETO 38 60 46 58
9 Kazincbarcika Kazincbarcik 38 59 50 56
10 Nyíregyháza Spartacus FC Nyíregyház 38 53 49 56
11 Csákvári TK Csákvári 38 57 59 52
12 BFC Siófok BFC Siófok 38 49 53 47
13 Samsung Vác FC Samsung Vác 38 44 51 46
14 Dorogi FC Dorogi FC 38 54 59 43
15 Tiszakécske Tiszakécske 38 34 52 43
16 Budafoki Budafoki 38 46 66 41
17 Balmazujvaros Balmazujvaro 38 33 48 40
18 Cegledi Cegledi 38 35 68 32
19 Mosonmagyaróvári TE Mosonmagyar 38 35 61 31
20 Monori SE Monori SE 38 49 70 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
TERCERA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Budafoki Budafoki 34 75 24 87
2 Pécsi MFC Pécsi MFC 34 92 22 76
3 Szigetszentmiklosi Szigetszentm 34 77 39 68
4 Dunaújváros Dunaújváro 34 77 41 64
5 Hódmezővásárhelyi Hódmezővá 34 47 37 58
6 Paksi SE II Paksi SE II 34 58 45 53
7 Szekszárdi UFC Szekszárdi 34 38 32 52
8 Szentlőrinc SE Szentlőrinc 34 53 56 47
9 Penzugyor Penzugyor 34 43 48 46
10 Dabas Dabas 34 31 38 43
11 Dunaharaszti MTK Dunaharaszti 34 39 47 42
12 Ferencváros II Ferencváros 34 50 54 41
13 Mórahalom Mórahalom 34 50 57 39
14 Bekescsaba B Bekescsaba 34 44 66 36
15 Gyulai Termál Gyulai 34 29 56 36
16 Dabas-Gyón Dabas-Gyón 34 39 92 31
17 Méhkeréki Méhkeréki 34 34 58 29
18 Komlói Bányász SK Komlói 34 24 88 9

  USO DE MEMORIA  
6,203,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1293
Total Execution Time  0.1312
  CADENA URL  
/historico/Budafoki-Mte
  GET DATOS  
$_GET['/historico/Budafoki-Mte']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0032  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 = 'Budafoki-Mte' AND l.year = 2024 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.0018  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=89646 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=89646 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=89646 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=89646 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=89646 AND type_rel = 2
0.0023  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 = '89646' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '89646' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72462 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0052  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=89646 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (73256,72462,71432) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72462 AND teamId = 89646
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 73256 AND teamId = 89646
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 89646
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 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 = 72462 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '89646' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '89646' and rp.type = 4
0.0020  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '89646' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 events2024 e ON e.player_id = p.id AND e.league_id = 72462 WHERE rp.league_id = 72462 AND rp.teamId = 89646 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.0040  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 events2024 e ON e.player_id = p.id AND e.league_id = 72462 WHERE rp.league_id = 72462 AND rp.teamId = 89646 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 events2024 e ON e.player_id = p.id AND e.league_id = 72462 WHERE rp.league_id = 72462 AND rp.teamId = 89646 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 89646 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0026  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 = 72462 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.0025  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 = 68258 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 63278 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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.0022  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 = 50172 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 44343 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 33940 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 72462 ORDER BY nameShow LIMIT 100