4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Osasuna Promesas - Real Unión Club
Jornada 34
FINALIZADO
01
00
597 Pts. Elo
11º

514 Pts. Elo
13º

2-1
Sábado, 27 Abril 2024, 16:00
Max Svensson 57'
1 - 0
Max Svensson 61'
2 - 0
2 - 1
 63' Asier Benito

Osasuna Promesas

4-5-1
Alineación Inicial
Suplentes

Real Unión Club

5-4-1
Alineación Inicial
Suplentes

Eventos del partido

Goles

Gol de
Max Svensson
minuto 57'
Gol de
Max Svensson
minuto 61'
minuto 63'Gol de Asier Benito

Tarjetas

Tarjeta Roja a
Pablo Valencia
minuto 23'

Cambios

Entra en el partido
Darío Ramos
minuto 24'
Sale del partido
Xabi Huarte
minuto 24'
minuto 46'Entra en el partido Carlos Beitia
minuto 46'Sale del partido J. Beobide
minuto 60'Sale del partido Roger Riera
minuto 60'Sale del partido Antón Escobar
minuto 60'Sale del partido Alex Cerdá
minuto 60'Entra en el partido Iñigo Muñoz
minuto 60'Entra en el partido Tommi O'reilly
minuto 60'Entra en el partido Asier Benito
Entra en el partido
M. Echegoyen
minuto 70'
Entra en el partido
Jorge Agirre
minuto 70'
Sale del partido
Max Svensson
minuto 70'
Sale del partido
A. Osambela
minuto 70'
Entra en el partido
C. Mutilva
minuto 78'
Sale del partido
Ander Yoldi
minuto 78'
minuto 80'Entra en el partido Peru Ruiz
minuto 80'Sale del partido Ander Vidorreta
0 Comentarios

No hay comentarios


Partido televisado en...
Canal Medio Idioma País
FEF TV TV Castellano

  USO DE MEMORIA  
6,866,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.7185
Total Execution Time  0.7196
  CADENA URL  
/partido/Osasuna-B/Real-Union-Club-Irun/alineacion?section=legal
  GET DATOS  
$_GET['/partido/Osasuna-B/Real-Union-Club-Irun/alineacion']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72358 AND teamId = 6587549 and type = 33
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72358 AND teamId = 6587556 and type = 33
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '193264' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 193264 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 193264 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0019  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='193264' AND `active` = 1 AND year = 2024
0.0065  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='72358' AND relp.team_id=6587549 WHERE relp.in_squad=1 and mp.`match_id` = '193264' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0068  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='72358' AND relp.team_id=6587556 WHERE relp.in_squad=1 and mp.`match_id` = '193264' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=193264 AND extraId = 72358 AND type_rel = 4
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2468 AND type_rel = 3
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 193264 AND league_id = 72358 AND year = 2024