4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Sevilla Sub 19 - Real Madrid Sub 19
1/16 Final
FINALIZADO
20
10
90 Pts. Elo

186 Pts. Elo

1-2
Domingo, 07 Enero 2024, 18:00
0 - 1
 60' Daniel Yañez
Nacho Vizcaíno 72'
1 - 1
1 - 2
 85' Hugo De Llanos

Eventos del partido

Goles

minuto 60'Daniel YañezGol de Daniel Yañez
Nacho VizcaínoGol de
Nacho Vizcaíno
minuto 72'
minuto 85'Hugo De LlanosGol de Hugo De Llanos

Tarjetas

Bakary SowT. Amarilla
Bakary Sow
minuto 49'
Razvan JaladeT. Amarilla
Razvan Jalade
minuto 90'
minuto 90'Cristian PereaT. Amarilla Cristian Perea

Cambios

Ibra SowSale del partido
Ibra Sow
minuto 17'
JesuliEntra en el partido
Jesuli
minuto 17'
C. ColomerEntra en el partido
C. Colomer
minuto 26'
JesuliSale del partido
Jesuli
minuto 26'
minuto 76'Chema AndrésEntra en el partido Chema Andrés
minuto 76'Pol DuránSale del partido Pol Durán
minuto 82'Daniel YañezSale del partido Daniel Yañez
minuto 82'Paulo IagoEntra en el partido Paulo Iago
Jorge MorenoSale del partido
Jorge Moreno
minuto 86'
Nacho VizcaínoSale del partido
Nacho Vizcaíno
minuto 86'
Iván SalgueroSale del partido
Iván Salguero
minuto 86'
Jesús CruzEntra en el partido
Jesús Cruz
minuto 86'
Á. ArquelladaEntra en el partido
Á. Arquellada
minuto 86'
Edu AltozanoEntra en el partido
Edu Altozano
minuto 86'
minuto 88'Roberto MartínEntra en el partido Roberto Martín
minuto 88'Iker BravoSale del partido Iker Bravo
minuto 88'Dani MesoneroSale del partido Dani Mesonero
minuto 88'Diego AguadoEntra en el partido Diego Aguado

Alineaciones

Sevilla Sub 19

Sevilla Sub 19

4-4-2
Alineación Inicial
Suplentes
Real Madrid Sub 19

Real Madrid Sub 19

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,575,064 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.4636
Total Execution Time  0.4646
  CADENA URL  
/partido/Sevilla-Fc-Juvenil/Real-Madrid-Juvenil/2024
  GET DATOS  
$_GET['/partido/Sevilla-Fc-Juvenil/Real-Madrid-Juvenil/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0105  SELECT data1 FROM stats2024 t WHERE league_id = 74910 AND teamId = 6623967 and type = 33
0.0105  SELECT data1 FROM stats2024 t WHERE league_id = 74910 AND teamId = 6623981 and type = 33
0.0107  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '648347' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 648347 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0106  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 648347 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0106  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='648347' AND `active` = 1 AND year = 2024
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='74910' AND relp.team_id=6623967 WHERE relp.in_squad=1 and mp.`match_id` = '648347' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0157  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='74910' AND relp.team_id=6623981 WHERE relp.in_squad=1 and mp.`match_id` = '648347' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0107  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=648347 AND extraId = 74910 AND type_rel = 4
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1776 AND type_rel = 3
0.0108  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1776 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0109  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 (1236708,1236715,1236706,1235909,1235833) ORDER BY n.cover_points DESC, update_date DESC
0.0105  SELECT rating1, rating2 FROM calendars_elo WHERE id=648347 AND league_id=74910 AND year=2024
0.0105  SELECT position FROM tables2024 WHERE team=6623967 AND league_id=74910 AND round=1
0.0105  SELECT position FROM tables2024 WHERE team=6623981 AND league_id=74910 AND round=1
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 648347 AND league_id = 74910 AND year = 2024