Remove unnecessary join to hierarchy table.