4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Balatonlelle SE
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 2012/2013
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Dunaújváros Dunaújváro 26 86 12 66
2 Szekszárdi UFC Szekszárdi 26 53 15 63
3 Nagyatádi FC Nagyatádi 26 43 43 44
4 Pécsi II Pécsi II 26 53 30 42
5 Szentlőrinc SE Szentlőrinc 26 52 36 42
6 Bölcskei Bölcskei 26 50 42 40
7 Komlói Bányász SK Komlói 26 45 42 40
8 Bonyhád Völgység Bonyhád 26 47 45 40
9 Nagybaracska Híd Nagybaracska 26 55 45 32
10 Dombóvári Fc Dombóvári 26 43 43 31
11 Siófok II Siófok II 26 29 72 25
12 Nagybajomi Nagybajomi 26 26 61 21
13 Balatonlelle SE Balatonlelle 26 22 68 15
14 Tolna Tolna 26 23 73 11
TEMPORADA 2011/2012
TERCERA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Kaposvári Rákóczi II Kaposvári 28 60 23 63
2 Pécsi II Pécsi II 28 62 23 57
3 Nagyatádi FC Nagyatádi 28 53 32 56
4 Szekszárdi UFC Szekszárdi 28 55 18 53
5 Szentlőrinc SE Szentlőrinc 28 52 26 52
6 Komlói Bányász SK Komlói 28 49 39 46
7 Bölcskei Bölcskei 28 50 42 41
8 Bonyhád Völgység Bonyhád 28 51 58 41
9 Siófok II Siófok II 28 53 51 40
10 Nagybajomi Nagybajomi 28 50 48 39
11 Balatonlelle SE Balatonlelle 28 36 50 31
12 Dombóvári Fc Dombóvári 28 31 48 26
13 Bátaszék SE Bátaszék 28 31 60 20
14 Mohácsi Mohácsi 28 34 77 19
15 Bárcsi SC Bárcsi SC 28 11 83 7
TEMPORADA 2010/2011
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Paksi SE II Paksi SE II 30 82 21 75
2 Szentlőrinc SE Szentlőrinc 30 72 23 67
3 Kaposvári Rákóczi II Kaposvári 30 49 33 50
4 Balatonlelle SE Balatonlelle 30 38 40 50
5 Nagyatádi FC Nagyatádi 30 49 35 48
6 Dombóvári Fc Dombóvári 30 45 44 44
7 Nagykanizsai TE Nagykanizsai 30 48 40 42
8 Bölcskei Bölcskei 30 54 55 41
9 Siófok II Siófok II 30 43 53 41
10 Szekszárdi UFC Szekszárdi 30 36 44 40
11 Bonyhád Völgység Bonyhád 30 35 43 39
12 Pogány Pogány 30 45 60 34
13 Bóly Bóly 30 41 55 33
14 Bogad Bogad 30 41 69 27
15 Mohácsi Mohácsi 30 38 67 24
16 Komlói Bányász SK Komlói 30 32 66 22
TEMPORADA 2008/2009
TERCERA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Szigetszentmiklosi Szigetszentm 30 77 22 73
2 Velence SE Velence SE 30 80 38 68
3 Soroksár SC Soroksár 30 59 30 64
4 Siófok II Siófok II 30 54 26 53
5 Dunaharaszti MTK Dunaharaszti 30 63 40 52
6 Móri SE Móri SE 30 47 36 42
7 Törökbálinti TC Törökbáli 30 55 54 39
8 Penzugyor Penzugyor 30 37 46 38
9 Csepel FC Csepel FC 29 36 40 37
10 Videoton II Videoton II 30 40 49 35
11 Sárisápi Bányász Sárisápi 29 35 49 31
12 Dorogi FC Dorogi FC 29 36 52 31
13 III. Kerületi TVE III. 30 39 63 30
14 Kornye Kornye 30 36 65 26
15 Balatonlelle SE Balatonlelle 29 29 54 24
16 Csillaghegyi Csillaghegyi 30 29 88 14
TEMPORADA 2006/2007
SEGUNDA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 BFC Siófok BFC Siófok 30 59 24 62
2 Szombathelyi Haladas Szombathelyi 30 66 25 60
3 FC Felcsút FC Felcsút 30 52 25 60
4 Bárcsi SC Bárcsi SC 30 49 30 59
5 Lombard Pápa TFC Lombard 30 42 24 51
6 Dunaújváros Dunaújváro 30 51 46 46
7 Gyirmot Gyirmot 30 58 40 44
8 Mosonmagyaróvári TE Mosonmagyar 30 45 63 40
9 DAC Györ DAC Györ 30 53 48 39
10 Soroksár SC Soroksár 30 35 30 39
11 Kaposvölgye VSC Kaposvölgye 30 37 48 39
12 BKV Előre BKV Előre 30 41 48 38
13 Budaörsi Budaörsi 30 32 51 31
14 Celldömölk VSE Celldömölk 30 22 57 21
15 Héviz FC Héviz FC 30 23 49 18
16 Balatonlelle SE Balatonlelle 30 24 81 11
TEMPORADA 2005/2006
SEGUNDA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Paksi SE Paksi SE 30 66 22 76
2 FC Felcsút FC Felcsút 30 72 41 63
3 Gyirmot Gyirmot 30 53 25 57
4 DAC Györ DAC Györ 30 52 38 51
5 Szombathelyi Haladas Szombathelyi 30 38 37 42
6 Bárcsi SC Bárcsi SC 30 42 47 42
7 Celldömölk VSE Celldömölk 30 31 35 38
8 BFC Siófok BFC Siófok 30 39 42 37
9 Budakalász Budakalász 30 39 43 36
10 Héviz FC Héviz FC 30 32 34 35
11 Balatonlelle SE Balatonlelle 30 30 49 33
12 BKV Előre BKV Előre 30 32 41 31
13 Dunaújváros Dunaújváro 30 36 53 31
14 Mosonmagyaróvári TE Mosonmagyar 30 35 47 30
15 Kaposvölgye VSC Kaposvölgye 30 42 59 30
16 FC Ajka FC Ajka 30 27 53 25

  USO DE MEMORIA  
5,474,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0025
Controller Execution Time ( Home / Category )  0.5818
Total Execution Time  0.5843
  CADENA URL  
/historico/Balatonlelle-Se
  GET DATOS  
$_GET['/historico/Balatonlelle-Se']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0041  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 = 'Balatonlelle-Se' 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=64192 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=64192 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=64192 AND type_rel = 2
0.0024  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 = '64192' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '64192' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0029  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 = '64192' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0067  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 = '64192' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=64192 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0059  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 (71432,68494) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 68494 AND teamId = 64192
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 64192
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 = '64192' 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 = '64192' and rp.type = 4
0.0022  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 = '64192' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 64192 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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 64192 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 64192 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0068  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 = 64192 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0049  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.0050  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 = 24554 AND t.round = 26 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 `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 = 24589 AND t.round = 30 ORDER BY team.conference 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 `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 = 24630 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 = 24661 AND t.round = 30 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 `tables2007` 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 = 14521 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 `tables2006` 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 = 14519 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC