1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for active researchers, academics and students of physics

-- Recent self answers
-- Answers probably to flag

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

fork query

edited dec 13 17 jon.doe26651

created jun 22 12 prateekjaiswal