select st.Value as TagName from PostsWithDeleted
cross apply STRING_SPLIT (LTRIM(REPLACE(REPLACE(Tags, '<', ' '), '>', '')), ' ') st
where Id = ##ID##

select Tags.TagName
from Posts
inner join PostTags on Posts.ID = PostTags.PostId
inner join Tags on Tags.ID = PostTags.TagId
where Posts.Id = ##ID##