Number of new topics and posts by category - monthly


(Charles Walter) #1

Is there a query that can be run to get the number of topics or posts for each category? I’d like to begin merging categories, and am looking for an easy way to pull data without having to request the data category by category. Thx


(Jeff Atwood) #2

Pretty sure this is in in the raw json for the categories page.


(Charles Walter) #3

Thx @codinghorror for the response. I tried looking at:
www.helloforos.com/categories.json

But didn’t see a list of all the categories with their post count.

Anyhow, I think I was able to create my first query in data explorer…

SELECT
c.name,
c.topics_month,
c.posts_month
FROM categories c
WHERE c.id > 0