de-normalize subscription part 2