Filter mods/bots from post_count?

data & reporting
1

Hey,

I’m trying to filter out moderators/bots out of post_count. I’ve tried using NOT IN as shown below. I’ve tried with the user ids as well but nothing seems to work. Any help?

SELECT
distinct(t.id) as topic_id,
t.posts_count as comments

FROM topics t
LEFT JOIN posts p ON t.id = p.topic_id and t.user_id = p.user_id
LEFT JOIN users u ON u.id = t.id

WHERE t.category_id IN (20,21,5,7,9,11)
AND t.id NOT IN (17,19,21,23,6300,6301)
– AND strpos(t.title, ‘About the’) != 0
–AND u.username NOT IN (‘system’, ‘river’, ‘Pearson’)
order by t.id asc

2

Still need help with this. Not sure if there’s any other information thats needed for assistance.

The query is supposed to count all unique posters under a topic excluding users who are mods/admin, as well as bots. However, I am not sure how to filter out staff and bots from post_count.

Hopefully this makes it more clear with how its supposed to work and what isnt working.