4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Kozarmisleny - Nyíregyháza Spartacus
Jornada 34
FINALIZADO
20
30
452 Pts. Elo
5º

817 Pts. Elo
1º

0-2
Sábado, 25 Mayo 2024, 17:00
0 - 1
 42' P. Beke
0 - 2
 70' M. Kovacsreti

Eventos del partido

Goles

minuto 42'P. BekeGol de P. Beke
minuto 70'M. KovacsretiGol de M. Kovacsreti

Tarjetas

Konstantinos IkonomouT. Amarilla
Konstantinos Ikonomou
minuto 46'
minuto 46'B. NagyT. Amarilla B. Nagy
F. SzabolcsT. Amarilla
F. Szabolcs
minuto 51'
minuto 51'M. KovacsretiT. Amarilla M. Kovacsreti
minuto 87'B. OlahT. Amarilla B. Olah

Cambios

F. SzabolcsEntra en el partido
F. Szabolcs
minuto 46'
P. HorváthSale del partido
P. Horváth
minuto 46'
B. DaruEntra en el partido
B. Daru
minuto 46'
B. KozicsSale del partido
B. Kozics
minuto 46'
Sámuel MajorSale del partido
Sámuel Major
minuto 62'
R. SchuszterEntra en el partido
R. Schuszter
minuto 62'
minuto 62'P. BekeSale del partido P. Beke
minuto 62'M. GresoEntra en el partido M. Greso
minuto 68'A. SigerEntra en el partido A. Siger
minuto 68'O. TamásSale del partido O. Tamás
Konstantinos IkonomouSale del partido
Konstantinos Ikonomou
minuto 71'
B. SzabóEntra en el partido
B. Szabó
minuto 71'
minuto 75'P. VassSale del partido P. Vass
minuto 75'K. VidaEntra en el partido K. Vida
minuto 75'B. OlahEntra en el partido B. Olah
minuto 75'B. FarkasSale del partido B. Farkas
Ádin MolnárSale del partido
Ádin Molnár
minuto 79'
M. NagyEntra en el partido
M. Nagy
minuto 79'

Otros

minuto 42'M. KovacsretiAsistencia M. Kovacsreti

Alineaciones

Kozarmisleny

Kozarmisleny

4-5-1
Alineación Inicial
Suplentes
Nyíregyháza Spartacus

Nyíregyháza Spartacus

3-4-3
Alineación Inicial
Suplentes

Estadísticas del partido

Kozarmisleny Kozarmisleny Nyíregyháza Spartacus Nyíregyház
0
Goles
 2
2
Tarjetas Amarillas
 3
0
Tarjetas Rojas
 0
0
Asistencias
 1
3
Sustituciones
 3


  USO DE MEMORIA  
6,822,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Match / Index )  0.4473
Total Execution Time  0.4488
  CADENA URL  
/partido/Kozarmisleny/Nyiregyhaza-Spartacus-Fc/2017?section=legal
  GET DATOS  
$_GET['/partido/Kozarmisleny/Nyiregyhaza-Spartacus-Fc/2017']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0147  SELECT data1 FROM stats2024 t WHERE league_id = 72462 AND teamId = 6588709 and type = 33
0.0147  SELECT data1 FROM stats2024 t WHERE league_id = 72462 AND teamId = 6588711 and type = 33
0.0155  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '76909' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0149  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 76909 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0148  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 76909 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0147  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='76909' AND `active` = 1 AND year = 2024
0.0212  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='72462' AND relp.team_id=6588709 WHERE relp.in_squad=1 and mp.`match_id` = '76909' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0185  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='72462' AND relp.team_id=6588711 WHERE relp.in_squad=1 and mp.`match_id` = '76909' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=76909 AND extraId = 72462 AND type_rel = 4
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=369 AND type_rel = 3
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 369 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148  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 (414190) ORDER BY n.cover_points DESC, update_date DESC
0.0146  SELECT * FROM futbol.calendars_lineups WHERE id = 76909 AND league_id = 72462 AND year = 2024