Top 50 Posts with Delete Votes

1

Please login or register to vote for this query.

(click on this box to dismiss)

English

Q&A for linguists, etymologists, and serious English language enthusiasts

select top ##Top?5##
  p.Id as [Post Link],
  sum(p.Score) as Score,
  count(v.Id) as DeleteVotes,
  max(p.ClosedDate) as ClosedDate
from
  Posts p
  inner join Votes v on p.Id = v.PostId
  inner join VoteTypes vt on v.VoteTypeId = vt.Id
  inner join PostTypes pt on p.PostTypeId = pt.Id
where
  vt.Name = 'Deletion' AND
  (
    (##Answers?0## = 1 AND pt.Name = 'Answer') OR
    (##Questions?1## = 1 AND pt.Name = 'Question')
  )
group by
  p.Id
order by
  DeleteVotes DESC,
  Score

Enter Parameters

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