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` = 118) AND `object`.`publish_time` <= "2025-11-23 13:23:41" AND `object`.`publish` = 0 AND `object`.`alanguage` = 'vietnamese'
GROUP BY `att`.`moduleid`
ORDER BY `object`.`updated` desc, `object`.`id` desc
LIMIT 450 , 30
Hồ sơ
Phó Thủ tướng Thường trực Chính phủ Phạm Bình Minh, Trưởng Ban Chỉ đạo quốc gia chống buôn lậu, gian lận thương mại và hàng giả vừa ký ban hành Kế hoạch 119/KH-BCĐ389 về cao điểm...