SELECT A.Id AS QuestionId, Posts.Id AS RelatedQuestionId,...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results