note: this query includes questions that were deleted in the duplicate count
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 original.Id AS [Post Link], COUNT(*) AS Duplicates FROM PostsWithDeleted original JOIN PostLinks ON RelatedPostId=original.Id WHERE LinkTypeId=3 and original.tags like '%<rust>%' GROUP BY original.Id ORDER BY Duplicates DESC