SELECT username
FROM users u
JOIN user_stats us
ON u.id = us.user_id
WHERE us.first_post_created_at BETWEEN :start_date::date
AND :end_date::date
I want to know how to turn an SQL query into a badge setting.I want users to receive a ‘New Contributors’ badge when they make their first post.
2 Likes
ondrej
2
Hello Copymonopoly,
Have you had a look at this topic below?
2 Likes