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

Noticias de liga-de-campeones-concacaf-grupos

Hay 0 Noticias
No se han encontrado usuarios con esto parámetros, vuelve a intentarlo!

  USO DE MEMORIA  
3,916,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Newlist / Index )  0.0382
Total Execution Time  0.0395
  CADENA URL  
/noticias/competicion/liga-de-campeones-concacaf-grupos
  GET DATOS  
$_GET['/noticias/competicion/liga-de-campeones-concacaf-grupos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (6)  
0.0019  SELECT id FROM keywords WHERE keyword="liga" AND lang = 1
0.0018  SELECT id FROM keywords WHERE keyword="campeones" AND lang = 1
0.0018  SELECT id FROM keywords WHERE keyword="concacaf" AND lang = 1
0.0019  SELECT id FROM keywords WHERE keyword="grupos" AND lang = 1
0.0091  SELECT p.id,p.votes_up,p.content_type,p.teaser,p.totalcomments,p.votes_down,p.title,p.views,p.alias,p.video_content_id,p.picture_content_id,LEFT(p.body,300) as body,pic.author_id as pauthor_id,v.author_id as vauthor_id FROM `rel_keywords_l` as rk INNER JOIN `rel_keywords_c` AS rk2 ON rk.content_id = rk2.content_id INNER JOIN `rel_keywords_c` AS rk3 ON rk.content_id = rk3.content_id INNER JOIN `news` as p ON p.id = rk.content_id WHERE (rk.keyword_id = 316 AND rk.content_type = 4) AND (rk2.keyword_id = 324 AND rk2.content_type = 4) AND (rk3.keyword_id = 875 AND rk3.content_type = 4) LEFT JOIN `pictures` as pic ON p.picture_content_id = pic.id AND pic.banned=0 LEFT JOIN `videos` as v ON p.video_content_id = v.id GROUP BY rk.content_id ORDER BY rk.points+rk2.points+rk3.points DESC,rk.content_id DESC LIMIT 0, 12
0.0091  SELECT count(p.id) as cuenta FROM `rel_keywords_l` as rk INNER JOIN `rel_keywords_c` AS rk2 ON rk.content_id = rk2.content_id INNER JOIN `rel_keywords_c` AS rk3 ON rk.content_id = rk3.content_id INNER JOIN `news` AS p ON p.id = rk.content_id WHERE (rk.keyword_id = 316 AND rk.content_type = 4) AND (rk2.keyword_id = 324 AND rk2.content_type = 4) AND (rk3.keyword_id = 875 AND rk3.content_type = 4) GROUP BY rk.content_id