I’m trying to execute:
SELECT user_id, 0 post_id, current_timestamp granted_at FROM badge_posts WHERE (:backfill OR user_id IN (:user_ids) OR 0 NOT IN (:post_ids) ) GROUP BY user_id HAVING count(*) > 1000
but I’m getting an error on :backfill. Can anyone tell me why?
I know this SQL used to run in badge creation.