0

Please login or register to vote for this query.

(click on this box to dismiss)

Answers probably to flag

Q&A for anime and manga fans

-- 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
where question.posttypeid = 1
and selfAnswer.posttypeid = 2
and len(selfAnswer.Body) < 200
group by question.Id, 
         question.CreationDate
having count(distinct selfAnswer.id) > 1
order by 
        question.CreationDate desc

fork query

created oct 17 11 MPelletier