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

J. Spence - 2019/2020

Jugador del ADO Den Haag

Noticias de J. Spence ( Hay 0 Noticias )

Ordenar por Destacadas Últimas noticias Más populares Más comentadas Más votadas


  USO DE MEMORIA  
4,044,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Newlist / Index )  0.1291
Total Execution Time  0.1305
  CADENA URL  
/noticias/jugador/j-spence-47573/4/1
  GET DATOS  
$_GET['/noticias/jugador/j-spence-47573/4/1']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (2)  
0.0149  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 `news` as p INNER JOIN fa_user_mini u ON u.id = p.author_id INNER JOIN `rel_news` as rp ON p.id = rp.id_new 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 WHERE (v.id is not null or p.id is not null) AND rp.id_content = '47573' and rp.type = 3 ORDER BY p.creation_date > '2024-04-12' DESC,p.totalcomments DESC LIMIT 0, 12
0.0147  SELECT COUNT(DISTINCT(p.id)) as total FROM `news` p INNER JOIN `rel_news` as rp ON p.id = rp.id_new WHERE rp.id_content = '47573' and rp.type = 3