4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Katovice
TEMPORADA 2023/2024
4. LIGA CHECA GRUPO 1
Equipo PJ GF GC Puntos
1 Mariánské Lázně Mariánské 15 36 13 33
2 Petrin Plzen Petrin Plzen 15 35 15 32
3 Aritma Praha Aritma Praha 15 27 11 30
4 Baník Sokolov Baník 15 38 16 29
5 Horovice Horovice 15 21 20 27
6 FK Komárov FK Komárov 15 24 20 23
7 Spartak Sobeslav Spartak 15 29 28 21
8 Příbram II Příbram 15 26 27 20
9 Jindřichův Hradec Jindřichův 15 26 32 20
10 Katovice Katovice 15 27 29 18
11 Doubravka Doubravka 15 20 19 15
12 Rokycany Rokycany 15 13 30 15
13 Jiskra Domažlice II Jiskra 15 24 35 14
14 Klatovy Klatovy 15 24 35 13
15 Tachov Tachov 15 13 27 11
16 Cesky Krumlov Cesky 15 17 43 8
TEMPORADA 2022/2023
4. LIGA CHECA GRUPO 1
Equipo PJ GF GC Puntos
1 TJ Sokol Lom Sokol 30 77 35 65
2 Spartak Sobeslav Spartak 30 66 38 56
3 Petrin Plzen Petrin Plzen 30 64 46 50
4 Doubravka Doubravka 30 51 42 48
5 Katovice Katovice 30 59 58 47
6 Aritma Praha Aritma Praha 30 46 37 45
7 Hořovicko Hořovicko 30 38 38 44
8 Cesky Krumlov Cesky 30 43 51 44
9 Mariánské Lázně Mariánské 30 49 60 44
10 Jiskra Domažlice II Jiskra 30 56 50 43
11 Příbram II Příbram 30 58 60 42
12 Klatovy Klatovy 30 55 57 40
13 FK Komárov FK Komárov 30 46 57 40
14 Rokycany Rokycany 30 41 38 39
15 SK Tochovice Tochovice 30 44 68 24
16 Horní Bříza Horní 30 19 77 8
TEMPORADA 2021/2022
4. LIGA CHECA GRUPO 1
Equipo PJ GF GC Puntos
1 Robstav Přeštice Robstav 30 88 23 80
2 České Budějovice II České 30 84 30 63
3 Klatovy Klatovy 30 68 52 55
4 Doubravka Doubravka 30 59 37 53
5 TJ Sokol Lom Sokol 30 64 41 51
6 Katovice Katovice 30 60 55 49
7 Spartak Sobeslav Spartak 30 61 38 48
8 Petrin Plzen Petrin Plzen 30 65 47 48
9 Rokycany Rokycany 30 67 54 39
10 Mýto Mýto 30 42 59 35
11 Mariánské Lázně Mariánské 30 51 70 33
12 Hvězda Cheb Hvězda Cheb 30 35 55 33
13 Hořovicko Hořovicko 30 35 72 32
14 Jindřichův Hradec Jindřichův 30 34 77 25
15 Cesky Lev - Union Beroun Cesky Union 30 24 78 19
16 Tatran Sedlčany Tatran 30 39 88 18
TEMPORADA 2020/2021
4. LIGA CHECA GRUPO 1
Equipo PJ GF GC Puntos
1 Robstav Přeštice Robstav 8 31 4 24
2 TJ Sokol Lom Sokol 8 20 9 16
3 České Budějovice II České 7 16 6 16
4 Petrin Plzen Petrin Plzen 7 18 13 13
5 Jindřichův Hradec Jindřichův 7 16 11 13
6 Doubravka Doubravka 8 17 22 12
7 Katovice Katovice 8 21 17 11
8 Klatovy Klatovy 7 10 9 11
9 Spartak Sobeslav Spartak 8 17 17 10
10 Cesky Lev - Union Beroun Cesky Union 7 7 17 10
11 Rokycany Rokycany 8 17 13 9
12 Mariánské Lázně Mariánské 8 13 22 9
13 Mýto Mýto 7 11 15 8
14 Tatran Sedlčany Tatran 8 12 25 6
15 Hořovicko Hořovicko 8 8 19 3
16 Hvězda Cheb Hvězda Cheb 8 9 24 3
TEMPORADA 2019/2020
4. LIGA CHECA GRUPO 1
Equipo PJ GF GC Puntos
1 České Budějovice II České 16 42 24 33
2 Katovice Katovice 16 34 23 32
3 Robstav Přeštice Robstav 16 36 13 31
4 Rokycany Rokycany 16 31 24 30
5 Spartak Sobeslav Spartak 16 40 17 29
6 Mýto Mýto 16 33 24 27
7 Cesky Lev - Union Beroun Cesky Union 16 26 34 24
8 Klatovy Klatovy 16 22 24 22
9 Sokol Čížová Sokol 16 30 23 21
10 Petrin Plzen Petrin Plzen 16 34 33 21
11 Doubravka Doubravka 16 23 26 21
12 Tatran Sedlčany Tatran 16 29 38 19
13 Mariánské Lázně Mariánské 16 23 33 17
14 Hvězda Cheb Hvězda Cheb 16 27 45 14
15 Jindřichův Hradec Jindřichův 16 22 49 12
16 Hořovicko Hořovicko 16 22 44 10

  USO DE MEMORIA  
5,354,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.4919
Total Execution Time  0.4931
  CADENA URL  
/historico/Otava-Katovice
  GET DATOS  
$_GET['/historico/Otava-Katovice']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0134  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 = 'Otava-Katovice' 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.0126  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=121416 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=121416 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=121416 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255  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 = 72419
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=121416 AND type_rel = 2
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1523 AND type_rel = 3
0.0143  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1523 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (714382) ORDER BY n.cover_points DESC, update_date DESC
0.0130  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 = '121416' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '121416' 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 = '121416' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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 = 72419 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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=121416 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,72419) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 72419 AND teamId = 121416
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 72506 AND teamId = 121416
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 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 = 72419 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 = '121416' 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 = '121416' 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 = '121416' 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 = 72419 WHERE rp.league_id = 72419 AND rp.teamId = 121416 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 = 72419 WHERE rp.league_id = 72419 AND rp.teamId = 121416 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 72419 WHERE rp.league_id = 72419 AND rp.teamId = 121416 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  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 = 121416 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0132  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 = 72419 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.0132  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 = 68188 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.0132  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 = 63518 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.0133  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 = 57122 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.0133  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 = 50441 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