SELECT article.*, DATE_FORMAT(article.date, "%d/%m/%Y") AS f_date, TIME_FORMAT(article.date, "%H:%i") AS f_time, category.name AS category_name, category.slug AS category_slug FROM (`int_article` AS article) INNER JOIN `int_article_site` AS site ON `site`.`id_article` = `article`.`id` INNER JOIN `int_article_category` AS category ON `category`.`id` = `article`.`id_category` INNER JOIN `int_article_author` AS author ON `author`.`id` = `article`.`id_author` WHERE site.id_institution = "252" AND (article.expiration > NOW() OR article.expiration IS NULL) AND article.date <= NOW() AND category.site = "1" ORDER BY `article`.`date` DESC LIMIT 9