Kill some ActiveRecord deprecation warnings

* use `.all` instead of `.scope`
* use `.joins` for `.includes` explicitly
* do not use options in `.find_by_foo`