reset joins for legacy categories