Tags with the most HNQs

1

Please login or register to vote for this query.

(click on this box to dismiss)

Bicycles Meta

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

SELECT 
t.tagname, COUNT(p.Id) AS Count
FROM PostHistory ph INNER JOIN Posts p ON ph.PostId=p.Id
  INNER JOIN PostTags pt on p.Id=pt.PostId
  INNER JOIN Tags t on pt.TagId = t.Id
WHERE ph.PostHistoryTypeId=52
GROUP BY t.Tagname
ORDER BY COUNT(p.Id) DESC

Enter Parameters

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