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

Rusia manda a Portugal a la repesca

Quedaron 1 a 1.

Rusia se ha clasificado para el Mundial pese a empatar en Azerbaiyán, por lo que Portugal jugará la repesca.

Un tanto a los 16 minutos de Shirokov adelantó al conjunto ruso, que encajó el empate en los últimos compases con un remate de cabeza de Javadov (m.90)

Rusia, que no jugaba un Mundial desde la edición de Corea del Sur y Japón 2002, acaba líder del grupo F de la zona europea con 22 puntos, uno más que Portugal, a la que de nada le valió vencer en Coimbra a Luxemburgo (3-0) con tantos de Varela (m.30), Nani (36) y Hélder.

No hay comentarios


  USO DE MEMORIA  
4,000,896 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Notice / Index )  0.2513
Total Execution Time  0.2523
  CADENA URL  
/noticia/rusia-manda-portugal-repesca
  GET DATOS  
$_GET['/noticia/rusia-manda-portugal-repesca']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0004   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` = '87705'
0.0160  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 = 'rusia-manda-portugal-repesca' AND n.content_type != 2
0.0150  SELECT * FROM rel_news WHERE id_new = 87705 ORDER BY (type = 5) DESC,(type = 4) DESC, (type = 3) DESC,(type = 1) DESC
0.0149  SELECT title as name,alias FROM topics WHERE id =6
0.0147  SELECT user_name FROM fa_user WHERE id =235713
0.0149  SELECT u.user_name,u.id FROM rel_votes v INNER JOIN fa_user u ON v.userId = u.id WHERE v.contentId = 87705 AND v.contentType = 4 ORDER BY v.datetime ASC
0.0145  SELECT alias FROM `news` as p WHERE author_id = 235713 AND id < 87705 ORDER by p.id DESC LIMIT 1
0.0146  SELECT alias FROM `news` as p WHERE author_id = 235713 AND id > 87705 ORDER BY p.id ASC LIMIT 1
0.0145  SELECT id_content FROM rel_news WHERE id_new = '87705' AND type = '5'
0.0147  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.0145  SELECT * FROM topics ORDER BY priority ASC