4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ferencváros Sub 19
TEMPORADA 2023/2024
LIGA HUNGRÍA SUB 19 ÉLITE
Equipo PJ GF GC Puntos
1 Puskás Akadémia Sub 19 Puskás 19 58 22 49
2 Vasas Kubala Sub 19 Vasas Kubala 19 40 32 37
3 Debreceni VSC Sub 19 Debreceni 19 40 29 34
4 Diósgyőr VTK Sub 19 Diósgyőr 19 35 24 34
5 Kisvárda Sub 19 Kisvárda 18 33 13 33
6 Ferencváros Sub 19 Ferencváros 18 45 27 28
7 Győri ETO Sub 19 Győri 17 38 30 28
8 Illés Akadémia Sub 19 Illés 20 26 46 23
9 Újpest Sub 19 Újpest 20 28 36 20
10 Paksi SE Sub 19 Paksi 19 31 63 15
11 Tarpa SC Sub 19 Tarpa 19 20 45 13
12 III. Kerületi TVE Sub 19 III. 19 13 40 13
TEMPORADA 2022/2023
LIGA HUNGRÍA SUB 19 ÉLITE GRUPO 2
Equipo PJ GF GC Puntos
1 Puskás Akadémia Sub 19 Puskás 14 32 12 36
2 Ferencváros Sub 19 Ferencváros 14 33 19 30
3 Újpest Sub 19 Újpest 14 23 19 23
4 Pécsi MFC Sub 19 Pécsi 14 26 31 16
5 Budapest Honved Sub 19 Budapest 14 16 23 16
6 Győri ETO Sub 19 Győri 14 26 28 15
7 Vasas Kubala Sub 19 Vasas Kubala 14 15 24 11
8 Illés Akadémia Sub 19 Illés 14 12 27 8
TEMPORADA 2021/2022
LIGA HUNGRÍA SUB 19 ÉLITE GRUPO 2
Equipo PJ GF GC Puntos
1 MTK Budapest Sub 19 Budapest 14 35 10 37
2 Illés Akadémia Sub 19 Illés 14 18 17 23
3 Győri ETO Sub 19 Győri 14 23 21 20
4 Puskás Akadémia Sub 19 Puskás 14 23 22 20
5 Ferencváros Sub 19 Ferencváros 14 19 21 15
6 Budapest Honved Sub 19 Budapest 14 20 27 15
7 Újpest Sub 19 Újpest 14 17 29 14
8 Vasas Kubala Sub 19 Vasas Kubala 14 18 26 13
TEMPORADA 2020/2021
LIGA HUNGRÍA SUB 19 ÉLITE GRUPO 2
Equipo PJ GF GC Puntos
1 MTK Budapest Sub 19 Budapest 14 38 15 34
2 Vasas Kubala Sub 19 Vasas Kubala 14 37 23 28
3 Budapest Honved Sub 19 Budapest 14 28 15 28
4 Győri ETO Sub 19 Győri 14 24 30 16
5 Illés Akadémia Sub 19 Illés 14 19 26 15
6 Ferencváros Sub 19 Ferencváros 14 18 29 15
7 Nyíregyháza Spartacus FC Su Nyíregyház 14 21 30 11
8 Debreceni VSC Sub 19 Debreceni 14 14 31 9
TEMPORADA 2019/2020
LIGA HUNGRÍA SUB 19 ÉLITE
Equipo PJ GF GC Puntos
TEMPORADA 2018/2019
LIGA HUNGRÍA SUB 19 ÉLITE
Equipo PJ GF GC Puntos
1 MTK Budapest Sub 19 Budapest 28 75 31 62
2 Budapest Honved Sub 19 Budapest 28 56 32 58
3 Debreceni VSC Sub 19 Debreceni 28 49 45 44
4 Ferencváros Sub 19 Ferencváros 28 46 49 39
5 Illés Akadémia Sub 19 Illés 28 46 47 38
6 Puskás Akadémia Sub 19 Puskás 28 44 52 33
7 Győri ETO Sub 19 Győri 28 45 64 30
8 Diósgyőr VTK Sub 19 Diósgyőr 28 23 64 17
TEMPORADA 2017/2018
LIGA HUNGRÍA SUB 19 ÉLITE
Equipo PJ GF GC Puntos
1 Illés Akadémia Sub 19 Illés 28 74 38 60
2 Budapest Honved Sub 19 Budapest 28 60 33 57
3 Puskás Akadémia Sub 19 Puskás 28 56 40 47
4 MTK Budapest Sub 19 Budapest 28 58 48 44
5 Ferencváros Sub 19 Ferencváros 28 49 41 44
6 Fehérvár Sub 19 Fehérvár 28 47 65 40
7 Debreceni VSC Sub 19 Debreceni 28 28 60 19
8 Győri ETO Sub 19 Győri 28 26 73 10
TEMPORADA 2016/2017
LIGA HUNGRÍA SUB 19 ÉLITE
Equipo PJ GF GC Puntos
1 Budapest Honved Sub 19 Budapest 28 53 40 50
2 Ferencváros Sub 19 Ferencváros 28 54 36 48
3 Debreceni VSC Sub 19 Debreceni 28 53 52 40
4 Illés Akadémia Sub 19 Illés 28 44 40 39
5 MTK Budapest Sub 19 Budapest 28 45 40 37
6 Puskás Akadémia Sub 19 Puskás 28 38 39 36
7 Vasas Kubala Sub 19 Vasas Kubala 28 34 49 36
8 Győri ETO Sub 19 Győri 28 25 50 24
TEMPORADA 2015/2016
LIGA HUNGRÍA SUB 19 ÉLITE GRUPO 3
Equipo PJ GF GC Puntos
1 Puskás Akadémia Sub 19 Puskás 14 36 8 38
2 Budapest Honved Sub 19 Budapest 14 36 17 32
3 MTK Budapest Sub 19 Budapest 14 29 20 28
4 Vasas Kubala Sub 19 Vasas Kubala 14 25 24 20
5 Debreceni VSC Sub 19 Debreceni 14 18 27 15
6 Ferencváros Sub 19 Ferencváros 14 21 27 12
7 Zalaegerszegi TE Sub 19 Zalaegerszeg 14 20 33 10
8 Vác FC Sub 19 Vác 14 13 42 7
TEMPORADA 2012/2013
LIGA HUNGRÍA SUB 19 ÉLITE
Equipo PJ GF GC Puntos
1 MTK Budapest Sub 19 Budapest 30 77 29 72
2 Budapest Honved Sub 19 Budapest 30 93 34 70
3 Ferencváros Sub 19 Ferencváros 30 49 28 63
4 Fehérvár Sub 19 Fehérvár 30 74 46 58
5 Győri ETO Sub 19 Győri 30 69 45 56
6 Vasas Kubala Sub 19 Vasas Kubala 30 67 47 54
7 Debreceni VSC Sub 19 Debreceni 30 63 50 47
8 Illés Akadémia Sub 19 Illés 30 45 58 36
9 Újpest Sub 19 Újpest 30 44 50 35
10 Vác FC Sub 19 Vác 30 42 52 33
11 Kaposvári Rákóczi Sub 19 Kaposvári 30 22 40 30
12 Nyíregyháza Spartacus FC Su Nyíregyház 30 36 63 28
13 Pécsi MFC Sub 19 Pécsi 30 43 65 27
14 Diósgyőr VTK Sub 19 Diósgyőr 30 26 70 26
15 Kecskeméti TE Sub 19 Kecskeméti 30 45 71 25
16 Békéscsaba Sub 19 Békéscsaba 30 32 79 16

  USO DE MEMORIA  
5,359,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.4766
Total Execution Time  0.4782
  CADENA URL  
/historico/Ferencvaros-Sub19
  GET DATOS  
$_GET['/historico/Ferencvaros-Sub19']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=138815 AND type_rel = 2
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2385 AND type_rel = 3
0.0159  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 = '138815' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0154  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 = '138815' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0149  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '138815' and rp.type = 4
0.0147  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 = '138815' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0156  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 = 73458 WHERE rp.league_id = 73458 AND rp.teamId = 138815 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.0162  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 = 73458 WHERE rp.league_id = 73458 AND rp.teamId = 138815 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 73458 WHERE rp.league_id = 73458 AND rp.teamId = 138815 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 138815 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0152  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 = 73458 AND t.round = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 = 68691 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 71136 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 63909 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 66596 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 59206 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 61648 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 59210 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 59224 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 59226 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 59227 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables2016` 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 = 59229 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 `tables2016` 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 = 59240 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 = 59250 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC