LQ Delete-able posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT top 1000 Id AS [Post Link], AcceptedAnswerId, CreationDate, Score, ViewCount, AnswerCount, LastActivityDate, DeletionDate
FROM POSTS
WHERE CLOSEDDATE IS NOT NULL
AND DeletionDate IS NULL
AND AcceptedAnswerId IS NOT NULL
AND Score <= 3
AND ViewCount < 100
ORDER BY LastActivityDate DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results