Dupe questions by summed rep of orig + dupe

1

Please login or register to vote for this query.

(click on this box to dismiss)

Well, using the sum of the log of the reps to ordering gives much better results.

Reverse Engineering Meta

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

SELECT TOP 100
  Orig.Id AS [Post Link],
  OrigUser.Id AS [User Link],
  OrigUser.Reputation AS OrigRep,
  Dupe.Id AS [Post Link],
  DupeUser.Id AS [User Link],
  DupeUser.Reputation AS DupeRep
FROM
  Posts Orig,
  Users OrigUser,
  Posts Dupe,
  Users DupeUser,
  PostLinks
WHERE
  PostLinks.RelatedPostId = Orig.Id
  AND
  Orig.OwnerUserId = OrigUser.Id
  AND
  PostLinks.PostId = Dupe.Id
  AND
  Dupe.OwnerUserId = DupeUser.Id
  AND
  DupeUser.Id <> OrigUser.Id
  AND
  PostLinks.LinkTypeId = 3
ORDER BY LOG(DupeUser.Reputation) + LOG(OrigUser.Reputation) DESC

Enter Parameters

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