select distinct [Post Link] = a.Id, a.Score from Posts q ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select distinct [Post Link] = a.Id, a.Score
from Posts q
inner join Posts a
  on q.Id = a.ParentId
  and q.OwnerUserId <> a.OwnerUserId
  and q.AcceptedAnswerId = a.Id
inner join Posts oa
  on q.Id = oa.ParentId
  and a.Id <> oa.Id
  and q.OwnerUserId <> oa.OwnerUserId
where q.PostTypeId = 1
  and a.Score <= -3
  and a.Score < oa.Score
order by a.Score;

Enter Parameters

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