Automatically Apply Badges to Group Members (in Hosted Version)

Here is the badge SQL, just replace your_group_name

select user_id, created_at granted_at, NULL post_id
from group_users
where group_id = (
  select g.id from groups g where g.name = 'your_group_name'
)