Regular Emeritus
SELECT user_id, granted_at
FROM user_badges
WHERE badge_id = 3
Description: Users with this badge have been a regular user of this forum now or in the past. The badge is awarded when the user first attained Trust Level 3.
Leader Emeritus
SELECT user_id, granted_at
FROM user_badges
WHERE badge_id = 4
Description: Users with this badge have been an exemplary user of this forum now or in the past. The badge is awarded when the user first attained Trust Level 4.
Revocation query: NO (This is the important one )
Targets posts: NO
Trigger: Daily
As a title: YES
Granted multiple: NO
Show badge: YES
Show post granting badge: NO
Enable: YES