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` = 149) AND `object`.`publish_time` <= "2023-01-29 05:19:37" AND `object`.`publish` = 0 AND `object`.`alanguage` = 'vietnamese'
GROUP BY `att`.`moduleid`
ORDER BY `object`.`updated` desc, `object`.`id` desc
LIMIT 0 , 30
Côn Đảo có nguồn tài nguyên thiên nhiên và hệ sinh thái phong phú, đa dạng sinh học cao, có tiềm năng lớn trong khai thác dịch vụ sinh thái rừng.