Old Closed Posts with no answers that weren't closed as duplicate, migrated or merged (score > 0)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT [id] [Post Link] ,id, creationDate, score, viewcount
FROM   posts q 
WHERE  posttypeid = 1 
       AND creationdate < ( Getdate() - 30 ) 
       AND COALESCE(answercount,0) = 0 
       AND Score > 0
       AND closeddate IS NOT NULL 
       AND id NOT IN (SELECT postid 
                      FROM   posthistory 
                      WHERE  (posthistorytypeid = 10 
                      AND COMMENT in ( 1 )) 
                      or posthistorytypeid in (17,18,35,37,38))
ORDER BY SCORE DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached