4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Tiszakécske
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
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 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
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Tiszakécske Tiszakécske 30 75 32 71
2 Pécsi MFC Pécsi MFC 30 75 23 68
3 Iváncsa Iváncsa 30 62 41 60
4 Dunaújváros Dunaújváro 30 53 33 55
5 Szeol Szeol 30 42 29 53
6 Dabas Dabas 30 44 40 44
7 Szentlőrinc SE Szentlőrinc 30 43 42 44
8 Szekszárdi UFC Szekszárdi 30 36 41 39
9 Budapest Honvéd II Budapest 30 47 44 38
10 Paksi SE II Paksi SE II 30 39 47 37
11 Kozarmisleny Kozarmisleny 30 31 45 34
12 Rákosmenti KSK Rákosmenti 30 32 41 33
13 Makó FC Makó FC 30 34 62 31
14 Hódmezővásárhelyi Hódmezővá 30 30 49 30
15 Mórahalom Mórahalom 30 28 62 17
16 Vecsés FC Vecsés FC 30 20 60 17
TEMPORADA 1998/1999
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 Tatabánya Tatabánya 38 85 50 83
2 Nagykanizsa Nagykanizsa 38 66 38 71
3 Szeged SC Szeged SC 38 73 32 70
4 Salgótarjáni BTC Salgótarjá 38 63 39 67
5 Sopron Sopron 38 61 50 62
6 Tiszaújváros Tiszaújvár 38 54 48 60
7 Komaromi Komaromi 38 59 50 57
8 Érd VSE Érd VSE 38 59 52 57
9 Szolnoki MÁV Szolnoki 38 57 55 53
10 Komlói Bányász SK Komlói 38 56 59 53
11 Tiszakécske Tiszakécske 38 52 54 52
12 Tiszavasvari Tiszavasvari 38 46 40 50
13 Békéscsaba Békéscsaba 38 45 38 49
14 Kaposvari Rakoczi Kaposvari 38 49 66 47
15 Demecser FC Demecser FC 38 47 54 45
16 Pécsi MFC Pécsi MFC 38 52 63 45
17 Kaba SE Kaba SE 38 63 69 44
18 Soroksár SC Soroksár 38 48 84 35
19 Soproni Vasutas SE Soproni 38 39 84 24
20 Kecskemét Kecskemét 38 32 81 19
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,497,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.4690
Total Execution Time  0.4714
  CADENA URL  
/historico/Tiszakecske
  GET DATOS  
$_GET['/historico/Tiszakecske']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=63838 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=369 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 369 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0126  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 (414190) ORDER BY n.cover_points DESC, update_date DESC
0.0133  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 = '63838' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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.0129  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=63838 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 72462 AND teamId = 63838
0.0139  SELECT count(id) as num_players from rel_players WHERE league_id = 73256 AND teamId = 63838
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 63838
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 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.0127  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 = '63838' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '63838' and rp.type = 4
0.0126  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 = '63838' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0140  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 = 63838 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.0140  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 = 63838 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 = 63838 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 63838 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0134  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.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 `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.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 `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.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 `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.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 `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.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 `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 = 39610 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 `tables1999` 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 = 14515 AND t.round = 38 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 `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