"Sorry, An error has occurred" when changing a badge sql trigger to "When a user is edited or created"

Contribute Bug
8

OK so I have this query:

SELECT cf.user_id user_id, cf.updated_at granted_at
FROM user_custom_fields cf
WHERE cf.name like 'user_field_1' AND
LENGTH(cf.value) > 1

would it work if I modify it to:

SELECT cf.user_id user_id u.id, cf.updated_at granted_at
FROM user_custom_fields cf u
WHERE cf.name like 'user_field_1'
AND (
  u.id IN (:user_ids)
  OR :backfill
)
AND LENGTH(cf.value) > 1

?

(Sorry I’m not very good with SQL)