4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Real Valladolid - Huesca
Jornada 37
FINALIZADO
40
30
1795 Pts. Elo
49%
2º

1252 Pts. Elo
51%
17º

1-0
Domingo, 28 Abril 2024, 18:30
V. Meseguer 9'
1 - 0
Real Valladolid

Real Valladolid

4-3-3
Alineación Inicial
Suplentes
Huesca

Huesca

4-4-2
Alineación Inicial
Suplentes

Eventos del partido

Goles

V. MeseguerGol de
V. Meseguer
minuto 9'

Tarjetas

S. EscuderoT. Amarilla
S. Escudero
minuto 29'
minuto 58'Samu ObengT. Amarilla Samu Obeng
minuto 61'M. LoureiroT. Amarilla M. Loureiro
Lucas RosaT. Amarilla
Lucas Rosa
minuto 74'
V. MeseguerT. Amarilla
V. Meseguer
minuto 79'
minuto 90'Jovanny BolívarT. Amarilla Jovanny Bolívar
César TárregaT. Amarilla
César Tárrega
minuto 92'

Cambios

minuto 49'Rafa TresacoEntra en el partido Rafa Tresaco
minuto 49'Gerard ValentínSale del partido Gerard Valentín
S. EscuderoSale del partido
S. Escudero
minuto 62'
Raúl MoroSale del partido
Raúl Moro
minuto 62'
Lucas RosaEntra en el partido
Lucas Rosa
minuto 62'
Iván SánchezEntra en el partido
Iván Sánchez
minuto 62'
AnuarSale del partido
Anuar
minuto 62'
Amath NdiayeEntra en el partido
Amath Ndiaye
minuto 62'
minuto 70'Joaquín MuñozEntra en el partido Joaquín Muñoz
minuto 70'Javi MierSale del partido Javi Mier
minuto 70'Hugo VallejoEntra en el partido Hugo Vallejo
minuto 70'EladySale del partido Elady
SalaEntra en el partido
Sala
minuto 80'
Amath NdiayeSale del partido
Amath Ndiaye
minuto 80'
minuto 82'K. HashimotoSale del partido K. Hashimoto
minuto 82'I. KortajarenaEntra en el partido I. Kortajarena
minuto 83'Juanjo NietoSale del partido Juanjo Nieto
minuto 83'Jovanny BolívarEntra en el partido Jovanny Bolívar
Á. NegredoSale del partido
Á. Negredo
minuto 86'
Marcos AndréEntra en el partido
Marcos André
minuto 86'

Otros

S. EscuderoAsistencia
S. Escudero
minuto 9'
minuto 48'Gerard ValentínLesionado Gerard Valentín
Amath NdiayeLesionado
Amath Ndiaye
minuto 79'

Estadísticas del partido

Real Valladolid Real Huesca Huesca
49%
Posesión del balón
 51%
1
Goles
 0
4
Tiros a puerta
 0
6
Tiros fuera
 6
12
Total tiros
 7
0
Paradas del portero
 2
5
Saques de esquina
 3
0
Fueras de juego
 2
0
Tarjetas Rojas
 0
1
Asistencias
 0
1
Lesiones
 1
3
Sustituciones
 3
19
Faltas
 6
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
LaLiga TV M3 TV Castellano
DGO TV -
DSports TV -
DGO TV Latino
DSports TV Latino
DSports TV -

  USO DE MEMORIA  
7,292,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.6309
Total Execution Time  0.6319
  CADENA URL  
/partido/Valladolid/Huesca/2024
  GET DATOS  
$_GET['/partido/Valladolid/Huesca/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0126  SELECT data1 FROM stats2024 t WHERE league_id = 72177 AND teamId = 6584350 and type = 33
0.0127  SELECT data1 FROM stats2024 t WHERE league_id = 72177 AND teamId = 6584340 and type = 33
0.0135  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '61182' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 61182 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0129  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 61182 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0275  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72177 AND t.round = 37 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='61182' AND `active` = 1 AND year = 2024
0.0168  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=6584350 WHERE relp.in_squad=1 and mp.`match_id` = '61182' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0165  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` = '61182' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0157  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 = 61182 AND rel.extraId = 72177 WHERE n.status = 1 AND n.ln='es' AND n.creation_date>'2024-02-28 17:30:00' AND n.creation_date<'2024-04-30 17:04:58' GROUP BY n.id ORDER BY n.cover_points DESC,n.creation_date DESC LIMIT 5
0.0126  SELECT * FROM futbol.calendars_lineups WHERE id = 61182 AND league_id = 72177 AND year = 2024