4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Zadar - NK Osijek
FINALIZADO
00
30
399 Pts. Elo

1107 Pts. Elo

0-4
Miércoles, 25 Octubre 2017, 15:30
0 - 1
17' P. Bockaj
0 - 2
49' E. Grezda
0 - 3
55' A. Lukić
0 - 4
73' N. Jambor

Eventos del partido

Goles

minuto 17'P. BockajGol de P. Bockaj
minuto 49'E. GrezdaGol de E. Grezda
minuto 55'A. LukićGol de A. Lukić
minuto 73'N. JamborGol de N. Jambor

Tarjetas

minuto 1'D. LyopaT. Amarilla D. Lyopa
minuto 32'Z. LesjakT. Amarilla Z. Lesjak
minuto 34'M. SkoricT. Amarilla M. Skoric

Cambios

minuto 55'E. GrezdaSale del partido E. Grezda
minuto 55'G. BobanEntra en el partido G. Boban
J. GagulaEntra en el partido
J. Gagula
minuto 56'
K. TorbarinaSale del partido
K. Torbarina
minuto 56'
I. ŠimurinaEntra en el partido
I. Šimurina
minuto 62'
M. VerunicaSale del partido
M. Verunica
minuto 62'
minuto 62'M. SkoricSale del partido M. Skoric
minuto 62'A. SimunecEntra en el partido A. Simunec
minuto 69'A. GrgićSale del partido A. Grgić
minuto 69'H. HajradinovićEntra en el partido H. Hajradinović
D. ŽupanSale del partido
D. Župan
minuto 71'
L. ZdrilićEntra en el partido
L. Zdrilić
minuto 71'

Alineaciones




  USO DE MEMORIA  
5,837,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.1014
Total Execution Time  0.1024
  CADENA URL  
/partido/Zadar/Osijek/2018
  GET DATOS  
$_GET['/partido/Zadar/Osijek/2018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0018  SELECT data1 FROM stats2018 t WHERE league_id = 39161 AND teamId = 817677 and type = 33
0.0017  SELECT data1 FROM stats2018 t WHERE league_id = 39161 AND teamId = 817675 and type = 33
0.0019  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '660021' and rp.type = 2018 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 660021 AND year = 2018 AND channel = 'Footters' LIMIT 1
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 660021 AND year = 2018 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='660021' AND `active` = 1 AND year = 2018
0.0029  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='39161' AND relp.team_id=817677 WHERE relp.in_squad=1 and mp.`match_id` = '660021' AND mp.year='2018' ORDER BY mp.`team` ASC, p.`role` ASC
0.0027  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='39161' AND relp.team_id=817675 WHERE relp.in_squad=1 and mp.`match_id` = '660021' AND mp.year='2018' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=660021 AND extraId = 39161 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=650 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 650 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 (1256322,1143655,875908,808269,639066) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT position FROM tables2018 WHERE team=817677 AND league_id=39161 AND round=3
0.0018  SELECT position FROM tables2018 WHERE team=817675 AND league_id=39161 AND round=3
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 660021 AND league_id = 39161 AND year = 2018