100 Most Duplicated Posts on [Site]

0

Please login or register to vote for this query.

(click on this box to dismiss)

Lists the top 100 most duplicated posts (posts which have been closed as a duplicate of the given post).

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 100
  CONCAT('site://q/', pl.RelatedPostId, '|', CASE 
    WHEN pwd.DeletionDate IS NULL
    THEN pwd.Title
    ELSE '[deleted]'
    END
  ) AS [Target Post],
  COUNT(*) AS [Dupe Count],
  pwd.Tags,
  pwd.CreationDate AS [Target Posted Date],
  CONCAT('https://data.stackexchange.com/stackoverflow/query/1430005/duplicates-for-post?OriginalPostId=', pwd.Id, '|All Dupes') AS [Link to List of All Duplicates]
FROM PostLinks pl
JOIN PostsWithDeleted pwd ON pwd.Id = pl.RelatedPostId
WHERE LinkTypeId = 3 -- Dupe Type Code 
AND pwd.tags LIKE '%java%'
GROUP BY pl.RelatedPostId, pwd.DeletionDate, pwd.Title, pwd.Tags, pwd.CreationDate, pwd.Id
ORDER BY COUNT(*) DESC, pwd.CreationDate DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results