4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Charlton Athletic - Queens Park Rangers
Jornada 32
FINALIZADO
10
00
1153 Pts. Elo
20º

1371 Pts. Elo
4º

1-0
Sábado, 22 Febrero 2014, 16:00
  • Asistencia: 17.333 espectadores
J. Jackson 90'
1 - 0

Eventos del partido

Goles

J. JacksonGol de
J. Jackson
minuto 90'

Tarjetas

J. JacksonT. Amarilla
J. Jackson
minuto 90'

Cambios

minuto 59'W. KeaneEntra en el partido W. Keane
minuto 59'J. HoilettSale del partido J. Hoilett
GhoochannejhadSale del partido
Ghoochannejhad
minuto 64'
A. AjdarevićEntra en el partido
A. Ajdarević
minuto 64'
D. GreenSale del partido
D. Green
minuto 64'
Marcus TudgayEntra en el partido
Marcus Tudgay
minuto 64'
minuto 70'K. DoyleSale del partido K. Doyle
minuto 70'M. MaïgaEntra en el partido M. Maïga
minuto 81'Thomas CarrollSale del partido Thomas Carroll
minuto 81'Y. BenayounEntra en el partido Y. Benayoun
S. ChurchSale del partido
S. Church
minuto 89'
Callum HarriottEntra en el partido
Callum Harriott
minuto 89'

Alineaciones

Charlton Athletic

Charlton Athletic

4-4-2
Alineación Inicial
Suplentes
Queens Park Rangers

Queens Park Rangers

4-5-1
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,989,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3522
Total Execution Time  0.3532
  CADENA URL  
/partido/Charlton-Athletic-Fc/Queens-Park-Rangers-Fc/2014
  GET DATOS  
$_GET['/partido/Charlton-Athletic-Fc/Queens-Park-Rangers-Fc/2014']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0126  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '64839' and rp.type = 2014 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 64839 AND year = 2014 AND channel = 'Footters' LIMIT 1
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 64839 AND year = 2014 AND channel = 'Footters' LIMIT 1
0.0125  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='64839' AND `active` = 1 AND year = 2014
0.0245  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='2437' AND relp.team_id=51216 WHERE relp.in_squad=1 and mp.`match_id` = '64839' AND mp.year='2014' ORDER BY mp.`team` ASC, p.`role` ASC
0.0265  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='2437' AND relp.team_id=51213 WHERE relp.in_squad=1 and mp.`match_id` = '64839' AND mp.year='2014' ORDER BY mp.`team` ASC, p.`role` ASC
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=64839 AND extraId = 2437 AND type_rel = 4
0.0125  SELECT * FROM futbol.calendars_lineups WHERE id = 64839 AND league_id = 2437 AND year = 2014