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

Histórico de participación

Partidos del Bruntal

Ir al LIVESCORE
02 Mar 24  Finalizado Bruntal
4 - 3
Nove Sady 2
14 Jun 24  en 1 mes Krnov
17:30
Bruntal 0
09 Jun 24  en 1 mes Bruntal
17:00
FC Vratimov 0
02 Jun 24  en 1 mes Opava II
10:15
Bruntal 0
26 May 24  en 1 mes Bruntal
17:00
Polanka nad Odrou 0
19 May 24  en 29 días Šumperk
17:00
Bruntal 0
12 May 24  en 22 días Bruntal
16:30
Břidličná 0
04 May 24  en 14 días Valašské Meziříčí
16:30
Bruntal 0
28 Abr 24  en 8 días Bruntal
16:00
Beskyd Frenstat 0
20 Abr 24  en 16 h TJ Repiste
16:00
Bruntal 0
14 Abr 24  Finalizado Bruntal
0 - 3
Unie Hlubina 0
07 Abr 24  Finalizado Havířov
2 - 1
Bruntal 0
31 Mar 24  Finalizado Bruntal
0 - 0
Bílovec 0
24 Mar 24  Finalizado Bohumin Bospor
4 - 1
Bruntal 0
17 Mar 24  Finalizado Bruntal
2 - 2
Jeseník 0
09 Mar 24  Finalizado Vitkovice
1 - 2
Bruntal 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,953,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2363
Total Execution Time  0.2382
  CADENA URL  
/fc-slavoj-olympia-bruntal
  GET DATOS  
$_GET['/fc-slavoj-olympia-bruntal']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0129  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 = 'fc-slavoj-olympia-bruntal' 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.0108  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=111775 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=111775 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0108  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=111775 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0109  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=111775 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0226  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 = 72429
0.0108  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=111775 AND type_rel = 2
0.0120  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 = '111775' ORDER BY l.year DESC,cat.coefficient DESC
0.0120  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 = '111775' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0112  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 = 72429 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0113  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 = 111775 AND rp.league_id = 72429 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0109  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 = 111775 AND rp.league_id = 72429 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1