4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Diósgyőr VTK - Puskás Akadémia
Jornada 9
FINALIZADO
00
00
902 Pts. Elo
7º

633 Pts. Elo
9º

3-2
Sábado, 19 Septiembre 2015, 18:00
D. Okuka 46'
1 - 0
Soma Novothny 66'
2 - 0
2 - 1
 81' L. Pekár
2 - 2
 86' Donat Zsoter
Tamás Egerszegi 90'
3 - 2

Eventos del partido

Goles

D. OkukaGol de
D. Okuka
minuto 46'
Soma NovothnyGol de
Soma Novothny
minuto 66'
minuto 81'L. PekárGol de L. Pekár
minuto 86'Donat ZsoterGol de Donat Zsoter
Tamás EgerszegiGol de
Tamás Egerszegi
minuto 90'

Cambios

V. KomanSale del partido
V. Koman
minuto 33'
D. BarcziEntra en el partido
D. Barczi
minuto 33'
minuto 62'L. LencseEntra en el partido L. Lencse
minuto 62'Patrik TischlerSale del partido Patrik Tischler
M. KitlSale del partido
M. Kitl
minuto 67'
Tamás EgerszegiEntra en el partido
Tamás Egerszegi
minuto 67'
minuto 72'M. DinjarSale del partido M. Dinjar
minuto 72'Donat ZsoterEntra en el partido Donat Zsoter
T. TakácsEntra en el partido
T. Takács
minuto 74'
D. OkukaSale del partido
D. Okuka
minuto 74'
minuto 78'B. PeterEntra en el partido B. Peter
minuto 78'B. PauljevicSale del partido B. Pauljevic

Otros

V. KomanLesionado
V. Koman
minuto 33'
I. BognárAsistencia
I. Bognár
minuto 46'
D. BarcziAsistencia
D. Barczi
minuto 66'
minuto 81'B. GrgicAsistencia B. Grgic
minuto 86'B. GrgicAsistencia B. Grgic
G. KovacsAsistencia
G. Kovacs
minuto 90'

Alineaciones

Diósgyőr VTK

Diósgyőr VTK

4-4-2
Alineación Inicial
Suplentes
Puskás Akadémia

Puskás Akadémia

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,856,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.1185
Total Execution Time  0.1195
  CADENA URL  
/partido_15703/Diosgyori-Vtk/Puskas-Fc/2016
  GET DATOS  
$_GET['/partido_15703/Diosgyori-Vtk/Puskas-Fc/2016']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0021  SELECT data1 FROM stats2016 t WHERE league_id = 15703 AND teamId = 218204 and type = 33
0.0021  SELECT data1 FROM stats2016 t WHERE league_id = 15703 AND teamId = 218212 and type = 33
0.0030  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '18204' and rp.type = 2016 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 18204 AND year = 2016 AND channel = 'Footters' LIMIT 1
0.0022  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 18204 AND year = 2016 AND channel = 'Footters' LIMIT 1
0.0023  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='18204' AND `active` = 1 AND year = 2016
0.0117  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='15703' AND relp.team_id=218204 WHERE relp.in_squad=1 and mp.`match_id` = '18204' AND mp.year='2016' ORDER BY mp.`team` ASC, p.`role` ASC
0.0096  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='15703' AND relp.team_id=218212 WHERE relp.in_squad=1 and mp.`match_id` = '18204' AND mp.year='2016' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18204 AND extraId = 15703 AND type_rel = 4
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 18204 AND league_id = 15703 AND year = 2016