rebuild join with revision & *links tables