您可以使用数据浏览器(Data Explorer)获取有关论坛翻译的更多数据。
此查询返回论坛上的所有分类,除了那些配置为排除在 AI 翻译之外的分类:
SELECT c.id as category_id, c.name
FROM categories c
WHERE c.id NOT IN (
SELECT unnest(string_to_array(value, '|')::integer[])
FROM site_settings
WHERE name = 'ai_translation_excluded_categories'
)
ORDER BY c.id
SELECT
c.id AS category_id,
COUNT(DISTINCT pl.post_id) AS translated_posts,
COUNT(DISTINCT pl.locale) AS languages,
COUNT(*) AS total_translations
FROM post_localizations pl
JOIN posts p ON p.id = pl.post_id
JOIN topics t ON t.id = p.topic_id
JOIN categories c ON c.id = t.category_id
GROUP BY c.id, c.name
ORDER BY total_translations DESC