¿Eres mayor de edad?

SI NO

Confirma si tienes 18 años

Faldón apuestas
4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Real Sociedad Sub 19 - UD Logroñés Sub 19
Jornada 18
FINALIZADO
20
50
55 Pts. Elo
5º

22 Pts. Elo
8º

1-2
Sábado, 25 Enero 2025, 16:30
0 - 1
 14' P. Santolaya
0 - 2
 25' D. González
U. Alfageme 67'
1 - 2

Eventos del partido

Goles

minuto 14'P. SantolayaGol de P. Santolaya
minuto 25'D. GonzálezGol de D. González
U. AlfagemeGol de
U. Alfageme
minuto 67'

Tarjetas

Unax AyoT. Amarilla
Unax Ayo
minuto 42'
minuto 61'L. IssmanT. Amarilla L. Issman
minuto 72'P. SantolayaT. Amarilla P. Santolaya
minuto 78'D. GonzálezT. Amarilla D. González
I. CalderonT. Amarilla
I. Calderon
minuto 78'
minuto 80'Iñaki CamposT. Amarilla Iñaki Campos
minuto 87'Eder LarreaT. Amarilla Eder Larrea

Cambios

Aimar MadinaSale del partido
Aimar Madina
minuto 46'
D. LópezSale del partido
D. López
minuto 46'
E. UgaldeEntra en el partido
E. Ugalde
minuto 46'
Joel MartinezEntra en el partido
Joel Martinez
minuto 46'
L. PetrovicSale del partido
L. Petrovic
minuto 60'
Eloy NebredaSale del partido
Eloy Nebreda
minuto 60'
Eiji KuboEntra en el partido
Eiji Kubo
minuto 60'
U. AlfagemeEntra en el partido
U. Alfageme
minuto 60'
minuto 70'P. AldamaSale del partido P. Aldama
minuto 70'Dani MartínezEntra en el partido Dani Martínez
I. CalderonSale del partido
I. Calderon
minuto 81'
M. ElcanoEntra en el partido
M. Elcano
minuto 81'
minuto 85'D. GonzálezSale del partido D. González
minuto 85'C. EspinosaSale del partido C. Espinosa
minuto 85'J. HugoEntra en el partido J. Hugo
minuto 85'A. BeracoecheaEntra en el partido A. Beracoechea

Alineaciones

Real Sociedad Sub 19

Real Sociedad Sub 19

4-4-2
Alineación Inicial
Suplentes
UD Logroñés Sub 19

UD Logroñés Sub 19

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,634,336 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  1.2001
Total Execution Time  1.2011
  CADENA URL  
/partido/Real-Sociedad-Futbol-Juvenil/Ud-Logrones-Juvenil/2025?section=legal
  GET DATOS  
$_GET['/partido/Real-Sociedad-Futbol-Juvenil/Ud-Logrones-Juvenil/2025']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0215  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 77072
0.0108  SELECT data1 FROM stats2025 t WHERE league_id = 77072 AND teamId = 6656403 and type = 33
0.0108  SELECT data1 FROM stats2025 t WHERE league_id = 77072 AND teamId = 6656397 and type = 33
0.0111  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '100373' and rp.type = 2025 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0108  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 100373 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0110  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 100373 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0118  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 77072 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='100373' AND `active` = 1 AND year = 2025
0.0207  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='77072' AND relp.team_id=6656403 WHERE relp.in_squad=1 and mp.`match_id` = '100373' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0133  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='77072' AND relp.team_id=6656397 WHERE relp.in_squad=1 and mp.`match_id` = '100373' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=100373 AND extraId = 77072 AND type_rel = 4
0.0106  SELECT rating1, rating2 FROM calendars_elo WHERE id=100373 AND league_id=77072 AND year=2025
0.0106  SELECT * FROM futbol.calendars_lineups WHERE id = 100373 AND league_id = 77072 AND year = 2025