Replied to topics in a certain category, but exclude replies to own topics

[nstemp]

Hello!

I want to create a badge for those who help in the forums, so I want to give it to the people who have replied X times to ANY thread inside the category ‘Help’. Of course this has to avoid replies in your own topic.

Please any help would be great! I have no idea how to deal with this kind of databases (I’m new to discourse )

[dax (Daniela)]

I need something similar. For now I use this code, trigger daily:

@riking

SELECT p.user_id user_id, min(p.id) post_id, min(p.created_at) granted_at
FROM badge_posts p
JOIN topics t ON p.topic_id = t.id
WHERE t.category_id = (SELECT id FROM categories WHERE slug = ‘introductions’)
GROUP BY p.user_id

And this is the problem:

@nstemp

Of course this has to avoid replies in your own topic.

Users that start topics inside particular category must be excluded from count.
We have a little number of users that write a lot of posts in a single topic only to reply a single question

[alefattorini (Alessio Fattorini)]

I’m interested into it as well, how to avoid such problem?