Duplicate questions of deleted questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT PostLinks.PostId as [Post Link] FROM PostLinks
WHERE
  PostLinks.LinkTypeId = 3 AND
  (SELECT Posts.ID FROM Posts WHERE Posts.Id = PostLinks.PostId) IS NOT NULL AND
  (SELECT Posts.Id FROM Posts WHERE Posts.Id = PostLinks.RelatedPostId) IS NULL
GROUP BY PostLinks.PostId
ORDER BY PostLinks.PostId

Enter Parameters

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