4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FK Ostrov
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 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 2018/2019
4. LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 FK Zbuzany FK Zbuzany 32 81 33 67
2 Sokol Hostouň Sokol 32 81 37 66
3 Baník Souš Baník Souš 32 61 44 62
4 Motorlet Praha Motorlet 32 62 47 53
5 FK Ostrov FK Ostrov 41 62 80 51
6 SK Kladno SK Kladno 32 41 39 50
7 Chomutov Chomutov 31 47 53 49
8 Neratovice-Byškovice Neratovice-B 31 58 51 48
9 Olympie Brezova Olympie 31 47 57 46
10 Meteor Praha Meteor Praha 32 45 36 45
11 Brandýs nad Labem Brandýs 31 47 43 44
12 Ostrá Ostrá 41 50 69 42
13 Sokol Libiš Sokol Libiš 31 54 66 34
14 Polaban Nymburk Polaban 32 31 56 32
15 TJ Tatran Rakovnik Tatran 32 52 74 28
16 Mostecký Mostecký 31 47 81 26
TEMPORADA 2016/2017
4. LIGA CHECA GRUPO 1
Equipo PJ GF GC Puntos
1 Sokol Čížová Sokol 30 83 30 71
2 Motorlet Praha Motorlet 30 72 23 63
3 Karlovy Vary Karlovy Vary 30 91 38 62
4 Admira Praha Admira Praha 30 64 26 61
5 Tatran Sedlčany Tatran 30 42 40 46
6 Dobris Dobris 30 54 56 43
7 Klatovy Klatovy 30 44 47 43
8 Doubravka Doubravka 30 48 41 40
9 Aritma Praha Aritma Praha 30 34 45 40
10 Mariánské Lázně Mariánské 30 45 42 39
11 Malše Roudné Malše 30 45 56 37
12 SK Jankov SK Jankov 30 33 44 35
13 Rokycany Rokycany 30 46 56 34
14 Cesky Krumlov Cesky 30 27 55 34
15 FK Ostrov FK Ostrov 30 45 74 33
16 Sušice Sušice 30 16 116 1

  USO DE MEMORIA  
5,489,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0825
Total Execution Time  0.0837
  CADENA URL  
/historico/Fk-Ostrov
  GET DATOS  
$_GET['/historico/Fk-Ostrov']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0033  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-Ostrov' 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.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=89389 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=89389 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=89389 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=89389 AND type_rel = 2
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 = '89389' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '89389' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '89389' 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 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=89389 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,72420) 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 = 72420 AND teamId = 89389
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 72506 AND teamId = 89389
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 = '89389' 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 = '89389' 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 = '89389' 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 = 72420 WHERE rp.league_id = 72420 AND rp.teamId = 89389 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 = 72420 WHERE rp.league_id = 72420 AND rp.teamId = 89389 AND (e.action = 4 or e.action = 5) 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 = 72420 WHERE rp.league_id = 72420 AND rp.teamId = 89389 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 89389 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 = 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.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 `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.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 = 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.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 `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.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 = 44435 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 `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 = 33747 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC