4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hlinsko
TEMPORADA 2023/2024
4. LIGA CHECA GRUPO 3
Equipo PJ GF GC Puntos
1 Ústí nad Orlicí Ústí 15 39 11 38
2 Benátky nad Jizerou Benátky 15 24 7 37
3 Velke Hamry Velke Hamry 15 31 19 33
4 Pěnčín-Turnov Pěnčín-Tu 15 30 17 28
5 Vysoké Mýto Vysoké 15 24 18 28
6 Slavia HK Slavia HK 15 23 24 25
7 Chrudim II Chrudim II 15 25 22 22
8 Benešov Benešov 15 25 25 19
9 Dobrovice Dobrovice 15 21 24 19
10 Spoje Prague Spoje Prague 15 21 25 18
11 Trutnov Trutnov 15 25 26 17
12 Hlinsko Hlinsko 15 19 22 17
13 Kosmonosy Kosmonosy 15 22 34 17
14 Novy Bydzov Novy Bydzov 15 19 35 14
15 FK Caslav FK Caslav 15 17 31 7
16 Letohrad Letohrad 15 9 34 5
TEMPORADA 2022/2023
4. LIGA CHECA GRUPO 3
Equipo PJ GF GC Puntos
1 Slovan Liberec II Slovan 30 89 22 73
2 Ústí nad Orlicí Ústí 30 49 36 64
3 Benátky nad Jizerou Benátky 30 60 31 58
4 Trutnov Trutnov 30 59 48 52
5 Velke Hamry Velke Hamry 30 64 33 50
6 Hlinsko Hlinsko 30 56 53 50
7 Chrudim II Chrudim II 30 55 53 42
8 Dobrovice Dobrovice 30 41 50 41
9 Pěnčín-Turnov Pěnčín-Tu 30 59 65 38
10 Vysoké Mýto Vysoké 30 50 43 37
11 Novy Bydzov Novy Bydzov 30 40 48 34
12 Letohrad Letohrad 30 46 65 34
13 FK Caslav FK Caslav 30 39 65 28
14 Brandýs nad Labem Brandýs 30 35 71 28
15 Dvůr Králové Dvůr 30 27 67 25
16 Náchod Náchod 30 21 40 20
TEMPORADA 2021/2022
4. LIGA CHECA GRUPO 3
Equipo PJ GF GC Puntos
1 FK Kolín FK Kolín 30 96 35 79
2 Vysoké Mýto Vysoké 30 81 32 63
3 Velke Hamry Velke Hamry 30 75 39 57
4 Kosmonosy Kosmonosy 30 70 55 48
5 FK Caslav FK Caslav 30 56 49 48
6 Benátky nad Jizerou Benátky 30 62 32 46
7 Letohrad Letohrad 30 48 46 41
8 Trutnov Trutnov 30 40 55 40
9 Sokol Libiš Sokol Libiš 30 55 67 38
10 Dvůr Králové Dvůr 30 41 50 34
11 Hlinsko Hlinsko 30 41 54 34
12 Náchod Náchod 30 28 55 34
13 SK Tochovice Tochovice 30 53 73 30
14 Poříčany Poříčany 30 38 71 30
15 Horky nad Jizerou Horky 30 38 65 26
16 Kutna Hora Kutna Hora 30 41 85 26
TEMPORADA 2020/2021
4. LIGA CHECA GRUPO 3
Equipo PJ GF GC Puntos
1 FK Kolín FK Kolín 8 36 7 22
2 Náchod Náchod 8 31 9 21
3 Vysoké Mýto Vysoké 8 21 8 19
4 Velke Hamry Velke Hamry 8 19 9 19
5 Kosmonosy Kosmonosy 8 23 22 15
6 Benátky nad Jizerou Benátky 8 23 17 13
7 Poříčany Poříčany 8 12 10 11
8 Hlinsko Hlinsko 8 7 12 10
9 Dvůr Králové Dvůr 8 15 14 9
10 FK Caslav FK Caslav 8 15 18 9
11 Letohrad Letohrad 8 11 16 8
12 Trutnov Trutnov 8 14 17 7
13 Kutna Hora Kutna Hora 8 12 37 6
14 Horky nad Jizerou Horky 7 13 19 5
15 Sokol Libiš Sokol Libiš 7 8 22 3
16 Polaban Nymburk Polaban 8 6 29 3
TEMPORADA 2019/2020
4. LIGA CHECA GRUPO 3
Equipo PJ GF GC Puntos
1 Vysoké Mýto Vysoké 16 42 16 40
2 Benátky nad Jizerou Benátky 16 33 17 37
3 Náchod Náchod 16 39 14 34
4 Dvůr Králové Dvůr 16 36 24 28
5 FK Kolín FK Kolín 16 29 18 27
6 Trutnov Trutnov 16 24 35 24
7 Velke Hamry Velke Hamry 16 29 22 23
8 Letohrad Letohrad 16 24 24 22
9 Horky nad Jizerou Horky 16 25 33 22
10 Hlinsko Hlinsko 16 27 24 21
11 Ostrá Ostrá 16 25 23 21
12 FK Caslav FK Caslav 16 27 35 18
13 Sokol Libiš Sokol Libiš 16 22 30 16
14 Kutna Hora Kutna Hora 16 17 35 14
15 Poříčany Poříčany 16 20 41 12
16 Polaban Nymburk Polaban 16 13 41 10
TEMPORADA 2006/2007
4. LIGA CHECA GRUPO 3
Equipo PJ GF GC Puntos
1 Slovan Liberec II Slovan 30 58 21 67
2 Letohrad Letohrad 30 41 18 60
3 Dvůr Králové Dvůr 30 68 34 52
4 Dobrovice Dobrovice 30 54 41 51
5 Pardubice Pardubice 30 38 26 45
6 Velim Velim 30 44 38 43
7 Týnište nad Orlicí Týnište 30 32 32 43
8 Trutnov Trutnov 30 46 47 42
9 Hlavice Hlavice 30 31 33 40
10 Český Brod Český Brod 30 53 54 36
11 Predmerice nad Labem Predmerice 30 46 62 35
12 Agria Chocen Agria Chocen 30 35 60 35
13 Chrudim Chrudim 30 34 41 34
14 Hlinsko Hlinsko 30 47 64 33
15 Ústí nad Orlicí Ústí 30 31 43 26
16 Sedmihorky Sedmihorky 30 24 68 17

  USO DE MEMORIA  
5,591,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.5198
Total Execution Time  0.5216
  CADENA URL  
/historico/Hlinsko-Fk
  GET DATOS  
$_GET['/historico/Hlinsko-Fk']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0209  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 = 'Hlinsko-Fk' 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=88141 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=88141 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=88141 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=88141 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 = 72426
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=88141 AND type_rel = 2
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 = '88141' ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '88141' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '88141' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 72426 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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 = 72506 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=88141 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (72506,72426,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 = 72426 AND teamId = 88141
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 72506 AND teamId = 88141
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 88141
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 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 = 72426 AND t.round = 15 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '88141' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '88141' and rp.type = 4
0.0127  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 = '88141' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 72426 WHERE rp.league_id = 72426 AND rp.teamId = 88141 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.0126  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 = 72426 WHERE rp.league_id = 72426 AND rp.teamId = 88141 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 72426 WHERE rp.league_id = 72426 AND rp.teamId = 88141 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 88141 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72426 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 = 68190 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 = 63520 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 `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 = 57124 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 = 50443 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.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 `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 = 27585 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC