4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Pruhonice

¿Falta algún dato de este equipo?

Si tienes datos del equipo que no se encuentran en la página nos encantaría que los compartas con nosotros. Un editor de la página validará los datos y en el plazo de tiempo más breve posible completarán los datos actuales con los enviados.

Información sobre Pruhonice

Enviar Datos
Información

Histórico de participación

Copa Checa
1 vez
(2024)

Partidos del Pruhonice

Ir al LIVESCORE

Noticias de Copa Checa

Ver últimas noticias

El Viktoria Plzen, eliminado de la Copa ante un Tercera

BeSoccer - Miércoles, 19 Octubre 2022
0 1.595

Sigue la mala temporada para el Viktoria Plzen. El rival del Barcelona en la Champions League cayó este miércoles en dieciseisavos de la Copa de la República Checa contra un Tercera División. El Hlucin le endosó un 3-2 y lo mandó fuera de la competición.

El Slovácko tumba al gigante Sparta de Praga y levanta su primera Copa Checa

David Caravaca - Miércoles, 18 Mayo 2022
4 2.446

Ha saltado la sorpresa en la final de la Copa de la República Checa. El Slovácko, de la ciudad de Uherské Hradiste, donde hay tan solo 20.000 habitantes, derrotó al Sparta de Praga y se hizo con el primero de sus entorchados de su historia en este torneo. Alcanzó subcampeonatos en 2005 y 2009.

¡13 goles y un póker en un partido de la Copa Checa!

BeSoccer - Jueves, 04 Marzo 2021
0 630

El Slavia de Praga goleó 10-3 al Karlovy Vary en los octavos de la Copa Checa y dejó un electrónico para el recuerdo. Además de la cantidad de dianas, destacó Stanislav Tecl, que marcó cuatro tantos.

El Sparta de Praga se llevó la Copa Checa

BeSoccer - Jueves, 02 Julio 2020
0 96

El Sparta de Praga remontó la ventaja inicial del Slovan Liberec. Así, se impuso en la final de la Copa de la República Checa (2-1). Se llevó este título por séptima vez en su historia.

Sparta de Praga y Sigma, multados por insultos racistas a jugadores del Viktoria Plzen

BeSoccer - Viernes, 26 Junio 2020
0 186

La Liga Checa impuso un castigo de 6.500 y 4.800 euros, respectivamente, a Sparta de Praga y Sigma por los insultos de sus aficionados a Joen Ngandu Kayamba y Jean-David Beaguel.

Ver más noticias del equipo»



  USO DE MEMORIA  
4,638,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.0522
Total Execution Time  0.0546
  CADENA URL  
/Spartak-Pruhonice
  GET DATOS  
$_GET['/Spartak-Pruhonice']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=159236 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=642 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 642 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1194015,1140203,962816,854403,851992) ORDER BY n.cover_points DESC, update_date DESC
0.0023  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 = '159236' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id WHERE (c.datateam1 = 159236 or c.datateam2 = 159236) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0022  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 159236 or c.datateam2 = 159236) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0022  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN events2024 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 159236 or c.datateam2 = 159236) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0023  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024_base as c ON c.league_id = l.id WHERE (c.datateam1 = 159236 or c.datateam2 = 159236) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0024  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024_base as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 159236 or c.datateam2 = 159236) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0021  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024_base as c ON c.league_id = l.id INNER JOIN events2024_base as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players_base rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 159236 or c.datateam2 = 159236) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)