4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Debreceni EAC
TEMPORADA 2023/2024
TERCERA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Putnok VSE Putnok VSE 25 62 19 53
2 Cigánd SE Cigánd SE 25 44 17 50
3 Kisvárda II Kisvárda 25 40 23 50
4 Debreceni VSC II Debreceni 25 56 32 44
5 Debreceni EAC Debreceni 25 33 30 40
6 Tiszaújváros Tiszaújvár 25 44 33 39
7 Újpest FC II Újpest 25 44 42 39
8 Eger Eger 25 29 29 38
9 Karcag SE Karcag SE 25 32 33 33
10 Sényő Carnifex Sényő 25 38 48 29
11 Salgótarjáni BTC Salgótarjá 25 28 40 29
12 Diósgyőr VTK II Diósgyőr 25 31 39 28
13 FC Hatvan FC Hatvan 25 26 40 27
14 Tiszafuredi Tiszafuredi 25 35 44 25
15 REAC REAC 25 25 58 20
16 Gyongyosi Gyongyosi 25 20 60 7
TEMPORADA 2022/2023
TERCERA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Budapest BVSC Budapest 38 101 15 102
2 Putnok VSE Putnok VSE 38 70 46 79
3 Debreceni EAC Debreceni 38 65 29 67
4 Debreceni VSC II Debreceni 37 78 57 62
5 Körösladány Körösladá 38 57 55 60
6 Kisvárda II Kisvárda 38 63 42 59
7 Karcag SE Karcag SE 38 58 51 58
8 Sényő Carnifex Sényő 38 58 66 57
9 BKV Előre BKV Előre 38 55 55 51
10 Penzugyor Penzugyor 38 57 50 50
11 Diósgyőr VTK II Diósgyőr 38 52 58 49
12 FC Hatvan FC Hatvan 38 64 73 49
13 Budapesti Vasas II Budapesti 38 70 60 48
14 Tiszaújváros Tiszaújvár 38 53 73 48
15 Füzesgyarmati Füzesgyarma 38 52 59 47
16 Hajdúszoboszlói SE Hajdúszobos 38 45 50 46
17 Tiszafuredi Tiszafuredi 38 56 70 46
18 Eger Eger 38 50 56 44
19 Bekescsaba B Bekescsaba 38 53 103 25
20 Jászberényi FC Jászberény 37 28 117 16
TEMPORADA 2021/2022
TERCERA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Kazincbarcika Kazincbarcik 38 106 24 101
2 Debreceni EAC Debreceni 38 93 31 83
3 BKV Előre BKV Előre 38 64 45 74
4 Hajdúszoboszlói SE Hajdúszobos 38 74 39 70
5 Tiszaújváros Tiszaújvár 38 79 54 69
6 Kisvárda II Kisvárda 38 67 47 65
7 Sényő Carnifex Sényő 38 66 59 62
8 Putnok VSE Putnok VSE 38 66 48 59
9 Újpest FC II Újpest 38 67 53 57
10 Füzesgyarmati Füzesgyarma 38 49 53 51
11 Bekescsaba B Bekescsaba 38 82 75 50
12 Diósgyőr VTK II Diósgyőr 38 73 71 50
13 Tiszafuredi Tiszafuredi 38 57 60 47
14 Debreceni VSC II Debreceni 38 63 67 45
15 Eger Eger 38 47 66 44
16 Jászberényi Vasas Jászberény 38 44 71 35
17 Salgótarjáni BTC Salgótarjá 38 38 65 31
18 Hidasnémeti VSC Hidasnémeti 38 39 109 27
19 Törökszentmiklós Törökszent 38 36 93 21
20 Tallya KSE Tallya KSE 38 27 107 21
TEMPORADA 2020/2021
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 Debreceni VSC Debreceni 38 89 40 80
2 Gyirmot Gyirmot 38 60 31 78
3 Budapesti Vasas Budapesti 38 65 35 78
4 Pécsi MFC Pécsi MFC 38 51 33 64
5 FC Ajka FC Ajka 38 65 47 62
6 Budaörsi Budaörsi 38 62 59 59
7 Nyíregyháza Spartacus FC Nyíregyház 38 40 31 57
8 Soroksár SC Soroksár 38 51 44 57
9 Szolnoki MÁV Szolnoki 38 43 40 57
10 Szeged 2011 Szeged 2011 38 46 54 56
11 Szombathelyi Haladas Szombathelyi 38 50 42 54
12 Györi ETO Györi ETO 38 53 48 46
13 BFC Siófok BFC Siófok 38 49 58 45
14 Dorogi FC Dorogi FC 38 34 50 44
15 Békéscsaba Békéscsaba 38 43 60 44
16 Szentlőrinc SE Szentlőrinc 38 32 52 42
17 Csákvári TK Csákvári 38 54 66 38
18 Kazincbarcika Kazincbarcik 38 32 61 33
19 Kaposvari Rakoczi Kaposvari 38 33 65 33
20 Debreceni EAC Debreceni 38 32 68 23
TEMPORADA 2019/2020
TERCERA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Debreceni EAC Debreceni 17 45 20 38
2 Füzesgyarmati Füzesgyarma 18 30 18 38
3 Cegledi Cegledi 18 36 24 36
4 Sényő Carnifex Sényő 17 37 28 32
5 ESMTK ESMTK 18 29 20 31
6 Jászberényi Vasas Jászberény 18 37 31 29
7 Tiszaújváros Tiszaújvár 18 30 27 26
8 Putnok VSE Putnok VSE 18 27 25 25
9 Balassagyarmat VSE Balassagyarm 18 27 28 24
10 Eger Eger 18 19 31 20
11 Gyöngyös Gyöngyös 18 28 36 20
12 Tallya KSE Tallya KSE 17 20 25 18
13 Debreceni VSC II Debreceni 18 29 36 16
14 FC Hatvan FC Hatvan 17 16 33 10
15 Diósgyőr VTK II Diósgyőr 18 19 47 8
16 Ózdi FC Ózdi FC 0 0 0 0
TEMPORADA 2018/2019
TERCERA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Szolnoki MÁV Szolnoki 30 61 31 65
2 Jászberényi Vasas Jászberény 30 75 31 64
3 ESMTK ESMTK 30 50 28 60
4 Füzesgyarmati Füzesgyarma 30 65 32 55
5 Sényő Carnifex Sényő 30 56 46 49
6 Putnok VSE Putnok VSE 30 49 50 49
7 Tiszaújváros Tiszaújvár 30 54 37 48
8 Nyírbátori FC Nyírbátori 30 39 39 46
9 Debreceni EAC Debreceni 30 57 58 44
10 Eger Eger 30 33 43 36
11 Gyöngyös Gyöngyös 30 40 52 30
12 Diósgyőr VTK II Diósgyőr 30 36 59 30
13 Tallya KSE Tallya KSE 30 27 47 29
14 Salgótarjáni BTC Salgótarjá 30 33 60 29
15 Sajóbábony Vegyész Sajóbábony 30 33 67 25
16 Cigánd SE Cigánd SE 30 30 58 22
TEMPORADA 2017/2018
TERCERA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Monori SE Monori SE 28 77 18 76
2 ESMTK ESMTK 28 37 24 50
3 Putnok VSE Putnok VSE 28 46 40 46
4 Tiszaújváros Tiszaújvár 28 43 40 43
5 Jászberényi Vasas Jászberény 28 36 35 38
6 Diósgyőr VTK II Diósgyőr 28 41 34 38
7 Nyírbátori FC Nyírbátori 28 47 42 37
8 Füzesgyarmati Füzesgyarma 28 38 39 36
9 Gyöngyös Gyöngyös 28 41 45 36
10 Cigánd SE Cigánd SE 28 41 51 35
11 MTK Budapest II Budapest 28 45 40 34
12 Debreceni EAC Debreceni 28 42 57 34
13 Tallya KSE Tallya KSE 28 32 49 29
14 Balassagyarmat VSE Balassagyarm 28 33 59 25
15 Tiszafuredi Tiszafuredi 28 32 58 24
16 Salgótarján Salgótarjá 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

  USO DE MEMORIA  
6,170,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1143
Total Execution Time  0.1155
  CADENA URL  
/historico/Deac
  GET DATOS  
$_GET['/historico/Deac']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0030  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 = 'Deac' 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=86687 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=86687 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=86687 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=86687 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72641
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=86687 AND type_rel = 2
0.0031  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 = '86687' 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 = '86687' 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 = 72641 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=86687 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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,72641,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.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 72641 AND teamId = 86687
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 73256 AND teamId = 86687
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 86687
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 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 = 72641 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '86687' 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 = '86687' and rp.type = 4
0.0033  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 = '86687' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032  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 = 72641 WHERE rp.league_id = 72641 AND rp.teamId = 86687 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.0021  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 = 72641 WHERE rp.league_id = 72641 AND rp.teamId = 86687 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 72641 WHERE rp.league_id = 72641 AND rp.teamId = 86687 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 86687 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,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 = 72641 AND t.round = 26 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 `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 = 68428 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 = 63554 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.0024  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 = 57039 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.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 `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 = 50572 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.0021  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 = 44610 AND t.round = 30 ORDER BY team.conference 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 `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 = 39609 AND t.round = 30 ORDER BY team.conference 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 `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.0024  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