4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Bicskei
TEMPORADA 2023/2024
TERCERA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Tatabánya Tatabánya 26 51 26 56
2 Veszprém Veszprém 26 55 32 53
3 Bicskei Bicskei 26 42 24 53
4 III. Kerületi TVE III. 26 44 26 51
5 Komaromi Komaromi 26 33 28 39
6 Budaörsi Budaörsi 26 44 44 38
7 Gyirmót II Gyirmót II 26 49 50 38
8 Dorogi FC Dorogi FC 26 37 33 37
9 Sopron Sopron 26 36 33 34
10 Puskás Akadémia II Puskás 26 41 33 33
11 Balatonfüredi Balatonfüre 26 31 38 32
12 Kelen Kelen 26 32 47 32
13 Győri ETO II Győri 26 39 41 28
14 Haladas / Zanati Haladas 26 35 55 22
15 Zalaegerszegi TE II Zalaegerszeg 26 25 51 17
16 Csornai SE Csornai SE 26 28 61 12
TEMPORADA 2022/2023
TERCERA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Veszprém Veszprém 38 82 24 92
2 Tatabánya Tatabánya 38 77 35 90
3 Nagykanizsai ULE Nagykanizsai 38 105 41 87
4 Puskás Akadémia II Puskás 38 77 35 70
5 III. Kerületi TVE III. 38 82 40 68
6 Erdi VSE Erdi VSE 38 55 33 65
7 Bicskei Bicskei 38 59 41 63
8 Kaposvari Rakoczi Kaposvari 38 58 44 60
9 Budaörsi Budaörsi 38 56 43 60
10 Balatonfüredi Balatonfüre 38 50 52 56
11 Fehérvár II Fehérvár 38 48 56 55
12 Komaromi Komaromi 38 57 53 53
13 Győri ETO II Győri 38 61 60 52
14 Gyirmót II Gyirmót II 38 65 83 39
15 Zalaegerszegi TE II Zalaegerszeg 38 45 83 38
16 Kelen Kelen 38 42 60 32
17 Csornai SE Csornai SE 38 42 85 27
18 Teskánd Teskánd 38 50 111 25
19 Móri SE Móri SE 38 35 93 21
20 Zsámbéki Zsámbéki 38 33 107 13
TEMPORADA 2021/2022
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Mosonmagyaróvári TE Mosonmagyar 38 114 20 100
2 Budapest BVSC Budapest 38 93 32 88
3 Veszprém Veszprém 38 69 29 80
4 Győri ETO II Győri 38 68 45 67
5 Puskás Akadémia II Puskás 38 65 39 66
6 Bicskei Bicskei 38 50 44 62
7 Pápai Perutz Pápai 38 49 41 59
8 Tatabánya Tatabánya 38 52 43 57
9 Kaposvari Rakoczi Kaposvari 38 50 46 53
10 Nagykanizsai ULE Nagykanizsai 38 60 67 53
11 Fehérvár II Fehérvár 38 47 54 52
12 Zalaegerszegi TE II Zalaegerszeg 38 59 63 48
13 Balatonfüredi Balatonfüre 38 54 67 47
14 Erdi VSE Erdi VSE 38 56 69 46
15 Kelen Kelen 38 43 52 42
16 Gyirmót II Gyirmót II 38 61 71 40
17 Komaromi Komaromi 38 55 73 35
18 Sopron Sopron 38 37 81 28
19 Gárdony Gárdony 38 35 72 22
20 Andráshida Andráshida 38 26 135 11
TEMPORADA 2020/2021
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 III. Kerületi TVE III. 38 91 22 88
2 Mosonmagyaróvári TE Mosonmagyar 38 79 35 74
3 Veszprém Veszprém 37 61 44 67
4 Nagykanizsai ULE Nagykanizsai 38 77 50 66
5 Tatabánya Tatabánya 37 56 39 61
6 Lipot SK Lipot SK 38 66 58 60
7 Sopron Sopron 38 56 50 60
8 Puskás Akadémia II Puskás 38 67 51 58
9 Komaromi Komaromi 38 52 59 56
10 Erdi VSE Erdi VSE 38 51 54 54
11 Balatonfüredi Balatonfüre 38 69 58 52
12 Bicskei Bicskei 38 42 50 50
13 Zalaegerszegi TE II Zalaegerszeg 38 56 64 49
14 Lombard Pápa TFC Lombard 38 48 56 48
15 Fehérvár II Fehérvár 38 52 58 47
16 BKV Előre BKV Előre 38 46 60 44
17 Gárdony Gárdony 38 58 82 44
18 Szabadkikoto Szabadkikoto 38 63 82 37
19 Ménfőcsanak Ménfőcsana 38 37 72 29
20 Nagyatádi FC Nagyatádi 38 32 115 12
TEMPORADA 2019/2020
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Erdi VSE Erdi VSE 19 40 16 42
2 III. Kerületi TVE III. 19 43 21 41
3 Lipot SK Lipot SK 19 33 21 39
4 Ménfőcsanak Ménfőcsana 19 25 22 30
5 Pápai Perutz Pápai 19 25 22 30
6 Komaromi Komaromi 19 29 23 29
7 Nagykanizsai ULE Nagykanizsai 19 25 27 28
8 Veszprém Veszprém 19 22 16 25
9 Mosonmagyaróvári TE Mosonmagyar 19 30 29 25
10 Bicskei Bicskei 19 20 24 22
11 Puskás Akadémia II Puskás 19 29 27 21
12 BKV Előre BKV Előre 19 21 27 20
13 Sárvári FC Sárvári 19 15 22 20
14 Videoton II Videoton II 19 17 25 20
15 Héviz FC Héviz FC 19 22 40 13
16 Balatonlelle SE Balatonlelle 19 13 47 10
TEMPORADA 2011/2012
TERCERA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Erdi VSE Erdi VSE 30 75 21 75
2 Dorogi FC Dorogi FC 30 51 14 68
3 ESMTK ESMTK 30 64 25 61
4 Újbuda TC Újbuda TC 30 58 38 55
5 Soroksár SC Soroksár 30 46 26 51
6 Diósdi TC Diósdi TC 30 54 39 48
7 Sárisápi Bányász Sárisápi 30 42 37 48
8 Biatorbágy Biatorbágy 30 43 35 46
9 Penzugyor Penzugyor 30 47 40 44
10 Százhalombattai Százhalomba 30 48 52 37
11 RAFC RAFC 30 31 51 33
12 Bicskei Bicskei 30 33 51 28
13 III. Kerületi TVE III. 30 39 62 28
14 Budafoki LC Budafoki LC 30 27 51 28
15 Törökbálinti TC Törökbáli 30 34 79 19
16 Gázművek Gázművek 30 21 92 5
TEMPORADA 2010/2011
TERCERA HUNGRÍA GRUPO 4
Equipo PJ GF GC Puntos
1 Dunaújváros Dunaújváro 30 46 21 61
2 Maglódi TC Maglódi TC 30 46 31 54
3 Dunaharaszti MTK Dunaharaszti 30 46 30 50
4 ESMTK ESMTK 30 53 38 47
5 Bicskei Bicskei 30 50 41 46
6 Törökbálinti TC Törökbáli 30 43 46 45
7 Penzugyor Penzugyor 30 49 44 44
8 Móri SE Móri SE 30 45 32 43
9 Erdi VSE Erdi VSE 30 47 42 42
10 Százhalombattai Százhalomba 30 54 55 42
11 Soroksár SC Soroksár 30 35 38 38
12 Biatorbágy Biatorbágy 30 33 42 37
13 Budafoki LC Budafoki LC 30 33 48 34
14 Sárisápi Bányász Sárisápi 30 41 56 31
15 Dorogi FC Dorogi FC 30 33 58 24
16 Zsámbéki Zsámbéki 30 22 54 15

  USO DE MEMORIA  
5,928,792 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0955
Total Execution Time  0.0967
  CADENA URL  
/historico/Bicskei-Tc
  GET DATOS  
$_GET['/historico/Bicskei-Tc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
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 = 72644
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=86701 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=583 AND type_rel = 3
0.0020  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.0019  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.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 = '86701' 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 = 72644 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=86701 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,72644,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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72644 AND teamId = 86701
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 73256 AND teamId = 86701
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 86701
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 = 72644 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 = '86701' 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 = '86701' and rp.type = 4
0.0021  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 = '86701' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0025  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 = 72644 WHERE rp.league_id = 72644 AND rp.teamId = 86701 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.0020  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 = 72644 WHERE rp.league_id = 72644 AND rp.teamId = 86701 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 72644 WHERE rp.league_id = 72644 AND rp.teamId = 86701 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 = 86701 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 = 72644 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.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 `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 = 68427 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.0028  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 = 63556 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.0027  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 = 57111 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.0027  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 = 50574 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.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 = 24595 AND t.round = 30 ORDER BY team.conference 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 `tables2011` 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 = 24633 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC