SELECT
n.id_noticia AS id,
n.titulo,
n.volanta,
n.bajada,
n.autor,
n.muestra_autor,
ns.nombre AS seccion,
CONCAT_WS('/', './nota', n.id_noticia, n.slug, '') AS link,
n.is_image AS has_image,
n.is_video AS has_video,
n.is_audio AS has_audio,
IF(n.is_image,
CONCAT('./uploads/noticias/3/', imagen_principal),
IF(n.is_video,
(SELECT CONCAT('https://img.youtube.com/vi/', video, '/0.jpg') FROM noticias_videos WHERE id_noticia = id ORDER BY id_video DESC LIMIT 1),
'./uploads/noticias/3/vacia.png')
) AS imagen
FROM noticias n
LEFT JOIN noticias_secciones ns USING(id_seccion)
INNER JOIN noticias_columnistas ncol ON ncol.id_noticia = n.id_noticia
INNER JOIN columnistas col USING(id_columnista)
WHERE
n.activo=1
AND col.id_columnista = 6
AND n.lecturas > 0
AND (DATEDIFF('2025-12-15', n.fecha) <= 100)
ORDER BY n.lecturas DESC, n.orden, n.id_noticia DESC
LIMIT 0, 10
