Questions in danger of auto-delete (after 365 days)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

---This includes simply the user's questions with score<=0 and no answers.
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
WHERE (q.Score<=0) and (q.AnswerCount=0)
ORDER BY q.CreationDate ASC

---From https://meta.stackexchange.com/help/roomba
---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

Options:
Switch to main site
loading Hold tight while we fetch your results