¿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
AD San Juan Sub 19 - UD Logroñés Sub 19
Jornada 4
FINALIZADO
40
40
28 Pts. Elo
4º

22 Pts. Elo
3º

1-1
Domingo, 22 Septiembre 2024, 12:00
0 - 1
 11' D. González
U. Elso 90'
1 - 1

Eventos del partido

Goles

minuto 11'D. GonzálezGol de D. González
U. ElsoGol de
U. Elso
minuto 90'

Tarjetas

M. HerranzT. Amarilla
M. Herranz
minuto 49'
Unai LandaT. Amarilla
Unai Landa
minuto 75'
minuto 76'C. EspinosaT. Amarilla C. Espinosa
A. ArocenaT. Amarilla
A. Arocena
minuto 77'
minuto 81'L. IssmanT. Amarilla L. Issman
minuto 87'Ángel NaldaT. Amarilla Ángel Nalda
minuto 90'Dani MartínezT. Amarilla Dani Martínez
U. ElsoT. Amarilla
U. Elso
minuto 90'

Cambios

minuto 68'Moussa SangareEntra en el partido Moussa Sangare
minuto 68'J. HugoSale del partido J. Hugo
minuto 68'Ángel NaldaEntra en el partido Ángel Nalda
minuto 68'Raúl BelloSale del partido Raúl Bello
X. TamaritSale del partido
X. Tamarit
minuto 71'
M. HerranzSale del partido
M. Herranz
minuto 71'
J. EstivezEntra en el partido
J. Estivez
minuto 71'
J. AgorretaEntra en el partido
J. Agorreta
minuto 71'
Unai LandaSale del partido
Unai Landa
minuto 76'
C. LópezEntra en el partido
C. López
minuto 76'
minuto 78'Dani MartínezEntra en el partido Dani Martínez
minuto 78'L. IssmanEntra en el partido L. Issman
minuto 78'C. EspinosaSale del partido C. Espinosa
minuto 78'D. GonzálezSale del partido D. González
U. MunuceEntra en el partido
U. Munuce
minuto 85'
Ibai GonzálezSale del partido
Ibai González
minuto 85'

Alineaciones

AD San Juan Sub 19

AD San Juan 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,167,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Match / Index )  1.1442
Total Execution Time  1.1455
  CADENA URL  
/partido/Ad-San-Juan-Juvenil/Ud-Logrones-Juvenil
  GET DATOS  
$_GET['/partido/Ad-San-Juan-Juvenil/Ud-Logrones-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0105  SELECT data1 FROM stats2025 t WHERE league_id = 77072 AND teamId = 6656405 and type = 33
0.0105  SELECT data1 FROM stats2025 t WHERE league_id = 77072 AND teamId = 6656397 and type = 33
0.0106  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '99208' 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 = 99208 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0105  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 99208 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0109  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 = 77072 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='99208' AND `active` = 1 AND year = 2025
0.0120  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=6656405 WHERE relp.in_squad=1 and mp.`match_id` = '99208' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0120  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` = '99208' 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=99208 AND extraId = 77072 AND type_rel = 4
0.0105  SELECT rating1, rating2 FROM calendars_elo WHERE id=99208 AND league_id=77072 AND year=2025
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 99208 AND league_id = 77072 AND year = 2025