4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Chorley - FC Halifax Town
FINALIZADO
10
10
237 Pts. Elo
24º

222 Pts. Elo

0-1
Sábado, 25 Enero 2020, 16:00
0 - 1
60' C. King

Eventos del partido

Goles

minuto 60'C. KingGol de C. King

Tarjetas

C. Meppen-WaltersT. Amarilla
C. Meppen-Walters
minuto 8'
minuto 77'J. KingT. Amarilla J. King

Cambios

C. HallSale del partido
C. Hall
minuto 71'
C. HolroydEntra en el partido
C. Holroyd
minuto 71'
C. Meppen-WaltersSale del partido
C. Meppen-Walters
minuto 71'
Josh O'keefeEntra en el partido
Josh O'keefe
minuto 71'
minuto 79'J. RedshawSale del partido J. Redshaw
minuto 79'J. AllenEntra en el partido J. Allen
minuto 81'C. KingSale del partido C. King
minuto 81'M. DuckworthEntra en el partido M. Duckworth
minuto 90'D. RodneySale del partido D. Rodney
minuto 90'T. Sho-SilvaEntra en el partido T. Sho-Silva

Alineaciones




  USO DE MEMORIA  
6,631,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.2708
Total Execution Time  0.2719
  CADENA URL  
/partido/Chorley-139/Halifax-Town/2020
  GET DATOS  
$_GET['/partido/Chorley-139/Halifax-Town/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0018  SELECT data1 FROM stats2020 t WHERE league_id = 50119 AND teamId = 6283914 and type = 33
0.0017  SELECT data1 FROM stats2020 t WHERE league_id = 50119 AND teamId = 6283921 and type = 33
0.0023  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '146245' and rp.type = 2020 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 146245 AND year = 2020 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 146245 AND year = 2020 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='146245' AND `active` = 1 AND year = 2020
0.0226  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='50119' AND relp.team_id=6283914 WHERE relp.in_squad=1 and mp.`match_id` = '146245' AND mp.year='2020' ORDER BY mp.`team` ASC, p.`role` ASC
0.0227  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='50119' AND relp.team_id=6283921 WHERE relp.in_squad=1 and mp.`match_id` = '146245' AND mp.year='2020' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=146245 AND extraId = 50119 AND type_rel = 4
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 146245 AND league_id = 50119 AND year = 2020