Find questions ripe for the Revival and Necromancer badges

10

Please login or register to vote for this query.

(click on this box to dismiss)

Searches for open, non-CW posts older than 60 days with no accepted answer and no answer scoring 2 or more. (Now updated so merged questions do not appear.)

Server Fault

Q&A for system administrators and IT professionals

-- Find questions ripe for the Revival and Necromancer badges
-- (Now updated so merged questions do not appear.)

SELECT TOP 1000
    p.Id AS [Post Link],
    p.Score,
    p.CreationDate as [Asked Date],
    p.ViewCount
FROM
    Posts p
WHERE
    p.AcceptedAnswerId IS NULL
    AND
    p.PostTypeId = 1
    AND
    p.CreationDate < GETDATE() - 60
    AND
    p.CommunityOwnedDate IS NULL
    AND
    p.ClosedDate IS NULL
AND NOT EXISTS
    (
        SELECT *
        FROM Posts p2
        WHERE p2.ParentId = p.Id
        AND p2.Score >= 2
        AND p2.PostTypeId = 2
    )
AND NOT EXISTS
    (
        SELECT *
        FROM PostHistory ph
        WHERE ph.PostId = p.Id
        AND ph.PostHistoryTypeId = 14
     )  
ORDER BY
    p.Score DESC

Enter Parameters

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