Q&A for designers and users of artificial or invented languages, consciously developed instead of having developed naturally
SELECT TOP 100 * FROM PostsWithDeleted LEFT JOIN PostHistory on PostsWithDeleted.Id = PostHistory.PostId WHERE PostHistory.PostHistoryTypeId in (1, 10, 12)