I've inherited this complex query (I am assuming it was generated from an ORM) from a coworker and