Which of your answers should you delete?

1

Please login or register to vote for this query.

(click on this box to dismiss)

Returns links to answers that have a negative overall score, what the overall score is and if the answer was accepted.

Stack Overflow

Q&A for professional and enthusiast programmers

select
  a.id [Post Link],
  sum(case v.votetypeid when 1 then 15 when 2 then 10 when 3 then -2 end) [Net reputation]
from Posts a
left join Votes v on v.postid = a.id and v.votetypeid in (1, 2, 3)
where a.owneruserId = ##UserId## and a.posttypeid = 2
group by a.id
having sum(case v.votetypeid when 1 then 15 when 2 then 10 when 3 then -2 else 1 end) < 0
order by 2

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results