Badges based on User Custom Fields?

[downey (Michael Downey)]

I think you’d simply add the following:

AND EXISTS (
  SELECT 1 FROM user_badges ib
  WHERE cf.user_id = ib.user_id
  AND ib.badge_id = 888
)

Where 888 is the badge ID number of the other prerequisite badge. See the following for details:

Badges predicated on getting a series of other badges?

Story: As an admin, I’d like to create a badge that is automatically granted if (and only if) a user has received a certain list of other badges, so that we can create a list of accomplishments/tasks in our community, and a title/role when certain of those items are achieved. Is this possible within the current system and SQL, or does there need to be some notion of “sub-badges” to accomplish something like this?