Closed questions with nonpositive scores sorted by delete votes

0

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 p.Id as [Post Link], max(p.Score) as [Score], max(p.AnswerCount) as [Answers], count(v.Id) as [Delete Votes] from posts p 
  inner join votes v 
    on v.PostId=p.Id
    where v.VoteTypeId=10 and p.PostTypeId=1 and Score < 1
group by p.Id
order by [Delete Votes] desc, Score asc

Enter Parameters

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