4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FK Louny
TEMPORADA 2023/2024
4. LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Chomutov Chomutov 15 43 14 39
2 Újezd Praha 4 Újezd Praha 15 32 20 29
3 Meteor Praha Meteor Praha 15 32 23 29
4 SK Kladno SK Kladno 15 38 18 27
5 Slaný Slaný 15 24 19 27
6 Neratovice-Byškovice Neratovice-B 15 25 14 26
7 Hřebeč Hřebeč 15 33 25 25
8 FK Ostrov FK Ostrov 15 24 24 25
9 Brandýs nad Labem Brandýs 15 28 27 22
10 Olympie Brezova Olympie 15 25 27 20
11 Štětí Štětí 15 21 20 19
12 Admira Praha II Admira Praha 15 15 23 17
13 Český Brod Český Brod 15 23 31 15
14 Hvězda Cheb Hvězda Cheb 15 7 39 9
15 TJ Sokol Nespeky Sokol 15 18 45 8
16 FK Louny FK Louny 15 10 29 5
TEMPORADA 2022/2023
4. LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Ceská Lípa Ceská Lípa 30 63 24 69
2 Újezd Praha 4 Újezd Praha 30 65 31 66
3 SK Kladno SK Kladno 29 76 34 56
4 Kosmonosy Kosmonosy 30 67 43 52
5 Chomutov Chomutov 30 47 28 52
6 Neratovice-Byškovice Neratovice-B 30 42 27 51
7 Olympie Brezova Olympie 30 54 50 44
8 FK Louny FK Louny 30 42 53 40
9 Meteor Praha Meteor Praha 30 59 48 39
10 Český Brod Český Brod 30 48 42 37
11 Štětí Štětí 30 52 67 33
12 Slaný Slaný 30 42 62 31
13 Admira Praha II Admira Praha 29 38 45 30
14 Hvězda Cheb Hvězda Cheb 30 40 77 28
15 Sokol Libiš Sokol Libiš 30 38 80 26
16 Vilémov Vilémov 30 36 98 12
TEMPORADA 2021/2022
4. LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Banik Most - Sous Banik Most. 30 72 23 66
2 Neratovice-Byškovice Neratovice-B 30 66 33 63
3 Ceská Lípa Ceská Lípa 30 78 42 57
4 SK Kladno SK Kladno 30 61 37 56
5 Český Brod Český Brod 30 48 33 49
6 Aritma Praha Aritma Praha 30 59 42 48
7 Štětí Štětí 30 51 41 45
8 FK Louny FK Louny 30 53 38 44
9 Brandýs nad Labem Brandýs 30 51 56 40
10 Meteor Praha Meteor Praha 30 55 51 39
11 Olympie Brezova Olympie 30 49 52 38
12 Chomutov Chomutov 30 47 45 36
13 FK Ostrov FK Ostrov 30 34 55 33
14 Slaný Slaný 30 36 64 33
15 Dobris Dobris 30 31 70 20
16 TJ Tatran Rakovnik Tatran 30 12 121 3
TEMPORADA 2020/2021
4. LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Banik Most - Sous Banik Most. 7 15 4 17
2 SK Kladno SK Kladno 8 15 12 16
3 Český Brod Český Brod 8 13 4 15
4 Neratovice-Byškovice Neratovice-B 8 15 6 14
5 Ceská Lípa Ceská Lípa 8 18 10 14
6 Meteor Praha Meteor Praha 7 16 11 13
7 Chomutov Chomutov 8 17 17 12
8 Aritma Praha Aritma Praha 8 9 7 11
9 Slaný Slaný 8 7 13 11
10 FK Ostrov FK Ostrov 8 14 21 10
11 Brandýs nad Labem Brandýs 8 15 14 9
12 FK Louny FK Louny 8 13 14 7
13 Dobris Dobris 8 11 21 7
14 TJ Tatran Rakovnik Tatran 8 10 16 6
15 Štětí Štětí 7 13 21 4
16 Olympie Brezova Olympie 7 5 15 4
TEMPORADA 2019/2020
4. LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Český Brod Český Brod 16 24 9 43
2 Baník Souš Baník Souš 16 37 22 32
3 Meteor Praha Meteor Praha 16 28 21 28
4 Chomutov Chomutov 16 27 17 26
5 FK Ostrov FK Ostrov 16 35 29 24
6 Aritma Praha Aritma Praha 16 19 15 24
7 Olympie Brezova Olympie 16 35 36 24
8 Neratovice-Byškovice Neratovice-B 16 32 22 23
9 SK Kladno SK Kladno 16 31 27 22
10 Brandýs nad Labem Brandýs 16 21 22 20
11 Slaný Slaný 16 26 33 19
12 TJ Tatran Rakovnik Tatran 16 24 33 18
13 FK Louny FK Louny 16 26 31 16
14 Štětí Štětí 16 30 42 16
15 Dobris Dobris 16 25 49 11
16 Ceská Lípa Ceská Lípa 16 25 37 9
TEMPORADA 2017/2018
4. LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Velvary Velvary 30 55 21 73
2 Sokol Hostouň Sokol 30 67 30 64
3 Motorlet Praha Motorlet 30 56 32 59
4 Český Brod Český Brod 30 64 42 56
5 Ostrá Ostrá 30 53 36 50
6 Baník Souš Baník Souš 30 66 55 48
7 Neratovice-Byškovice Neratovice-B 30 53 43 48
8 Úvaly Úvaly 30 52 45 46
9 SK Kladno SK Kladno 30 46 40 45
10 Chomutov Chomutov 30 67 51 44
11 Meteor Praha Meteor Praha 30 48 48 40
12 Ceská Lípa Ceská Lípa 30 39 63 33
13 TJ Tatran Rakovnik Tatran 30 39 48 32
14 FK Louny FK Louny 30 47 54 29
15 Nový Bor Nový Bor 30 15 75 8
16 SK Hrobce SK Hrobce 30 22 106 8
TEMPORADA 2015/2016
4. LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Lovosice Lovosice 30 61 31 62
2 Český Brod Český Brod 30 65 29 60
3 SK Kladno SK Kladno 30 63 32 56
4 Sokol Libiš Sokol Libiš 30 52 37 53
5 Meteor Praha Meteor Praha 30 57 38 47
6 Baník Souš Baník Souš 30 47 40 46
7 Neratovice-Byškovice Neratovice-B 30 44 43 44
8 Rakovník Rakovník 30 44 44 41
9 Chomutov Chomutov 30 45 45 40
10 Polaban Nymburk Polaban 30 31 37 39
11 Horní Měcholupy Horní 30 33 43 37
12 Úvaly Úvaly 30 48 54 36
13 Litomericko Litomericko 30 40 58 36
14 Vilémov Vilémov 30 31 63 25
15 Litvínov Litvínov 30 28 62 22
16 FK Louny FK Louny 30 32 65 20

  USO DE MEMORIA  
5,522,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5405
Total Execution Time  0.5417
  CADENA URL  
/historico/Fk-Louny
  GET DATOS  
$_GET['/historico/Fk-Louny']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0133  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 = 'Fk-Louny' 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.0125  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=65697 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=65697 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124  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=65697 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253  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 = 72420
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65697 AND type_rel = 2
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1523 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1523 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0125  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 (714382) ORDER BY n.cover_points DESC, update_date DESC
0.0130  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 = '65697' ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '65697' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '65697' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  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 = 72420 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0142  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=65697 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0133  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 (72420,71432,68174) 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.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 72420 AND teamId = 65697
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 68174 AND teamId = 65697
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 65697
0.0143  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 = 72420 AND t.round = 15 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0133  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 = '65697' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65697' and rp.type = 4
0.0134  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 = '65697' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0138  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 = 72420 WHERE rp.league_id = 72420 AND rp.teamId = 65697 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.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 = 72420 WHERE rp.league_id = 72420 AND rp.teamId = 65697 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 = 72420 WHERE rp.league_id = 72420 AND rp.teamId = 65697 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0143  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 = 65697 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72420 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 68189 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.0129  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 = 63519 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.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 `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 = 57123 AND t.round = 8 ORDER BY team.conference ASC,t.position 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 `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 = 50442 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 39716 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 16000 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC