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)

Mathematics

Q&A for people studying math at any level and professionals in related fields

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