# Assigned a badge based on multiple badge assignment

**URL:** <https://meta.discourse.org/t/assigned-a-badge-based-on-multiple-badge-assignment/221251>\
**Category:** Data & reporting\
**Tags:** sql-triggered-badge\
**Created:** [March 17, 2022, 4:31pm UTC](https://meta.discourse.org/t/assigned-a-badge-based-on-multiple-badge-assignment/221251 "2022-03-17T16:31:49Z")\
**Posts on this page:** 1\
**Showing post:** 5

<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:** [March 18, 2022, 4:27pm UTC](https://meta.discourse.org/t/assigned-a-badge-based-on-multiple-badge-assignment/221251/5 "2022-03-18T16:27:03Z")

</div>

Thank you but I’ve an error in my installation

```plaintext
> ActiveRecord::PreparedStatementInvalid: missing value for :backfill in /*
> * DataExplorer Query
> * Query: /admin/plugins/explorer?id=13
> * Started by: alefattorini
> */
> WITH query AS (
> SELECT u.id user_id, current_timestamp granted_at 
> FROM users u 
> WHERE u.id IN ( 
> SELECT ub.user_id 
> FROM user_badges ub 
> WHERE ub.badge_id = 102
> GROUP BY ub.user_id 
> HAVING COUNT(*) >= 1
> ) AND u.active AND u.silenced_till IS NULL AND u.id > 0 AND 
> (:backfill OR u.id IN (:user_ids) )
> ) SELECT * FROM query
> LIMIT 1000

```

---

_[View the full topic](https://meta.discourse.org/t/assigned-a-badge-based-on-multiple-badge-assignment/221251)._