4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Deportivo Aragón - Real Oviedo
Jornada 6
FINALIZADO
11
11
914 Pts. Elo
11º

1201 Pts. Elo
15º

1-0
Domingo, 06 Octubre 1985, 00:00
Roberto 70'
1 - 0

Eventos del partido

Goles

RobertoGol de
Roberto
minuto 70'

Tarjetas

BlesaT. Amarilla
Blesa
minuto
minuto TomásT. Amarilla Tomás
minuto 60'ThompsonTarjeta Roja a Thompson
RocaTarjeta Roja a
Roca
minuto 60'

Cambios

Gabriel DíazSale del partido
Gabriel Díaz
minuto 73'
HerrerosEntra en el partido
Herreros
minuto 73'
minuto 73'JoaquínEntra en el partido Joaquín
minuto 73'JuanitoSale del partido Juanito
BernalEntra en el partido
Bernal
minuto 89'
RobertoSale del partido
Roberto
minuto 89'

Alineaciones

Deportivo Aragón

Deportivo Aragón

4-4-2
Alineación Inicial
Suplentes
Real Oviedo

Real Oviedo

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,700,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.0870
Total Execution Time  0.0880
  CADENA URL  
/partido/Real-Zaragoza-B/Real-Oviedo/1986
  GET DATOS  
$_GET['/partido/Real-Zaragoza-B/Real-Oviedo/1986']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0018  SELECT data1 FROM stats1986 t WHERE league_id = 5482 AND teamId = 95705 and type = 33
0.0017  SELECT data1 FROM stats1986 t WHERE league_id = 5482 AND teamId = 95702 and type = 33
0.0040  SELECT rdh.pos, rdh.playerId AS player_id, rdh.team, dp.alias, dp.role, dp.name, dp.nick, dp.last_name, '' AS num FROM rel_dreamteam_historical AS rdh INNER JOIN dataplayers AS dp ON rdh.playerId=dp.id WHERE rdh.match_id=360 AND rdh.league_id=5482 ORDER BY rdh.team ASC, rdh.pos ASC, dp.nick ASC
0.0021  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '360' and rp.type = 1986 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 = 360 AND year = 1986 AND channel = 'Footters' LIMIT 1
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 360 AND year = 1986 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='360' AND `active` = 1 AND year = 1986
0.0044  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='5482' AND relp.team_id=95705 WHERE relp.in_squad=1 and mp.`match_id` = '360' AND mp.year='1986' ORDER BY mp.`team` ASC, p.`role` ASC
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='5482' AND relp.team_id=95702 WHERE relp.in_squad=1 and mp.`match_id` = '360' AND mp.year='1986' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '5482' AND id_match = '360'
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=360 AND extraId = 5482 AND type_rel = 4
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 360 AND league_id = 5482 AND year = 1986