select tagname, count(*) from posts inner join (select di...


Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

select tagname, count(*) from posts inner join
(select distinct
from posts inner join
posthistory closed on closed.postid = and closed.posthistorytypeid = 10 inner join
posthistory edittags on edittags.postid = and edittags.posthistorytypeid = 6 and edittags.creationdate > closed.creationdate inner join
posthistory reopen on reopen.postid = and reopen.posthistorytypeid = 11 and reopen.creationdate > edittags.creationdate
where posts.closeddate is null) sq on = inner join
posttags on posttags.postid = inner join
tags on = posttags.tagid
group by tagname
order by 2 desc

Enter Parameters

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