# 특정 다른 배지를 보유한 경우의 배지

**URL:** <https://meta.discourse.org/t/badge-for-having-certain-other-badges/173436>\
**Category:** Data & reporting\
**Tags:** sql-triggered-badge\
**Created:** [12월 16, 2020, 12:07오전 UTC](https://meta.discourse.org/t/badge-for-having-certain-other-badges/173436 "2020-12-16T00:07:07Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![alefattorini](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/alefattorini/32/119928_2.png) [@alefattorini](https://meta.discourse.org/u/alefattorini)\
**Post date:** [12월 17, 2020, 10:38오전 UTC](https://meta.discourse.org/t/badge-for-having-certain-other-badges/173436/2 "2020-12-17T10:38:51Z")

</div>

회원들의 대체 사용자 레벨을 생성하려면 다음과 같은 쿼리를 사용합니다.  
`ib.badge_id`를 회원들이 획득해야 하는 배지 ID로 교체할 수 있습니다.

```
SELECT user_id, CURRENT_TIMESTAMP granted_at, NULL post_id
FROM user_badges pb
WHERE badge_id = 1
AND EXISTS (
  SELECT 1 FROM user_badges ib
  WHERE pb.user_id = ib.user_id
  AND ib.badge_id = 11
)
AND EXISTS (
  SELECT 1 FROM user_badges ib
  WHERE pb.user_id = ib.user_id
  AND ib.badge_id = 124
)
AND EXISTS (
  SELECT 1 FROM user_badges ib
  WHERE pb.user_id = ib.user_id
  AND ib.badge_id = 123
)
AND EXISTS (
  SELECT 1 FROM user_badges ib
  WHERE pb.user_id = ib.user_id
  AND ib.badge_id = 127
)
AND EXISTS (
   SELECT 1 FROM user_badges ib
   WHERE pb.user_id = ib.user_id
  AND ib.badge_id = 5
)

```

---

_[View the full topic](https://meta.discourse.org/t/badge-for-having-certain-other-badges/173436)._