Orig-Dupe pairs with disjunct tags

1

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

SELECT *
FROM PostLinks
WHERE Id NOT IN (
  SELECT PostLinks.Id
  FROM PostLinks, PostTags DupeTags, PostTags OrigTags
  WHERE
    PostLinks.LinkTypeId = 3
    AND
    DupeTags.PostId = PostLinks.PostId
    AND
    PostLinks.RelatedPostId = OrigTags.PostId
    AND
    DupeTags.TagId = OrigTags.TagId
)

Enter Parameters

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