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

Sorteo de la Copa, la semana que viene.

Lo que todos los clasificados de 2ªB estamos esperando será la semana que viene.

4comenta tu también!
Hace 13 años por 7vallesRiojanos
|
Detalle de votos
Pedro, en Mónaco, con la supercopa de Europa

Una de copas Imagen subida por: templario2009

8

El sorteo de la copa del rey referente a los dieciseisavos de final será el próximo día 22 de Septiembre (miércoles) a las 13:00 en Las Rozas según la RFEF. Suerte para la UDL

4 Comentarios
  • glorioso1990
    Hace 13 años glorioso1990 dice: yo espero k le toque el gordo al logroñes x su cercania pq asi iwal m animo a ir aunke no sea d ningun ekipo yo espero k le toque el gordo al logroñes x su cercania pq asi iwal m animo a ir aunke no sea d ningun ekipo
  • JVJ2
    Hace 13 años JVJ2 dice: Además se incorporaran todos los equipos de primera, que haran la competición, mucho más competitiva....veremos ya duelos muy disputados...SUERTE¡¡ Además se incorporaran todos los equipos de primera, que haran la competición, mucho más competitiva....veremos ya duelos muy disputados...SUERTE¡¡
  • reusenc-javi
    Hace 13 años reusenc-javi dice: Madrid y Barça les tocara con un 2ªB, cuando jueguen en el estadio del de 2ªB, el municipal ara xifra record, n cabran sentados y venderan mas entradass para estar de pie. Madrid y Barça les tocara con un 2ªB, cuando jueguen en el estadio del de 2ªB, el municipal ara xifra record, n cabran sentados y venderan mas entradass para estar de pie.
  • 7vallesRiojanos
    Hace 13 años 7vallesRiojanos dice: Ya era hora de saberlo. Ya era hora de saberlo.
Tags relacionados

  USO DE MEMORIA  
4,054,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Notice / Index )  0.0645
Total Execution Time  0.0662
  CADENA URL  
/noticia/sorteo-copa-semana-que-viene
  GET DATOS  
$_GET['/noticia/sorteo-copa-semana-que-viene']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0008   SELECT c.comment_id, 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` = '13066' AND c.comment_id IN (463252,463104,462790,462613) GROUP BY c.comment_id
0.0031  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 = 'sorteo-copa-semana-que-viene' AND n.content_type != 2
0.0021  SELECT * FROM rel_news WHERE id_new = 13066 ORDER BY (type = 5) DESC,(type = 4) DESC, (type = 3) DESC,(type = 1) DESC
0.0017  SELECT title as name,alias FROM topics WHERE id =5
0.0017  SELECT user_name FROM fa_user WHERE id =2531
0.0019  SELECT u.user_name,u.id FROM rel_votes v INNER JOIN fa_user u ON v.userId = u.id WHERE v.contentId = 13066 AND v.contentType = 4 ORDER BY v.datetime ASC
0.0024  SELECT alias FROM `news` as p WHERE author_id = 2531 AND id < 13066 ORDER by p.id DESC LIMIT 1
0.0022  SELECT alias FROM `news` as p WHERE author_id = 2531 AND id > 13066 ORDER BY p.id ASC LIMIT 1
0.0046   SELECT c.comment,c.id,c.author_id,c.author_name,c.last_update,c.creation_date,c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, c.template, NOW() AS difference_time, fau.changeA AS changeA FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id=0 AND c.lang = '1' AND c.language = 'es' AND c.`new_content_id` = '13066' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
0.0025   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '463252' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0025   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '463104' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0023   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '462790' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0022   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '462613' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0019  SELECT id_content FROM rel_news WHERE id_new = '13066' AND type = '5'
0.0025  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.0020  SELECT * FROM topics ORDER BY priority ASC