finished HUGE refactor that makes use of subqueries. much easier testability and reusability. Writing type queries for assembly and Type took 5 minutes!
asd