Forum style questions - multiple self answers from asker

1

Please login or register to vote for this query.

(click on this box to dismiss)

Answers probably to flag

Stack Overflow

Q&A for professional and enthusiast programmers

-- Self answers with user definable string in body
-- Answers probably to flag

select question.Id as [Post Link], 
       question.CreationDate
from posts as question
    inner join posts as selfAnswer
        on  selfAnswer.owneruserid = question.owneruserid
        and selfAnswer.parentid = question.id
        inner join Users as users on users.Id = question.owneruserid
where question.posttypeid = 1
and selfAnswer.posttypeid = 2
and users.reputation < ##MaxUserRep?100##
group by question.Id, 
         question.CreationDate
having count(distinct selfAnswer.id) > 1
order by 
        question.CreationDate asc

Enter Parameters

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