4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Bohumin Bospor
Información

Histórico de participación

Partidos del Bohumin Bospor

Ir al LIVESCORE
02 Mar 24  Finalizado Bohumin Bospor Bohumin Bospor
2 - 1
Přerov Přerov 0
28 Feb 24  Finalizado Cesky Tesin Cesky Tesin
1 - 1
Bohumin Bospor Bohumin Bospor 1
21 Feb 24  Aplazado Petřvald na Moravě Petřvald na Moravě
-
Bohumin Bospor Bohumin Bospor 1
13 Feb 24  Finalizado Karviná II Karviná II
5 - 0
Bohumin Bospor Bohumin Bospor 1
16 Jun 24  en 1 mes Polanka nad Odrou Polanka nad Odrou
17:30
Bohumin Bospor Bohumin Bospor 0
09 Jun 24  en 1 mes Bohumin Bospor Bohumin Bospor
17:00
Šumperk Šumperk 0
01 Jun 24  en 1 mes Břidličná Břidličná
16:00
Bohumin Bospor Bohumin Bospor 0
26 May 24  en 24 días Bohumin Bospor Bohumin Bospor
17:00
Valašské Meziříčí Valašské Meziříčí 0
19 May 24  en 17 días Beskyd Frenstat Beskyd Frenstat
17:00
Bohumin Bospor Bohumin Bospor 0
12 May 24  en 10 días Bohumin Bospor Bohumin Bospor
16:30
TJ Repiste TJ Repiste 0
04 May 24  en 2 días Unie Hlubina Unie Hlubina
16:30
Bohumin Bospor Bohumin Bospor 0
28 Abr 24  Finalizado Bohumin Bospor Bohumin Bospor
0 - 4
Havířov Havířov 0
21 Abr 24  Finalizado Bílovec Bílovec
2 - 1
Bohumin Bospor Bohumin Bospor 0
14 Abr 24  Finalizado Bohumin Bospor Bohumin Bospor
2 - 0
Krnov Krnov 0
07 Abr 24  Finalizado Bohumin Bospor Bohumin Bospor
1 - 0
Jeseník Jeseník 0
30 Mar 24  Finalizado Vitkovice Vitkovice
2 - 0
Bohumin Bospor Bohumin Bospor 0
24 Mar 24  Finalizado Bohumin Bospor Bohumin Bospor
4 - 1
Bruntal Bruntal 0
16 Mar 24  Finalizado FC Vratimov FC Vratimov
2 - 4
Bohumin Bospor Bohumin Bospor 0
10 Mar 24  Finalizado Bohumin Bospor Bohumin Bospor
1 - 0
Opava II Opava II 0

Noticias de 4. Liga Checa

Ver últimas noticias

¡Vergüenza! Un asistente dirige borracho un partido de Cuarta División

Milan Sefara, árbitro asistente de un partido de juveniles que se disputó en la República Checa, dejó unas imágenes vergonzosas por un evidente estado de embriaguez que le impedía apenas mantenerse en pie.




  USO DE MEMORIA  
4,975,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0025
Controller Execution Time ( Home / Category )  0.0520
Total Execution Time  0.0545
  CADENA URL  
/bohumin-bospor
  GET DATOS  
$_GET['/bohumin-bospor']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0028  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 = 'bohumin-bospor' 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=101657 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=101657 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=101657 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=101657 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=101657 AND type_rel = 2
0.0024  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 = '101657' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0026  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 = 72506 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 101657 AND rp.league_id = 72429 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0020  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 101657 AND rp.league_id = 72429 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0022  SELECT c.name,l.categoryId,l.group_code,c.CountryCode,c.alias FROM categories_besoccer c INNER JOIN leagues_besoccer l ON l.categoryId = c.id WHERE c.active_year = l.year AND c.location = 'cz' AND (c.ctype = 1) AND c.id != 1523 GROUP BY c.id ORDER BY c.troncal=1 DESC,c.coefficient DESC LIMIT 10