In a forum in the early stages of growth, it feels handy to know who has recently made their first post. If I happen to see it, it has a little banner box. But if I don’t see that, is there any way to find the post? (The Admin interface tells me that there has been a new contributor.)
I’ve looked in all recently updated threads and don’t see the box.
Can I search for all users with only 1 post? Or all users with only a few posts?
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
Я хочу узнать, как преобразовать SQL-запрос в настройку значка. Я хочу, чтобы пользователи получали значок «Новые участники», когда делают свой первый пост.
ondrej
28.Февраль.2025 21:07:14
2
Привет, Copymonopoly,
Вы уже посмотрели эту тему ниже?