0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people looking to bypass life's everyday problems with simple tricks

SELECT Id AS [Post Link],ClosedDate FROM Posts
WHERE CONVERT(date,ClosedDate) <= DATEADD(d, -9, CONVERT(date,GETUTCDATE()))
AND (CONVERT(date,LastEditDate) <= DATEADD(d, -9, CONVERT(date,GETUTCDATE()))
         OR LastEditDate IS NULL)
  AND Score = 1
  AND AcceptedAnswerId IS NULL
  -- Exclude positive answers
  AND NOT EXISTS (SELECT * FROM Posts p2 WHERE p2.ParentId = Posts.Id AND Score > 0)
  -- Exclude closed as duplicate
  AND NOT EXISTS (SELECT * FROM PostLinks WHERE PostId = Posts.Id AND LinkTypeId = 3)
  -- Exclude migrated and merged
  AND NOT EXISTS (SELECT * FROM PostHistory WHERE PostId = Posts.Id AND PostHistoryTypeId IN (17,18,35,37))
ORDER BY ClosedDate

fork query

created dec 16 17 anonymous