0

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.)

Q&A for professional and enthusiast programmers

-- 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,
    p.Tags
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

fork query

edited feb 22 14 Mark Hurd

created dec 17 11 mattdm