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

Segunda parte del ¿Y tú, quién crees que ascenderá?

Voten y apuesten por los que crean que son candidatos, los que más votaciones tengan a mitad de temporada los subiré a la encuesta principal y, a su vez, bajaré a los que menos puntos tengan de la principal.

Real_Madrid_Castilla_-_Mirandés

Imagen subida por: kevscaceres

8
Encuesta
38 %
25 %
25 %
13 %
0 %
0 %
0 %
Encuesta cerrada
3 Comentarios + 2 respuestas
  • elcherm
    Actualizado hace 10 años (Creado hace 10 años ) elcherm dice: A pesar del mini-bajón sigo creyendo que será el Sporting. El Recreativo también es de mis apuestas (de hecho va el primero) y tu propio equipo, el Las Palmas, tiene una gran plantilla para lograrlo.
  • elcherm
    Hace 10 años elcherm dice: De las opciones que has puesto me inclino por el Mirandés.
  • xxgerrycanaryxx
    Hace 10 años xxgerrycanaryxx dice: Voten por su favorito y voten en la encuesta principal.

  USO DE MEMORIA  
4,064,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Poll / Index )  0.1849
Total Execution Time  0.1859
  CADENA URL  
/encuesta/segunda-parte-y-tu-quien-crees-que-ascendera
  GET DATOS  
$_GET['/encuesta/segunda-parte-y-tu-quien-crees-que-ascendera']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0016   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` = '87584' AND c.comment_id IN (2245181,2245182,2244111) GROUP BY c.comment_id
0.0084  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 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 = 'segunda-parte-y-tu-quien-crees-que-ascendera' AND n.content_type = 2
0.0099  SELECT id, new_id, title, votes FROM `poll_options` WHERE `new_id`=87584 ORDER BY `votes` DESC
0.0036  SELECT id FROM `rel_votes` WHERE userId = '0' AND contentId = '87584' AND contentType = '5' AND remote = '316212850' AND datetime > '2024-04-27 16:10:06'
0.0028  SELECT user_name FROM `fa_user` WHERE id = 433915
0.0064  SELECT * FROM rel_news WHERE id_new = 87584 ORDER BY (type = 5) DESC,(type = 4) DESC, (type = 3) DESC,(type = 1) DESC
0.0025  SELECT title as name,alias FROM topics WHERE id =24
0.0018  SELECT user_name FROM fa_user WHERE id =377086
0.0030  SELECT u.user_name,u.id FROM rel_votes v INNER JOIN fa_user u ON v.userId = u.id WHERE v.contentId = 87584 AND v.contentType = 4 ORDER BY v.datetime ASC
0.0030  SELECT alias FROM `news` as p WHERE author_id = 377086 AND id < 87584 ORDER by p.id DESC LIMIT 1
0.0065  SELECT alias FROM `news` as p WHERE author_id = 377086 AND id > 87584 ORDER BY p.id ASC LIMIT 1
0.0240   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` = '87584' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
0.0233   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 = '2245181' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0376   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 = '2245182' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0143   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 = '2244111' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0029  SELECT * FROM topics ORDER BY priority ASC