Find reverse duplicates

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

--Tag: The tag in question.

SELECT count(Source.Id)
FROM PostLinks 
LEFT JOIN Posts AS Source ON Source.Id = PostLinks.PostID
LEFT JOIN Posts AS Target ON Target.ID = PostLinks.RelatedPostID 
WHERE
  PostLinks.LinkTypeId = 3 AND
  Target.Tags = '820' and
  Source.Tags = '3'

Enter Parameters

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