0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

select
  Posts.Id as [Post Link],
  count(*) as [Close Votes]
from Posts
inner join Votes on Posts.Id=Votes.PostId
where Votes.VoteTypeId=6 and Posts.ClosedDate is NULL
group by Posts.Id
order by [Close Votes] desc

fork query

created jan 29 12 anonymous