Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
---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 WHERE (q.OwnerUserId=##userid##) AND (q.Score<=0) AND (q.AnswerCount=0) AND (q.CommentCount<=1) AND (q.PostTypeId=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 ---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