self accepted answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Islam

Q&A for Muslims, experts in Islam, and those interested in learning more about Islam

-- Recent self answers
-- Answers probably to flag

select selfAnswer.Id as [Post Link], 
       selfAnswer.Score as Score
from posts as question
    inner join posts as selfAnswer
        on  selfAnswer.owneruserid = question.owneruserid
        and selfAnswer.parentid = question.id
where 
    question.posttypeid = 1
and selfAnswer.posttypeid = 2
and question.ownerUserId = ##UserId##
order by 
        selfAnswer.CreationDate desc

Enter Parameters

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