4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Real Avilés Sub 19 - Real Sporting Sub 19
Jornada 29
FINALIZADO
20
00
17 Pts. Elo
18º

66 Pts. Elo
4º

1-4
Domingo, 17 Abril 2022, 12:00
Pau Silva 1'
1 - 0
1 - 1
 34' Samu Montes
1 - 2
 56' Tomás Fuentes
1 - 3
 66' David Núñez
1 - 4
 90' David Núñez

Eventos del partido

Goles

Pau SilvaGol de
Pau Silva
minuto 1'
minuto 34'Samu MontesGol de Samu Montes
minuto 56'Tomás FuentesGol de Tomás Fuentes
minuto 66'David NúñezGol de penalti David Núñez
minuto 90'David NúñezGol de David Núñez

Tarjetas

S. CernudaT. Amarilla
S. Cernuda
minuto 35'
RodrigoT. Amarilla
Rodrigo
minuto 71'

Cambios

GómezSale del partido
Gómez
minuto 57'
J. SoñezSale del partido
J. Soñez
minuto 57'
Carlos CarballoEntra en el partido
Carlos Carballo
minuto 57'
Pau SilvaSale del partido
Pau Silva
minuto 57'
I. DíazEntra en el partido
I. Díaz
minuto 57'
Pau XifréEntra en el partido
Pau Xifré
minuto 57'
Diego Augusto EncaboSale del partido
Diego Augusto Encabo
minuto 64'
OriolEntra en el partido
Oriol
minuto 64'
minuto 70'BesteiroEntra en el partido Besteiro
minuto 70'Tomás FuentesSale del partido Tomás Fuentes
minuto 70'Sergio DacalEntra en el partido Sergio Dacal
minuto 70'Dani SáezSale del partido Dani Sáez
minuto 77'Dani PérezSale del partido Dani Pérez
minuto 77'C. MoránEntra en el partido C. Morán
minuto 84'Samu MontesSale del partido Samu Montes
minuto 84'Sergio GutiérrezEntra en el partido Sergio Gutiérrez
minuto 84'C. HernándezSale del partido C. Hernández
minuto 84'Adrián RuedaEntra en el partido Adrián Rueda
C. HernandezEntra en el partido
C. Hernandez
minuto 86'
Michael AgborSale del partido
Michael Agbor
minuto 86'

Alineaciones

Real Avilés Sub 19

Real Avilés Sub 19

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

Real Sporting Sub 19

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,916,512 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.5929
Total Execution Time  0.5939
  CADENA URL  
/partido/Real-Aviles-Cf-Juvenil/Real-Sporting-Juvenil/2022
  GET DATOS  
$_GET['/partido/Real-Aviles-Cf-Juvenil/Real-Sporting-Juvenil/2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0147  SELECT data1 FROM stats2022 t WHERE league_id = 63680 AND teamId = 6457439 and type = 33
0.0146  SELECT data1 FROM stats2022 t WHERE league_id = 63680 AND teamId = 6457450 and type = 33
0.0148  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '134781' and rp.type = 2022 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 134781 AND year = 2022 AND channel = 'Footters' LIMIT 1
0.0144  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 134781 AND year = 2022 AND channel = 'Footters' LIMIT 1
0.0145  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='134781' AND `active` = 1 AND year = 2022
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='63680' AND relp.team_id=6457439 WHERE relp.in_squad=1 and mp.`match_id` = '134781' AND mp.year='2022' ORDER BY mp.`team` ASC, p.`role` ASC
0.0173  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='63680' AND relp.team_id=6457450 WHERE relp.in_squad=1 and mp.`match_id` = '134781' AND mp.year='2022' ORDER BY mp.`team` ASC, p.`role` ASC
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=134781 AND extraId = 63680 AND type_rel = 4
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=156 AND type_rel = 3
0.0151  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 156 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147  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 (1312138,1296752,1287260,1285942,1285456) ORDER BY n.cover_points DESC, update_date DESC
0.0144  SELECT rating1, rating2 FROM calendars_elo WHERE id=134781 AND league_id=63680 AND year=2022
0.0145  SELECT * FROM futbol.calendars_lineups WHERE id = 134781 AND league_id = 63680 AND year = 2022