Remove parentheses.

Inb4 adding it back.
Use raw mode for status column because it's a custom datatype.

To prevent AREL from exploding.
The status being custom datatype fix.
Count with condition is deprecated.
Start removing the find helper usage.
Remove usage of deprecated dynamic finder.

There are more of this.
Yet another scoping with lambda thing.
Yet another scope lambda thing.
Simplify tag subscription post_ids finder.
Replace count(:condition, etc) with where(:condition).etc.count