Thanks, very interesting. This definitely clears things up.
So I’m running this query:
SELECT t.id, t.title, t.user_id, t.category_id, t.posts_count
FROM topics as t
JOIN categories as c
ON (t.category_id = c.id)
WHERE c.slug IN ('alenepa','alenepanews','alenepadata','alenepash')
and it’s returning me these results:
But from what I can tell, these topics seem to have been modified or deleted so that may be why posts_count = 0.
So is there a proper way of differentiating a “reply” post from a post which initiated the topic ? I was thinking maybe by comparing created_at or maybe reply_to_post_number. For instance, in our situation, I don’t want the first post by Kane York but all the other posts.