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.

Stack Overflow

Q&A for professional and enthusiast programmers

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