Escudo del Karviná

Karviná

Entrenador: Marek Bielan

Información
  • Nombre del equipo Karviná
  • Nombre completo Městský Fotbalový Klub OKD Karviná
  • Nombre corto KAR
  • País República Checa
  • Ciudad Karviná
  • Entrenador Marek Bielan
  • URL del equipo en RF testing.resultados-futbol.com/Karvina
Otros Datos
  • Año de Fundación 2003
Internet

Información sobre el estadio

  • Nombre del estadio Městský stadion
  • Capacidad 12500
  • Dirección Slovenská 2882 733 01 Karviná-Hranice
  • Teléfono +420 596 311 252
  • Fax +420 596 341 731
Městský stadion

Partidos del Karviná

Ir al LIVESCORE
22 Mar 24  Finalizado Zagłębie Sosnowiec
0 - 1
Karviná 0
03 Feb 24  Finalizado Karviná
2 - 1
Skalica 0
27 Ene 24  Finalizado Shkupi
0 - 1
Karviná 0
26 Ene 24  Finalizado Mauaense
0 - 2
Karviná 1
24 Ene 24  Finalizado Radnicki Nis
0 - 2
Karviná 0
20 Ene 24  Finalizado Žilina
7 - 4
Karviná 2
19 Ene 24  Finalizado Górnik Zabrze
2 - 3
Karviná 7
13 Ene 24  Finalizado Karviná
4 - 0
SFC Opava 0
13 Ene 24  Finalizado Karviná
1 - 0
SK Líšeň 1
28 Abr 24  en 8 días FC Trinity Zlín
15:00
Karviná 1
20 Abr 24  en 15 h Karviná
15:00
Bohemians 1905 1
14 Abr 24  Finalizado Baník Ostrava
2 - 2
Karviná 3
06 Abr 24  Finalizado Karviná
0 - 0
Viktoria Plzeň 78
31 Mar 24  Finalizado Hradec Králové
2 - 1
KarvináTarjeta Roja 1
16 Mar 24  Finalizado Karviná
2 - 1
České Budějovice 0
09 Mar 24  Finalizado Slovan Liberec
1 - 0
Karviná 9
02 Mar 24  Finalizado Tarjeta RojaKarviná
1 - 3
Slovácko 8
24 Feb 24  Finalizado Teplice
2 - 2
Karviná 8
18 Feb 24  Finalizado Karviná
0 - 3
Slavia Praha 5
14 Feb 24  Finalizado Tarjeta RojaKarviná
0 - 3
Pardubice 37
10 Feb 24  Finalizado Karviná
0 - 3
Sparta Praha 24

Plantilla del Karviná Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
77 29 sk 191 87 - - 3
31 25 cz 190 87 - - 1
30 24 cz 189 - - - -
Defensa
11 23 me 186 78 1 - 4
21 31 se 185 87 - - 1
37 24 sk 189 - 2 - 2
9 20 cz 175 - - - -
15 23 mk 174 71 - - -
18 29 cz 189 85 - - 4
25 39 cz 183 77 - - 3
22 30 cz 186 86 1 - 7
33 19 br - - - - -
5 23 cz - - - - -
24 28 sk 181 - - - 2
16 30 me 183 71 - - 1
17 23 cz 182 - - - -
29 28 sk 179 74 3 - -
Centrocampista
4 19 ci - - 1 - 3
12 23 cz 183 64 - - 1
2 20 ng 171 - - 1 3
3 19 ng 187 - - 1 3
23 32 cz 178 76 3 - 3
28 29 cz 180 75 1 - 4
9 17 cz 181 - - - -
6 21 cz 178 - - - 9
Delantero
19 25 ng 181 74 4 - 2
99 23 ba 176 - 3 1 6
7 27 sk 184 - 2 - 3
20 20 br - - - - -
26 20 ng 187 - 1 - 4
15 33 cz 189 89 1 - 2
17 30 sk 180 75 1 - 2
10 25 cv 178 66 1 - 2

Noticias del Karviná

Ver últimas noticias

El Slavia se reafirma, pero sufre ante el colista

El Slavia de Praga se reencontró con el triunfo tras el empate del pasado fin de semana, ante el Sigma Olomuc, a costa del colista, el Karvina (2-0), al que superó para mantener su ventaja como líder de la Liga de la República Checa.

A lo Borat: ¡saltó al campo semidesnudo!

En el partido entre el Victoria Plzen y el MFK Karviná, un espontáneo saltó al terreno de juego semidesnudo y recorrió buena parte del campo hasta que las autoridades lograron frenarlo.




  USO DE MEMORIA  
5,634,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3119
Total Execution Time  0.3138
  CADENA URL  
/karvina
  GET DATOS  
$_GET['/karvina']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0121  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 = 'karvina' 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.0106  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=13178 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=13178 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=13178 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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=13178 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 = 72209
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13178 AND type_rel = 2
0.0117  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13178 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0117  SELECT /*35 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 (420634,754702) ORDER BY n.cover_points DESC, update_date DESC
0.0135  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 = '13178' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0108  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 = 72209 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110  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 = 72209 AND t.round = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = 72209 WHERE rp.league_id = 72209 AND rp.teamId = 13178 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.0122  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 = 72209 WHERE rp.league_id = 72209 AND rp.teamId = 13178 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0168  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 = 72209 WHERE rp.league_id = 72209 AND rp.teamId = 13178 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30