¿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
SD Logroñés Sub 19 - La Calzada Sub 19
Jornada 21
FINALIZADO
10
10
16 Pts. Elo
13º

24 Pts. Elo
4º

0-1
Domingo, 23 Febrero 2025, 11:15
0 - 1
 23' R. Ochoa

Eventos del partido

Goles

minuto 23'R. OchoaGol de R. Ochoa

Tarjetas

minuto 65'D. DiazT. Amarilla D. Diaz
M. NajeraT. Amarilla
M. Najera
minuto 87'

Cambios

minuto 13'S. SaidiSale del partido S. Saidi
minuto 13'S. LopezEntra en el partido S. Lopez
minuto 46'B. MonteroSale del partido B. Montero
minuto 46'G. MartínSale del partido G. Martín
D. LopezSale del partido
D. Lopez
minuto 46'
D. San MartinEntra en el partido
D. San Martin
minuto 46'
minuto 46'D. GomezEntra en el partido D. Gomez
minuto 46'Y. CasadoEntra en el partido Y. Casado
minuto 66'L. PerezSale del partido L. Perez
minuto 66'Raul ZarcoEntra en el partido Raul Zarco
Y. ZiyaniSale del partido
Y. Ziyani
minuto 70'
I. UretaEntra en el partido
I. Ureta
minuto 70'
minuto 75'J. RodriguezEntra en el partido J. Rodriguez
minuto 75'G. OrtegaSale del partido G. Ortega
A. BravoEntra en el partido
A. Bravo
minuto 89'
J. ArechavaletaSale del partido
J. Arechavaleta
minuto 89'

Alineaciones

SD Logroñés Sub 19

SD Logroñés Sub 19

4-4-2
Alineación Inicial
Suplentes
La Calzada Sub 19

La Calzada Sub 19

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,574,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Match / Index )  1.0295
Total Execution Time  1.0307
  CADENA URL  
/partido/Sd-Logrones-Juvenil/La-Calzada-Juvenil
  GET DATOS  
$_GET['/partido/Sd-Logrones-Juvenil/La-Calzada-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0105  SELECT data1 FROM stats2025 t WHERE league_id = 76825 AND teamId = 6662949 and type = 33
0.0104  SELECT data1 FROM stats2025 t WHERE league_id = 76825 AND teamId = 6662954 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 = '142645' and rp.type = 2025 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 = 142645 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0105  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 142645 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0130  SELECT t.points,t.team,t.round FROM `tables2025` 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 = 76825 AND t.round >= 6 AND t.round <= 21 ORDER BY t.round ASC, t.points DESC, cast(t.gf as signed) - cast(t.ga as signed) DESC, t.ga DESC, dt.nameShow ASC
0.0105  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='142645' AND `active` = 1 AND year = 2025
0.0116  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='76825' AND relp.team_id=6662949 WHERE relp.in_squad=1 and mp.`match_id` = '142645' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0115  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='76825' AND relp.team_id=6662954 WHERE relp.in_squad=1 and mp.`match_id` = '142645' 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=142645 AND extraId = 76825 AND type_rel = 4
0.0105  SELECT rating1, rating2 FROM calendars_elo WHERE id=142645 AND league_id=76825 AND year=2025
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 142645 AND league_id = 76825 AND year = 2025