4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Sunderland - Sporting CP
Octavos
FINALIZADO
00
00
1637 Pts. Elo

2640 Pts. Elo

2-1
Miércoles, 24 Octubre 1973, 00:00
  • Asistencia: 31.568 espectadores
Bobby Kerr 32'
1 - 0
Mick Horswill 64'
2 - 0
2 - 1
 85' H. Yazalde

Eventos del partido

Goles

Bobby KerrGol de
Bobby Kerr
minuto 32'
Mick HorswillGol de
Mick Horswill
minuto 64'
minuto 85'H. YazaldeGol de H. Yazalde

Cambios

minuto 74'NandoSale del partido Nando
minuto 74'ToméEntra en el partido Tomé

Alineaciones

Sunderland

Sunderland

4-4-2
Alineación Inicial
Sporting CP

Sporting CP

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,611,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Match / Index )  0.3189
Total Execution Time  0.3204
  CADENA URL  
/partido/Sunderland-Afc/Sporting-Lisbon/1974
  GET DATOS  
$_GET['/partido/Sunderland-Afc/Sporting-Lisbon/1974']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0144  SELECT data1 FROM stats1974 t WHERE league_id = 11050 AND teamId = 172817 and type = 33
0.0144  SELECT data1 FROM stats1974 t WHERE league_id = 11050 AND teamId = 172816 and type = 33
0.0146  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '4331' and rp.type = 1974 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 4331 AND year = 1974 AND channel = 'Footters' LIMIT 1
0.0144  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 4331 AND year = 1974 AND channel = 'Footters' LIMIT 1
0.0144  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='4331' AND `active` = 1 AND year = 1974
0.0155  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='11050' AND relp.team_id=172817 WHERE relp.in_squad=1 and mp.`match_id` = '4331' AND mp.year='1974' ORDER BY mp.`team` ASC, p.`role` ASC
0.0179  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='11050' AND relp.team_id=172816 WHERE relp.in_squad=1 and mp.`match_id` = '4331' AND mp.year='1974' ORDER BY mp.`team` ASC, p.`role` ASC
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4331 AND extraId = 11050 AND type_rel = 4
0.0147  SELECT position FROM tables1974 WHERE team=172817 AND league_id=11050 AND round=2
0.0149  SELECT position FROM tables1974 WHERE team=172816 AND league_id=11050 AND round=2
0.0145  SELECT * FROM futbol.calendars_lineups WHERE id = 4331 AND league_id = 11050 AND year = 1974