Forum style questions - multiple self answers from asker


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], 
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 users.reputation < ##MaxUserRep?100##
group by question.Id, 
having count(distinct > 1
order by 
        question.CreationDate asc

Enter Parameters

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