Old Closed Posts with no answers that weren't closed as duplicate

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT [id] [Post Link] , creationDate, score
FROM   posts q 
WHERE  posttypeid = 1 
       AND creationdate < ( Getdate() - 30 ) 
       AND answercount = 0 
       AND closeddate IS NOT NULL 
       AND id NOT IN (SELECT postid 
                      FROM   posthistory 
                      WHERE  posthistorytypeid = 10 
                             AND COMMENT = 1)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results