de-normalize subscription part 1