fix join type for externally managed categories

• requires inner join to exclude externally managed documents