Q&A for people looking to improve their interpersonal communication skills
SELECT A.Id AS QuestionId, Posts.Id AS RelatedQuestionId, A.Title AS QuestionTitle, Posts.Title AS RelatedQuestionTitle, A.Tags AS QuestionTags, Posts.Tags AS RelatedQuestionTags FROM ( SELECT Posts.Id AS Id, Posts.Title AS Title, Posts.Tags AS Tags, PostLinks.LinkTypeId AS LinkType, PostLinks.RelatedPostId AS RelatedId FROM Posts JOIN PostLinks ON Posts.Id = PostLinks.PostId WHERE (PostLinks.LinkTypeId = 1) AND (Posts.CreationDate BETWEEN '2008/08/01' AND '2014/09/01') ) A JOIN Posts ON Posts.Id = A.RelatedId WHERE (Posts.CreationDate BETWEEN '2008/08/01' AND '2014/09/01') ORDER BY A.Id OFFSET 550000 ROWS