# Awarding badges multiple times with custom SQL

**URL:** <https://meta.discourse.org/t/awarding-badges-multiple-times-with-custom-sql/71279>\
**Category:** Data & reporting\
**Tags:** sql-triggered-badge\
**Created:** [October 3, 2017, 2:53am UTC](https://meta.discourse.org/t/awarding-badges-multiple-times-with-custom-sql/71279 "2017-10-03T02:53:36Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![barryvan](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/barryvan/32/82635_2.png) [@barryvan](https://meta.discourse.org/u/barryvan)\
**Post date:** [October 25, 2017, 10:12am UTC](https://meta.discourse.org/t/awarding-badges-multiple-times-with-custom-sql/71279/3 "2017-10-25T10:12:32Z")

</div>

Using a `case` statement and targeting posts seems to have resolved it. So it seems that badges which are not manually awarded can only be granted multiple times if they target posts. Is this something that could be made clearer on the page? Should I repost to #Contribute > UX or #Contribute > Feature to suggest this?

---

_[View the full topic](https://meta.discourse.org/t/awarding-badges-multiple-times-with-custom-sql/71279)._