4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
West Bromwich Albion - Liverpool
FINALIZADO
00
10
2045 Pts. Elo
20º

3290 Pts. Elo

2-2
Sábado, 21 Abril 2018, 13:30
  • Asistencia: 24.520 espectadores
0 - 1
4' Danny Ings
0 - 2
72' M. Salah
Jake Livermore 79'
1 - 2
S. Rondón 88'
2 - 2

Eventos del partido

Goles

minuto 4'Gol de Danny Ings
minuto 72'Gol de M. Salah
Gol de
Jake Livermore
minuto 79'
Gol de
S. Rondón
minuto 88'

Tarjetas

minuto 69'T. Amarilla Alberto Moreno

Cambios

minuto 66'Entra en el partido A. Oxlade-Chamberlain
minuto 66'Sale del partido Sadio Mané
minuto 66'Entra en el partido Roberto Firmino
minuto 66'Sale del partido Danny Ings
Entra en el partido
Jonny Evans
minuto 71'
Sale del partido
J. Mcclean
minuto 71'
Entra en el partido
Oliver Burke
minuto 77'
Sale del partido
Kieran Gibbs
minuto 77'
minuto 83'Sale del partido M. Salah
minuto 83'Entra en el partido Dejan Lovren
Entra en el partido
H. Robson-Kanu
minuto 89'
Sale del partido
Jay Rodríguez
minuto 89'

Otros

minuto 4'Asistencia G. Wijnaldum
minuto 72'Asistencia A. Oxlade-Chamberlain
Asistencia
C. Brunt
minuto 88'
  • susifutbolera
    Hace 6 años susifutbolera dice: 1-4


  USO DE MEMORIA  
6,369,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.2627
Total Execution Time  0.2637
  CADENA URL  
/partido/West-Bromwich/Liverpool/2018
  GET DATOS  
$_GET['/partido/West-Bromwich/Liverpool/2018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0096   SELECT c.comment_id, COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`league_id` = '38633' AND c.`match_id` = '411601' AND c.comment_id IN (19831394) GROUP BY c.comment_id
0.0106  SELECT data1 FROM stats2018 t WHERE league_id = 38633 AND teamId = 782882 and type = 33
0.0105  SELECT data1 FROM stats2018 t WHERE league_id = 38633 AND teamId = 782873 and type = 33
0.0108  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '411601' and rp.type = 2018 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 411601 AND year = 2018 AND channel = 'Footters' LIMIT 1
0.0107  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 411601 AND year = 2018 AND channel = 'Footters' LIMIT 1
0.0108   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '19831394' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0109  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='411601' AND `active` = 1 AND year = 2018
0.0161  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='38633' AND relp.team_id=782882 WHERE relp.in_squad=1 and mp.`match_id` = '411601' AND mp.year='2018' ORDER BY mp.`team` ASC, p.`role` ASC
0.0114  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='38633' AND relp.team_id=782873 WHERE relp.in_squad=1 and mp.`match_id` = '411601' AND mp.year='2018' ORDER BY mp.`team` ASC, p.`role` ASC
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 411601 AND league_id = 38633 AND year = 2018