4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Unión Adarve Sub 19 - Alcorcón Sub 19
Jornada 14
FINALIZADO
40
20
26 Pts. Elo
9º

21 Pts. Elo
14º

1-0
Sábado, 09 Diciembre 2023, 16:00
Alejandro Pérez 2'
1 - 0

Eventos del partido

Goles

Alejandro PérezGol de
Alejandro Pérez
minuto 2'

Tarjetas

Javier PulidoT. Amarilla
Javier Pulido
minuto 13'
Rubén MunicioT. Amarilla
Rubén Municio
minuto 33'
minuto 41'N. Di DomenicoT. Amarilla N. Di Domenico
Carlos HidalgoT. Amarilla
Carlos Hidalgo
minuto 61'
minuto 65'Alonso PérezT. Amarilla Alonso Pérez
Julián MartinT. Amarilla
Julián Martin
minuto 78'

Cambios

minuto 45'Hugo GuillenEntra en el partido Hugo Guillen
minuto 45'Adrián PereaSale del partido Adrián Perea
Miguel RuizEntra en el partido
Miguel Ruiz
minuto 53'
Javier PulidoSale del partido
Javier Pulido
minuto 53'
Daniel UtreraEntra en el partido
Daniel Utrera
minuto 67'
G. De VargasSale del partido
G. De Vargas
minuto 67'
D. CaparrósSale del partido
D. Caparrós
minuto 67'
I. AlarconEntra en el partido
I. Alarcon
minuto 67'
minuto 70'C. SánchezSale del partido C. Sánchez
minuto 70'Raúl GonzálezEntra en el partido Raúl González
minuto 78'Víctor GordoEntra en el partido Víctor Gordo
minuto 78'D. MartinEntra en el partido D. Martin
minuto 78'Marco VergaraSale del partido Marco Vergara
minuto 78'Jaume IbarsSale del partido Jaume Ibars
minuto 82'N. SerranoEntra en el partido N. Serrano
minuto 82'N. Di DomenicoSale del partido N. Di Domenico
Álvaro GarcíaEntra en el partido
Álvaro García
minuto 86'
Carlos HidalgoSale del partido
Carlos Hidalgo
minuto 86'

Alineaciones

Unión Adarve Sub 19

Unión Adarve Sub 19

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

Alcorcón Sub 19

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,834,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Match / Index )  0.4848
Total Execution Time  0.4865
  CADENA URL  
/partido/Union-Adarve-Juvenil/Ad-Alcorcon-Juvenil/2024?section=legal
  GET DATOS  
$_GET['/partido/Union-Adarve-Juvenil/Ad-Alcorcon-Juvenil/2024']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0147  SELECT data1 FROM stats2024 t WHERE league_id = 73245 AND teamId = 6599206 and type = 33
0.0144  SELECT data1 FROM stats2024 t WHERE league_id = 73245 AND teamId = 6599205 and type = 33
0.0150  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '433407' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 433407 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0145  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 433407 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0145  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='433407' AND `active` = 1 AND year = 2024
0.0163  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=6599206 WHERE relp.in_squad=1 and mp.`match_id` = '433407' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0173  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=6599205 WHERE relp.in_squad=1 and mp.`match_id` = '433407' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=433407 AND extraId = 73245 AND type_rel = 4
0.0146  SELECT rating1, rating2 FROM calendars_elo WHERE id=433407 AND league_id=73245 AND year=2024
0.0148  SELECT * FROM futbol.calendars_lineups WHERE id = 433407 AND league_id = 73245 AND year = 2024