Hey Toni,
Does this Data Explorer query work for your needs? It will show you a count of topics and posts in each category:
SELECT category_id,
stats.topic_count,
stats.post_count
FROM categories ccc
LEFT JOIN (SELECT topics.category_id,
Count(*) topic_count,
SUM(topics.posts_count) post_count
FROM topics
WHERE ( "topics"."deleted_at" IS NULL )
AND ( topics.id NOT IN (SELECT cc.topic_id
FROM categories cc
WHERE topic_id IS NOT NULL) )
AND "topics"."visible" = true
GROUP BY topics.category_id
) stats
ON stats.category_id = ccc.id