다른 질문을 위해 데이터 탐색기를 사용할 수도 있습니다
혹시 이렇게 생각하신 건가요?
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