Find questions ripe for the Revival and Necromancer badges

11

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

Language Learning

Q&A for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition

SELECT
    p.Id AS [Post Link], t.name as [Edit type]
FROM
    Posts p
INNER JOIN 
    PostHistory h ON h.PostId = p.Id
INNER JOIN 
    PostHistoryTypes t ON t.Id = h.PostHistoryTypeId 
WHERE 
    p.ParentID IS NULL AND t.Id = 18

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results