SELECT TOP 50 p.Id AS [Post Link], t.name as [Edit type]...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

-- Enter Query Title
-- Enter Query Description

SELECT TOP 50
    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 > 17

Enter Parameters

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