What is the bug reporter badge?

You would need to select from posts instead of badge_posts and basically reimplement the filters that view gives to avoid data leaks.