I wanted to ask a hand on a query. I wanted to create a badge granted when someone replies at least once on at least topics.
So far, using different sql queries in this thread I have the easy part : 50 replies
SELECT user_id, 0 post_id, current_timestamp granted_at FROM badge_posts WHERE post_number > 1 AND (:backfill OR user_id IN (:user_ids) OR 0 NOT IN (:post_ids) ) GROUP BY user_id HAVING count(*) >= 50
But I lack the knowledge to add the trigger that the replies need to be into 50 or more different topics.
If anyone has a clue, I’ll take it