Simplify view methods.

Move recurring select queries into models to dedupe.