0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions older than a year that you can mark for deletion by simply downvoting them. The rules are detailed here: http://meta.stackoverflow.com/a/92006. The view count rules are relaxed to 2x the question age because those might fail to keep up a steady stream of views at some point in the future.

Q&A for Ubuntu users and developers

DECLARE @DataDumpDate as datetime
SELECT  @DataDumpDate = MAX(CreationDate)
FROM    PostHistory

SELECT Score,
       Id                                                                AS [Post Link],
       CASE WHEN CommunityOwnedDate IS NOT NULL THEN 'Yes' ELSE NULL END AS Wiki,
       OwnerUserId                                                       AS [User Link]
FROM   Posts
WHERE  PostTypeId = 1
       AND (Score = 1 OR (Score = 2 AND OwnerUserId IS NULL))
       AND (AnswerCount = 0 OR AnswerCount IS NULL)
       AND CommentCount <= 1
       AND DATEDIFF(day, CreationDate, @DataDumpDate) > 365
       AND ViewCount <= (DATEDIFF(day, CreationDate, @DataDumpDate) * 1.5)
ORDER  BY Score DESC, CreationDate ASC

view current version

edited mar 12 12

created mar 12 12 e