4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Portland Timbers - Sporting Kansas City
Jornada 14
FINALIZADO
10
40
1594 Pts. Elo
11º

2008 Pts. Elo
2º

0-1
Sábado, 28 Junio 2014, 05:00
0 - 1
 24' L. Olum

Eventos del partido

Goles

minuto 24'L. OlumGol de L. Olum

Tarjetas

minuto 36'S. SinovicT. Amarilla S. Sinovic
minuto 65'K. EllisT. Amarilla K. Ellis
minuto 90'D. DwyerT. Amarilla D. Dwyer
Will JohnsonT. Amarilla
Will Johnson
minuto 90'
minuto 90'P. NagamuraT. Amarilla P. Nagamura

Cambios

minuto 56'L. OlumSale del partido L. Olum
minuto 56'C.j. SapongEntra en el partido C.j. Sapong
R. WallaceSale del partido
R. Wallace
minuto 65'
G. FernándezEntra en el partido
G. Fernández
minuto 65'
minuto 80'A. MartinezEntra en el partido A. Martinez
minuto 80'S. ZizzoSale del partido S. Zizzo
M. HarringtonSale del partido
M. Harrington
minuto 82'
Maxi UrrutiEntra en el partido
Maxi Urruti
minuto 82'

Alineaciones

Portland Timbers

Portland Timbers

4-4-2
Alineación Inicial
Suplentes
Sporting Kansas City

Sporting Kansas City

4-4-2
Alineación Inicial
Suplentes

Estadísticas del partido

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: comment/main_view.php

Line Number: 2068

Portland Timbers Portland Sporting Kansas City Sporting


  USO DE MEMORIA  
5,898,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.0936
Total Execution Time  0.0947
  CADENA URL  
/partido/Portland-Timbers/Kansas-City-Wizards/2014
  GET DATOS  
$_GET['/partido/Portland-Timbers/Kansas-City-Wizards/2014']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0019  SELECT data1 FROM stats2014 t WHERE league_id = 3632 AND teamId = 67671 and type = 33
0.0018  SELECT data1 FROM stats2014 t WHERE league_id = 3632 AND teamId = 67675 and type = 33
0.0021  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '178868' and rp.type = 2014 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 = 178868 AND year = 2014 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 178868 AND year = 2014 AND channel = 'Footters' LIMIT 1
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 3632 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='178868' AND `active` = 1 AND year = 2014
0.0029  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='3632' AND relp.team_id=67671 WHERE relp.in_squad=1 and mp.`match_id` = '178868' AND mp.year='2014' ORDER BY mp.`team` ASC, p.`role` ASC
0.0025  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='3632' AND relp.team_id=67675 WHERE relp.in_squad=1 and mp.`match_id` = '178868' AND mp.year='2014' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=178868 AND extraId = 3632 AND type_rel = 4
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 178868 AND league_id = 3632 AND year = 2014