Do we need build_type in this query? I don't see it used elsewhere. If we don't need it, you can eliminate a `JOIN`.