Forum style questions - self answers from asker


Please login or register to vote for this query.

(click on this box to dismiss)

Multiple self answers from asker, sorted by the number of times self-answered, and filtered to exclude questions prior to Jan 1, 2010. (To avoid questions from 2008 with historical locks.)


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

select TOP 1000 question.Id as [Post Link], 
       count(selfAnswer.Id) as [Count]
from posts as question
    inner join posts as selfAnswer
        on  selfAnswer.owneruserid = question.owneruserid
        and selfAnswer.parentid =
        inner join Users as users on users.Id = question.owneruserid
where question.posttypeid = 1
and selfAnswer.posttypeid = 2
--and question.CommunityOwnedDate is null
group by question.Id, 
having count(distinct > 0
order by 
        [Count] DESC,
        question.CreationDate DESC

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results