4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
UD Logroñés Sub 19 B - Varea Sub 19
Jornada 4
FINALIZADO
00
40
45 Pts. Elo
5º

23 Pts. Elo
16º

6-1
Sábado, 07 Octubre 2023, 17:30
D. Valdes 7'
1 - 0
E. De Miguel 16'
2 - 0
Ángel Nalda 22'
3 - 0
A. Beracoechea 25'
4 - 0
A. Beracoechea 31'
5 - 0
5 - 1
 46' M. Fernandez
D. Hurtado 74'
6 - 1

Eventos del partido

Goles

D. ValdesGol de
D. Valdes
minuto 7'
E. De MiguelGol de
E. De Miguel
minuto 16'
Ángel NaldaGol de
Ángel Nalda
minuto 22'
A. BeracoecheaGol de
A. Beracoechea
minuto 25'
A. BeracoecheaGol de
A. Beracoechea
minuto 31'
minuto 46'M. FernandezGol de M. Fernandez
D. HurtadoGol de
D. Hurtado
minuto 74'

Tarjetas

minuto 32'A. MartinezT. Amarilla A. Martinez
minuto 37'D. NicolasT. Amarilla D. Nicolas
minuto 65'M. FernandezT. Amarilla M. Fernandez
minuto 70'D. SaenzT. Amarilla D. Saenz

Cambios

minuto 34'D. NicolasEntra en el partido D. Nicolas
minuto 34'A. MartinezSale del partido A. Martinez
minuto 46'A. VillaverdeSale del partido A. Villaverde
minuto 46'N. TobiasSale del partido N. Tobias
minuto 46'D. SanchezEntra en el partido D. Sanchez
minuto 46'T. ReinaldoEntra en el partido T. Reinaldo
minuto 46'D. DelgadoEntra en el partido D. Delgado
minuto 46'Bilal ChannoufSale del partido Bilal Channouf
D. ValdesSale del partido
D. Valdes
minuto 55'
M. MuroEntra en el partido
M. Muro
minuto 55'
T. MunillaSale del partido
T. Munilla
minuto 55'
D. HurtadoEntra en el partido
D. Hurtado
minuto 55'
F. VizcainoEntra en el partido
F. Vizcaino
minuto 70'
A. VillarEntra en el partido
A. Villar
minuto 70'
I. TorresSale del partido
I. Torres
minuto 70'
N. SerranoEntra en el partido
N. Serrano
minuto 70'
Ángel NaldaSale del partido
Ángel Nalda
minuto 70'
D. CondeSale del partido
D. Conde
minuto 70'
minuto 74'D. SaenzSale del partido D. Saenz
minuto 74'G. RamirezEntra en el partido G. Ramirez

Alineaciones

UD Logroñés Sub 19 B

UD Logroñés Sub 19 B

4-4-2
Alineación Inicial
Suplentes
Varea Sub 19

Varea Sub 19

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,789,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3695
Total Execution Time  0.3706
  CADENA URL  
/partido/Ud-Logrones-B-Juvenil/Varea-Cd-Juvenil/2024
  GET DATOS  
$_GET['/partido/Ud-Logrones-B-Juvenil/Varea-Cd-Juvenil/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0024  SELECT data1 FROM stats2024 t WHERE league_id = 73382 AND teamId = 6610998 and type = 33
0.0020  SELECT data1 FROM stats2024 t WHERE league_id = 73382 AND teamId = 6610992 and type = 33
0.0029  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '567400' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 567400 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0021  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 567400 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0033  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='567400' AND `active` = 1 AND year = 2024
0.0070  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='73382' AND relp.team_id=6610998 WHERE relp.in_squad=1 and mp.`match_id` = '567400' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0072  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='73382' AND relp.team_id=6610992 WHERE relp.in_squad=1 and mp.`match_id` = '567400' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=567400 AND extraId = 73382 AND type_rel = 4
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=112 AND type_rel = 3
0.0020  SELECT rating1, rating2 FROM calendars_elo WHERE id=567400 AND league_id=73382 AND year=2024
0.0021  SELECT * FROM futbol.calendars_lineups WHERE id = 567400 AND league_id = 73382 AND year = 2024