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

Once inicial ante la UD Alzira

Alzira versus Athletic

El Athletic Club presentará el siguiente once inicial ante la UD Alzira: 1 Raúl, 2 Gurpegi, 5 Ocio, 4 Ustaritz, 3 Saborit, 6 Orbaiz, 8 Iturraspe, 10 Ander Herrera, 7 Susaeta, 9 Igor Martínez y 11 Ibai.

En el banquillo estarán 13 Kepa, 12 Guillermo y 14 Iñigo.

Por la UD Alzira juegan Sito, Ferrer, Arnau, Antonio, Calero, Jorge, Edu López, López, Roberto Amarilla, Escudero y Galindo. En el banquillo estarán Bernat, Nereu, Edgar, Miguel Ángel, Marc, Jordan, Serra, Gisbert, Asensio y Lionel.

  • ElMalvis
    Hace 12 años ElMalvis dice: Probaturas lógicas de una pretemporadaProbaturas lógicas de una pretemporada
Tags relacionados

  USO DE MEMORIA  
4,003,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Notice / Index )  0.0515
Total Execution Time  0.0525
  CADENA URL  
/noticia/once-inicial-ud-alzira
  GET DATOS  
$_GET['/noticia/once-inicial-ud-alzira']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0005   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` = '42133' AND c.comment_id IN (1016309) GROUP BY c.comment_id
0.0024  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 = 'once-inicial-ud-alzira' AND n.content_type != 2
0.0018  SELECT * FROM rel_news WHERE id_new = 42133 ORDER BY (type = 5) DESC,(type = 4) DESC, (type = 3) DESC,(type = 1) DESC
0.0018  SELECT title as name,alias FROM topics WHERE id =5
0.0018  SELECT user_name FROM fa_user WHERE id =3435
0.0018  SELECT u.user_name,u.id FROM rel_votes v INNER JOIN fa_user u ON v.userId = u.id WHERE v.contentId = 42133 AND v.contentType = 4 ORDER BY v.datetime ASC
0.0021  SELECT alias FROM `news` as p WHERE author_id = 3435 AND id < 42133 ORDER by p.id DESC LIMIT 1
0.0021  SELECT alias FROM `news` as p WHERE author_id = 3435 AND id > 42133 ORDER BY p.id ASC LIMIT 1
0.0021   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` = '42133' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
0.0019   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 = '1016309' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0020  SELECT id_content FROM rel_news WHERE id_new = '42133' 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.0018  SELECT * FROM topics ORDER BY priority ASC