Which tags with at least 1000 question in past 30 days had most duplicates?


Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

SELECT Tags.TagName,
       COUNT(*) AS Duplicates
FROM Posts
INNER JOIN PostHistory ON PostHistory.PostId = Posts.Id
INNER JOIN PostTags ON PostTags.PostId = Posts.Id
INNER JOIN Tags ON Tags.Id = PostTags.TagId
WHERE PostHistory.PostHistoryTypeId = 10
  AND PostHistory.Comment IN (1,
  AND Posts.CreationDate >= DATEADD(DAY, -30, GETDATE())
  AND Posts.CreationDate <= GETDATE()
  GROUP BY Tags.TagName HAVING COUNT(*) > 5
ORDER BY Duplicates DESC

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results