Accepted non-self-answers without accept-vote, where question owner exists

1

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 p.AcceptedAnswerId as [Post Link], p.OwnerUserId as [User Link] from Posts p 
where p.OwnerUserId is not null and p.AcceptedAnswerId not in (
select v.PostId from Votes v 
where v.VoteTypeId = 1 ) and p.AcceptedAnswerId not in (
select q.Id from Posts q 
where q.OwnerUserId = p.OwnerUserId) 
order by p.AcceptedAnswerId desc

Enter Parameters

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