Sorry I meant TL2
SELECT u.id user_id, current_timestamp granted_at
FROM users u
WHERE u.id IN (
SELECT invited_by_id
FROM invites i
JOIN users u2 ON u2.id = i.user_id
WHERE i.deleted_at IS NULL AND u2.active AND u2.trust_level >= 2 AND not u2.blocked
GROUP BY invited_by_id
HAVING COUNT(*) > 3
) AND u.active AND NOT u.blocked AND u.id > 0 AND
(:backfill OR u.id IN (:user_ids) )
Its meant to be a reasonably hard to get badge
https://meta.discourse.org/t/what-do-user-trust-levels-do/4924/5?u=sam
Member is defined as TL2 throughout Discourse.