4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Havlíčkův Brod
TEMPORADA 2023/2024
4. LIGA CHECA GRUPO 4
Equipo PJ GF GC Puntos
1 Zbrojovka Brno II Zbrojovka 23 62 14 59
2 Sokol Lanzhot Sokol 23 55 23 50
3 Vrchovina Vrchovina 23 54 31 43
4 Lisen B Lisen B 23 51 30 43
5 Havlíčkův Brod Havlíčkův 23 36 26 37
6 Spartak Velká Bíteš Spartak 23 36 32 36
7 Ždírec nad Droubravou Ždírec 23 31 30 34
8 Žďár nad Sázavou Žďár 23 37 39 34
9 Slavoj Polná Slavoj 23 33 37 30
10 Humpolec Humpolec 23 29 39 28
11 Sokol Tasovice Sokol 23 33 45 27
12 Velké Meziříčí Velké 23 23 44 25
13 Pelhřimov Pelhřimov 23 24 37 20
14 Břeclav Břeclav 23 31 47 20
15 Dálnice Speřice Dálnice 23 25 52 19
16 Stará Říše Stará 23 20 54 11
TEMPORADA 2022/2023
4. LIGA CHECA GRUPO 4
Equipo PJ GF GC Puntos
1 Start Brno Start Brno 26 63 22 63
2 Žďár nad Sázavou Žďár 26 60 27 57
3 Tatran Brno Bohunice Tatran Brno 26 51 28 52
4 Sokol Lanzhot Sokol 26 49 24 50
5 Sokol Tasovice Sokol 26 57 34 49
6 Břeclav Břeclav 26 37 47 39
7 Vysocina Jihlava II Vysocina 26 42 39 35
8 Ždírec nad Droubravou Ždírec 26 34 32 33
9 Spartak Velká Bíteš Spartak 26 37 51 31
10 Stará Říše Stará 26 35 38 27
11 Dálnice Speřice Dálnice 26 22 57 22
12 Humpolec Humpolec 26 31 54 21
13 Havlíčkův Brod Havlíčkův 26 17 41 17
14 Bystřice nad Pernštejnem Bystřice 26 27 68 11
TEMPORADA 2021/2022
4. LIGA CHECA GRUPO 4
Equipo PJ GF GC Puntos
1 Hodonín-Šardice Hodonín-Ša 26 75 16 68
2 Zbrojovka Brno II Zbrojovka 26 55 20 53
3 Sokol Lanzhot Sokol 26 53 21 52
4 Start Brno Start Brno 26 55 29 49
5 Sokol Tasovice Sokol 26 51 39 40
6 Havlíčkův Brod Havlíčkův 26 43 41 36
7 Spartak Velká Bíteš Spartak 26 30 32 36
8 Břeclav Břeclav 26 37 40 36
9 Humpolec Humpolec 26 27 40 35
10 Bystřice nad Pernštejnem Bystřice 26 30 67 29
11 Žďár nad Sázavou Žďár 26 38 59 24
12 Ždírec nad Droubravou Ždírec 26 29 39 22
13 Stará Říše Stará 26 32 61 20
14 Slavoj Polná Slavoj 26 15 66 10
TEMPORADA 2020/2021
4. LIGA CHECA GRUPO 4
Equipo PJ GF GC Puntos
1 Spartak Velká Bíteš Spartak 10 17 8 22
2 Hodonín-Šardice Hodonín-Ša 10 27 9 21
3 Sokol Lanzhot Sokol 9 16 6 18
4 Zbrojovka Brno II Zbrojovka 9 17 12 18
5 Ždírec nad Droubravou Ždírec 9 13 10 15
6 Havlíčkův Brod Havlíčkův 8 18 11 14
7 Start Brno Start Brno 9 15 15 14
8 Žďár nad Sázavou Žďár 10 26 18 13
9 Sokol Tasovice Sokol 10 21 16 13
10 Břeclav Břeclav 10 10 10 12
11 Bystřice nad Pernštejnem Bystřice 10 15 24 10
12 Humpolec Humpolec 8 9 20 5
13 Stará Říše Stará 9 9 26 4
14 Slavoj Polná Slavoj 9 5 33 1
TEMPORADA 2019/2020
4. LIGA CHECA GRUPO 4
Equipo PJ GF GC Puntos
1 Sokol Lanzhot Sokol 1 5 0 3
2 Start Brno Start Brno 1 4 0 3
3 Sokol Tasovice Sokol 1 5 3 3
4 Zbrojovka Brno II Zbrojovka 1 2 0 3
5 Ždírec nad Droubravou Ždírec 1 2 0 3
6 Vysocina Jihlava II Vysocina 1 3 2 3
7 Humpolec Humpolec 1 2 1 3
8 Žďár nad Sázavou Žďár 1 2 3 0
9 Břeclav Břeclav 1 1 2 0
10 Havlíčkův Brod Havlíčkův 1 3 5 0
11 Stará Říše Stará 1 0 2 0
12 Spartak Velká Bíteš Spartak 1 0 2 0
13 Slavoj Polná Slavoj 1 0 4 0
14 Bystřice nad Pernštejnem Bystřice 1 0 5 0
TEMPORADA 2018/2019
4. LIGA CHECA GRUPO 4
Equipo PJ GF GC Puntos
1 Blansko Blansko 28 95 20 78
2 Slovan Rosice Slovan 28 74 20 65
3 Stará Říše Stará 28 74 31 55
4 Sokol Tasovice Sokol 28 69 33 54
5 Žďár nad Sázavou Žďár 28 53 35 50
6 Sokol Lanzhot Sokol 28 62 31 48
7 Slavoj Polná Slavoj 28 51 48 41
8 Spartak Velká Bíteš Spartak 28 56 55 40
9 Bzenec Bzenec 28 43 53 36
10 FC Strani FC Strani 28 38 44 32
11 Ždírec nad Droubravou Ždírec 28 26 45 30
12 Břeclav Břeclav 28 35 62 25
13 Humpolec Humpolec 28 29 60 23
14 Havlíčkův Brod Havlíčkův 28 31 74 21
15 Nove Sady Nove Sady 28 25 77 21
16 Bystrc Kníničky Bystrc 28 20 93 10
TEMPORADA 2017/2018
4. LIGA CHECA GRUPO 4
Equipo PJ GF GC Puntos
1 Vrchovina Vrchovina 29 60 30 63
2 Slovan Rosice Slovan 29 72 26 54
3 Žďár nad Sázavou Žďár 27 59 31 52
4 Sokol Tasovice Sokol 29 51 48 48
5 Šumperk Šumperk 29 53 39 46
6 Stará Říše Stará 29 48 38 46
7 Bzenec Bzenec 27 62 54 42
8 Slavoj Polná Slavoj 28 60 57 41
9 Ždírec nad Droubravou Ždírec 29 27 35 40
10 Břeclav Břeclav 29 39 43 38
11 Blansko Blansko 29 31 38 33
12 Spartak Velká Bíteš Spartak 28 38 52 31
13 FC Strani FC Strani 29 41 59 27
14 Tišnov Tišnov 11 25 4 24
15 Havlíčkův Brod Havlíčkův 29 35 80 24
16 Třebíč Třebíč 29 29 96 10
TEMPORADA 2015/2016
4. LIGA CHECA GRUPO 4
Equipo PJ GF GC Puntos
1 Blansko Blansko 30 55 34 57
2 Hodonín-Šardice Hodonín-Ša 30 69 42 56
3 Kozlovice Kozlovice 30 52 35 51
4 Uhersky Brod Uhersky Brod 30 48 39 50
5 Sokol Tasovice Sokol 30 50 41 48
6 Slovan Rosice Slovan 30 54 37 45
7 Stará Říše Stará 30 50 39 45
8 Slavoj Polná Slavoj 30 43 56 42
9 Šumperk Šumperk 30 44 46 39
10 Přerov Přerov 30 39 45 37
11 Vrchovina Vrchovina 30 36 47 37
12 Pelhřimov Pelhřimov 30 39 61 36
13 Žďár nad Sázavou Žďár 30 34 39 34
14 Bystřice nad Pernštejnem Bystřice 30 49 59 34
15 Ždírec nad Droubravou Ždírec 30 36 54 28
16 Havlíčkův Brod Havlíčkův 30 34 58 27
TEMPORADA 2014/2015
4. LIGA CHECA GRUPO 4
Equipo PJ GF GC Puntos
1 Velké Meziříčí Velké 30 65 23 66
2 FC Zlínsko FC Zlínsko 30 59 40 52
3 Vrchovina Vrchovina 30 44 30 51
4 Havlíčkův Brod Havlíčkův 30 49 42 49
5 Stará Říše Stará 30 37 39 47
6 Hodonín-Šardice Hodonín-Ša 30 55 34 46
7 Bystřice nad Pernštejnem Bystřice 30 47 45 40
8 Slovan Rosice Slovan 30 45 39 39
9 Sokol Tasovice Sokol 30 38 53 37
10 Slavoj Polná Slavoj 30 55 52 36
11 Pelhřimov Pelhřimov 30 40 47 36
12 Žďár nad Sázavou Žďár 30 37 45 36
13 Uhersky Brod Uhersky Brod 30 38 47 33
14 Blansko Blansko 30 34 52 33
15 Napajedla Napajedla 30 46 72 27
16 Mutenice Mutenice 30 34 63 27
TEMPORADA 2007/2008
4. LIGA CHECA GRUPO 4
Equipo PJ GF GC Puntos
1 Blansko Blansko 30 64 34 62
2 Žďár nad Sázavou Žďár 30 63 41 59
3 Spartak Hulín Spartak 30 59 35 54
4 SK Líšeň SK Líšeň 30 53 35 49
5 Velké Meziříčí Velké 30 48 49 47
6 Sokol Protivanov Sokol 30 48 38 46
7 Sokol Konice Sokol Konice 30 50 40 44
8 FC Zlínsko FC Zlínsko 30 57 48 41
9 Vyškov Vyškov 30 38 33 39
10 Třebíč Třebíč 30 42 41 38
11 Rousínov Rousínov 30 40 48 38
12 Rájec-Jestrebí Rájec-Jestr 30 40 44 35
13 Boskovice Boskovice 30 44 61 34
14 CAFC Zidenice Brno CAFC 30 30 46 33
15 Havlíčkův Brod Havlíčkův 30 37 70 25
16 Hrusovany nad Jevisovkou Hrusovany 30 35 85 22

  USO DE MEMORIA  
6,081,856 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1154
Total Execution Time  0.1166
  CADENA URL  
/historico/Havli-K-V-Brod
  GET DATOS  
$_GET['/historico/Havli-K-V-Brod']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0030  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 = 'Havli-K-V-Brod' 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=31001 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=31001 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=31001 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=31001 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 72427
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=31001 AND type_rel = 2
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 = '31001' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '31001' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '31001' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 72427 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=31001 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 (72506,72427,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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 72427 AND teamId = 31001
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 72506 AND teamId = 31001
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 31001
0.0022  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 = 72427 AND t.round = 24 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 = '31001' 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 = '31001' 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 = '31001' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 72427 WHERE rp.league_id = 72427 AND rp.teamId = 31001 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 = 72427 WHERE rp.league_id = 72427 AND rp.teamId = 31001 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 72427 WHERE rp.league_id = 72427 AND rp.teamId = 31001 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 31001 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72427 AND t.round = 24 ORDER BY team.conference ASC,t.position 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 `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 = 68191 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.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 `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 = 63521 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.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 `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 = 57125 AND t.round = 10 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 `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 = 50444 AND t.round = 1 ORDER BY team.conference ASC,t.position 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 `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 = 44437 AND t.round = 28 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 `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 = 39718 AND t.round = 30 ORDER BY team.conference 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 `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 = 16002 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 `tables2015` 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 = 9186 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 `tables2008` 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 = 27577 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC