4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Bzenec
TEMPORADA 2023/2024
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 FC Strani FC Strani 21 57 21 50
2 Kozlovice Kozlovice 22 46 21 47
3 Bzenec Bzenec 21 53 21 42
4 FC Vsetín FC Vsetín 22 46 28 41
5 Slavičín Slavičín 22 34 39 36
6 Holešov Holešov 21 53 38 34
7 Šternberk Šternberk 22 32 36 32
8 Nove Sady Nove Sady 22 42 41 31
9 Batov Batov 23 41 39 26
10 HFK Olomouc HFK Olomouc 22 25 36 24
11 FC Kostelec na Hane Kostelec 22 33 54 24
12 Nový Jičín Nový 23 22 51 24
13 Tatran Všechovice Tatran 21 49 52 22
14 Skaštice Skaštice 22 26 41 21
15 Jiskra Rýmařov Jiskra 22 32 45 20
16 Přerov Přerov 22 20 48 17
TEMPORADA 2022/2023
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Kozlovice Kozlovice 26 51 24 57
2 Slavičín Slavičín 26 52 32 55
3 Šternberk Šternberk 26 57 26 52
4 Nove Sady Nove Sady 26 56 43 47
5 Zbrojovka Brno II Zbrojovka 26 62 38 44
6 Batov Batov 26 44 50 39
7 Holešov Holešov 26 43 38 36
8 Skaštice Skaštice 26 43 49 32
9 FC Vsetín FC Vsetín 26 32 37 30
10 Bzenec Bzenec 26 45 62 30
11 Tatran Všechovice Tatran 26 53 65 28
12 Šumperk Šumperk 26 33 49 28
13 Přerov Přerov 26 32 57 23
14 HFK Olomouc HFK Olomouc 26 25 58 15
TEMPORADA 2021/2022
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Hranice Hranice 26 70 25 63
2 Přerov Přerov 26 75 26 56
3 Kozlovice Kozlovice 26 56 43 50
4 Nove Sady Nove Sady 26 58 34 45
5 FC Vsetín FC Vsetín 26 36 40 38
6 Skaštice Skaštice 26 46 49 37
7 Šumperk Šumperk 26 41 44 36
8 Valašské Meziříčí Valašské 26 43 48 36
9 Slavičín Slavičín 26 42 53 33
10 Bzenec Bzenec 26 36 44 32
11 Tatran Všechovice Tatran 26 43 70 26
12 HFK Olomouc HFK Olomouc 26 33 54 25
13 Holešov Holešov 26 26 46 17
14 FC Strani FC Strani 26 20 49 14
TEMPORADA 2020/2021
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Slavičín Slavičín 9 22 8 21
2 Tatran Všechovice Tatran 10 19 18 21
3 Hranice Hranice 9 27 9 19
4 Skaštice Skaštice 10 22 16 19
5 Přerov Přerov 10 26 22 18
6 Kozlovice Kozlovice 10 19 15 17
7 Bzenec Bzenec 9 15 18 16
8 FC Vsetín FC Vsetín 10 12 10 13
9 FC Strani FC Strani 10 12 12 13
10 Šumperk Šumperk 9 18 17 10
11 Valašské Meziříčí Valašské 10 15 19 9
12 HFK Olomouc HFK Olomouc 10 16 24 9
13 Nove Sady Nove Sady 10 13 20 8
14 Brumov Brumov 10 9 37 3
TEMPORADA 2019/2020
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Slavičín Slavičín 1 3 0 3
2 Skaštice Skaštice 1 5 3 3
3 FC Vsetín FC Vsetín 1 3 1 3
4 Bzenec Bzenec 1 2 1 3
5 HFK Olomouc HFK Olomouc 1 2 1 3
6 Přerov Přerov 1 2 1 3
7 Hranice Hranice 1 1 1 1
8 Kozlovice Kozlovice 1 1 1 1
9 Hodonín-Šardice Hodonín-Ša 1 1 2 0
10 Šumperk Šumperk 1 1 2 0
11 Tatran Všechovice Tatran 1 1 2 0
12 Brumov Brumov 1 3 5 0
13 FC Strani FC Strani 1 1 3 0
14 Nove Sady Nove Sady 1 0 3 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 2016/2017
4. LIGA CHECA GRUPO 4
Equipo PJ GF GC Puntos
1 Hodonín-Šardice Hodonín-Ša 30 90 34 73
2 Uhersky Brod Uhersky Brod 30 70 29 73
3 Slovan Rosice Slovan 30 50 23 57
4 Slavičín Slavičín 30 39 24 48
5 Sokol Tasovice Sokol 30 54 49 48
6 Břeclav Břeclav 30 44 46 46
7 Slavoj Polná Slavoj 30 70 67 45
8 Bzenec Bzenec 30 59 63 39
9 Vrchovina Vrchovina 30 36 50 36
10 Brumov Brumov 30 46 59 33
11 Stará Říše Stará 30 35 55 33
12 Spartak Velká Bíteš Spartak 30 43 55 32
13 Holešov Holešov 30 49 60 31
14 Žďár nad Sázavou Žďár 30 42 53 31
15 Bystřice nad Pernštejnem Bystřice 30 46 68 31
16 Pelhřimov Pelhřimov 30 24 62 18

  USO DE MEMORIA  
5,808,176 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1147
Total Execution Time  0.1160
  CADENA URL  
/historico/Tj-Slovan-Bzenec
  GET DATOS  
$_GET['/historico/Tj-Slovan-Bzenec']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0044  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 = 72428
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=89376 AND type_rel = 2
0.0026  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 = '89376' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 72428 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  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=89376 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,72428,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.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 72428 AND teamId = 89376
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72506 AND teamId = 89376
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 89376
0.0034  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 = 72428 AND t.round = 23 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = 72428 WHERE rp.league_id = 72428 AND rp.teamId = 89376 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.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 = 72428 WHERE rp.league_id = 72428 AND rp.teamId = 89376 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 72428 WHERE rp.league_id = 72428 AND rp.teamId = 89376 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 89376 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 `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 = 72428 AND t.round = 23 ORDER BY team.conference ASC,t.position 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 `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 = 68192 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.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 `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 = 63522 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.0054  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 = 57126 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.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 `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 = 50445 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.0026  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.0032  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 = 33749 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72428 ORDER BY nameShow LIMIT 100