Speed up nav rendering by using group by queries for asset types and subtypes