downvotes on bug reports


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 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 =
where in (select pt.postid from posttags pt
inner join tags t on pt.tagid =
where t.tagname = 'bug'

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

Enter Parameters

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