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]
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