Vous pouvez également utiliser l’explorateur de données pour vos autres questions
Est-ce que cela correspond à ce que vous aviez en tête ?
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