4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

El Oviedo y el getafe B empatan

El Oviedo prolongó su racha positiva a seis jornadas sin perder.

Aitor Sanz

Aitor Sanz controlando un balón Imagen subida por: batgol


El Oviedo prolongó su racha positiva a seis jornadas sin perder. Sin embargo, en su visita al Coliseum no ofreció una buena imagen con un filial azulón que desperdició varias ocasiones. También hay que destacar el acierto de Lledó en la portería azulona. El Getafe obtuvo su premio en la segunda parte con un tanto de Javi Flores, a la salida de un córner. Los oviedistas se rehicieron y empataron por medio de Aitor Sanz. Incluso el partido se les puso de cara con la expulsión del local Álex Pérez, pero las dos expulsiones de Aitor Sanz y Rubiato hizo que el Oviedo acabase con nueve y satisfecho con el punto sumado. Lamentar en este encuentro la lesión de Rubén Sánchez que tuvo que ser evacuado.

No hay comentarios


  USO DE MEMORIA  
3,989,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Notice / Index )  0.0574
Total Execution Time  0.0590
  CADENA URL  
/noticia/oviedo-getafe-b-empatan
  GET DATOS  
$_GET['/noticia/oviedo-getafe-b-empatan']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0003   SELECT 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.`new_content_id` = '50451'
0.0025  SELECT n.*,rn.*,u.user_name,u.user_name as media_username,p.title as ptitle,p.width,p.height,v.code,v.title as vtitle,p.id as pid,v.id as vid,p.author_id as pauthor_id,v.author_id as vauthor_id, v.url as video_url, v.type AS vtype FROM `news` n INNER JOIN fa_user u ON u.id = n.author_id INNER JOIN `rel_news` as rn ON n.id = rn.id_new LEFT JOIN `pictures` as p ON n.picture_content_id = p.id AND p.banned=0 LEFT JOIN `videos` as v ON n.video_content_id = v.id WHERE n.alias = 'oviedo-getafe-b-empatan' AND n.content_type != 2
0.0018  SELECT user_name FROM `fa_user` WHERE id = 5295
0.0026  SELECT * FROM rel_news WHERE id_new = 50451 ORDER BY (type = 5) DESC,(type = 4) DESC, (type = 3) DESC,(type = 1) DESC
0.0019  SELECT title as name,alias FROM topics WHERE id =25
0.0018  SELECT user_name FROM fa_user WHERE id =226111
0.0022  SELECT u.user_name,u.id FROM rel_votes v INNER JOIN fa_user u ON v.userId = u.id WHERE v.contentId = 50451 AND v.contentType = 4 ORDER BY v.datetime ASC
0.0021  SELECT alias FROM `news` as p WHERE author_id = 226111 AND id < 50451 ORDER by p.id DESC LIMIT 1
0.0021  SELECT alias FROM `news` as p WHERE author_id = 226111 AND id > 50451 ORDER BY p.id ASC LIMIT 1
0.0018  SELECT id_content FROM rel_news WHERE id_new = '50451' AND type = '5'
0.0021  SELECT l.id,c.`name` as name,l.group_code,l.total_group,c.CountryCode,c.`alias` as alias FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.status = 1 AND l.links = 2 AND l.year = 2024 AND c.listed = 1 AND l.tables = 1 AND l.group_code > 0 AND c.troncal = 1 AND l.game = 1 AND c.class < 5 ORDER BY c.coefficient DESC, c.name ASC ,l.group_code ASC
0.0019  SELECT * FROM topics ORDER BY priority ASC