4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FC Vsetín
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 FC Vsetín FC Vsetín 23 48 29 44
4 Bzenec Bzenec 22 54 22 43
5 Slavičín Slavičín 22 34 39 36
6 Holešov Holešov 21 53 38 34
7 Šternberk Šternberk 23 32 36 33
8 Nove Sady Nove Sady 23 43 43 31
9 Batov Batov 23 41 39 26
10 FC Kostelec na Hane Kostelec 23 33 54 25
11 HFK Olomouc HFK Olomouc 22 25 36 24
12 Nový Jičín Nový 23 22 51 24
13 Tatran Všechovice Tatran 22 49 52 23
14 Skaštice Skaštice 23 27 42 22
15 Jiskra Rýmařov Jiskra 22 32 45 20
16 Přerov Přerov 23 20 48 18
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 5
Equipo PJ GF GC Puntos
1 Slavičín Slavičín 30 68 35 65
2 Frýdlant Frýdlant 30 54 27 59
3 Nový Jičín Nový 30 68 36 58
4 Hranice Hranice 30 71 43 50
5 Opava II Opava II 30 66 37 49
6 Bohumin Bospor Bohumin 30 70 58 49
7 Kozlovice Kozlovice 30 49 39 47
8 Bruntal Bruntal 30 46 41 47
9 Havířov Havířov 30 45 55 44
10 FC Vsetín FC Vsetín 30 48 53 38
11 Heřmanice Slezská Heřmanice 30 56 69 38
12 SK Detmarovice Detmarovice 30 62 67 36
13 HFK Olomouc HFK Olomouc 30 39 59 30
14 Šumperk Šumperk 30 35 59 28
15 Přerov Přerov 30 29 69 19
16 Sokol Ústí Sokol Ústí 30 23 82 12
TEMPORADA 2017/2018
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Dolní Benešov Dolní 30 55 32 60
2 Havířov Havířov 30 75 41 59
3 Kozlovice Kozlovice 30 65 36 59
4 Nový Jičín Nový 30 53 29 55
5 Sokol Ústí Sokol Ústí 30 64 41 55
6 Opava II Opava II 30 60 33 54
7 Slavičín Slavičín 30 62 42 50
8 Frýdlant Frýdlant 30 44 47 43
9 Nove Sady Nove Sady 30 39 50 41
10 Bohumin Bospor Bohumin 30 49 47 37
11 FC Vsetín FC Vsetín 30 31 35 37
12 Jeseník Jeseník 30 41 69 30
13 Hranice Hranice 30 30 60 27
14 Lokomotiva Petrovice Lokomotiva 30 40 61 25
15 Šternberk Šternberk 30 39 72 21
16 Brumov Brumov 30 27 79 20
TEMPORADA 2015/2016
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Odra Petřkovice Odra 30 53 29 64
2 Lokomotiva Petrovice Lokomotiva 30 54 23 55
3 Slavičín Slavičín 30 50 31 53
4 Valašské Meziříčí Valašské 30 50 36 51
5 Nový Jičín Nový 30 46 32 49
6 Jiskra Rýmařov Jiskra 30 58 40 46
7 Nove Sady Nove Sady 30 51 47 41
8 Dolní Benešov Dolní 30 41 47 41
9 Opava II Opava II 30 44 42 38
10 Hranice Hranice 30 48 48 37
11 Brumov Brumov 30 33 59 36
12 Havířov Havířov 30 37 56 35
13 Velké Karlovice Velké 30 25 37 34
14 Frýdlant Frýdlant 30 36 61 33
15 Krnov Krnov 30 34 54 31
16 FC Vsetín FC Vsetín 30 28 46 28
TEMPORADA 2007/2008
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Baník Ostrava II Baník 30 70 19 69
2 Kravaře Kravaře 30 45 25 51
3 Slavičín Slavičín 30 64 33 49
4 Jiskra Rýmařov Jiskra 30 56 48 43
5 Beskyd Frenstat Beskyd 30 39 32 42
6 Hranice Hranice 30 49 48 40
7 Lázne Velké Losiny Lázne 30 42 51 40
8 Slavia Orlová-Lutyně Slavia 30 29 32 39
9 Brumov Brumov 30 41 53 39
10 Bystrice pod Hostýnem Bystrice 30 30 32 38
11 Napajedla Napajedla 30 42 50 38
12 Havířov Havířov 30 33 44 37
13 Mesto Albrechtice Mesto 30 35 51 37
14 Velké Karlovice Velké 30 29 43 36
15 SK Bohuslavice Bohuslavice 30 34 46 34
16 FC Vsetín FC Vsetín 30 29 60 24

  USO DE MEMORIA  
5,953,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0894
Total Execution Time  0.0906
  CADENA URL  
/historico/Vsetin
  GET DATOS  
$_GET['/historico/Vsetin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0042  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=65708 AND type_rel = 2
0.0022  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 = '65708' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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.0024  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=65708 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72428 AND teamId = 65708
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 72506 AND teamId = 65708
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 65708
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 = 72428 AND t.round = 23 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '65708' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65708' and rp.type = 4
0.0020  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 = '65708' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 72428 WHERE rp.league_id = 72428 AND rp.teamId = 65708 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.0019  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 = 65708 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 65708 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 65708 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,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.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 = 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.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 `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.0022  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.0022  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.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 `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 = 44438 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 39719 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 `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 = 16003 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 `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 = 27580 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC