downvotes on bug reports

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Overflow

Q&A about the site for professional and enthusiast programmers

select p.id as [Post Link]
, p.score
, count(*) as [Num of Downvotes]
, min(p.creationdate) as [Post created]
, min(v.creationdate) as [First DV]
, max(v.creationdate) as [Last DV]
from posts p
inner join votes v on v.postid = p.id
where p.id in (select pt.postid from posttags pt
inner join tags t on pt.tagid = t.id
where t.tagname = 'bug'

)
and v.votetypeid = 3 -- downvote
group by p.id, p.score
order by count(*) desc

Enter Parameters

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