Filter DownVotes in a Tag

1

Please login or register to vote for this query.

(click on this box to dismiss)

Find question in a tag that are getting down voted.

Computational Science

Q&A for scientists using computers to solve scientific problems

WITH A AS (select
  p.Id as [Post Link],p.ClosedDate,  sum(CASE WHEN v.VoteTypeId = 3 THEN 1 ELSE 0 END) AS downvotes
from
 Posts p
 inner join Votes v   on v.PostId = p.Id
INNER JOIN PostTags pt ON pt.PostId = p.Id
inner join Tags t   on t.id = pt.TagId and t.TagName = '##TagToSearch##'

where
  p.PostTypeId = 1 
  
  
group by
p.Id,p.ClosedDate )

SELECT TOP ##SelectTopCount## A.* FROM A where downvotes<##DownVotesAndLess##  order by
downvotes desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results