0

Please login or register to vote for this query.

(click on this box to dismiss)

No view count or character count constraints, score <= 0 Modification of: http://data.stackexchange.com/stackoverflow/s/1595

Q&A for anime and manga fans

-- Unaccepted self-answers without "fixed", "solved", or "found"
-- No view count or character count constraints, score <= 0
-- Modification of: http://data.stackexchange.com/stackoverflow/s/1595

select top 500 
       selfAnswer.Body,
       selfAnswer.Id as [Post Link], 
       selfAnswer.CreationDate, 
       len(selfAnswer.Body) as Length,
       selfAnswer.Score as Score,
       question.ViewCount
from posts as question
    inner join posts as allAnswers
        on allAnswers.parentid = question.id
    inner join posts as selfAnswer
        on  selfAnswer.owneruserid = question.owneruserid
        and selfAnswer.parentid = question.id
where selfAnswer.Score <= 0
and question.posttypeid = 1
and selfAnswer.posttypeid = 2
and (    question.acceptedAnswerId != selfAnswer.id 
      or question.acceptedAnswerId is null)
--and question.ViewCount < 1000
--and len(selfAnswer.Body) < 200
and selfAnswer.body not like '%fixed%'
and selfAnswer.body not like '%solved%'
and selfAnswer.body not like '%found%'
group by selfAnswer.Id, 
         selfAnswer.CreationDate, 
         len(selfAnswer.Body),
         selfAnswer.Score,
         question.ViewCount,
         selfAnswer.Body
having count(distinct allAnswers.id) > 1
order by selfAnswer.Score asc,
         len(selfAnswer.Body) asc, 
         selfAnswer.CreationDate desc

fork query

created oct 20 11 burpenator