Get Questions Closed as Dupe of Particular Question

1

Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers Meta

Q&A about the site for Drupal developers and administrators

SELECT DISTINCT *
FROM (
  SELECT r.CreationDate AS "Created", p.PostId AS [Post Link],
         r.Score, r.AnswerCount AS "Answers", r.Tags
  FROM PostLinks p
       JOIN Posts q ON q.Id = RelatedPostId
       JOIN Posts r ON r.Id = p.PostId
  WHERE LinkTypeId = 3
    AND RelatedPostId = ##QuestionId##
) d

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results