Questions in danger of auto-delete (after 365 days, not locked) answered by the given user


Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

---This includes simply the questions with score<=0, no answers and at most one comment.
SELECT TOP(##num?500##)
  q.Id AS [Post Link], 
  q.OwnerUserId AS [User Link],
  q.CreationDate, DATEDIFF(day, q.CreationDate, CAST(GETDATE() AS Date)) AS [Days],
  q.AnswerCount, q.CommentCount,
  q.Score, q.ViewCount, q.Tags
FROM Posts q INNER JOIN Posts a ON a.ParentId=q.Id
WHERE (a.OwnerUserId=##userid##) AND (q.Score<=0) AND (q.AnswerCount=0) AND (q.CommentCount<=1) AND
---do not include locked questions
  (q.Id not IN 
    (SELECT ph1.PostId FROM PostHistory ph1 INNER JOIN Posts q ON ph1.PostId=q.Id WHERE (q.PostTypeId=1) AND (ph1.PostHistoryTypeId=14) AND 
      (q.Id NOT IN 
        (SELECT ph2.PostId FROM PostHistory ph2 WHERE ph2.PostHistoryTypeId=15)
ORDER BY q.CreationDate ASC

---If the question is more than 365 days old, and ...
--- * has a score of 0 or less, or a score of 1 and a deleted owner
--- * has no answers
--- * is not locked
--- * has view count <= the age of the question in days times 1.5
--- * has 1 or 0 comments
--- * isn't on a meta site

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results