0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited mar 6 14

created mar 6 14 grgarside