4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Huesca - Real Zaragoza
Jornada 36
FINALIZADO
31
51
1338 Pts. Elo
62%
14º

1190 Pts. Elo
37%
13º

1-2
Sábado, 20 Abril 2024, 21:00
M. Loureiro 19'
1 - 0
1 - 1
 36' Adrián Liso
1 - 2
 50' Maikel Mesa
Huesca

Huesca

4-3-3
Alineación Inicial
Suplentes
Real Zaragoza

Real Zaragoza

3-5-2
Alineación Inicial
Suplentes

Eventos del partido

Goles

Gol de
M. Loureiro
minuto 19'
minuto 36'Gol de Adrián Liso
minuto 50'Gol de penalti Maikel Mesa

Tarjetas

minuto 11'T. Amarilla Adrián Liso
T. Amarilla
M. Loureiro
minuto 59'
minuto 67'T. Amarilla S. Mouriño
minuto 72'T. Amarilla Édgar Badía
T. Amarilla
Samu Obeng
minuto 77'
minuto 77'T. Amarilla A. Zedadka
minuto 85'2a Amarilla y Roja S. Mouriño
T. Amarilla
Jovanny Bolívar
minuto 89'
Tarjeta Roja a
Óscar Sielva
minuto 94'

Ocasiones

minuto 54'Tiro al palo Maikel Mesa

Cambios

minuto 46'Sale del partido Q. Lecoeuche
minuto 46'Entra en el partido A. Zedadka
Sale del partido
Joaquín Muñoz
minuto 61'
Entra en el partido
Hugo Vallejo
minuto 61'
Entra en el partido
Samu Obeng
minuto 62'
Sale del partido
Elady
minuto 62'
minuto 65'Sale del partido Maikel Mesa
minuto 65'Entra en el partido Jaume Grau
Sale del partido
M. Loureiro
minuto 70'
Entra en el partido
Jovanny Bolívar
minuto 70'
Entra en el partido
Javi Mier
minuto 70'
Sale del partido
I. Kortajarena
minuto 70'
minuto 76'Entra en el partido Germán Valera
minuto 76'Sale del partido Adrián Liso
Entra en el partido
Rafa Tresaco
minuto 82'
Sale del partido
Gerard Valentín
minuto 82'
minuto 87'Entra en el partido Jair Amador
minuto 87'Sale del partido Iván Azón

Otros

minuto 36'Asistencia Lluís López

Goles

minuto 47'Gol concedido Maikel Mesa

Otros

Penalti cometido
Javi Martínez
minuto 48'

Estadísticas del partido

Huesca Huesca Real Zaragoza Real
62%
Posesión del balón
 37%
1
Goles
 2
3
Tiros a puerta
 4
3
Tiros fuera
 4
6
Total tiros
 9
2
Paradas del portero
 3
8
Saques de esquina
 3
1
Fueras de juego
 3
0
Tarjetas Rojas
 0
0
Asistencias
 1
0
Tiros al palo
 1
3
Sustituciones
 3
14
Faltas
 17
1
Penalti cometido
 0
0 Comentarios

No hay comentarios


Partido televisado en...
Canal Medio Idioma País
LaLiga TV Hypermotion TV Castellano
Amazon Prime Video TV Castellano
DAZN TV Castellano
Movistar Plus+ TV Castellano
LaLiga TV M2 TV Castellano

  USO DE MEMORIA  
7,331,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.8400
Total Execution Time  0.8410
  CADENA URL  
/partido/Huesca/Real-Zaragoza
  GET DATOS  
$_GET['/partido/Huesca/Real-Zaragoza']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72177 AND teamId = 6584340 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72177 AND teamId = 6584351 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 = '61174' and rp.type = 2024 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 = 61174 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 61174 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0019  SELECT AVG(points) as avg_points, AVG(gf) as avg_gf, AVG(ga) as avg_gc, SUM(win_h) as win_home, SUM(win_a) as win_away, SUM(draw_h) as draw_home, SUM(draw_a) as draw_away from `tables2024` where league_id = 72177 and round = 37 group by league_id, round
0.0019  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='61174' AND `active` = 1 AND year = 2024
0.0150  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='72177' AND relp.team_id=6584340 WHERE relp.in_squad=1 and mp.`match_id` = '61174' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0122  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='72177' AND relp.team_id=6584351 WHERE relp.in_squad=1 and mp.`match_id` = '61174' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61174 AND extraId = 72177 AND type_rel = 4
0.0041  SELECT /*115 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' INNER JOIN bs_news_rel rel ON rel.newId = n.id AND rel.type_rel = 4 AND rel.typeId = 61174 AND rel.extraId = 72177 WHERE n.status = 1 AND n.ln='es' AND n.creation_date>'2024-02-20 20:00:00' AND n.creation_date<'2024-04-29 19:57:20' GROUP BY n.id ORDER BY n.cover_points DESC,n.creation_date DESC LIMIT 5
0.0018  SELECT avg_rating FROM elo_teams WHERE id=2136
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 61174 AND league_id = 72177 AND year = 2024