SELECT `object`.`id`, `object`.`title`,`object`.`canonical`, `object`.`image`, `object`.`created`, `object`.`viewed`, `object`.`description`, `object`.`short_description`, (SELECT fullname FROM user WHERE user.id = object.userid_created) as user_created, (SELECT title FROM article_catalogue WHERE article_catalogue.id = object.catalogueid) as catalogue_title, (SELECT count(id) FROM comment WHERE comment.detailid = object.id AND comment.module = 'article') as comment
FROM `catalogue_relationship` as `att`
INNER JOIN `article` as `object`
WHERE `att`.`module` = 'article' AND `att`.`moduleid` = `object`.`id` AND (`att`.`catalogueid` = 145) AND `object`.`publish_time` <= "2025-05-08 04:18:32" AND `object`.`publish` = 0 AND `object`.`alanguage` = 'vietnamese'
GROUP BY `att`.`moduleid`
ORDER BY `object`.`updated` desc, `object`.`id` desc
LIMIT 450 , 30
Cảnh báo
Thông tin từ Bộ Tài nguyên và Môi trường, trung bình mỗi năm, trên địa bàn cả nước thải ra môi trường hơn 3.650 triệu mét khối nước thải sinh hoạt.