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

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, 101)
GROUP BY Tags.TagName
ORDER BY Duplicates DESC

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results