4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
UD Sanse Sub 19 - Atlético Sub 19
Jornada 28
FINALIZADO
00
00
20 Pts. Elo
11º

134 Pts. Elo
1º

0-2
Sábado, 20 Abril 2024, 17:00
0 - 1
 7' Javi Alonso
0 - 2
 34' Darío Frey

UD Sanse Sub 19

4-4-2
Alineación Inicial
Suplentes

Atlético Sub 19

4-4-2
Alineación Inicial
Suplentes
UD Sanse Sub 19
Atlético Sub 19
Gol
Gol
Sale del partido
Entra en el partido
Entra en el partido
Entra en el partido
Sale del partido
Sale del partido
Sale del partido
Sale del partido
Sale del partido
Sale del partido
Entra en el partido
Entra en el partido
Entra en el partido
Entra en el partido
Sale del partido
Entra en el partido
Entra en el partido
Sale del partido
Sale del partido
Entra en el partido

Eventos del partido

Goles

minuto 7'Gol de Javi Alonso
minuto 34'Gol de Darío Frey

Cambios

minuto 45'Sale del partido Seydou Fall
minuto 45'Entra en el partido J. Castellanos
minuto 45'Entra en el partido Iván Vasiljevic
Entra en el partido
Hugo Gila
minuto 45'
Sale del partido
Mario Caballero
minuto 45'
minuto 45'Sale del partido Jano Monserrate
Sale del partido
L. Simon
minuto 61'
minuto 61'Sale del partido S. Rublico
minuto 61'Sale del partido Omar Janneh
Sale del partido
G. Negrete
minuto 61'
Entra en el partido
H. Gutiérrez
minuto 61'
minuto 61'Entra en el partido Paco Esteban
Entra en el partido
F. Ferreres
minuto 61'
minuto 61'Entra en el partido Diego Rosado
Sale del partido
Ian Tejero
minuto 67'
Entra en el partido
A. Sow
minuto 67'
Entra en el partido
Marcos Rayo
minuto 67'
Sale del partido
F. Crespo
minuto 67'
minuto 71'Sale del partido Raúl Girona
minuto 71'Entra en el partido Félix Giménez
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
6,868,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Match / Index )  0.3976
Total Execution Time  0.3994
  CADENA URL  
/partido/San-Sebastian-Reyes-A-Juvenil/Atletico-Madrid-Juvenil/2024
  GET DATOS  
$_GET['/partido/San-Sebastian-Reyes-A-Juvenil/Atletico-Madrid-Juvenil/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0020   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2024 AS ev WHERE ev.match_id=434800 ORDER BY (ev.action=1 OR ev.action=2 OR ev.action=6 OR ev.action=11 OR ev.action=12 OR ev.action=13) DESC,(ev.action=3 OR ev.action=4 OR ev.action=5) DESC,(ev.action=14 OR ev.action=15 OR ev.action=16 OR ev.action=17 OR ev.action=21) DESC,(ev.action=18 OR ev.action=19) DESC,(ev.action=20 OR ev.action=22) DESC, minute ASC, ev.real_date ASC, ev.id DESC, ev.action DESC
0.0046   SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=73245 WHERE dp.id IN (904112,3189174,3183913,3189171,3187360,3314668,1029131,3183986,3531779,3189055,3257586,3455781,3342564,3189480,3314695,904087,3314635,3520460,3325572,3279307,3184351,3265803) AND (rp.team_id=6599211 OR rp.team_id=6599207)
0.0051   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2024 AS ev WHERE ev.match_id=434800 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0026   SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=73245 WHERE dp.id IN (904112,3189174,3183913,3189171,3187360,3314668,1029131,3183986,3531779,3189055,3257586,3455781,3342564,3189480,3314695,904087,3314635,3520460,3325572,3279307,3184351,3265803) AND (rp.team_id=6599211 OR rp.team_id=6599207)
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 73245 AND teamId = 6599211 and type = 33
0.0019  SELECT data1 FROM stats2024 t WHERE league_id = 73245 AND teamId = 6599207 and type = 33
0.0046  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '434800' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 434800 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0039  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 434800 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='434800' AND `active` = 1 AND year = 2024
0.0053  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='73245' AND relp.team_id=6599211 WHERE relp.in_squad=1 and mp.`match_id` = '434800' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0043  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='73245' AND relp.team_id=6599207 WHERE relp.in_squad=1 and mp.`match_id` = '434800' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=434800 AND extraId = 73245 AND type_rel = 4
0.0018  SELECT rating1, rating2 FROM calendars_elo WHERE id=434800 AND league_id=73245 AND year=2024
0.0019  SELECT * FROM futbol.calendars_lineups WHERE id = 434800 AND league_id = 73245 AND year = 2024