SELECT news.id, DATE_FORMAT(news.date, "%d/%m/%Y") AS date, DATE_FORMAT(news.date, "%H\h%i") AS hour, news.slug, news.font, news.title, news.subtitle, SUBSTR(news.text, 1, 400) AS text, news.audio, editorial.name AS editorial_name, editorial.slug AS editorial_slug, subeditorial.name AS subeditorial_name, subeditorial.slug AS subeditorial_slug, video.link AS video, (
 SELECT ez_photo.file FROM ez_photo
 INNER JOIN int_newsroom_photo AS photo ON photo.id_photo = ez_photo.id
 WHERE photo.highlighted = "1" AND photo.id_gallery = news.id
 ORDER BY ez_photo.photo_order ASC
 LIMIT 1
 ) AS image
FROM (`int_newsroom` AS news)
INNER JOIN `int_newsroom_site` AS site ON `site`.`id_newsroom` = `news`.`id`
INNER JOIN `int_editorial` AS editorial ON `editorial`.`id` = `news`.`id_editorial`
LEFT JOIN `int_subeditorial` AS subeditorial ON (subeditorial.id = news.id_subeditorial AND subeditorial.site = "1")
LEFT JOIN `int_newsroom_video` as video ON `video`.`id_newsroom` = `news`.`id`
WHERE 
 editorial.site = "1" AND
 site.id_institution = "183" AND
 (news.expiration > NOW() OR news.expiration IS NULL) AND
 news.date <= NOW() AND
 news.active = "1"
 
AND (editorial.id = "17")
AND `news`.`id` NOT IN ('3426') 
ORDER BY news.date DESC
LIMIT 6