4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Tiszafuredi
TEMPORADA 2023/2024
TERCERA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Putnok VSE Putnok VSE 27 67 24 56
2 Cigánd SE Cigánd SE 27 46 18 54
3 Debreceni VSC II Debreceni 27 61 34 50
4 Kisvárda II Kisvárda 27 41 29 50
5 Debreceni EAC Debreceni 27 35 31 44
6 Tiszaújváros Tiszaújvár 27 45 34 41
7 Eger Eger 27 34 32 41
8 Újpest FC II Újpest 27 45 45 40
9 Karcag SE Karcag SE 27 36 34 39
10 Diósgyőr VTK II Diósgyőr 27 37 40 32
11 Salgótarjáni BTC Salgótarjá 27 29 42 30
12 FC Hatvan FC Hatvan 27 27 41 30
13 Tiszafuredi Tiszafuredi 27 39 47 29
14 Sényő Carnifex Sényő 27 40 52 29
15 REAC REAC 27 28 62 21
16 Gyongyosi Gyongyosi 27 22 67 8
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
TERCERA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Tiszakécske Tiszakécske 38 94 27 94
2 Budapest BVSC Budapest 38 75 39 78
3 Jászberényi Vasas Jászberény 38 78 41 73
4 Füzesgyarmati Füzesgyarma 38 70 44 72
5 Kisvárda II Kisvárda 38 57 45 68
6 Eger Eger 38 62 36 66
7 Balassagyarmat VSE Balassagyarm 38 46 32 64
8 Sényő Carnifex Sényő 38 65 58 57
9 Diósgyőr VTK II Diósgyőr 38 65 57 54
10 Cegledi Cegledi 38 45 47 50
11 Tiszafuredi Tiszafuredi 38 59 68 48
12 Tiszaújváros Tiszaújvár 38 51 62 48
13 Debreceni VSC II Debreceni 38 58 59 46
14 Tallya KSE Tallya KSE 38 52 57 43
15 Putnok VSE Putnok VSE 38 57 75 42
16 Salgótarján Salgótarjá 38 54 76 41
17 Gyöngyös Gyöngyös 38 54 80 39
18 FC Hatvan FC Hatvan 38 46 64 38
19 Sajóbábony Vegyész Sajóbábony 38 41 102 24
20 Mezőkövesd II Mezőkövesd 38 43 103 20
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 2008/2009
TERCERA HUNGRÍA GRUPO 5
Equipo PJ GF GC Puntos
1 Mezőkövesd-Zsory Mezőkövesd 30 78 21 70
2 Újpest FC II Újpest 30 70 19 70
3 Tura VSK Tura VSK 30 57 31 61
4 Gyöngyös Gyöngyös 30 43 34 49
5 Salgótarjáni BTC Salgótarjá 30 41 39 49
6 Balmazujvaros Balmazujvaro 30 43 44 46
7 Ózdi FC Ózdi FC 30 41 45 41
8 Putnok VSE Putnok VSE 30 51 48 40
9 Budapesti Vasas II Budapesti 30 40 39 37
10 Eger Eger 30 30 35 36
11 Maglódi TC Maglódi TC 30 32 52 36
12 RAFC RAFC 30 29 43 34
13 Balassagyarmat VSE Balassagyarm 30 35 52 34
14 Tiszaújváros Tiszaújvár 30 41 66 32
15 Tiszafuredi Tiszafuredi 30 44 74 26
16 Veresegyhaz VSK Veresegyhaz 30 33 66 16

  USO DE MEMORIA  
5,753,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.1363
Total Execution Time  0.1380
  CADENA URL  
/historico/Tiszafuredi-Vse
  GET DATOS  
$_GET['/historico/Tiszafuredi-Vse']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0068  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 = 'Tiszafuredi-Vse' 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.0023  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=86796 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=86796 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=86796 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=86796 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0065  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.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=86796 AND type_rel = 2
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=583 AND type_rel = 3
0.0036  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 583 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024  SELECT /*53 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 (100827) ORDER BY n.cover_points DESC, update_date DESC
0.0043  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 = '86796' ORDER BY l.year DESC,cat.coefficient DESC
0.0040  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 = '86796' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0042  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 = '86796' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0029  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.0037  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=86796 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0026  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.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 72641 AND teamId = 86796
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 73256 AND teamId = 86796
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 86796
0.0033  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 = 27 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 = '86796' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '86796' and rp.type = 4
0.0027  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 = '86796' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0039  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 = 86796 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.0024  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 = 86796 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 86796 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 86796 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0029  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 = 27 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 `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 = 57109 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 `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.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 `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 = 24679 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC