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

Partidos del Vinogradar

Ir al LIVESCORE

Estadísticas

GOLEADORES
ROJAS

Noticias de Copa Croata

Ver últimas noticias

El Hajduk Split, bicampeón de la Copa de Croacia

Con goles de Dario Melnjak y Marko Livaja, el Hajduk Split, por segunda vez consecutiva, se alzó con la Copa de Croacia tras vencer por 2-0 al Sibenik. Por 8ª vez en su historia, los hombres de Ivan Leko volvieron a vestirse de ganadores, lejos de los 16 títulos que tiene el Dinamo Zagreb.

El Hajduk Split gana la Copa Croata: es su primer título desde 2013

El Hajduk Split se impuso al HNK Rijeka en la final de la Copa Croata y volvió a ganar un título nueve años después. Hubo que remontar un gol inicial de Drmic para cosechar de nuevo un éxito que promete ser el inicio de una nueva era en el club. El gran héroe de la final, Melnjak, que firmó un doblete.

Sin miedo al COVID-19: Alemania y Croacia, únicas en jugarlo todo

La Alemana y la Croata son las únicas Federaciones de Europa que han conseguido jugar todas sus competiciones de esta temporada. Fútbol sala, fútbol femenino, ligas regulares, copas... todo ha estado sobre la mesa a pesar de la crisis del coronavirus.

Croacia suspende todas sus competiciones hasta el 31 de marzo

Ante el riesgo de contagio de coronavirus, la Federación Croata de Fútbol ha decidido suspender todas las competiciones del país hasta el próximo 31 de marzo.

El Rijeka vence y conquista su quinta Copa

El Rijeka se impuso al último campeón, el Dinamo Zagreb (3-1), en la final disputada en el estadio Aldo Drosina, de Pula, para conquistar su quinta Copa de Croacia, la segunda en los tres últimos años,




  USO DE MEMORIA  
4,587,608 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0506
Total Execution Time  0.0525
  CADENA URL  
/Vinogradar
  GET DATOS  
$_GET['/Vinogradar']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0024  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17936 AND type_rel = 2
0.0045  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 = '17936' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0032  (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 = 17936 or c.datateam2 = 17936) 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.0032  (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 = 17936 or c.datateam2 = 17936) 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.0031  (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 = 17936 or c.datateam2 = 17936) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0028  (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 = 17936 or c.datateam2 = 17936) 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.0031  (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 = 17936 or c.datateam2 = 17936) 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.0029  (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 = 17936 or c.datateam2 = 17936) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)