4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
CD Huétor Tájar - CD Torreperogil
Jornada 3
FINALIZADO
20
20
75 Pts. Elo
17º

100 Pts. Elo
5º

0-0
Domingo, 24 Septiembre 2023, 16:30

Eventos del partido

Tarjetas

minuto 5'Oscar RuizT. Amarilla Oscar Ruiz
J. EntrenaT. Amarilla
J. Entrena
minuto 63'
Victor ArmeroT. Amarilla
Victor Armero
minuto 70'
minuto 92'Adri GómezT. Amarilla Adri Gómez

Cambios

EstebanSale del partido
Esteban
minuto 55'
Victor ArmeroEntra en el partido
Victor Armero
minuto 55'
J. EntrenaSale del partido
J. Entrena
minuto 66'
CastilloEntra en el partido
Castillo
minuto 66'
minuto 72'J. TalaveraEntra en el partido J. Talavera
minuto 72'PeliSale del partido Peli
minuto 81'Oscar RuizSale del partido Oscar Ruiz
minuto 81'M. BallesterosEntra en el partido M. Ballesteros
BilySale del partido
Bily
minuto 86'
Manu DazaEntra en el partido
Manu Daza
minuto 86'
minuto 90'Chus RoaEntra en el partido Chus Roa
minuto 90'JoserraSale del partido Joserra
minuto 90'Mario OrdoñezSale del partido Mario Ordoñez
minuto 90'LucasEntra en el partido Lucas

Alineaciones

CD Huétor Tájar

CD Huétor Tájar

4-4-2
Alineación Inicial
Suplentes
CD Torreperogil

CD Torreperogil

4-5-1
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,642,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.2799
Total Execution Time  0.2809
  CADENA URL  
/partido/Huetor-Tajar/Cd-Torreperogil-Senior/2019?section=legal
  GET DATOS  
$_GET['/partido/Huetor-Tajar/Cd-Torreperogil-Senior/2019']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0019  SELECT data1 FROM stats2024 t WHERE league_id = 72268 AND teamId = 6586259 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72268 AND teamId = 6586269 and type = 33
0.0024  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '456392' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 456392 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0020  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 456392 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0024  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='456392' AND `active` = 1 AND year = 2024
0.0311  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='72268' AND relp.team_id=6586259 WHERE relp.in_squad=1 and mp.`match_id` = '456392' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0085  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='72268' AND relp.team_id=6586269 WHERE relp.in_squad=1 and mp.`match_id` = '456392' 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=456392 AND extraId = 72268 AND type_rel = 4
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 456392 AND league_id = 72268 AND year = 2024